Rename and fix some methods for getting projects

Never heard of a "JOIN", why is it better than "LEFT JOIN"?