Woocommerce Orders queries

wp.sql

##-- Show Orders Current Postmeta
SELECT DISTINCT pm.meta_key FROM wp_postmeta AS pm LEFT JOIN wp_posts AS p ON p.ID = pm.post_id WHERE p.post_type = 'shop_order';

##-- Show Last 20 Orders
SELECT SQL_CALC_FOUND_ROWS hush_posts.ID
FROM hush_posts 
WHERE 1=1 
AND hush_posts.post_type = 'shop_order'
AND ((hush_posts.post_status = 'wc-pending'
OR hush_posts.post_status = 'wc-processing'
OR hush_posts.post_status = 'wc-on-hold'
OR hush_posts.post_status = 'wc-completed'
OR hush_posts.post_status = 'wc-cancelled'
OR hush_posts.post_status = 'wc-refunded'
OR hush_posts.post_status = 'wc-failed')) 
ORDER BY hush_posts.menu_order, hush_posts.post_date DESC
LIMIT 0, 20