fr`.`regionID`'; $cache['fr']['SELECT subjectName, subjectCodeID FROM subjectCodes WHERE parentSubjectCodeID = 1 ORDER BY subjectCodeID ASC'][] = 'select ifnull(`subjectCodes__fr`.`subjectName`, `subjectCodes`.`subjectName`) as `subjectName`, `subjectCodes`.`subjectCodeID` from `subjectCodes` left join `subjectCodes_fr` as `subjectCodes__fr` on `subjectCodes`.`subjectCodeID` = `subjectCodes__fr`.`subjectCodeID` where `subjectCodes`.`parentSubjectCodeID` = 1 order by `subjectCodes`.`subjectCodeID` asc'; $cache['fr']['SELECT COUNT(p.personID) FROM subjectCodes s, people p WHERE (p.flag_publish = 1) AND (s.subjectCodeID = p.expertArea) AND (p.region LIKE \'_1_\') AND (p.gender LIKE \'_2_\') AND (s.parentSubjectCodeID LIKE \'_3_\') AND (p.flag_isProfiled = 2) ORDER BY upper(p.lastName), upper(p.firstName) ASC LIMIT 3, 4'][] = 'select count(`p`.`personID`) from `subjectCodes` as `s`, `people` as `p` where (`p`.`flag_publish` = 1) and (`s`.`subjectCodeID` = `p`.`expertArea`) and (`p`.`region` like \'_1_\') and (`p`.`gender` like \'_2_\') and (`s`.`parentSubjectCodeID` like \'_3_\') and (`p`.`flag_isProfiled` = 2) order by upper(`p`.`lastName`) asc, upper(`p`.`firstName`) asc limit 3,4'; $cache['fr']['SELECT CONCAT(p.firstName, \'_1_\', p.lastName) AS name, p.distinctionBlurb, p.expertArea, p.personID, p.portraitURL, s.parentSubjectCodeID FROM subjectCodes s, people p WHERE (p.flag_publish = 1) AND (s.subjectCodeID = p.expertArea) AND (p.region LIKE \'_2_\') AND (p.gender LIKE \'_3_\') AND (s.parentSubjectCodeID LIKE \'_4_\') AND (p.flag_isProfiled = 2) ORDER BY upper(p.lastName), upper(p.firstName) ASC LIMIT 3, 4'][] = 'select concat(`p`.`firstName`, \'_1_\', `p`.`lastName`) as `name`, ifnull(`p__fr`.`distinctionBlurb`, `p`.`distinctionBlurb`) as `distinctionBlurb`, `p`.`expertArea`, `p`.`personID`, `p`.`portraitURL`, `s`.`parentSubjectCodeID` from `subjectCodes` as `s`, `people` as `p` left join `people_fr` as `p__fr` on `p`.`personID` = `p__fr`.`personID` where (`p`.`flag_publish` = 1) and (`s`.`subjectCodeID` = `p`.`expertArea`) and (`p`.`region` like \'_2_\') and (`p`.`gender` like \'_3_\') and (`s`.`parentSubjectCodeID` like \'_4_\') and (`p`.`flag_isProfiled` = 2) order by upper(`p`.`lastName`) asc, upper(`p`.`firstName`) asc limit 3,4'; ?>