Les cours sur lesquels est inscrit un utilisateur avec son rôle dans le cours

SELECT c.id, c.shortname, c.fullname, u.id, u.username, u.firstname, u.lastname, r.shortname as 'role'
From mdl_user as u
join mdl_user_enrolments ue on ue.userid=u.id  AND u.id=18434
join mdl_enrol en on ue.enrolid=en.id
join mdl_role_assignments ra on u.id=ra.userid
join mdl_role r on ra.roleid=r.id 
join mdl_context cx on cx.id = ra.contextid and cx.contextlevel = 50
JOIN mdl_course c ON c.id = cx.instanceid AND en.courseid = c.id;
 AND u.id=18434;