SELECT u.username AS 'ID'
        ,u.firstname AS 'Names'
        ,u.lastname AS 'Lastnames'
        ,u.email AS 'Email'

        ,IFNULL(ELT(MAX(IF(r.id = 6 AND cmc.coursemoduleid = 21, cmc.completionstate, NULL))+1,
            'Incomplete', 'Complete'),'Incomplete') AS 'Activity 1'
        ,IFNULL(ELT(MAX(IF(r.id = 7 AND cmc.coursemoduleid = 22, cmc.completionstate, NULL))+1,
            'Incomplete', 'Complete'),'Incomplete') AS 'Activity 2'
        ,IFNULL(ELT(MAX(IF(r.id = 8 AND cmc.coursemoduleid = 23, cmc.completionstate, NULL))+1,
            'Incomplete', 'Complete'),'Incomplete') AS 'Activity 3'


        ,IFNULL(ELT(MAX(IF(f.id = 1 AND cmc.coursemoduleid = 6, cmc.completionstate, NULL))+1,
            'Incomplete', 'Complete'),'Incomplete') AS 'Feedback'

        ,IFNULL(ELT(MAX(IF(q.id = 1 AND cmc.coursemoduleid = 5, cmc.completionstate, NULL))+1,
            'Incomplete', 'Complete', 'Passed', 'Failed'),'Incomplete') AS 'Quiz'

        ,IFNULL((LEFT(g.finalgrade,2)),'Incomplete') AS 'Grade' -- for some reason it's only pulling grades from one course, disregarding course set as parameter

        ,IFNULL(ELT(MAX(IF(cert.id = 1 AND cmc.coursemoduleid = 49, cmc.completionstate, NULL))+1,
            'Incomplete', 'Complete', 'Passed', 'Failed'),'Incomplete') AS 'Certificate'

FROM prefix_user u LEFT JOIN prefix_grade_grades g ON u.id = g.userid
INNER JOIN prefix_course_modules_completion cmc ON cmc.userid = u.id
INNER JOIN prefix_course_modules cm ON cmc.coursemoduleid = cm.id
INNER JOIN prefix_course c ON cm.course = c.id
INNER JOIN prefix_resource r ON c.id = r.course
INNER JOIN prefix_feedback f ON c.id = f.course
INNER JOIN prefix_quiz q ON c.id = q.course
INNER JOIN prefix_certificate cert ON c.id = cert.course

WHERE (u.id > 7) AND (u.firstaccess > 0) AND (c.id = 5)

GROUP BY u.id
ORDER BY u.firstname ASC