ubjectCodeID = 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';
?>
science.ca Scientists