SELECT ra.*, r.name, r.shortname FROM {mdl_role_assignments} ra, {mdl_role} r, {mdl_context} c WHERE ra.userid = ? AND ra.roleid = r.id AND ra.contextid = c.id AND ra.contextid = ? ORDER BY c.contextlevel DESC, r.sortorder ASC
[edit]