(`t`.`subjectCodeID` = `c`.`subjectCodeID`) and (`t`.`askAQuestionID` = \'_1_\')'; $cache['fr']['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`, ifnull(`q__fr`.`questionBody`, `q`.`questionBody`) as `questionBody`, `q`.`askerName`, ifnull(`q__fr`.`askerLocation`, `q`.`askerLocation`) as `askerLocation` from `askAQuestions` as `q` INNER join `askAAnswers` as `a` on `q`.`askAQuestionID` = `a`.`askAQuestionID` left join `askAQuestions_fr` as `q__fr` on `q`.`askAQuestionID` = `q__fr`.`askAQuestionID` where (`q`.`flag_publish` = \'_1_\') and (`a`.`answeringExpert` = \'_2_\') order by `q`.`stat_timesViewed` desc limit 1,2'; $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'; $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 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 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'; ?> science.ca Scientists

Most popular scientists

No matches found.