COURSES
FILTER BY:
Location:
Course Type:
Suitable For:
string(4118) "SELECT ch.content as summary, cr.*,ci.archive,ci.title as cTitle,ci.id as courseid,ci.mode,ci.ref,ci.period_start,ci.duration,ci.site,ci.college,ci.ONLINEAPPREFERENCE,if( cx.cdStart IS null, period_start, cx.cdStart ) as newDate,  locate('culinary health and nutrition', ch.content) + locate('culinary health and nutrition', cr.MetaKeywords) + (locate('culinary health and nutrition', cdtitle) * 1000) + (locate('culinary health and nutrition', ci.TITLE) * 1000) + locate('culinary health and nutrition', cr.MetaDescription) as rel,short.duration as shortDuration,short.venue as shortLoc, DATE_FORMAT(short.startDate, '%d %M %Y') as shortDate, DATE_FORMAT(short.endDate, '%d %M %Y') as shortDate2, short.day as shortDay, short.times as shortTimes FROM courses_revisions cr 
INNER JOIN courses_dup dup ON cr.course_id=dup.id AND cr.is_latest = 1 AND cr.status_id !=99
INNER JOIN courses_dup_id dupid ON dupid.dup_id = dup.id
INNER JOIN courses_imported ci ON ci.id=dupid.course_id
LEFT OUTER JOIN course_sector cs ON cs.revision_id=cr.id
LEFT OUTER JOIN course_html ch on ch.id = cr.courseSummary 
LEFT OUTER JOIN cic_extras cx ON cx.CourseID=ci.id
LEFT OUTER JOIN bookeo short ON short.reference=replace(ci.id,'BOOK_','') 
WHERE   cr.is_latest=1 and (ci.college IN ('WKC') || short.showWKC=1)  AND (concat(' ',ch.content) LIKE '% culinary%' || concat(' ',cr.MetaKeywords) LIKE '% culinary%' || concat(' ',cr.MetaDescription) LIKE '% culinary%' || concat(' ',ci.TITLE) LIKE '% culinary%' || concat(' ',cr.cdSBTitle) like '% culinary%' || concat(' ',cr.CDTITLE) like '% culinary%' || concat(' ',cr.cdSPTitle) like '% culinary%'  || concat(' ',ch.content) LIKE '%(culinary%' || concat(' ',cr.MetaKeywords) LIKE '%(culinary%' || concat(' ',cr.MetaDescription) LIKE '%(culinary%' || concat(' ',ci.TITLE) LIKE '%(culinary%' || concat(' ',cr.cdSBTitle) like '%(culinary%' || concat(' ',cr.CDTITLE) like '%(culinary%' || concat(' ',cr.cdSPTitle) like '%(culinary%') AND (concat(' ',ch.content) LIKE '% health%' || concat(' ',cr.MetaKeywords) LIKE '% health%' || concat(' ',cr.MetaDescription) LIKE '% health%' || concat(' ',ci.TITLE) LIKE '% health%' || concat(' ',cr.cdSBTitle) like '% health%' || concat(' ',cr.CDTITLE) like '% health%' || concat(' ',cr.cdSPTitle) like '% health%'  || concat(' ',ch.content) LIKE '%(health%' || concat(' ',cr.MetaKeywords) LIKE '%(health%' || concat(' ',cr.MetaDescription) LIKE '%(health%' || concat(' ',ci.TITLE) LIKE '%(health%' || concat(' ',cr.cdSBTitle) like '%(health%' || concat(' ',cr.CDTITLE) like '%(health%' || concat(' ',cr.cdSPTitle) like '%(health%') AND (concat(' ',ch.content) LIKE '% and%' || concat(' ',cr.MetaKeywords) LIKE '% and%' || concat(' ',cr.MetaDescription) LIKE '% and%' || concat(' ',ci.TITLE) LIKE '% and%' || concat(' ',cr.cdSBTitle) like '% and%' || concat(' ',cr.CDTITLE) like '% and%' || concat(' ',cr.cdSPTitle) like '% and%'  || concat(' ',ch.content) LIKE '%(and%' || concat(' ',cr.MetaKeywords) LIKE '%(and%' || concat(' ',cr.MetaDescription) LIKE '%(and%' || concat(' ',ci.TITLE) LIKE '%(and%' || concat(' ',cr.cdSBTitle) like '%(and%' || concat(' ',cr.CDTITLE) like '%(and%' || concat(' ',cr.cdSPTitle) like '%(and%') AND (concat(' ',ch.content) LIKE '% nutrition%' || concat(' ',cr.MetaKeywords) LIKE '% nutrition%' || concat(' ',cr.MetaDescription) LIKE '% nutrition%' || concat(' ',ci.TITLE) LIKE '% nutrition%' || concat(' ',cr.cdSBTitle) like '% nutrition%' || concat(' ',cr.CDTITLE) like '% nutrition%' || concat(' ',cr.cdSPTitle) like '% nutrition%'  || concat(' ',ch.content) LIKE '%(nutrition%' || concat(' ',cr.MetaKeywords) LIKE '%(nutrition%' || concat(' ',cr.MetaDescription) LIKE '%(nutrition%' || concat(' ',ci.TITLE) LIKE '%(nutrition%' || concat(' ',cr.cdSBTitle) like '%(nutrition%' || concat(' ',cr.CDTITLE) like '%(nutrition%' || concat(' ',cr.cdSPTitle) like '%(nutrition%') and (short.showWKC=1 || short.showWKC is null) AND ci.archive = 0 AND  ci.id  NOT IN (select course_stage from course_hidden) AND cr.status_id=3  GROUP BY cr.id  ORDER BY  rel desc, if( CDTITLE = '', cTitle, cr.CDTITLE ) asc, ci.Level asc,period_start "
object(mysqli)#12925 (18) {
  ["affected_rows"]=>
  int(4)
  ["client_info"]=>
  string(6) "5.7.36"
  ["client_version"]=>
  int(50736)
  ["connect_errno"]=>
  int(0)
  ["connect_error"]=>
  NULL
  ["errno"]=>
  int(0)
  ["error"]=>
  string(0) ""
  ["error_list"]=>
  array(0) {
  }
  ["field_count"]=>
  int(1)
  ["host_info"]=>
  string(20) "127.0.0.1 via TCP/IP"
  ["info"]=>
  NULL
  ["insert_id"]=>
  int(0)
  ["server_info"]=>
  string(6) "5.7.36"
  ["server_version"]=>
  int(50736)
  ["sqlstate"]=>
  string(5) "00000"
  ["protocol_version"]=>
  int(10)
  ["thread_id"]=>
  int(11164255)
  ["warning_count"]=>
  int(0)
}