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 {attendance} AS att
JOIN {attendance}_sessions AS attsess ON attsess.attendanceid = att.id
JOIN {attendance_log} AS attlog ON attlog.sessionid = attsess.id
JOIN {attendance_statuses} AS attsta ON attsta.id = attlog.statusid
JOIN {user} AS u ON u.id = attlog.studentid
JOIN {course} AS c ON c.id = att.course
ORDER BY att.course,attsess.id,attlog.statusid