``` SELECT i.order_id, i.order_item_name, m.*, p.post_date AS order_date, pm_first_name.meta_value AS customer_first_name, pm_last_name.meta_value AS customer_last_name FROM `wp_woocommerce_order_items` AS i LEFT JOIN `wp_woocommerce_order_itemmeta` AS m ON i.order_item_id = m.order_item_id AND m.meta_key = '_product_id' JOIN `wp_posts` AS p ON i.order_id = p.ID -- Join to get order date LEFT JOIN `wp_postmeta` AS pm_first_name ON p.ID = pm_first_name.post_id AND pm_first_name.meta_key = '_billing_first_name' -- Get first name LEFT JOIN `wp_postmeta` AS pm_last_name ON p.ID = pm_last_name.post_id AND pm_last_name.meta_key = '_billing_last_name' -- Get last name WHERE m.meta_value = '20594' ORDER BY `i`.`order_id` DESC; ``` ``` SELECT i.order_id, i.order_item_name, m.meta_value AS product_id , p.post_date AS order_date, pm_first_name.meta_value AS customer_first_name, pm_last_name.meta_value AS customer_last_name FROM `wp_woocommerce_order_items` AS i LEFT JOIN `wp_woocommerce_order_itemmeta` AS m ON i.order_item_id = m.order_item_id AND m.meta_key = '_product_id' JOIN `wp_posts` AS p ON i.order_id = p.ID -- Join to get order date LEFT JOIN `wp_postmeta` AS pm_first_name ON p.ID = pm_first_name.post_id AND pm_first_name.meta_key = '_billing_first_name' -- Get first name LEFT JOIN `wp_postmeta` AS pm_last_name ON p.ID = pm_last_name.post_id AND pm_last_name.meta_key = '_billing_last_name' -- Get last name WHERE p.post_date like '2026-04-15%' ORDER BY `i`.`order_id` DESC; ``` 18.04.26 ``` SELECT i.order_id, i.order_item_name, m.meta_value AS product_id, p.post_date AS order_date, pm_first_name.meta_value AS customer_first_name, pm_last_name.meta_value AS customer_last_name, COALESCE(pm_sku.meta_value, vm_sku.meta_value) AS sku FROM `wp_woocommerce_order_items` AS i LEFT JOIN `wp_woocommerce_order_itemmeta` AS m ON i.order_item_id = m.order_item_id AND m.meta_key = '_product_id' JOIN `wp_posts` AS p ON i.order_id = p.ID LEFT JOIN `wp_postmeta` AS pm_first_name ON p.ID = pm_first_name.post_id AND pm_first_name.meta_key = '_billing_first_name' LEFT JOIN `wp_postmeta` AS pm_last_name ON p.ID = pm_last_name.post_id AND pm_last_name.meta_key = '_billing_last_name' LEFT JOIN `wp_woocommerce_order_itemmeta` AS pm_sku ON i.order_item_id = pm_sku.order_item_id AND pm_sku.meta_key = '_sku' LEFT JOIN `wp_postmeta` AS vm_sku ON m.meta_value = vm_sku.post_id AND vm_sku.meta_key = '_sku' -- For variable products WHERE m.meta_value = '20594' ORDER BY `i`.`order_id` DESC; ``` 18.04.26

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2026