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

        ,IFNULL(ELT(MAX(IF(r.id = 27 AND cmc.coursemoduleid = 43, cmc.completionstate, NULL))+1,
            'Unfinished', 'Finished'),'Unfinished') AS 'Activity 1'
        ,IFNULL(ELT(MAX(IF(r.id = 30 AND cmc.coursemoduleid = 46, cmc.completionstate, NULL))+1,
            'Unfinished', 'Finished'),'Unfinished') AS 'Activity 2'
        ,IFNULL(ELT(MAX(IF(r.id = 32 AND cmc.coursemoduleid = 48, cmc.completionstate, NULL))+1,
            'Unfinished', 'Finished'),'Unfinished') AS 'Activity 3'


        ,IFNULL(ELT(MAX(IF(f.id = 3 AND cmc.coursemoduleid = 10, cmc.completionstate, NULL))+1,
            'Unfinished', 'Finished'),'Unfinished') AS 'Feedback'

        ,IFNULL(ELT(MAX(IF(q.id = 3 AND cmc.coursemoduleid = 9, cmc.completionstate, NULL))+1,
            'Unfinished', 'Finished', 'Finished with pass', 'Finished with fail'),'Unfinished') AS 'Quiz'

        ,IFNULL((ROUND(g.finalgrade)),'Unfinished') AS 'Grade'

        ,IFNULL(ELT(MAX(IF(cert.id = 3 AND cmc.coursemoduleid = 51, cmc.completionstate, NULL))+1,
            'Unfinished', 'Finished'),'Unfinished') AS 'Certificate'

FROM prefix_user u
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
LEFT JOIN prefix_quiz q ON c.id = q.course
INNER JOIN prefix_certificate cert ON c.id = cert.course
LEFT JOIN prefix_grade_grades g ON u.id = g.userid
LEFT JOIN prefix_grade_items gi ON g.itemid = gi.id AND gi.itemtype = 'mod' AND gi.itemmodule = 'quiz' AND gi.iteminstance = q.id

WHERE (u.id > 2) AND (u.firstaccess > 0) AND (c.id = 3) AND ((gi.id = 6) OR (g.finalgrade IS NULL))

GROUP BY u.id
ORDER BY u.firstname ASC