SET NAMES 'utf8mb4';
set FOREIGN_KEY_CHECKS = 0;
SET SESSION sql_mode = "";
DROP TABLE IF EXISTS `wpse_wc_product_meta_lookup`;
CREATE TABLE IF NOT EXISTS `wpse_wc_product_meta_lookup` (
  `product_id` bigint(20) NOT NULL,
  `sku` varchar(100) DEFAULT '',
  `virtual` tinyint(1) DEFAULT 0,
  `downloadable` tinyint(1) DEFAULT 0,
  `min_price` decimal(19,4) DEFAULT NULL,
  `max_price` decimal(19,4) DEFAULT NULL,
  `onsale` tinyint(1) DEFAULT 0,
  `stock_quantity` double DEFAULT NULL,
  `stock_status` varchar(100) DEFAULT 'instock',
  `rating_count` bigint(20) DEFAULT 0,
  `average_rating` decimal(3,2) DEFAULT 0.00,
  `total_sales` bigint(20) DEFAULT 0,
  `tax_status` varchar(100) DEFAULT 'taxable',
  `tax_class` varchar(100) DEFAULT '',
  PRIMARY KEY (`product_id`),
  KEY `virtual` (`virtual`),
  KEY `downloadable` (`downloadable`),
  KEY `stock_status` (`stock_status`),
  KEY `stock_quantity` (`stock_quantity`),
  KEY `onsale` (`onsale`),
  KEY `min_max_price` (`min_price`,`max_price`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
REPLACE INTO `wpse_wc_product_meta_lookup` (`average_rating`,`downloadable`,`max_price`,`min_price`,`onsale`,`product_id`,`rating_count`,`sku`,`stock_quantity`,`stock_status`,`tax_class`,`tax_status`,`total_sales`,`virtual`) VALUES (
'0.00','0','299000.0000','299000.0000','0','1376','0','001AZ9-1-1','999','instock','','taxable','0','0'),(
'0.00','0','199000.0000','199000.0000','0','1099','0','001AZ9-1','999','instock','','taxable','0','0'),(
'5.00','0','199000.0000','199000.0000','0','843','1','001AZ9','999','instock','','taxable','1','0'),(
'0.00','0','199000.0000','199000.0000','0','840','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','99000.0000','99000.0000','0','1399','0','001AZ9-2','999','instock','','taxable','0','0'),(
'0.00','0','2590000.0000','199000.0000','0','1599','0','001AZ9-2-1','990','instock','','taxable','9','0'),(
'0.00','0','2590000.0000','2590000.0000','0','1600','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','199000.0000','199000.0000','0','1601','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','199000.0000','199000.0000','0','1602','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','199009.0000','199009.0000','0','1603','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1604','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1605','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1606','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1607','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1608','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1609','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1610','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1611','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1612','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1613','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1614','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1615','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1616','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1617','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1618','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1619','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1620','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1621','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1622','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1623','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1624','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1625','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1626','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1627','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1628','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1629','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1630','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1631','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1632','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1633','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1634','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1635','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1636','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1637','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1638','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1639','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1640','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1641','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1642','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1643','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1644','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1645','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1646','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1647','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1648','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','1649','0','',NULL,'instock','parent','taxable','0','0'),(
'0.00','0','1880000.0000','1880000.0000','0','2315','0','',NULL,'instock','','taxable','1','0'),(
'0.00','0','1890000.0000','1890000.0000','0','2316','0','',NULL,'instock','','taxable','9','0'),(
'0.00','0','199000.0000','199000.0000','0','2317','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','1720000.0000','1720000.0000','0','2355','0','',NULL,'instock','','taxable','10','0'),(
'0.00','0','1850000.0000','1850000.0000','0','2509','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','199000.0000','199000.0000','0','2512','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','199000.0000','199000.0000','0','2513','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','860000.0000','860000.0000','0','2717','0','',NULL,'instock','','taxable','1','0'),(
'0.00','0','980000.0000','980000.0000','1','2740','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','1880000.0000','1880000.0000','0','2733','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','1800000.0000','1800000.0000','1','2787','0','',NULL,'instock','','taxable','11','0'),(
'0.00','0','980000.0000','980000.0000','1','2788','0','','0','outofstock','','taxable','0','0'),(
'0.00','0','1250000.0000','1250000.0000','1','2791','0','','0','outofstock','','taxable','0','0'),(
'0.00','0','1250000.0000','1250000.0000','1','2792','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','955000.0000','955000.0000','0','2794','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','1100000.0000','1100000.0000','0','2799','0','',NULL,'instock','','taxable','1','0'),(
'0.00','0','0.0000','0.0000','0','2735','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','1790000.0000','1790000.0000','1','3027','0','',NULL,'instock','','taxable','2','0'),(
'0.00','0','2850000.0000','2850000.0000','1','3030','0','','1','instock','','taxable','0','0'),(
'0.00','0','1080000.0000','1080000.0000','1','3022','0','',NULL,'instock','','taxable','1','0'),(
'0.00','0','1950000.0000','1950000.0000','1','3039','0','',NULL,'instock','','taxable','5','0'),(
'0.00','0','2250000.0000','2250000.0000','1','3041','0','',NULL,'instock','','taxable','2','0'),(
'0.00','0','1580000.0000','1580000.0000','1','3133','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','980000.0000','980000.0000','1','3175','0','',NULL,'instock','','taxable','0','0'),(
'0.00','0','0.0000','0.0000','0','3264','0','',NULL,'instock','','taxable','0','0');