per(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';
$cache['en']['SELECT DISTINCT q.askAQuestionID, q.questionBody, q.askerName, q.askerLocation FROM askAQuestions q INNER JOIN askAAnswers a ON q.askAQuestionID = a.askAQuestionID WHERE (q.flag_publish = \'_1_\') AND (a.answeringExpert = \'_2_\') ORDER BY q.stat_timesViewed DESC LIMIT 1, 2'][] = 'SELECT DISTINCT q.askAQuestionID, q.questionBody, q.askerName, q.askerLocation FROM askAQuestions q INNER JOIN askAAnswers a ON q.askAQuestionID = a.askAQuestionID WHERE (q.flag_publish = \'_1_\') AND (a.answeringExpert = \'_2_\') 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';
?>
science.ca Scientists