SELECT min( min_price ) as min_price, MAX( max_price ) as max_price FROM wpvt_wc_product_meta_lookup WHERE product_id IN ( SELECT ID FROM wpvt_posts LEFT JOIN wpvt_term_relationships ON (wpvt_posts.ID = wpvt_term_relationships.object_id) LEFT JOIN wpvt_term_relationships AS tt1 ON (wpvt_posts.ID = tt1.object_id) LEFT JOIN wpvt_term_relationships AS tt2 ON (wpvt_posts.ID = tt2.object_id) WHERE wpvt_posts.post_type IN ('product') AND wpvt_posts.post_status = 'publish' AND ( wpvt_term_relationships.term_taxonomy_id IN (241) AND wpvt_posts.ID NOT IN ( SELECT object_id FROM wpvt_term_relationships WHERE term_taxonomy_id IN (7) ) AND ( tt1.term_taxonomy_id IN (241) AND wpvt_posts.ID NOT IN ( SELECT object_id FROM wpvt_term_relationships WHERE term_taxonomy_id IN (7) ) AND tt2.term_taxonomy_id IN (5061) ) ) )