ectCodes` 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 t.subjectCodeID, c.subjectName, c.parentSubjectCodeID FROM askAQuestionsTopics t, subjectCodes c WHERE (t.subjectCodeID = c.subjectCodeID) AND (t.askAQuestionID = \'_1_\')'][] = 'select `t`.`subjectCodeID`, ifnull(`c__fr`.`subjectName`, `c`.`subjectName`) as `subjectName`, `c`.`parentSubjectCodeID` from `askAQuestionsTopics` as `t`, `subjectCodes` as `c` left join `subjectCodes_fr` as `c__fr` on `c`.`subjectCodeID` = `c__fr`.`subjectCodeID` where (`t`.`subjectCodeID` = `c`.`subjectCodeID`) and (`t`.`askAQuestionID` = \'_1_\')';
$cache['en']['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(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)';
$cache['en']['SELECT subjectName, careers FROM subjectCodes WHERE subjectCodeID = \'_1_\''][] = 'SELECT subjectName, careers FROM subjectCodes WHERE subjectCodeID = \'_1_\'';
$cache['en']['SELECT CONCAT(firstName, \'_1_\', lastName) AS name, personID FROM people WHERE (expertArea = \'_2_\') AND (flag_publish = 1) AND (personID != \'_3_\')'][] = 'SELECT CONCAT(firstName, \'_1_\', lastName) AS name, personID FROM people WHERE (expertArea = \'_2_\') AND (flag_publish = 1) AND (personID != \'_3_\')';
$cache['en']['SELECT activityID, summary FROM activities WHERE personID = \'_1_\''][] = 'SELECT activityID, summary FROM activities WHERE personID = \'_1_\'';
?>
science.ca Scientists