sTopics t, subjectCodes c WHERE (t.subjectCodeID = c.subjectCodeID) AND (t.askAQuestionID = \'_1_\')'][] = 'SELECT t.subjectCodeID, c.subjectName, c.parentSubjectCodeID FROM askAQuestionsTopics t, subjectCodes c WHERE (t.subjectCodeID = c.subjectCodeID) AND (t.askAQuestionID = \'_1_\')';
$cache['en']['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 (flag_isProfiled = 2) ORDER BY hitCount DESC LIMIT 3, 4'][] = '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 (flag_isProfiled = 2) ORDER BY hitCount DESC LIMIT 3, 4';
$cache['en']['SELECT regionName, regionID FROM regions '][] = 'SELECT regionName, regionID FROM regions';
$cache['fr']['SELECT CONCAT(firstName, \'_1_\', lastName) AS name, personID, distinctionBlurb, quote, portraitURL, story, youngScientist, gender, theScience, infoGraphic, mystery, career, flag_isExpert, expertArea, DATE_FORMAT(dob, dob_format) AS dob, DATE_FORMAT(dod, dod_format) AS dod, pob, pod, residence, workplace, title, workStatus, degrees, awards, familyMembers, mentors, favoriteMusic, interests, personality, URL, lastUpdated, hitCount FROM people WHERE (personID = \'_2_\') AND (flag_publish = 1)'][] = 'select concat(`people`.`firstName`, \'_1_\', `people`.`lastName`) as `name`, `people`.`personID`, ifnull(`people__fr`.`distinctionBlurb`, `people`.`distinctionBlurb`) as `distinctionBlurb`, ifnull(`people__fr`.`quote`, `people`.`quote`) as `quote`, `people`.`portraitURL`, ifnull(`people__fr`.`story`, `people`.`story`) as `story`, ifnull(`people__fr`.`youngScientist`, `people`.`youngScientist`) as `youngScientist`, `people`.`gender`, ifnull(`people__fr`.`theScience`, `people`.`theScience`) as `theScience`, ifnull(`people__fr`.`infoGraphic`, `people`.`infoGraphic`) as `infoGraphic`, ifnull(`people__fr`.`mystery`, `people`.`mystery`) as `mystery`, ifnull(`people__fr`.`career`, `people`.`career`) as `career`, `people`.`flag_isExpert`, `people`.`expertArea`, date_format(`people`.`dob`, `people`.`dob_format`) as `dob`, date_format(`people`.`dod`, `people`.`dod_format`) as `dod`, ifnull(`people__fr`.`pob`, `people`.`pob`) as `pob`, ifnull(`people__fr`.`pod`, `people`.`pod`) as `pod`, ifnull(`people__fr`.`residence`, `people`.`residence`) as `residence`, ifnull(`people__fr`.`workplace`, `people`.`workplace`) as `workplace`, ifnull(`people__fr`.`title`, `people`.`title`) as `title`, `people`.`workStatus`, ifnull(`people__fr`.`degrees`, `people`.`degrees`) as `degrees`, ifnull(`people__fr`.`awards`, `people`.`awards`) as `awards`, ifnull(`people__fr`.`familyMembers`, `people`.`familyMembers`) as `familyMembers`, ifnull(`people__fr`.`mentors`, `people`.`mentors`) as `mentors`, ifnull(`people__fr`.`favoriteMusic`, `people`.`favoriteMusic`) as `favoriteMusic`, ifnull(`people__fr`.`interests`, `people`.`interests`) as `interests`, ifnull(`people__fr`.`personality`, `people`.`personality`) as `personality`, `people`.`URL`, `people`.`lastUpdated`, `people`.`hitCount` from `people` left join `people_fr` as `people__fr` on `people`.`personID` = `people__fr`.`personID` where (`people`.`personID` = \'_2_\') and (`people`.`flag_publish` = 1)';
$cache['fr']['SELECT subjectName, careers FROM subjectCodes WHERE subjectCodeID = \'_1_\''][] = 'select ifnull(`subjectCodes__fr`.`subjectName`, `subjectCodes`.`subjectName`) as `subjectName`, ifnull(`subjectCodes__fr`.`careers`, `subjectCodes`.`careers`) as `careers` from `subjectCodes` left join `subjectCodes_fr` as `subjectCodes__fr` on `subjectCodes`.`subjectCodeID` = `subjectCodes__fr`.`subjectCodeID` where `subjectCodes`.`subjectCodeID` = \'_1_\'';
$cache['fr']['SELECT CONCAT(firstName, \'_1_\', lastName) AS name, personID FROM people WHERE (expertArea = \'_2_\') AND (flag_publish = 1) AND (personID != \'_3_\')'][] = 'select concat(`people`.`firstName`, \'_1_\', `people`.`lastName`) as `name`, `people`.`personID` from `people` where (`people`.`expertArea` = \'_2_\') and (`people`.`flag_publish` = 1) and (`people`.`personID` <> \'_3_\')';
$cache['fr']['SELECT askAQuestionID FROM askAAnswers WHERE answeringExpert = \'_1_\''][] = 'select `askAAnswers`.`askAQuestionID` from `askAAnswers` where `askAAnswers`.`answeringExpert` = \'_1_\'';
$cache['fr']['SELECT q.questionBody, q.askAQuestionID, t.subjectCodeID FROM askAQuestionsTopics t, askAQuestions q WHERE (q.askAQuestionID = \'_1_\') AND (q.flag_publish = \'_2_\') AND (q.askAQuestionID = t.askAQuestionID)'][] = 'select ifnull(`q__fr`.`questionBody`, `q`.`questionBody`) as `questionBody`, `q`.`askAQuestionID`, `t`.`subjectCodeID` from `askAQuestionsTopics` as `t`, `askAQuestions` as `q` left join `askAQuestions_fr` as `q__fr` on `q`.`askAQuestionID` = `q__fr`.`askAQuestionID` where (`q`.`askAQuestionID` = \'_1_\') and (`q`.`flag_publish` = \'_2_\') and (`q`.`askAQuestionID` = `t`.`askAQuestionID`)';
$cache['fr']['SELECT activityID, summary FROM activities WHERE personID = \'_1_\''][] = 'select `activities`.`activityID`, ifnull(`activities__fr`.`summary`, `activities`.`summary`) as `summary` from `activities` left join `activities_fr` as `activities__fr` on `activities`.`activityID` = `activities__fr`.`activityID` where `activities`.`personID` = \'_1_\'';
?>
science.ca