SELECT DISTINCT att.course AS courseid,att.name AS Module,attsess.id AS sessionid,attlog.studentid AS studentid,attlog.id AS logid,attlog.statusid AS statusid,attsta.description AS description
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
ORDER BY att.course,attsess.id,attlog.statusid