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) WHERE wpvt_posts.post_type IN ('product') AND wpvt_posts.post_status = 'publish' AND ( wpvt_posts.ID NOT IN ( SELECT object_id FROM wpvt_term_relationships WHERE term_taxonomy_id IN (7) ) AND ( wpvt_posts.ID NOT IN ( SELECT object_id FROM wpvt_term_relationships WHERE term_taxonomy_id IN (7) ) AND wpvt_term_relationships.term_taxonomy_id IN (1746,1797,1807,1808,1809) ) ) )