Attendance (plugin)

Hello friend,

I changed the code so that it will present the dates properly, I've also added a few things like the instructors email, etc. Hope this helps!

SELECT DISTINCT u.firstname, u.lastname, c.shortname AS 'class', attsess.sessdate as 'class date',
attsta.description, attsess.lasttakenby as 'instructor', attlog.remarks, attsta.grade, attsta.deleted,
FROM_UNIXTIME (attsess.sessdate, '%D %M %Y') AS 'Class Date', (SELECT u.username FROM mdl_user as u
WHERE exists
(
SELECT attsess.id from mdl_attendance_sessions
WHERE u.id=attsess.lasttakenby
)) as 'instructor'
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