<snip>
>I hate correlated subqueries. They are so slow.

Are you sure about that? The following query with correlated subquery will not be slower than any alternatives but is more readable

SELECT * FROM mytable mt1
  WHERE NOT EXISTS (SELECT * FROM mytable WHERE id = mt1.id)