`, `people` as `p` left join `people_fr` as `p__fr` on `p`.`personID` = `p__fr`.`personID` where (`p`.`flag_publish` = 1) and (`s`.`subjectCodeID` = `p`.`expertArea`) and (`p`.`flag_isProfiled` = 2) order by `p`.`hitCount` desc limit 3,4';
$cache['fr']['SELECT regionName, regionID FROM regions '][] = 'select ifnull(`regions__fr`.`regionName`, `regions`.`regionName`) as `regionName`, `regions`.`regionID` from `regions` left join `regions_fr` as `regions__fr` on `regions`.`regionID` = `regions__fr`.`regionID`';
?>
science.ca