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 = 'unss' UPDATE university SET hits = (hits + 1) WHERE universityID = '8' SELECT * FROM university_specialty WHERE hide = 0 AND universityID = '8' ORDER BY longName SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '112' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '112' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '112' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '112' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '112' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '429' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '429' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '429' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '429' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '429' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '429' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '429' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1079' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1079' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1079' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1079' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1079' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1079' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1079' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '113' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '113' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '113' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '113' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '113' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '114' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '114' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '114' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '114' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '114' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '142' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1080' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1080' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1080' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1080' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1080' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1080' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1080' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '115' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '115' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '115' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '115' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '115' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '115' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '115' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '142' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1081' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1081' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1081' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1081' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1081' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1081' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1081' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '116' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '116' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '116' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '116' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '116' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '142' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '117' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '117' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '117' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '117' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '117' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '118' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '118' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '118' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '118' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '118' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '119' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '119' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '119' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '119' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '119' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1083' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1083' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1083' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1083' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1083' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1083' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1083' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '122' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '122' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '122' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '122' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '122' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '123' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '123' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '123' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '123' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '123' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '124' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '124' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '124' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '124' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '124' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '124' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '124' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '142' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1084' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1084' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1084' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1084' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1084' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1084' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1084' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '125' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '125' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '125' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '125' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '125' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '126' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '126' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '126' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '126' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '126' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1082' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1082' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1082' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1082' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1082' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1082' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1082' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1085' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1085' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1085' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1085' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1085' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1085' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1085' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '128' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '128' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '128' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '128' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '128' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '128' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '128' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '142' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1086' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1086' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1086' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1086' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1086' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1086' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1086' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '129' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '129' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '129' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '129' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '129' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '130' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '130' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '130' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '130' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '130' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1087' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1087' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1087' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1087' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1087' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1087' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1087' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '131' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '131' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '131' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '131' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '131' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '132' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '132' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '132' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '132' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '132' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '132' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '132' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '142' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1088' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1088' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1088' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1088' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1088' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1088' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1088' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '133' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '133' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '133' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '133' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '133' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '133' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '133' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '142' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1089' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1089' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1089' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1089' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1089' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1089' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1089' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '134' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '134' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '134' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '134' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '134' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '135' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '135' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '135' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '135' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '135' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '142' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '690' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '690' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '690' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '690' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '690' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '136' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '136' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '136' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '136' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '136' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '137' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '137' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '137' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '137' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '137' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '138' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '138' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '138' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '138' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '138' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '139' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '139' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '139' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '139' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '139' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '140' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '140' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '140' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '140' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '140' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '141' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '141' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '141' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '141' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '141' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '142' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '142' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '142' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '142' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '142' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '141' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '143' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '143' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '143' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '143' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '143' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '140' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1090' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1090' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1090' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1090' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1090' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1090' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1090' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '145' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '145' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '145' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '145' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '145' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '140' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '430' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '430' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '430' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '430' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '430' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '430' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '430' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '142' SELECT longName, cityID, pix FROM university WHERE universityID = '8' SELECT * FROM pic WHERE ID='19' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '146' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '146' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '146' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '146' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '146' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '140' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '112' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '112' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '429' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '429' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1079' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1079' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '113' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '113' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '114' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '114' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1080' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1080' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '115' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '115' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1081' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1081' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '116' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '116' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '117' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '117' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '118' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '118' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '119' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '119' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1083' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1083' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '122' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '122' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '123' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '123' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '124' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '124' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1084' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1084' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '125' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '125' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '126' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '126' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1082' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1082' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1085' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1085' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '128' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '128' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1086' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1086' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '129' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '129' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '130' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '130' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1087' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1087' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '131' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '131' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '132' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '132' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1088' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1088' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '133' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '133' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1089' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1089' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '134' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '134' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '135' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '135' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '690' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '690' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '136' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '136' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '137' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '137' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '138' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '138' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '139' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '139' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '140' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '140' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '141' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '141' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '142' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '142' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '143' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '143' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1090' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1090' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '145' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '145' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '430' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '430' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '146' SELECT url FROM university WHERE universityID = '8' SELECT url FROM university WHERE universityID = '8' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '146'
|