Anonymous

SELECT recipients.id, email, taggings.tag_id FROM `recipients` LEFT OUTER JOIN `taggings` ON taggings.recipient_id = recipients.id WHERE recipients.account_id = 1 AND (taggings.tag_id IN (1) AND NOT taggings.tag_id IN (2));