ER 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['fr']['SELECT a.activityID, a.summary, CONCAT(p.firstName, \'_1_\', p.lastName) AS name, p.expertArea FROM people p, activities a WHERE (a.personID = p.personID) AND (a.type = \'_2_\') ORDER BY p.expertArea, p.lastName, p.firstName ASC LIMIT 1, 2'][] = 'select `a`.`activityID`, ifnull(`a__fr`.`summary`, `a`.`summary`) as `summary`, concat(`p`.`firstName`, \'_1_\', `p`.`lastName`) as `name`, `p`.`expertArea` from `people` as `p`, `activities` as `a` left join `activities_fr` as `a__fr` on `a`.`activityID` = `a__fr`.`activityID` where (`a`.`personID` = `p`.`personID`) and (`a`.`type` = \'_2_\') order by `p`.`expertArea` asc, `p`.`lastName` asc, `p`.`firstName` asc 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 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'; ?>