odes`.`subjectCodeID` = `subjectCodes__fr`.`subjectCodeID` where `subjectCodes`.`parentSubjectCodeID` = 1 order by `subjectCodes`.`subjectCodeID` asc'; $cache['en']['SELECT questionBody, askerName, askerAge, askerGender, askerLocation, questionTimestamp, stat_timesViewed, askAQuestionID FROM askAQuestions WHERE (askAQuestionID = \'_1_\') AND (flag_publish = \'_2_\')'][] = 'SELECT questionBody, askerName, askerAge, askerGender, askerLocation, questionTimestamp, stat_timesViewed, askAQuestionID FROM askAQuestions WHERE (askAQuestionID = \'_1_\') AND (flag_publish = \'_2_\')'; $cache['en']['SELECT subjectCodeID FROM askAQuestionsTopics WHERE askaquestionID = \'_1_\''][] = 'SELECT subjectCodeID FROM askAQuestionsTopics WHERE askaquestionID = \'_1_\''; $cache['en']['SELECT parentSubjectCodeID FROM subjectCodes WHERE subjectCodeID = \'_1_\''][] = 'SELECT parentSubjectCodeID FROM subjectCodes WHERE subjectCodeID = \'_1_\''; $cache['en']['SELECT subjectName FROM subjectCodes WHERE subjectCodeID = \'_1_\''][] = 'SELECT subjectName FROM subjectCodes WHERE subjectCodeID = \'_1_\''; $cache['en']['SELECT answerBody, answeringExpert, answeringUser, answerTimestamp FROM askAAnswers WHERE askAQuestionID = \'_1_\' AND flag_publish = \'_2_\' ORDER BY answeringExpert DESC, answerTimestamp'][] = 'SELECT answerBody, answeringExpert, answeringUser, answerTimestamp FROM askAAnswers WHERE askAQuestionID = \'_1_\' AND flag_publish = \'_2_\' ORDER BY answeringExpert DESC, answerTimestamp'; $cache['en']['SELECT personID, CONCAT(firstName, \'_1_\', lastName) AS name FROM people WHERE personID = \'_2_\''][] = 'SELECT personID, CONCAT(firstName, \'_1_\', lastName) AS name FROM people WHERE personID = \'_2_\''; $cache['en']['SELECT URL, linkName FROM askALinks WHERE linkCategory = \'_1_\''][] = 'SELECT URL, linkName FROM askALinks WHERE linkCategory = \'_1_\''; $cache['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'; ?>