php删除订单代码,php – 删除Woocommerce中重复的导入订单

我在Woocommerce中有重复的订单,我想删除它们只保留独特的清洁簿记.

我不擅长sql,我写了这个请求但是当有重复时它列出了两个重复.

SELECT *

FROM `wp_posts`

WHERE post_type = 'shop_order' AND post_status = 'wc-completed'

GROUP BY post_date

HAVING count(*) > 1

ORDER BY `wp_posts`.`post_date` DESC

这给了我307个结果.

如何编写删除重复项的正确请求并仅保留唯一订单？

样本数据：

ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count

22282 227 2018-02-04 01:00:00 2018-02-04 00:00:00 Order – February 4,2018 @ 01:00 AM wc-completed open closed order-4-02-18-6 2018-03-19 17:12:32 2018-03-19 16:12:32 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 2

22277 0 2018-01-29 01:00:00 2018-01-29 00:00:00 Order – January 29,2018 @ 01:00 AM wc-completed open closed order-29-01-18-2 2018-03-19 17:12:33 2018-03-19 16:12:33 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 2

22276 0 2018-01-28 01:00:00 2018-01-28 00:00:00 Order – January 28,2018 @ 01:00 AM wc-completed open closed order-28-01-18-2 2018-03-19 17:12:33 2018-03-19 16:12:33 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 2

22275 0 2018-01-25 01:00:00 2018-01-25 00:00:00 Order – January 25,2018 @ 01:00 AM wc-completed open closed order-25-01-18-2 2018-03-19 17:12:33 2018-03-19 16:12:33 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 2

22232 154 2018-01-24 00:00:00 2018-01-24 00:00:00 Order – January 24,2018 @ 12:00 AM wc-completed open closed order-24-01-18-4 2018-01-24 00:00:00 2018-01-24 00:00:00 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 0

22230 213 2018-01-23 00:00:00 2018-01-23 00:00:00 Order – January 23,2018 @ 12:00 AM wc-completed open closed order-23-01-18-2 2018-01-23 00:00:00 2018-01-23 00:00:00 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 0

22229 0 2018-01-22 00:00:00 2018-01-22 00:00:00 Order – January 22,2018 @ 12:00 AM wc-completed open closed order-22-01-18-2 2018-01-22 00:00:00 2018-01-22 00:00:00 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 0

22228 224 2018-01-20 00:00:00 2018-01-20 00:00:00 Order – January 20,2018 @ 12:00 AM wc-completed open closed order-20-01-18-2 2018-01-20 00:00:00 2018-01-20 00:00:00 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 0

22227 0 2018-01-19 00:00:00 2018-01-19 00:00:00 Order – January 19,2018 @ 12:00 AM wc-completed open closed order-19-01-18-2 2018-01-19 00:00:00 2018-01-19 00:00:00 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 0

22226 0 2018-01-17 00:00:00 2018-01-17 00:00:00 Order – January 17,2018 @ 12:00 AM wc-completed open closed order-17-01-18-2 2018-01-17 00:00:00 2018-01-17 00:00:00 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 0

22225 0 2018-01-16 00:00:00 2018-01-16 00:00:00 Order – January 16,2018 @ 12:00 AM wc-completed open closed order-16-01-18-2 2018-01-16 00:00:00 2018-01-16 00:00:00 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 0

22224 0 2018-01-15 00:00:00 2018-01-15 00:00:00 Order – January 15,2018 @ 12:00 AM wc-completed open closed order-15-01-18-4 2018-01-15 00:00:00 2018-01-15 00:00:00 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 0

22222 0 2018-01-14 00:00:00 2018-01-14 00:00:00 Order – January 14,2018 @ 12:00 AM wc-completed open closed order-14-01-18-6 2018-01-14 00:00:00 2018-01-14 00:00:00 0 https://www.hemen-biarritz.com/?post_type=shop_ord... 0 shop_order 0

编辑：

SELECT DISTINCT post_date FROM `wp_posts` WHERE post_type = 'shop_order' AND post_status = 'wc-completed'

给了我614个结果,这是前一个请求的两倍.

wordpress：5.0

Woocommerce：3.5.2