sql - 我如何获得每个产品的退款总数？

Question

我想使用 WordPress WPDB 功能显示每个产品/ID 的退款数量。但我做不到。有人可以帮我吗？

这是我尝试过的一些代码，但没有一个有效：-

SELECT order_id FROM wp_woocommerce_order_itemmeta woim 
        LEFT JOIN wp_woocommerce_order_items oi 
        ON woim.order_item_id = oi.order_item_id 
        WHERE meta_key = '_product_id' AND meta_value = 5734
        GROUP BY order_id



SELECT * FROM wp_woocommerce_order_itemmeta woim JOIN wp_woocommerce_order_items oi JOIN wp_posts wp_pos ON woim.order_item_id = oi.order_item_id WHERE meta_key = '_product_id' AND meta_value = 5734 and wp_pos.post_status='wc-refunded'


SELECT * FROM `wp_woocommerce_order_itemmeta` WHERE `meta_key`='_product_id' AND `meta_value`='5734'


SELECT COUNT(*) FROM `wp_posts` WHERE `post_type`='shop_order' AND `post_status`='wc-refunded'



SELECT * FROM wp_woocommerce_order_itemmeta woim 
         JOIN wp_woocommerce_order_items oi 
       JOIN wp_posts wp_po 
        ON woim.order_item_id = oi.order_item_id 
        WHERE meta_key = '_product_id' AND meta_value = 5734 and wp_po.post_type='shop_order' AND wp_po.post_status='wc-refunded'

标签： sqldatabasewordpresswoocommerce