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 = 'pu' UPDATE university SET hits = (hits + 1) WHERE universityID = '3' SELECT * FROM university_specialty WHERE hide = 0 AND universityID = '3' ORDER BY longName SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '329' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '329' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '329' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '329' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '329' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '329' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '329' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1056' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1056' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1056' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1056' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1056' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1056' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1056' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '435' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '435' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '435' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '560' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '330' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '330' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '330' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '394' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '437' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '437' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '437' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '386' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '331' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '331' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '331' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '374' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '332' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '332' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '332' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '374' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '333' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '333' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '333' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '398' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '334' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '334' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '334' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '397' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '482' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '482' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '482' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '401' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '347' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '347' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '347' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '399' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '348' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '348' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '348' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '376' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '441' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '441' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '441' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '560' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1106' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1106' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1106' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1106' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1106' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1106' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1106' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '444' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '444' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '444' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '383' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '440' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '440' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '440' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '393' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '442' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '442' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '442' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '384' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '447' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '447' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '447' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '388' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1107' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1107' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1107' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1107' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1107' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1107' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1107' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '445' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '445' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '445' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '386' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '443' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '443' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '443' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '559' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '446' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '446' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '446' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '388' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1060' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1060' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1060' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1060' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1060' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1060' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1060' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '349' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '349' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '349' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '408' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '425' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '425' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '425' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '397' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '426' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '426' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '426' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '397' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '427' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '427' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '427' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '424' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '474' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '474' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '474' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '583' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '471' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '471' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '471' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '374' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '475' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '475' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '475' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '583' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1061' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1061' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1061' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1061' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1061' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1061' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1061' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '450' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '450' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '450' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '394' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '484' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '484' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '484' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '402' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1066' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1066' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1066' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1066' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1066' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1066' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1066' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1062' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1062' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1062' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1062' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1062' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1062' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1062' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1063' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1063' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1063' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1063' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1063' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1063' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1063' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '439' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '439' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '439' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '439' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '439' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '560' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '448' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '448' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '448' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '448' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '448' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '560' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '490' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '490' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '490' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '410' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '491' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '491' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '491' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '410' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '469' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '469' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '469' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '374' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '473' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '473' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '473' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '374' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '481' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '481' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '481' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '397' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '485' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '485' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '485' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '402' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '492' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '492' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '492' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '411' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '480' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '480' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '480' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '397' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '464' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '464' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '464' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '408' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '460' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '460' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '460' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '404' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '457' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '457' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '457' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '562' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '468' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '468' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '468' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '468' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '468' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '468' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '468' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '405' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '467' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '467' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '467' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '467' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '467' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '421' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '465' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '465' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '465' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '465' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '465' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '407' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '463' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '463' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '463' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '463' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '463' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '463' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '463' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '406' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '495' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '495' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '495' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '641' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '489' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '489' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '489' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '409' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '462' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '462' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '462' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '404' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '461' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '461' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '461' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '404' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '438' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '438' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '438' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '438' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '438' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '382' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '470' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '470' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '470' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '374' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '458' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '458' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '458' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '563' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '10' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '10' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '10' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '559' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '434' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '434' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '434' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '434' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '434' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '555' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '453' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '453' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '453' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '422' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '456' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '456' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '456' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '562' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '459' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '459' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '459' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '562' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '451' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '451' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '451' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '565' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '452' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '452' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '452' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '565' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '455' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '455' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '455' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '562' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '494' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '494' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '494' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '410' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1064' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1064' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1064' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1064' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1064' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1064' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1064' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1065' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1065' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1065' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1065' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1065' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1065' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1065' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '454' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '454' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '454' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '396' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '479' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '479' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '479' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '583' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '478' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '478' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '478' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '478' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '478' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '583' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '449' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '449' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '449' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '425' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '493' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '493' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '493' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '410' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '436' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '436' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '436' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '561' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '483' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '483' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '483' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '402' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '488' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '488' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '488' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '402' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '487' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '487' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '487' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '402' SELECT longName, cityID, pix FROM university WHERE universityID = '3' SELECT * FROM pic WHERE ID='1' SELECT cityID, longName, pix FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '486' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '486' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '486' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '402' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '329' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '329' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1056' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1056' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '435' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '435' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '330' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '330' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '437' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '437' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '331' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '331' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '332' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '332' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '333' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '333' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '334' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '334' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '482' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '482' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '347' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '347' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '348' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '348' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '441' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '441' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1106' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1106' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '444' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '444' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '440' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '440' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '442' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '442' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '447' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '447' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1107' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1107' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '445' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '445' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '443' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '443' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '446' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '446' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1060' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1060' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '349' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '349' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '425' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '425' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '426' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '426' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '427' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '427' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '474' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '474' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '471' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '471' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '475' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '475' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1061' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1061' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '450' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '450' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '484' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '484' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1066' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1066' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1062' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1062' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1063' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1063' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '439' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '439' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '448' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '448' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '490' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '490' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '491' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '491' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '469' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '469' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '473' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '473' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '481' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '481' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '485' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '485' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '492' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '492' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '480' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '480' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '464' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '464' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '460' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '460' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '457' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '457' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '468' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '468' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '467' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '467' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '465' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '465' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '463' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '463' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '495' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '495' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '489' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '489' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '462' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '462' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '461' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '461' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '438' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '438' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '470' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '470' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '458' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '458' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '10' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '10' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '434' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '434' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '453' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '453' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '456' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '456' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '459' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '459' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '451' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '451' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '452' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '452' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '455' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '455' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '494' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '494' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1064' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1064' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1065' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1065' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '454' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '454' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '479' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '479' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '478' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '478' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '449' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '449' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '493' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '493' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '436' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '483' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '483' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '488' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '488' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '487' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '487' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '486' SELECT url FROM university WHERE universityID = '3' SELECT url FROM university WHERE universityID = '3' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '486'
|