Moodle writes error if i trying to add a column (highlighted bold)
SELECT u.firstname AS 'First Name', u.lastname AS 'Last Name', (SELECT d1.data FROM prefix_user_info_data d1 JOIN prefix_user_info_field f1 ON d1.fieldid = f1.id AND f1.shortname = 'profname' WHERE d1.userid = u.id) AS 'Position', (SELECT d1.data FROM prefix_user_info_data d1 JOIN prefix_user_info_field f1 ON d1.fieldid = f1.id AND f1.shortname = 'companyname' WHERE d1.userid = u.id) AS 'Company', cc.name AS 'Partner type', institution AS 'Institution', city AS 'City', u.email AS 'E-mail', c.fullname AS 'Course', CASE WHEN gi.itemtype = 'Course' THEN c.fullname + ' Course Total' ELSE gi.itemname END AS 'Элемент курса', ROUND(gg.finalgrade,2) AS 'Grade', IFNULL((SELECT DATE_FORMAT(FROM_UNIXTIME(la.timeaccess), '%d.%m.%Y') FROM prefix_user_lastaccess la WHERE la.userid=u.id AND la.courseid=c.id),'Never') AS 'Date', (SELECT st.value FROM prefix_scorm_scoes_track AS st JOIN prefix_scorm AS sc ON sc.id=st.scormid WHERE st.ELEMENT='cmi.core.total_time') as 'Time Spent on Scorm', IF (ROUND(gg.finalgrade / gg.rawgrademax * 100 ,2) > 79,'Yes' , 'No') AS 'Certificate' 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_user AS u ON u.id = ra.userid JOIN prefix_grade_grades AS gg ON gg.userid = u.id JOIN prefix_grade_items AS gi ON gi.id = gg.itemid JOIN prefix_course_categories AS cc ON cc.id = c.category WHERE gi.courseid = c.id AND gi.itemname != 'Attendance' %%FILTER_CATEGORIES:c.category%% %%FILTER_COURSES:c.id%% GROUP BY u.firstname, u.lastname, u.email ORDER BY Name ASC
If i remove this line, report is working well.
Pleaese, help to fix a request.