[WooCommerce BR] Get orders from user by ID or e-mail

by-email.sql

SELECT wp_posts.* FROM wp_posts
INNER JOIN wp_users AS users ON users.user_email = 'EMAIL_YOU_WANT'
INNER JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id 
WHERE 1=1
AND wp_postmeta.meta_key = '_customer_user' 
AND wp_postmeta.meta_value = users.ID
AND wp_posts.post_type = 'shop_order'
GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC

by-id.sql

SELECT wp_posts.* FROM wp_posts
INNER JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id 
WHERE 1=1
AND wp_postmeta.meta_key = '_customer_user' 
AND wp_postmeta.meta_value = 'ID_YOU_WANT'
AND wp_posts.post_type = 'shop_order'
GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC