WHERE no_emails = 0 AND NOT EXISTS (SELECT 1 FROM channel_emails ce WHERE ce.channel_id = channels.id)