More efficient query using a left outer join. 

This can save a lot of time in big environments.

We ran into problems when we were troubleshooting problems for a user, the query was literally taking hours to complete.