Получить 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	

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

Ваш адрес email не будет опубликован. Обязательные поля помечены *