SELECT DISTINCT att.course AS courseid,c.shortname AS Nomducours,att.name AS Module,attsess.id AS sessionid,
attlog.studentid AS studentid,u.firstname AS Prenom,u.lastname AS Nom,attlog.id AS logid,attlog.statusid AS statusid,attsta.description AS description
FROM mdl_attendance AS att
JOIN mdl_attendance_sessions AS attsess ON attsess.attendanceid = att.id
JOIN mdl_attendance_log AS attlog ON attlog.sessionid = attsess.id
JOIN mdl_attendance_statuses AS attsta ON attsta.id = attlog.statusid
JOIN mdl_user AS u ON u.id = attlog.studentid
JOIN mdl_course AS c ON c.id = att.course
ORDER BY att.course,attsess.id,attlog.statusid;