Woocommerce 订单表数据结构初探

—
— Woocommerce 订单存储在 post 表、postmeta 表、woocommerce_order_items 和 woocommerce_order_itemmeta 表中。订单的各个部分存储在不同的表中。除此之外，订单状态通过存储订单状态列表的 taxonomies 进行管理。
— 任何正在/将要编写此查询的人都必须至少编写 5-6 个查询或
— 单个大连接查询。

SELECT
pmeta.*
FROM
wp_z8tmn5qbx1_postmeta pmeta,
wp_z8tmn5qbx1_posts p
WHERE
p.id = pmeta.meta_id
AND p.post_status IN ( ‘wc-cancelled’, ‘wc-failed’ )
and pmeta.post_id=31814
ORDER BY
p.post_date DESC

SELECT
*
FROM
wp_z8tmn5qbx1_posts
WHERE
post_type = ‘shop_order’
AND post_status IN ( ‘wc-cancelled’, ‘wc-failed’ )
AND ID = 54881
ORDER BY
post_date DESC

SELECT
*
FROM
wp_z8tmn5qbx1_postmeta
WHERE
post_id = 54881

SELECT
*
FROM
wp_z8tmn5qbx1_posts
WHERE
ID = 54881

SELECT
*
FROM
wp_z8tmn5qbx1_posts p
LEFT JOIN wp_z8tmn5qbx1_postmeta pmeta ON p.id = pmeta.post_id
WHERE
p.post_status IN ( ‘wc-cancelled’, ‘wc-failed’ )
ORDER BY
p.post_date DESC

SELECT
*
FROM
wp_z8tmn5qbx1_wc_order_stats os
LEFT JOIN wp_z8tmn5qbx1_woocommerce_order_items o ON os.order_id = o.order_id
LEFT JOIN wp_z8tmn5qbx1_woocommerce_order_itemmeta om ON o.order_item_id = om.order_item_id
WHERE
post_status IN ( ‘wc-cancelled’, ‘wc-failed’ )