More efficient query using a left outer join. This can save a lot of time in big environments.