Keloran

SELECT project.name, project.startdate, project.enddate, SUM(status.completed) as status, users.usernameFROM projectLEFT JOIN status ON status.projectid = project.idLEFT JOIN users ON users.id = project.ownerWHERE SUM(status.completed) / 100 = 1GROUP BY project.idORDER BY enddate ASC