Rename and fix some methods for getting projects

From what I understood I need the "LEFT JOIN" because I need properties from the left side not just the id