Wordpress: Consulta de woocommerce para obtener todas las notas de pedidos cancelados, independientemente del motivo de cancelación

SELECT * FROM wp_comments WHERE comment_post_ID IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_order' AND post_status = 'wc-cancelled');