g_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_\'';
$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 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 Scientifiques