newsHeadline, newsBody, newsPostDate FROM news WHERE approved = \'_1_\' ORDER BY newsPostDate DESC LIMIT 1, 2'][] = 'select ifnull(`news__fr`.`newsHeadline`, `news`.`newsHeadline`) as `newsHeadline`, ifnull(`news__fr`.`newsBody`, `news`.`newsBody`) as `newsBody`, `news`.`newsPostDate` from `news` left join `news_fr` as `news__fr` on `news`.`newsID` = `news__fr`.`newsID` where `news`.`approved` = \'_1_\' order by `news`.`newsPostDate` desc limit 1,2';
$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';
$cache['fr']['SELECT DISTINCT q.askAQuestionID, q.questionBody, q.askerName, q.askerLocation FROM askAQuestions q INNER JOIN askAAnswers a ON q.askAQuestionID = a.askAQuestionID WHERE (q.flag_publish = \'_1_\') AND (a.answeringExpert = \'_2_\') ORDER BY q.stat_timesViewed DESC LIMIT 1, 2'][] = 'select distinct `q`.`askAQuestionID`, ifnull(`q__fr`.`questionBody`, `q`.`questionBody`) as `questionBody`, `q`.`askerName`, ifnull(`q__fr`.`askerLocation`, `q`.`askerLocation`) as `askerLocation` from `askAQuestions` as `q` INNER join `askAAnswers` as `a` on `q`.`askAQuestionID` = `a`.`askAQuestionID` left join `askAQuestions_fr` as `q__fr` on `q`.`askAQuestionID` = `q__fr`.`askAQuestionID` where (`q`.`flag_publish` = \'_1_\') and (`a`.`answeringExpert` = \'_2_\') order by `q`.`stat_timesViewed` desc limit 1,2';
$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';
?>
science.ca Scientists