Estimados, estamos realizando algunas consultas sql para armar reportes personalizados que luego se incluirán en distintos roles.
Armamos esta consulta pero demora años en guardarse y luego siglos en armar el reporte.. que podrá ser?
SELECT
lastname as ‘Apellido’,
firstname as ‘Nombre’,
cur.shortname as ‘Materia’ ,
##ccat.name as ‘Carrera’,
DATE_FORMAT(FROM_UNIXTIME(MAX(l.time)),'%d-%m-20%y') as ‘Ultimo_acceso’
FROM prefix_user AS user
left JOIN prefix_log AS l ON user.id=l.userid
INNER JOIN prefix_role_assignments AS role ON user.id = role.userid
INNER JOIN prefix_context AS c ON c.id = role.contextid
INNER JOIN prefix_course AS cur ON cur.id=c.instanceid
##INNER JOIN prefix_course_categories AS ccat ON ccat.id = cur.category
LEFT JOIN prefix_user_lastaccess AS ul ON ul.userid = user.id
WHERE role.roleid=3
GROUP BY cur.id