T 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 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['fr']['SELECT feedbackName, feedbackBody, feedbackTime FROM feedback WHERE flag_publish = 1 ORDER BY feedbackTime DESC LIMIT 2, 3'][] = 'select `feedback`.`feedbackName`, ifnull(`feedback__fr`.`feedbackBody`, `feedback`.`feedbackBody`) as `feedbackBody`, `feedback`.`feedbackTime` from `feedback` left join `feedback_fr` as `feedback__fr` on `feedback`.`feedbackID` = `feedback__fr`.`feedbackID` where `feedback`.`flag_publish` = 1 order by `feedback`.`feedbackTime` desc limit 2,3';
$cache['fr']['SELECT name, url FROM sponsors WHERE sponsors_list_included = \'_1_\' ORDER BY display_order ASC'][] = 'select ifnull(`sponsors__fr`.`name`, `sponsors`.`name`) as `name`, ifnull(`sponsors__fr`.`url`, `sponsors`.`url`) as `url` from `sponsors` left join `sponsors_fr` as `sponsors__fr` on `sponsors`.`sponsorID` = `sponsors__fr`.`sponsorID` where `sponsors`.`sponsors_list_included` = \'_1_\' order by `sponsors`.`display_order` asc';
?>odeID ASC';
?>
science.ca