['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['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 hitCount, quizCorrect, quizIncorrect FROM siteStats WHERE siteStatsID = \'_1_\''][] = 'SELECT hitCount, quizCorrect, quizIncorrect FROM siteStats WHERE siteStatsID = \'_1_\'';
$cache['en']['SELECT COUNT(personID) AS count FROM people '][] = 'SELECT COUNT(personID) AS count FROM people';
$cache['en']['SELECT COUNT(personID) AS count, gender FROM people WHERE flag_isProfiled = 1 GROUP BY gender'][] = 'SELECT COUNT(personID) AS count, gender FROM people WHERE flag_isProfiled = 1 GROUP BY gender';
$cache['en']['SELECT DISTINCT expertArea FROM people WHERE flag_isProfiled = 1'][] = 'SELECT DISTINCT expertArea FROM people WHERE flag_isProfiled = 1';
$cache['en']['SELECT COUNT(personID) AS count FROM people WHERE flag_isExpert = \'_1_\''][] = 'SELECT COUNT(personID) AS count FROM people WHERE flag_isExpert = \'_1_\'';
$cache['en']['SELECT DISTINCT expertArea FROM people WHERE flag_isExpert = \'_1_\''][] = 'SELECT DISTINCT expertArea FROM people WHERE flag_isExpert = \'_1_\'';
$cache['en']['SELECT SUM(hitCount) AS sum FROM people WHERE (flag_isProfiled = 1) AND (hitCount != \'_1_\')'][] = 'SELECT SUM(hitCount) AS sum FROM people WHERE (flag_isProfiled = 1) AND (hitCount != \'_1_\')';
$cache['en']['SELECT COUNT(personID) AS count FROM people WHERE (flag_isProfiled = 1) AND (hitCount != \'_1_\')'][] = 'SELECT COUNT(personID) AS count FROM people WHERE (flag_isProfiled = 1) AND (hitCount != \'_1_\')';
$cache['en']['SELECT MIN(dob) AS min, MAX(dob) AS max FROM people WHERE (flag_isProfiled = 1) AND (dob != \'_1_\') AND (dob != \'_2_\')'][] = 'SELECT MIN(dob) AS min, MAX(dob) AS max FROM people WHERE (flag_isProfiled = 1) AND (dob != \'_1_\') AND (dob != \'_2_\')';
$cache['en']['SELECT COUNT(askAQuestionID) AS count FROM askAQuestions '][] = 'SELECT COUNT(askAQuestionID) AS count FROM askAQuestions';
$cache['en']['SELECT COUNT(askAAnswerID) AS count FROM askAAnswers '][] = 'SELECT COUNT(askAAnswerID) AS count FROM askAAnswers';
$cache['en']['SELECT AVG(askerAge) AS avg FROM askAQuestions WHERE askerAge > 1'][] = 'SELECT AVG(askerAge) AS avg FROM askAQuestions WHERE askerAge > 1';
$cache['en']['SELECT COUNT(askAQuestionID) AS count, askerGender FROM askAQuestions GROUP BY askerGender'][] = 'SELECT COUNT(askAQuestionID) AS count, askerGender FROM askAQuestions GROUP BY askerGender';
$cache['en']['SELECT COUNT(activityID) AS count FROM activities '][] = 'SELECT COUNT(activityID) AS count FROM activities';
$cache['en']['SELECT COUNT(quizID) AS count FROM quiz '][] = 'SELECT COUNT(quizID) AS count FROM quiz';
$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';
?>
science.ca