SELECT email
FROM user_user
WHERE blacklisted = 0
AND id NOT IN (
SELECT userid
FROM listuser
WHERE listid IN (3, 4, 5, 7, 11, 27)
);
SELECT email
FROM user_user
WHERE blacklisted = 0
AND id NOT IN (
SELECT userid
FROM listuser
WHERE listid IN (3, 4, 5, 7, 11, 27)
);