odes
WHERE subjectCodeID = \'_1_\'';
$cache['en']['SELECT subjectName
FROM subjectCodes
WHERE subjectCodeID = \'_1_\''][] = 'SELECT subjectName
FROM subjectCodes
WHERE subjectCodeID = \'_1_\'';
$cache['en']['SELECT answerBody, answeringExpert, answeringUser, answerTimestamp
FROM askAAnswers
WHERE askAQuestionID = \'_1_\'
AND flag_publish = \'_2_\'
ORDER BY answeringExpert DESC, answerTimestamp'][] = 'SELECT answerBody, answeringExpert, answeringUser, answerTimestamp
FROM askAAnswers
WHERE askAQuestionID = \'_1_\'
AND flag_publish = \'_2_\'
ORDER BY answeringExpert DESC, answerTimestamp';
$cache['en']['SELECT URL, linkName FROM askALinks WHERE linkCategory = \'_1_\''][] = 'SELECT URL, linkName FROM askALinks WHERE linkCategory = \'_1_\'';
$cache['fr']['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`, 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`.`flag_isProfiled` = 2) order by `p`.`hitCount` desc limit 3,4';
$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 regionName, regionID FROM regions '][] = 'select ifnull(`regions__fr`.`regionName`, `regions`.`regionName`) as `regionName`, `regions`.`regionID` from `regions` left join `regions_fr` as `regions__fr` on `regions`.`regionID` = `regions__fr`.`regionID`';
$cache['fr']['SELECT questionBody, askerName, askerAge, askerGender, askerLocation, questionTimestamp, stat_timesViewed, askAQuestionID FROM askAQuestions WHERE (askAQuestionID = \'_1_\') AND (flag_publish = \'_2_\')'][] = 'select ifnull(`askAQuestions__fr`.`questionBody`, `askAQuestions`.`questionBody`) as `questionBody`, `askAQuestions`.`askerName`, `askAQuestions`.`askerAge`, `askAQuestions`.`askerGender`, ifnull(`askAQuestions__fr`.`askerLocation`, `askAQuestions`.`askerLocation`) as `askerLocation`, `askAQuestions`.`questionTimestamp`, `askAQuestions`.`stat_timesViewed`, `askAQuestions`.`askAQuestionID` from `askAQuestions` left join `askAQuestions_fr` as `askAQuestions__fr` on `askAQuestions`.`askAQuestionID` = `askAQuestions__fr`.`askAQuestionID` where (`askAQuestions`.`askAQuestionID` = \'_1_\') and (`askAQuestions`.`flag_publish` = \'_2_\')';
$cache['fr']['SELECT subjectCodeID
FROM askAQuestionsTopics
WHERE askaquestionID = \'_1_\''][] = 'select `askAQuestionsTopics`.`subjectCodeID` from `askAQuestionsTopics` where `askaquestionID` = \'_1_\'';
$cache['fr']['SELECT parentSubjectCodeID
FROM subjectCodes
WHERE subjectCodeID = \'_1_\''][] = 'select `subjectCodes`.`parentSubjectCodeID` from `subjectCodes` where `subjectCodes`.`subjectCodeID` = \'_1_\'';
$cache['fr']['SELECT subjectName
FROM subjectCodes
WHERE subjectCodeID = \'_1_\''][] = 'select ifnull(`subjectCodes__fr`.`subjectName`, `subjectCodes`.`subjectName`) as `subjectName` from `subjectCodes` left join `subjectCodes_fr` as `subjectCodes__fr` on `subjectCodes`.`subjectCodeID` = `subjectCodes__fr`.`subjectCodeID` where `subjectCodes`.`subjectCodeID` = \'_1_\'';
$cache['fr']['SELECT answerBody, answeringExpert, answeringUser, answerTimestamp
FROM askAAnswers
WHERE askAQuestionID = \'_1_\'
AND flag_publish = \'_2_\'
ORDER BY answeringExpert DESC, answerTimestamp'][] = 'select ifnull(`askAAnswers__fr`.`answerBody`, `askAAnswers`.`answerBody`) as `answerBody`, `askAAnswers`.`answeringExpert`, `askAAnswers`.`answeringUser`, `askAAnswers`.`answerTimestamp` from `askAAnswers` left join `askAAnswers_fr` as `askAAnswers__fr` on `askAAnswers`.`askAAnswerID` = `askAAnswers__fr`.`askAAnswerID` where `askAAnswers`.`askAQuestionID` = \'_1_\' and `askAAnswers`.`flag_publish` = \'_2_\' order by `askAAnswers`.`answeringExpert` desc, `askAAnswers`.`answerTimestamp` asc';
$cache['fr']['SELECT personID, CONCAT(firstName, \'_1_\', lastName) AS name
FROM people
WHERE personID = \'_2_\''][] = 'select `people`.`personID`, concat(`people`.`firstName`, \'_1_\', `people`.`lastName`) as `name` from `people` where `people`.`personID` = \'_2_\'';
$cache['fr']['SELECT URL, linkName FROM askALinks WHERE linkCategory = \'_1_\''][] = 'select ifnull(`askALinks__fr`.`URL`, `askALinks`.`URL`) as `URL`, ifnull(`askALinks__fr`.`linkName`, `askALinks`.`linkName`) as `linkName` from `askALinks` left join `askALinks_fr` as `askALinks__fr` on `askALinks`.`askALinksID` = `askALinks__fr`.`askALinksID` where `askALinks`.`linkCategory` = \'_1_\'';
?>
science.ca