Q&A for scientific skepticism
SELECT * from users LEFT JOIN posts on users.id = posts.owneruserid WHERE posts.id IS NULL