Spanish:
Les quiero dejar una consulta de la base de datos para conocer todos los estudiantes registrados en la base de datos
Google Translater
I want to leave a query of the database to know all the students registered in the database
SELECT
*
FROM
mdl_role
JOIN mdl_role_assignments ON mdl_role_assignments.roleid = mdl_role.id
JOIN mdl_user ON mdl_user.id = mdl_role_assignments.userid
JOIN mdl_context ON mdl_context.id = mdl_role_assignments.contextid
JOIN mdl_course ON mdl_course.id = mdl_context.instanceid
WHERE
mdl_role.shortname = 'student'