Strange, I see no reason for any of these queries to be slow. Good you
found one that works, but check your indexes when you get time - "the
possibility of duplicate indexes on columns being used in joins" may well
be the reason for the first two being so slow.

Set