['en']['SELECT regionName, regionID FROM regions '][] = 'SELECT regionName, regionID FROM regions'; $cache['en']['SELECT subjectName, subjectCodeID FROM subjectCodes WHERE parentSubjectCodeID = 1 ORDER BY subjectCodeID ASC'][] = 'SELECT subjectName, subjectCodeID FROM subjectCodes WHERE parentSubjectCodeID = 1 ORDER BY subjectCodeID ASC'; $cache['en']['SELECT COUNT(p.personID) FROM subjectCodes s, people p WHERE (p.flag_publish = 1) AND (s.subjectCodeID = p.expertArea) AND (p.region LIKE \'_1_\') AND (p.gender LIKE \'_2_\') AND (s.parentSubjectCodeID LIKE \'_3_\') AND (p.flag_isProfiled = 2) ORDER BY upper(p.lastName), upper(p.firstName) ASC LIMIT 3, 4'][] = 'SELECT COUNT(p.personID) FROM subjectCodes s, people p WHERE (p.flag_publish = 1) AND (s.subjectCodeID = p.expertArea) AND (p.region LIKE \'_1_\') AND (p.gender LIKE \'_2_\') AND (s.parentSubjectCodeID LIKE \'_3_\') AND (p.flag_isProfiled = 2) ORDER BY upper(p.lastName), upper(p.firstName) ASC LIMIT 3, 4'; $cache['en']['SELECT CONCAT(p.firstName, \'_1_\', p.lastName) AS name, p.distinctionBlurb, p.expertArea, p.personID, p.portraitURL, s.parentSubjectCodeID FROM subjectCodes s, people p WHERE (p.flag_publish = 1) AND (s.subjectCodeID = p.expertArea) AND (p.region LIKE \'_2_\') AND (p.gender LIKE \'_3_\') AND (s.parentSubjectCodeID LIKE \'_4_\') AND (p.flag_isProfiled = 2) ORDER BY upper(p.lastName), upper(p.firstName) ASC LIMIT 3, 4'][] = 'SELECT CONCAT(p.firstName, \'_1_\', p.lastName) AS name, p.distinctionBlurb, p.expertArea, p.personID, p.portraitURL, s.parentSubjectCodeID FROM subjectCodes s, people p WHERE (p.flag_publish = 1) AND (s.subjectCodeID = p.expertArea) AND (p.region LIKE \'_2_\') AND (p.gender LIKE \'_3_\') AND (s.parentSubjectCodeID LIKE \'_4_\') AND (p.flag_isProfiled = 2) ORDER BY upper(p.lastName), upper(p.firstName) ASC LIMIT 3, 4'; ?>