It turns out, I had forgotten to put ParentProjects.ProjectID in the GROUP BY clause (as the error was indeed claiming). But the error message said "Projects.ProjectID" because it was...

I only put the ParentProject.ProjectID in the ORDER BY because i was trying to simplify the code as much as possible before posting. I get the exact same error, regardless...