SELECT DISTINCT att.course AS courseid,c.shortname AS NomAbregeducours,c.fullname AS NomduCours,att.name AS Module,attsess.id AS sessionid,FROM_UNIXTIME(attsess.sessdate) AS DateDébut,FROM_UNIXTIME(attsess.sessdate+attsess.duration) AS DateFin,
attlog.studentid AS studentid,u.firstname AS Prenom,u.lastname AS Nom,u.email AS Courriel,attlog.id AS logid,attlog.statusid AS statusid,attsta.description AS statut,attlog.remarks AS Remarques
FROM mdl2b_attendance AS att
JOIN mdl2b_attendance_sessions AS attsess ON attsess.attendanceid = att.id
JOIN mdl2b_attendance_log AS attlog ON attlog.sessionid = attsess.id
JOIN mdl2b_attendance_statuses AS attsta ON attsta.id = attlog.statusid
JOIN mdl2b_user AS u ON u.id = attlog.studentid
JOIN mdl2b_course AS c ON c.id = att.course
ORDER BY att.course,attsess.id,attlog.statusid;