Получить email заказов по дате woocommerce

select 
   pm.meta_value
    /*max( CASE WHEN im.meta_key = '_product_id' and i.order_item_id = im.order_item_id THEN im.meta_value END ) as Prod_ID*/
from 
    wp_posts as p
    inner join
    wp_postmeta as pm 
    on p.id = pm.post_id
    inner join
    wp_woocommerce_order_items as i 
    on p.id = i.order_id
    inner join 
    wp_woocommerce_order_itemmeta as im 
    on i.order_item_id = im.order_item_id
where 
    p.post_type = 'shop_order'
    AND pm.meta_key = '_billing_email'
    and p.post_date BETWEEN '2023-03-19 00:00:00' AND '2023-03-19 23:59:59'
    and p.post_status = 'wc-completed'
    AND i.order_item_name LIKE '%Double Chin%' 
	 group BY pm.meta_value

select

pm.meta_value

/*max( CASE WHEN im.meta_key = '_product_id' and i.order_item_id = im.order_item_id THEN im.meta_value END ) as Prod_ID*/

from

wp_posts as p

inner join

wp_postmeta as pm

on p.id = pm.post_id

inner join

wp_woocommerce_order_items as i

on p.id = i.order_id

inner join

wp_woocommerce_order_itemmeta as im

on i.order_item_id = im.order_item_id

where

p.post_type = 'shop_order'

AND pm.meta_key = '_billing_email'

and p.post_date BETWEEN '2023-03-19 00:00:00' AND '2023-03-19 23:59:59'

and p.post_status = 'wc-completed'

AND i.order_item_name LIKE '%Double Chin%'

group BY pm.meta_value

Добавить комментарий Отменить ответ