getting moodle roles

SELECT u.idnumber, u.firstname, u.lastname, r.id, r.roleid, c.idnumber AS m_name, c.id AS c_id, role.shortname
FROM mdl_user u
LEFT JOIN mdl_role_assignments r ON u.id = r.userid
LEFT JOIN mdl_role role ON r.roleid = role.id
LEFT JOIN mdl_context c1 ON r.contextid = c1.id
LEFT JOIN mdl_course c ON c1.instanceid = c.id
WHERE u.idnumber =  'p.fagan'
AND (
c.idnumber NOT LIKE  'C%'
AND c.idnumber NOT LIKE  '%-E-%'
AND c.idnumber NOT LIKE  '%-S-%'
AND c.idnumber NOT LIKE  '%-A-%'
AND c.idnumber NOT LIKE  '%-P-%'
AND c.idnumber NOT LIKE  '%-AD-%'
)