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 = 'shu' UPDATE university SET hits = (hits + 1) WHERE universityID = '24' SELECT * FROM university_specialty WHERE hide = 0 AND universityID = '24' ORDER BY longName SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '629' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '629' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '629' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '629' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '629' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '472' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '634' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '634' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '634' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '634' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '634' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '634' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '634' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '476' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '641' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '641' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '641' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '641' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '641' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '641' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '641' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '480' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '653' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '653' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '653' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '653' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '653' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '489' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '658' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '658' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '658' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '658' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '658' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '658' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '658' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '580' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '657' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '657' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '657' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '657' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '657' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '657' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '657' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '493' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '628' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '628' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '628' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '628' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '628' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '628' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '628' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '471' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1113' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1113' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1113' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1113' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1113' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1113' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1113' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '638' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '638' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '638' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '638' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '638' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '638' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '638' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '479' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '637' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '637' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '637' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '637' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '637' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '637' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '637' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '478' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '644' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '644' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '644' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '644' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '644' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '644' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '644' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '477' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '659' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '659' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '659' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '659' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '659' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '659' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '659' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '492' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '680' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '680' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '680' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '680' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '680' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '680' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '680' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '503' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '656' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '656' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '656' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '656' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '656' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '656' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '656' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '579' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '643' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '643' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '643' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '643' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '643' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '643' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '643' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '477' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '672' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '672' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '672' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '672' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '672' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '672' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '672' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '500' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '651' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '651' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '651' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '651' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '651' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '651' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '651' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '488' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '650' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '650' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '650' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '650' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '650' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '650' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '650' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '487' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '681' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '681' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '681' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '681' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '681' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '681' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '681' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '505' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '639' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '639' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '639' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '639' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '639' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '639' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '639' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '480' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '640' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '640' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '640' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '640' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '640' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '640' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '640' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '481' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '648' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '648' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '648' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '648' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '648' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '648' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '648' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '486' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '649' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '649' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '649' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '649' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '649' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '649' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '649' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '486' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1091' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1091' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1091' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1091' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1091' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1091' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1091' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '675' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '675' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '675' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '675' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '675' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '675' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '675' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '504' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '645' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '645' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '645' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '645' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '645' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '645' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '645' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '486' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '647' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '647' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '647' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '647' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '647' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '647' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '647' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '486' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '671' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '671' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '671' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '671' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '671' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '671' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '671' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '499' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '666' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '666' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '666' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '666' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '666' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '666' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '666' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '498' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '662' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '662' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '662' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '662' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '662' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '662' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '662' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '663' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '663' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '663' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '663' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '663' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '663' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '663' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '664' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '664' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '664' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '664' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '664' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '664' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '664' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '631' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '631' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '631' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '631' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '631' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '631' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '631' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '473' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1092' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1092' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1092' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1092' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1092' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1092' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1092' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '661' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '661' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '661' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '661' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '661' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '661' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '661' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '495' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '632' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '632' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '632' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '632' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '632' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '632' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '632' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '473' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '676' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '676' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '676' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '676' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '676' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '676' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '676' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '504' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '682' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '682' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '682' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '682' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '682' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '682' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '682' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '506' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '669' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '669' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '669' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '669' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '669' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '669' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '669' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '670' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '670' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '670' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '670' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '670' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '670' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '670' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1093' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1093' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1093' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1093' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1093' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1093' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1093' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '646' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '646' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '646' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '646' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '646' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '646' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '646' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '487' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '642' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '642' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '642' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '642' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '642' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '642' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '642' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '485' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '674' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '674' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '674' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '674' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '674' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '674' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '674' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '501' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '660' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '660' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '660' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '660' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '660' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '660' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '660' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '496' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '633' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '633' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '633' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '633' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '633' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '633' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '633' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '474' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '652' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '652' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '652' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '652' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '652' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '652' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '652' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '489' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '673' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '673' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '673' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '673' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '673' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '673' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '673' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '502' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '654' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '654' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '654' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '654' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '654' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '654' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '654' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '490' SELECT longName, cityID, pix FROM university WHERE universityID = '24' SELECT * FROM pic WHERE ID='44' SELECT cityID, longName, pix FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '655' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '655' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '655' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '655' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '655' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '655' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '655' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '490' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '629' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '629' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '634' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '634' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '641' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '641' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '653' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '653' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '658' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '658' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '657' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '657' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '628' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '628' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1113' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1113' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '638' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '638' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '637' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '637' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '644' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '644' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '659' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '659' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '680' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '680' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '656' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '656' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '643' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '643' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '672' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '672' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '651' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '651' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '650' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '650' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '681' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '681' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '639' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '639' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '640' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '640' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '648' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '648' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '649' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '649' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1091' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1091' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '675' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '675' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '645' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '645' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '647' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '647' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '671' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '671' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '666' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '666' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '662' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '662' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '663' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '663' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '664' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '664' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '631' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '631' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1092' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1092' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '661' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '661' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '632' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '632' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '676' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '676' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '682' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '682' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '669' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '669' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '670' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '670' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1093' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1093' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '646' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '646' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '642' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '642' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '674' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '674' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '660' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '660' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '633' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '633' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '652' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '652' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '673' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '673' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '654' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '654' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '655' SELECT url FROM university WHERE universityID = '24' SELECT url FROM university WHERE universityID = '24' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '655'
|