-- rewind begin page {"strategy":"fast","orderBy":[{"name":"order_id","direction":"ASC"}],"pageBy":{"name":"order_id","direction":"ASC"},"page":"first","limit":2500}
CREATE TABLE `wptq_wc_order_stats` (
  `order_id` bigint(20) unsigned NOT NULL,
  `parent_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `num_items_sold` int(11) NOT NULL DEFAULT 0,
  `total_sales` double NOT NULL DEFAULT 0,
  `tax_total` double NOT NULL DEFAULT 0,
  `shipping_total` double NOT NULL DEFAULT 0,
  `net_total` double NOT NULL DEFAULT 0,
  `returning_customer` tinyint(1) DEFAULT NULL,
  `status` varchar(200) NOT NULL,
  `customer_id` bigint(20) unsigned NOT NULL,
  `date_paid` datetime DEFAULT '0000-00-00 00:00:00',
  `date_completed` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`order_id`),
  KEY `date_created` (`date_created`),
  KEY `customer_id` (`customer_id`),
  KEY `status` (`status`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('240','218','2022-12-28 07:48:29','2022-12-28 12:48:29','-1','-16.2','0','0','-16.2',NULL,'wc-cancelled','1','0000-00-00 00:00:00','0000-00-00 00:00:00');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('407','0','2023-01-03 19:47:30','2023-01-04 00:47:30','1','22.75','0','10.85','11.9','0','wc-completed','2','2023-01-03 19:47:34','2023-01-04 21:12:51');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('432','0','2023-01-04 23:13:14','2023-01-05 04:13:14','1','26.15','0','11.15','15','0','wc-completed','3','2023-01-04 23:13:18','2023-01-05 09:10:09');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('614','0','2023-01-07 00:53:40','2023-01-07 05:53:40','1','26.6','0','12.6','14','0','wc-completed','4','2023-01-07 00:53:44','2023-01-08 14:28:04');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('659','0','2023-01-07 07:13:26','2023-01-07 12:13:26','1','20.25','0','9.2','11.05','0','wc-completed','5','2023-01-07 07:13:31','2023-01-08 14:28:09');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('660','0','2023-01-07 17:42:43','2023-01-07 22:42:43','1','22.75','0','10.85','11.9','0','wc-completed','6','2023-01-07 17:42:48','2023-01-08 14:28:10');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('661','0','2023-01-07 19:44:37','2023-01-08 00:44:37','1','26.6','0','12.6','14','0','wc-completed','7','2023-01-07 19:44:41','2023-01-08 14:28:11');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('675','0','2023-01-09 11:58:37','2023-01-09 16:58:37','1','24.4','0','10.4','14','0','wc-completed','8','2023-01-09 11:58:41','2023-01-09 13:08:09');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('676','0','2023-01-09 14:22:12','2023-01-09 19:22:12','1','21.05','0','10.85','10.2','0','wc-completed','9','2023-01-09 14:22:17','2023-01-09 15:07:55');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('677','0','2023-01-09 19:09:25','2023-01-10 00:09:25','1','22.3','0','10.4','11.9','0','wc-completed','10','2023-01-09 19:09:29','2023-01-10 00:05:57');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('1625','0','2023-01-19 00:43:24','2023-01-19 05:43:24','1','22.75','0','10.85','11.9','0','wc-completed','11','2023-01-19 00:43:28','2023-01-20 11:02:59');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('1627','0','2023-01-20 07:06:40','2023-01-20 12:06:40','2','59.5','0','32.3','27.2','0','wc-completed','12','2023-01-20 07:06:44','2023-01-20 11:17:51');
INSERT INTO `wptq_wc_order_stats` (`order_id`,`parent_id`,`date_created`,`date_created_gmt`,`num_items_sold`,`total_sales`,`tax_total`,`shipping_total`,`net_total`,`returning_customer`,`status`,`customer_id`,`date_paid`,`date_completed`) VALUES('1628','0','2023-01-20 07:13:56','2023-01-20 12:13:56','1','27.19','1.19','9','17','1','wc-completed','12','2023-01-20 07:14:01','2023-01-20 11:01:21');
-- rewind next pageValue "1628"
-- rewind end page {"strategy":"fast","orderBy":[{"name":"order_id","direction":"ASC"}],"pageBy":{"name":"order_id","direction":"ASC"},"page":"first","limit":2500}
-- rewind begin page {"strategy":"fast","orderBy":[{"name":"order_id","direction":"ASC"}],"pageBy":{"name":"order_id","direction":"ASC"},"page":"fast","limit":2500,"pageValue":"1628"}
-- rewind end page {"strategy":"fast","orderBy":[{"name":"order_id","direction":"ASC"}],"pageBy":{"name":"order_id","direction":"ASC"},"page":"fast","limit":2500,"pageValue":"1628"}
