AND ( 
  wp_term_relationships.term_taxonomy_id IN (9580,9581,9582,9583,9584,9585,9586,9587,9588,9589,9592,9594,9604,9609,9610,9611,9612,9613,9711) 
  AND 
  wp_posts.ID NOT IN (
				SELECT object_id
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (8982)
			)
) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'gd-sale-agreed' OR wp_posts.post_status = 'gd-under-offer')))