Pasted

-- 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;