from `askAQuestions` as `q` INNER join `askAQuestionsTopics` as `t` on `t`.`askAQuestionID` = `q`.`askAQuestionID` INNER join `subjectCodes` as `c` on `t`.`subjectCodeID` = `c`.`subjectCodeID` left join `askAQuestions_fr` as `q__fr` on `q`.`askAQuestionID` = `q__fr`.`askAQuestionID` where (`q`.`flag_publish` = \'_1_\') and (`c`.`parentSubjectCodeID` = \'_2_\') order by `q`.`stat_timesViewed` desc limit 1,2';
$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_\')';
?>
science.ca