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 WHERE wpvt_posts.post_type IN ('product') AND wpvt_posts.post_status = 'publish' AND ( ( SELECT COUNT(1) FROM wpvt_term_relationships WHERE term_taxonomy_id IN (3440) AND object_id = wpvt_posts.ID ) = 1 AND wpvt_posts.ID NOT IN ( SELECT object_id FROM wpvt_term_relationships WHERE term_taxonomy_id IN (7) ) ) )