presently running Moodle 2.6. IIS 7, Server 2008 R2, MariaDB 5.x and PHP 5.6. I am trying to pull a report using the configurable reports plugin and am having issues with some sql statements. I am trying to generate a report showing all Moodle classes, with their full names and their Course ID Number. I am using a an adhoc report as follows.

SELECT

USER.firstname AS Firstname,

USER.lastname AS Lastname,

USER.idnumber Employee_ID,

course.fullname AS Course

FROM prefix_course AS course 

JOIN prefix_enrol AS en ON en.courseid = course.id

JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id

JOIN prefix_user AS USER ON USER.id = ue.userid

 

WHERE USER.id NOT IN (

SELECT u.id

FROM prefix_course AS c

JOIN prefix_context AS ctx ON c.id = ctx.instanceid

JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id

JOIN prefix_role AS r ON r.id = ra.roleid

JOIN prefix_user AS u ON u.id = ra.userid

WHERE c.id=course.id

)

ORDER BY Course, Lastname, Firstname

I am trying to use the following SQL to pull the Course ID Number without success"

c.idnumber AS CourseIDNum

after this section:

USER.firstname AS Firstname,

USER.lastname AS Lastname,

USER.idnumber Employee_ID,

course.fullname AS Course

c.idnumber AS CourseIDNum

But I get a message saying error. 

What am I missing?