troublesome_query.sql

SELECT COUNT(*)
FROM "users"
LEFT OUTER JOIN blacklisted_emails b_e ON LOWER(b_e.email) = LOWER(users.email)
LEFT OUTER JOIN
  (SELECT "campaign_emails".*
   FROM "campaign_emails"
   INNER JOIN "campaign_blasts" ON "campaign_blasts"."id" = "campaign_emails"."campaign_blast_id"
   INNER JOIN "email_campaigns" ON "email_campaigns"."id" = "campaign_blasts"."email_campaign_id"
   WHERE (email_campaigns.id = NULL)) c_e ON c_e.user_id = users.id
WHERE (b_e.email IS NULL)
  AND (c_e.id IS NULL)