SELECT p.project_id, p.projectstatus, p.name, c.course_id, c.name AS courseName, GROUP_CONCAT (u.firstname SEPARATOR '<br />' AS studentFirstname, GROUP_CONCAT (u.lastname SEPARATOR '<br />' AS studentLastname,
				cp.firstname AS contactFirstname, cp.lastname AS contactLastname, d.firstname AS directorFirstname, d.lastname AS directorLastname,
				d.phone AS directorPhone, startdate AS startDate, endmonthestimate AS endMonthEstimate, description, specifieddescription AS specifiedDescription,
				contractnumber AS contractNumber
FROM users AS u
JOIN project_proposal AS pp ON u.username = pp.username
JOIN project AS p ON pp.pp_id = p.pp_id
JOIN contact_person as cp ON pp.pp_id = cp.pp_id
JOIN course AS c ON p.course_id = c.course_id
JOIN project_status AS ps ON p.projectstatus = ps.projectstatus
JOIN director AS d ON p.director_id = d.director_id
JOIN project_users AS pu ON p.project_id = pu.project_id
GROUP BY p.project_id, u.username