SELECT DISTINCT mu.id, mu.firstname, mu.lastname, mu.email,FROM_UNIXTIME(mul.timeaccess, '%d %M %Y, %h:%i:%s'), mc.fullname, mr.shortname FROM mdl_user mu, mdl_user_enrolments mue, mdl_enrol me, mdl_course mc, mdl_role_assignments mra, mdl_role mr, mdl_user_lastaccess mul WHERE mu.id <> 5 AND mr.shortname = "editingteacher" AND mu.id = mue.userid AND mue.enrolid = me.id AND me.courseid = mc.id AND mc.fullname <> "ingles" AND mu.id = mra.userid AND mra.roleid = mr.id AND mu.id = mul.userid AND mul.courseid = mc.id




FROM mdl_user mu, mdl_user_enrolments mue, mdl_enrol me, mdl_course mc, mdl_role_assignments mra, mdl_role mr