Find a Training Solutions course
To find out what Training Solution courses are on offer select a category from the list below.
SELECT DISTINCT s.Section, s.Section_ID FROM courseinfo.course AS c
INNER JOIN courseinfo.coursetimes AS ct ON c.Course_ID = ct.Course_ID
INNER JOIN courseinfo.section AS s ON c.Section_ID = s.Section_ID
LEFT JOIN courseinfo.category AS cat ON c.Category = cat.Category_ID
LEFT JOIN courseinfo.award AS a ON c.Award = a.Award_ID
LEFT JOIN courseinfo.enrol AS e ON c.Enrol = e.Enrol_ID
LEFT JOIN courseinfo.location AS l ON ct.college = l.Location_ID
WHERE (c.Display > '0' AND ct.Location_Display > '0')
AND (c.Semester_Code = '2010/1' OR c.Semester_Code = '0000/0')
AND ((cat.Category_ID != '1' AND ct.Run_Date = '0')
OR (cat.Category_ID = '1' AND ct.Run_Date >= UNIX_TIMESTAMP() OR UPPER(ct.Run_Date) = 'TBA'))
AND (cat.Category_ID = '1' AND (s.Section_ID = '' AND (cat.Category_ID = '' AND (l.Location_ID = ''))
ORDER BY s.Section ASC
cat.Category_ID = '1' AND (s.Section_ID = '' AND (cat.Category_ID = '' AND (l.Location_ID = '')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY s.Section ASC' at line 13