Farnborough College of Technology
FOR ADVICE CALL 01252 40 55 55
string(479) "SELECT cr.*,ci.mode,cr.id as linkid,ci.duration, ci.title as cTitle,DATE_FORMAT(ci.period_start,"%d/%m/%Y") as start_date,ci.time,ci.year_of_course,ci.days,ci.ref,ci.course_stage FROM courses_revisions cr INNER JOIN courses_imported ci ON ci.ref=cr.course_id WHERE ci.archive=0 and is_latest=1 AND REPLACE(ci.course_stage,'/','-') NOT IN (select course_stage from course_hidden) AND ci.ref ='APL2EN' AND cr.status_id=3 GROUP BY ci.course_stage ORDER BY ci.period_start ASC"