from `subjectCodes` left join `subjectCodes_fr` as `subjectCodes__fr` on `subjectCodes`.`subjectCodeID` = `subjectCodes__fr`.`subjectCodeID` where `subjectCodes`.`subjectCodeID` = \'_1_\'';
$cache['fr']['SELECT CONCAT(firstName, \'_1_\', lastName) AS name, personID FROM people WHERE (expertArea = \'_2_\') AND (flag_publish = 1) AND (personID != \'_3_\')'][] = 'select concat(`people`.`firstName`, \'_1_\', `people`.`lastName`) as `name`, `people`.`personID` from `people` where (`people`.`expertArea` = \'_2_\') and (`people`.`flag_publish` = 1) and (`people`.`personID` <> \'_3_\')';
$cache['fr']['SELECT activityID, summary FROM activities WHERE personID = \'_1_\''][] = 'select `activities`.`activityID`, ifnull(`activities__fr`.`summary`, `activities`.`summary`) as `summary` from `activities` left join `activities_fr` as `activities__fr` on `activities`.`activityID` = `activities__fr`.`activityID` where `activities`.`personID` = \'_1_\'';
?>
science.ca