FB Advanced WooCommerce - Rewritten query

-- Ref. https://www.facebook.com/groups/advanced.woocommerce/permalink/1339363232744759/
SELECT
    posts.ID
FROM
    posts
    INNER JOIN
    term_relationships ON
        (posts.ID = term_relationships.object_id)
    INNER JOIN
    postmeta ON
        ( posts.ID = postmeta.post_id )
    INNER JOIN
    postmeta AS mt1 ON
        ( posts.ID = mt1.post_id )
WHERE
        (term_relationships.term_taxonomy_id IN (2365,2366,2367,2374,2375,2376,2385,2386) )
        AND (postmeta.meta_key = '_price' AND ( ( mt1.meta_key = '_visibility' AND mt1.meta_value IN
('visible','catalog') ) ) )
        AND posts.post_type = 'product'
        AND (posts.post_status = 'publish' OR posts.post_status = 'private')
ORDER BY
    postmeta.meta_value DESC,
    posts.ID DESC
LIMIT 0, 10;