WooCommerce SQL

SELECT wpfa_posts.ID FROM wpfa_posts WHERE (post_status = 'wc-cancelled' OR post_status='wc-completed' OR post_status='wc-processing' OR post_status='wc-on-hold' OR post_status='wc-refunded' OR post_status='wc-failed') AND wpfa_posts.ID IN
(
SELECT DISTINCT wpfa_postmeta.post_id FROM wpfa_postmeta, wpfa_posts WHERE meta_key = '_wc_billplz_id')

// wpdb

SELECT $wpdb->posts.ID
            FROM $wpdb->posts
            WHERE (post_status = 'wc-cancelled' OR post_status='wc-completed' OR post_status='wc-processing' OR post_status='wc-on-hold' OR post_status='wc-refunded' OR post_status='wc-failed')
            AND $wpdb->posts.ID
            IN
            (
            SELECT DISTINCT $wpdb->postmeta.post_id
            FROM $wpdb->postmeta, $wpdb->posts
            WHERE meta_key = '_wc_billplz_id')