QuestionID, q.questionBody, q.askerName, q.askerLocation FROM askAQuestions q INNER JOIN askAQuestionsTopics t ON t.askAQuestionID = q.askAQuestionID INNER JOIN subjectCodes c ON t.subjectCodeID = c.subjectCodeID WHERE (q.flag_publish = \'_1_\') AND (c.parentSubjectCodeID = \'_2_\') ORDER BY q.stat_timesViewed DESC LIMIT 1, 2';
$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_\'';
$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 (flag_isProfiled = 2) ORDER BY hitCount DESC 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`.`flag_isProfiled` = 2) order by `p`.`hitCount` desc limit 3,4';
$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 regionName, regionID FROM regions '][] = 'select ifnull(`regions__fr`.`regionName`, `regions`.`regionName`) as `regionName`, `regions`.`regionID` from `regions` left join `regions_fr` as `regions__fr` on `regions`.`regionID` = `regions__fr`.`regionID`';
?>
science.ca Scientifiques