.lastName), upper(p.firstName) ASC'][] = 'select `p`.`personID` 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`) <> \'_1_\') order by upper(`p`.`lastName`) asc, upper(`p`.`firstName`) asc';
$cache['fr']['SELECT CONCAT(p.firstName, \'_1_\', p.lastName) AS name, p.story, p.personID, p.portraitURL, s.parentSubjectCodeID FROM subjectCodes s, people p WHERE (p.flag_publish = 1) AND (s.subjectCodeID = p.expertArea) AND (p.personID = \'_2_\') ORDER BY upper(p.lastName), upper(p.firstName) ASC'][] = 'select concat(`p`.`firstName`, \'_1_\', `p`.`lastName`) as `name`, ifnull(`p__fr`.`story`, `p`.`story`) as `story`, `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`.`personID` = \'_2_\') order by upper(`p`.`lastName`) asc, upper(`p`.`firstName`) asc';
$cache['fr']['SELECT q.askAQuestionID FROM askAQuestions q WHERE (q.flag_publish = \'_1_\') AND (q.flag_qotw = \'_2_\') ORDER BY q.stat_timesViewed DESC'][] = 'select `q`.`askAQuestionID` from `askAQuestions` as `q` where (`q`.`flag_publish` = \'_1_\') and (`q`.`flag_qotw` = \'_2_\') order by `q`.`stat_timesViewed` desc';
$cache['fr']['SELECT q.askAQuestionID, q.questionBody, q.askerName, q.askerLocation FROM askAQuestions q WHERE (q.flag_publish = \'_1_\') AND (q.askAQuestionID = \'_2_\') ORDER BY q.stat_timesViewed DESC'][] = 'select `q`.`askAQuestionID`, ifnull(`q__fr`.`questionBody`, `q`.`questionBody`) as `questionBody`, `q`.`askerName`, ifnull(`q__fr`.`askerLocation`, `q`.`askerLocation`) as `askerLocation` from `askAQuestions` as `q` left join `askAQuestions_fr` as `q__fr` on `q`.`askAQuestionID` = `q__fr`.`askAQuestionID` where (`q`.`flag_publish` = \'_1_\') and (`q`.`askAQuestionID` = \'_2_\') order by `q`.`stat_timesViewed` desc';
$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 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['fr']['SELECT quizID FROM quiz WHERE (question != \'_1_\') AND (question IS NOT NULL)'][] = 'select `quiz`.`quizID` from `quiz` left join `quiz_fr` as `quiz__fr` on `quiz`.`quizID` = `quiz__fr`.`quizID` where (ifnull(`quiz__fr`.`question`, `quiz`.`question`) <> \'_1_\') and (ifnull(`quiz__fr`.`question`, `quiz`.`question`) is not null)';
$cache['fr']['SELECT quizID, question, answer_a, answer_b, answer_c, answer_d, answer, personID FROM quiz WHERE quizID = 1'][] = 'select `quiz`.`quizID`, ifnull(`quiz__fr`.`question`, `quiz`.`question`) as `question`, ifnull(`quiz__fr`.`answer_a`, `quiz`.`answer_a`) as `answer_a`, ifnull(`quiz__fr`.`answer_b`, `quiz`.`answer_b`) as `answer_b`, ifnull(`quiz__fr`.`answer_c`, `quiz`.`answer_c`) as `answer_c`, ifnull(`quiz__fr`.`answer_d`, `quiz`.`answer_d`) as `answer_d`, `quiz`.`answer`, `quiz`.`personID` from `quiz` left join `quiz_fr` as `quiz__fr` on `quiz`.`quizID` = `quiz__fr`.`quizID` where `quiz`.`quizID` = 1';
$cache['fr']['SELECT title, description, link, feedId FROM jobItems ORDER BY feedId ASC, `timestamp` DESC LIMIT 1'][] = 'select `jobItems`.`title`, `jobItems`.`description`, `jobItems`.`link`, `feedId` from `jobItems` order by `feedId` asc, `jobItems`.`timestamp` desc limit 1';
$cache['fr']['SELECT name, url FROM sponsors WHERE sponsors_list_included = \'_1_\' ORDER BY display_order ASC'][] = 'select ifnull(`sponsors__fr`.`name`, `sponsors`.`name`) as `name`, ifnull(`sponsors__fr`.`url`, `sponsors`.`url`) as `url` from `sponsors` left join `sponsors_fr` as `sponsors__fr` on `sponsors`.`sponsorID` = `sponsors__fr`.`sponsorID` where `sponsors`.`sponsors_list_included` = \'_1_\' order by `sponsors`.`display_order` asc';
?>
science.ca