‚Äč

COURSES
FILTER BY:
Suitable For:
string(1388) "SELECT ch.content as summary, cr.*,ci.archive,ci.id as courseid,ci.title as cTitle,ci.mode,ci.ref,ci.period_start,ci.college,ci.duration,ci.site,ci.Level,ci.ONLINEAPPREFERENCE,if( cx.cdStart IS null, period_start, cx.cdStart ) as newDate,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 || ci.id=dupid.course_id and ci.college= 'BOOKEO')
INNER JOIN course_cat ccat ON ccat.revision_id=cr.id
INNER JOIN program_ids ccat2 ON ccat2.id=ccat.program_cat_id
LEFT OUTER JOIN bookeo short ON short.reference=replace(ci.id,'BOOK_','')
LEFT OUTER JOIN course_html ch on ch.id = cr.courseSummary 
LEFT OUTER JOIN cic_extras cx ON cx.CourseID=ci.id
WHERE   cr.is_latest=1 and ci.id NOT IN (select course_stage from course_hidden) and (short.showWKC=1 || short.showWKC is null) and ci.college IN ('WKC','BOOKEO') and (ccat.program_cat_id=523 || ccat2.wkcCat=523)  AND ci.archive = 0 AND cr.status_id=3  GROUP BY cr.id ORDER BY period_start ASC, if( CDTITLE = '', cTitle, cr.CDTITLE ) asc, ci.Level ASC"
object(mysqli)#12746 (18) {
  ["affected_rows"]=>
  int(0)
  ["client_info"]=>
  string(6) "5.7.35"
  ["client_version"]=>
  int(50735)
  ["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(9140565)
  ["warning_count"]=>
  int(0)
}