-- rewind begin page {"strategy":"fast","orderBy":[{"name":"order_item_id","direction":"ASC"}],"pageBy":{"name":"order_item_id","direction":"ASC"},"page":"first","limit":2500}
CREATE TABLE `wptq_wc_order_product_lookup` (
  `order_item_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `variation_id` bigint(20) unsigned NOT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `product_qty` int(11) NOT NULL,
  `product_net_revenue` double NOT NULL DEFAULT 0,
  `product_gross_revenue` double NOT NULL DEFAULT 0,
  `coupon_amount` double NOT NULL DEFAULT 0,
  `tax_amount` double NOT NULL DEFAULT 0,
  `shipping_amount` double NOT NULL DEFAULT 0,
  `shipping_tax_amount` double NOT NULL DEFAULT 0,
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`),
  KEY `product_id` (`product_id`),
  KEY `customer_id` (`customer_id`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('13','240','128','0','1','2022-12-28 07:48:29','-1','0','0','0','0','0','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('25','407','244','0','2','2023-01-03 19:47:30','1','11.9','22.75','2.1','0','10.85','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('28','432','73','0','3','2023-01-04 23:13:14','1','15','26.15','0','0','11.15','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('30','614','475','562','4','2023-01-07 00:53:40','1','14','26.6','0','0','12.6','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('32','659','475','637','5','2023-01-07 07:13:26','1','11.05','20.25','1.95','0','9.2','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('35','660','475','633','6','2023-01-07 17:42:43','1','11.9','22.75','2.1','0','10.85','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('38','661','475','633','7','2023-01-07 19:44:37','1','14','26.6','0','0','12.6','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('40','675','667','0','8','2023-01-09 11:58:37','1','14','24.4','0','0','10.4','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('42','676','668','0','9','2023-01-09 14:22:12','1','10.2','21.05','1.8','0','10.85','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('45','677','663','0','10','2023-01-09 19:09:25','1','11.9','22.3','2.1','0','10.4','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('48','1625','1435','0','11','2023-01-19 00:43:24','1','11.9','22.75','2.1','0','10.85','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('51','1627','1427','0','12','2023-01-20 07:06:40','2','27.2','59.5','4.8','0','32.3','0');
INSERT INTO `wptq_wc_order_product_lookup` (`order_item_id`,`order_id`,`product_id`,`variation_id`,`customer_id`,`date_created`,`product_qty`,`product_net_revenue`,`product_gross_revenue`,`coupon_amount`,`tax_amount`,`shipping_amount`,`shipping_tax_amount`) VALUES('54','1628','1434','0','12','2023-01-20 07:13:56','1','17','27.19','0','1.19','9','0');
-- rewind next pageValue "54"
-- rewind end page {"strategy":"fast","orderBy":[{"name":"order_item_id","direction":"ASC"}],"pageBy":{"name":"order_item_id","direction":"ASC"},"page":"first","limit":2500}
-- rewind begin page {"strategy":"fast","orderBy":[{"name":"order_item_id","direction":"ASC"}],"pageBy":{"name":"order_item_id","direction":"ASC"},"page":"fast","limit":2500,"pageValue":"54"}
-- rewind end page {"strategy":"fast","orderBy":[{"name":"order_item_id","direction":"ASC"}],"pageBy":{"name":"order_item_id","direction":"ASC"},"page":"fast","limit":2500,"pageValue":"54"}
