['fr']['SELECT objective, materials, `procedure`, personID FROM activities WHERE activityID = \'_1_\''][] = 'select ifnull(`activities__fr`.`objective`, `activities`.`objective`) as `objective`, ifnull(`activities__fr`.`materials`, `activities`.`materials`) as `materials`, ifnull(`activities__fr`.`procedure`, `activities`.`procedure`) as `procedure`, `activities`.`personID` from `activities` left join `activities_fr` as `activities__fr` on `activities`.`activityID` = `activities__fr`.`activityID` where `activities`.`activityID` = \'_1_\'';
$cache['fr']['SELECT CONCAT(firstName, \'_1_\', lastName) AS name, portraitURL FROM people WHERE personID = \'_2_\''][] = 'select concat(`people`.`firstName`, \'_1_\', `people`.`lastName`) as `name`, `people`.`portraitURL` from `people` where `people`.`personID` = \'_2_\'';
$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_\')';
?>
science.ca