oncat(`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 (ifnull(`p__fr`.`infoGraphic`, `p`.`infoGraphic`) <> \'_2_\') order by upper(`p`.`lastName`) asc, upper(`p`.`firstName`) asc limit 2,3';
$cache['en']['SELECT q.askAQuestionID, q.questionBody, q.askerName, q.askerLocation FROM askAQuestions q WHERE q.flag_publish = \'_1_\' ORDER BY q.stat_timesViewed DESC LIMIT 1, 2'][] = 'SELECT q.askAQuestionID, q.questionBody, q.askerName, q.askerLocation FROM askAQuestions q WHERE q.flag_publish = \'_1_\' ORDER BY q.stat_timesViewed DESC LIMIT 1, 2';
$cache['en']['SELECT subjectName, subjectCodeID FROM subjectCodes WHERE parentSubjectCodeID = 1 ORDER BY subjectCodeID ASC'][] = 'SELECT subjectName, subjectCodeID FROM subjectCodes WHERE parentSubjectCodeID = 1 ORDER BY subjectCodeID ASC';
$cache['en']['SELECT t.subjectCodeID, c.subjectName, c.parentSubjectCodeID FROM askAQuestionsTopics 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 a.activityID, a.summary, CONCAT(p.firstName, \'_1_\', p.lastName) AS name, p.expertArea FROM people p, activities a WHERE (a.personID = p.personID) AND (a.type = \'_2_\') ORDER BY p.expertArea, p.lastName, p.firstName ASC LIMIT 1, 2'][] = 'SELECT a.activityID, a.summary, CONCAT(p.firstName, \'_1_\', p.lastName) AS name, p.expertArea FROM people p, activities a WHERE (a.personID = p.personID) AND (a.type = \'_2_\') ORDER BY p.expertArea, p.lastName, p.firstName ASC LIMIT 1, 2';
$cache['en']['SELECT name, url FROM sponsors WHERE sponsors_list_included = \'_1_\' ORDER BY display_order ASC'][] = 'SELECT name, url FROM sponsors WHERE sponsors_list_included = \'_1_\' ORDER BY display_order ASC';
$cache['en']['SELECT newsHeadline, newsBody, newsPostDate FROM news WHERE approved = \'_1_\' ORDER BY newsPostDate DESC LIMIT 1, 2'][] = 'SELECT newsHeadline, newsBody, newsPostDate FROM news WHERE approved = \'_1_\' ORDER BY newsPostDate DESC LIMIT 1, 2';
?>
science.ca Scientists