AND ( 
  wp_term_relationships.term_taxonomy_id IN (9573,9575,9576,9577,9578,9579,9582,9595,9596,9607,9611,9617,9618,9619,9620,9711) 
  AND 
  wp_posts.ID NOT IN (
				SELECT object_id
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (8982)
			)
) AND ( 
  ( wp_postmeta.meta_key = '_alaska_grown' AND wp_postmeta.meta_value IN ('yes') ) 
  AND 
  ( mt1.meta_key = '_made_in_alaska' AND mt1.meta_value IN ('yes') )
) 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')))