Rename and fix some methods for getting projects

I think this should be a normal "JOIN" not "LEFT JOIN", no?