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 ( wpvt_posts.ID NOT IN ( SELECT object_id FROM wpvt_term_relationships WHERE term_taxonomy_id IN (7) ) ) )