Welding
string(656) "SELECT ch.content as summary, cr.*,ci.archive,ci.title as cTitle,ci.colourCat,ci.mode,ci.ref,ci.period_start,ci.duration,ci.site,cs.sector_id as secID, cr.id as revid FROM courses_revisions cr INNER JOIN course_sector cs on cs.revision_id=cr.id INNER JOIN course_cat ct on ct.revision_id=cr.id INNER JOIN courses_imported ci ON ci.ref=cr.course_id LEFT OUTER JOIN course_html ch on ch.id = cr.courseSummary WHERE cr.is_latest=1 AND ci.course_stage NOT IN (select course_stage from course_hidden) AND ci.archive = 0 AND ct.program_cat_id='17015' AND cr.status_id=3 GROUP BY ci.ref ORDER BY customSort asc, trim(cr.CDTITLE) ASC,cTitle asc, period_start"
