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['en']['SELECT questionBody, askerName, askerAge, askerGender, askerLocation, questionTimestamp, stat_timesViewed, askAQuestionID FROM askAQuestions WHERE (askAQuestionID = \'_1_\') AND (flag_publish = \'_2_\')'][] = 'SELECT questionBody, askerName, askerAge, askerGender, askerLocation, questionTimestamp, stat_timesViewed, askAQuestionID FROM askAQuestions WHERE (askAQuestionID = \'_1_\') AND (flag_publish = \'_2_\')';
$cache['en']['SELECT subjectCodeID
FROM askAQuestionsTopics
WHERE askaquestionID = \'_1_\''][] = 'SELECT subjectCodeID
FROM askAQuestionsTopics
WHERE askaquestionID = \'_1_\'';
$cache['en']['SELECT parentSubjectCodeID
FROM subjectCodes
WHERE subjectCodeID = \'_1_\''][] = 'SELECT parentSubjectCodeID
FROM subjectCodes
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 personID, CONCAT(firstName, \'_1_\', lastName) AS name
FROM people
WHERE personID = \'_2_\''][] = 'SELECT personID, CONCAT(firstName, \'_1_\', lastName) AS name
FROM people
WHERE personID = \'_2_\'';
$cache['en']['SELECT URL, linkName FROM askALinks WHERE linkCategory = \'_1_\''][] = 'SELECT URL, linkName FROM askALinks WHERE linkCategory = \'_1_\'';
?>
science.ca