Profesional desarrollo web
SELECT * FROM wp_posts WHERE post_type = 'shop_order' AND post_status = 'wc-cancelled' ORDER BY post_date DESC;