WooCommerce most/least sold products Mysql query

woocommerce-most-sold-query.sql

# Exclude product variations since they don't include the "total_sales" meta key filled by WooCommerce
SELECT ID, post_title, post_status, post_modified, meta_value 
FROM wp_posts 
INNER JOIN wp_postmeta ON wp_postmeta.post_id=wp_posts.ID 
AND wp_postmeta.meta_key='total_sales' 
WHERE post_type='product' 
ORDER BY CAST(`wp_postmeta`.`meta_value` as UNSIGNED) DESC;