Query |
SET NAMES UTF8 SELECT u.universityID, u.longName as name, up.name as uniPic FROM users_apll ua INNER JOIN university_specialty AS us ON (ua.university_specialtyID = us.university_specialtyID) LEFT JOIN university AS u ON (u.universityID = us.universityID) LEFT JOIN pic AS up ON (up.ID = u.pix) WHERE userID = '' GROUP BY u.universityID ORDER BY u.longName ASC SELECT s.specialtyID, s.shortName, s.longName, s.url FROM specialty as s INNER JOIN university_specialty AS us ON (s.specialtyID = us.specialtyID) WHERE s.hide = 0 AND us.hide=0 GROUP BY specialtyID ORDER BY s.shortName SELECT universityID, longName as shortName,url FROM university WHERE hide = 0 ORDER BY shortName SELECT cityID, shortName FROM city WHERE hide = 0 AND cityID IN (SELECT cityID FROM university WHERE hide = 0) OR cityID IN (SELECT cityID FROM university_affiliate WHERE hide = 0) ORDER BY shortName SELECT universityID,longName,url,shortName FROM university WHERE url = 'su' UPDATE university SET hits = (hits + 1) WHERE universityID = '5' SELECT * FROM university_specialty WHERE hide = 0 AND universityID = '5' ORDER BY longName SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '185' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '13' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '13' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '13' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '13' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '13' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '13' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '13' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '197' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '3' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '3' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '3' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '3' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '3' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '3' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '3' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '202' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '172' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '172' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '172' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '172' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '172' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '172' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '172' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '166' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '173' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '173' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '173' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '173' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '173' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '173' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '173' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '175' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '17' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '17' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '17' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '17' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '17' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '17' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '17' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '533' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '174' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '174' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '174' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '174' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '174' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '174' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '174' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '182' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '175' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '175' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '175' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '175' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '175' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '175' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '175' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '525' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '176' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '176' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '176' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '176' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '176' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '176' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '176' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '547' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1072' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1072' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1072' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1072' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1072' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1072' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1072' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '177' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '177' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '177' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '177' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '177' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '177' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '177' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '547' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '178' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '178' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '178' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '178' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '178' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '178' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '178' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '547' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '179' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '179' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '179' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '179' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '179' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '179' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '179' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '547' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '180' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '180' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '180' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '180' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '180' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '180' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '180' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '528' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '181' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '181' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '181' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '181' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '181' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '181' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '181' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '243' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '18' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '18' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '18' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '18' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '18' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '18' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '18' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '235' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '182' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '182' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '182' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '182' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '182' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '182' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '182' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '548' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '183' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '183' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '183' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '183' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '183' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '183' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '183' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '236' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '184' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '184' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '184' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '184' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '184' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '184' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '184' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '165' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '185' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '185' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '185' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '185' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '185' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '185' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '185' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '547' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '186' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '186' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '186' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '186' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '186' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '270' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '187' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '187' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '187' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '187' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '187' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '187' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '187' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '173' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '188' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '188' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '188' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '188' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '188' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '188' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '188' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '242' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '189' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '189' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '189' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '189' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '189' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '189' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '189' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '554' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '190' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '190' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '190' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '190' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '190' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '190' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '190' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '550' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1073' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1073' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1073' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1073' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1073' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1073' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1073' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '543' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '543' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '543' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '543' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '543' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '543' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '543' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '200' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '192' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '192' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '192' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '192' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '192' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '192' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '192' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '530' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '193' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '193' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '193' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '193' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '193' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '193' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '193' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '268' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '194' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '194' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '194' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '194' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '194' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '194' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '194' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '211' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '195' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '195' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '195' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '195' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '195' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '195' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '195' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '214' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '196' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '196' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '196' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '196' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '196' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '196' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '196' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '198' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '535' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '535' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '535' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '535' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '535' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '535' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '535' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '189' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '225' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '225' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '225' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '225' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '225' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '225' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '225' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '287' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '226' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '226' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '226' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '226' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '226' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '226' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '226' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '174' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '696' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '696' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '696' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '696' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '696' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '696' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '696' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '177' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '534' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '534' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '534' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '534' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '534' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '534' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '534' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '188' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '227' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '227' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '227' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '227' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '227' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '227' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '227' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '537' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '542' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '542' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '542' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '542' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '542' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '542' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '542' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '199' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '228' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '228' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '228' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '228' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '228' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '228' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '228' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '192' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '229' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '229' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '229' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '229' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '229' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '229' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '229' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '244' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '230' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '230' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '230' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '230' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '230' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '230' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '230' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '267' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '231' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '231' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '231' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '231' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '231' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '231' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '231' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '212' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '232' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '232' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '232' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '232' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '232' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '232' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '232' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '536' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '546' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '546' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '546' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '546' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '546' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '546' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '546' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '289' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '233' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '233' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '233' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '233' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '233' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '233' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '233' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '162' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '234' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '234' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '234' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '234' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '234' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '234' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '234' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '254' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '260' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '260' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '260' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '260' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '260' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '260' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '260' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '203' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '261' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '261' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '261' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '261' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '261' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '261' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '261' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '205' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '686' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '686' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '686' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '686' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '686' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '686' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '686' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '260' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '688' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '688' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '688' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '688' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '688' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '688' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '688' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '261' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '687' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '687' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '687' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '687' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '687' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '687' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '687' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '262' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '699' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '699' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '699' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '699' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '699' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '699' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '699' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '535' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '262' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '262' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '262' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '262' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '262' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '262' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '262' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '241' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '263' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '263' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '263' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '263' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '263' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '263' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '263' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '176' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '264' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '264' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '264' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '264' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '264' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '264' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '264' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '547' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '265' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '265' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '265' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '265' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '265' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '265' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '265' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '257' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '702' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '702' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '702' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '702' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '702' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '702' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '702' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '251' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '532' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '532' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '532' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '532' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '532' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '532' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '532' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '541' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '266' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '266' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '266' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '266' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '266' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '266' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '266' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '171' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '539' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '539' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '539' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '539' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '539' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '539' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '539' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '194' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '267' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '267' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '267' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '267' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '267' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '267' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '267' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '226' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '268' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '268' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '268' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '268' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '268' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '268' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '268' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '169' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '269' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '269' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '269' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '269' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '269' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '269' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '269' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '255' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '270' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '270' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '270' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '270' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '270' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '270' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '270' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '160' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '536' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '536' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '536' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '536' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '536' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '190' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '694' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '694' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '694' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '694' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '694' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '694' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '694' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '240' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '271' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '271' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '271' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '271' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '271' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '271' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '271' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '249' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '701' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '701' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '701' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '701' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '701' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '701' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '701' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '250' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '272' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '272' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '272' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '272' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '272' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '272' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '272' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '204' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '273' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '273' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '273' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '273' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '273' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '273' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '273' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '159' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '285' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '285' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '285' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '285' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '285' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '285' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '285' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '524' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '286' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '286' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '286' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '286' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '286' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '286' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '286' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '238' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '540' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '540' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '540' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '540' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '540' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '540' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '540' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '195' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '697' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '697' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '697' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '697' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '697' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '697' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '697' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '179' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '537' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '537' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '537' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '537' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '537' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '537' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '537' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '191' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '530' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '530' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '530' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '530' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '530' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '530' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '530' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '545' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '292' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '292' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '292' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '292' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '292' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '292' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '292' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '213' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '293' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '293' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '293' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '293' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '293' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '293' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '293' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '252' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '296' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '296' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '296' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '296' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '296' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '170' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '297' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '297' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '297' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '297' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '297' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '297' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '297' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '544' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '298' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '298' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '298' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '298' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '298' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '298' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '298' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '253' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '299' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '299' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '299' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '299' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '299' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '299' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '299' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '206' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '700' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '700' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '700' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '700' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '700' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '700' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '700' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '551' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '300' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '300' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '300' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '300' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '300' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '300' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '300' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '552' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '301' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '301' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '301' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '301' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '301' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '301' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '301' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '237' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '541' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '541' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '541' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '541' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '541' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '541' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '541' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '196' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '538' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '538' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '538' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '538' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '538' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '538' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '538' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '193' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '689' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '689' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '689' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '689' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '689' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '689' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '689' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '227' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '302' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '302' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '302' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '302' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '302' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '302' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '302' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '529' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '698' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '698' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '698' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '698' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '698' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '698' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '698' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '534' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '303' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '303' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '303' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '303' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '303' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '303' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '303' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '532' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '304' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '304' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '304' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '304' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '304' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '304' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '304' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '259' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '305' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '305' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '305' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '305' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '305' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '305' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '305' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '585' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '306' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '306' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '306' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '306' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '306' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '538' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '533' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '533' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '533' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '533' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '533' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '533' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '533' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '187' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '307' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '307' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '307' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '307' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '307' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '307' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '307' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '264' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '308' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '308' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '308' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '308' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '308' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '308' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '308' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '265' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '309' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '309' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '309' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '309' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '309' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '309' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '309' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '269' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '310' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '310' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '310' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '310' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '310' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '310' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '310' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '546' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '311' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '311' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '311' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '311' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '311' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '311' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '311' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '531' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '312' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '312' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '312' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '312' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '312' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '312' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '312' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '271' SELECT longName, cityID, pix FROM university WHERE universityID = '5' SELECT * FROM pic WHERE ID='17' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '544' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '544' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '544' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '544' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '544' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '544' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '544' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '201' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '13' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '13' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '3' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '3' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '172' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '172' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '173' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '173' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '17' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '17' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '174' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '174' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '175' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '175' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '176' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '176' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1072' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1072' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '177' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '177' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '178' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '178' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '179' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '179' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '180' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '180' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '181' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '181' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '18' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '18' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '182' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '182' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '183' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '183' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '184' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '184' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '185' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '185' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '186' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '186' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '187' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '187' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '188' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '188' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '189' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '189' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '190' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '190' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1073' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1073' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '543' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '543' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '192' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '192' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '193' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '193' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '194' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '194' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '195' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '195' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '196' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '196' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '535' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '535' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '225' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '225' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '226' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '226' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '696' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '696' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '534' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '534' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '227' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '227' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '542' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '542' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '228' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '228' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '229' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '229' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '230' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '230' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '231' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '231' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '232' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '232' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '546' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '546' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '233' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '233' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '234' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '234' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '260' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '260' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '261' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '261' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '686' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '686' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '688' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '688' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '687' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '687' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '699' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '699' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '262' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '262' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '263' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '263' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '264' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '264' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '265' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '265' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '702' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '702' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '532' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '532' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '266' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '266' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '539' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '539' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '267' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '267' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '268' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '268' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '269' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '269' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '270' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '270' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '536' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '536' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '694' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '694' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '271' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '271' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '701' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '701' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '272' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '272' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '273' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '273' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '285' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '285' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '286' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '286' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '540' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '540' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '697' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '697' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '537' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '537' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '530' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '530' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '292' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '292' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '293' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '293' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '296' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '296' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '297' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '297' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '298' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '298' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '299' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '299' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '700' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '700' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '300' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '300' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '301' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '301' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '541' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '541' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '538' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '538' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '689' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '689' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '302' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '302' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '698' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '698' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '303' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '303' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '304' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '304' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '305' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '305' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '306' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '306' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '533' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '533' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '307' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '307' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '308' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '308' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '309' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '309' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '310' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '310' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '311' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '311' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '312' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '312' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '544' SELECT url FROM university WHERE universityID = '5' SELECT url FROM university WHERE universityID = '5' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '544'
|