| 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 = 'yuzu'
UPDATE university SET hits = (hits + 1) WHERE universityID = '9'
SELECT * FROM university_specialty WHERE hide = 0 AND universityID = '9' ORDER BY longName
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '43' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '43' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '43' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '43' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '43' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '43' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '43' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '45' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '45' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '45' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '45' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '45' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '45' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '45' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '46' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '46' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '46' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '46' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '46' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '46' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '46' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '48' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '48' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '48' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '48' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '48' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '48' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '48' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '49' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '49' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '49' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '49' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '49' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '49' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '49' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '50' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '50' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '50' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '50' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '50' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '50' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '50' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '54' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '54' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '54' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '54' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '54' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '54' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '54' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '55' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '55' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '55' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '55' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '55' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '55' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '55' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '111' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '111' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '111' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '111' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '111' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '111' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '111' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1095' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1095' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1095' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1095' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1095' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1095' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1095' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1094' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1094' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1094' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1094' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1094' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1094' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1094' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '61' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '61' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '61' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '61' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '61' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '61' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '61' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '62' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '62' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '62' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '62' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '62' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '62' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '62' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '63' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '63' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '63' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '63' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '63' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '63' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '63' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '64' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '64' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '64' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '64' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '64' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '64' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '64' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '65' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '65' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '65' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '65' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '65' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '65' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '65' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '66' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '66' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '66' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '66' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '66' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '66' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '66' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '67' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '67' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '67' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '67' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '67' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '67' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '67' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1096' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1096' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1096' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1096' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1096' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1096' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1096' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1097' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1097' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1097' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1097' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1097' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1097' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1097' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '68' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '68' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '68' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '68' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '68' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '68' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '68' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '69' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '69' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '69' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '69' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '69' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '69' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '69' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1111' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1111' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1111' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1111' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1111' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1111' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1111' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '71' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '71' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '71' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '71' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '71' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '71' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '71' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1098' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1098' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1098' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1098' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1098' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1098' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1098' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1105' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1105' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1105' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1105' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1105' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1105' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1105' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '73' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '73' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '73' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '73' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '73' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '73' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '73' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '74' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '74' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '74' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '74' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '74' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '74' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '74' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '90' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '90' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '90' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '90' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '90' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '90' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '90' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '72' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '72' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '72' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '72' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '72' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '72' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '72' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '91' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '91' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '91' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '91' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '91' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '91' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '91' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '92' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '92' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '92' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '92' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '92' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '92' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '92' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '93' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '93' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '93' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '93' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '93' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '93' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '93' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '94' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '94' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '94' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '94' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '94' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '94' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '94' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '95' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '95' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '95' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '95' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '95' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '95' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '95' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1099' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1099' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1099' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1099' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1099' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1099' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1099' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1100' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1100' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1100' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1100' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1100' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1100' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1100' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '428' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '428' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '428' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '428' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '428' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '428' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '428' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1112' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1112' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1112' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1112' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1112' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1112' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1112' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '96' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '96' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '96' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '96' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '96' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '96' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '96' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '97' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '97' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '97' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '97' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '97' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '97' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '97' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '98' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '98' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '98' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '98' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '98' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '98' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '98' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '99' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '99' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '99' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '99' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '99' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '99' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '99' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '100' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '100' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '100' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '100' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '100' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '100' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '100' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '101' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '101' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '101' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '101' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '101' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '101' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '101' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1101' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1101' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1101' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1101' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1101' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1101' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1101' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1102' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1102' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1102' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1102' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1102' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1102' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1102' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1103' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1103' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1103' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1103' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1103' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1103' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1103' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1104' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1104' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1104' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1104' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1104' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1104' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1104' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '102' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '102' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '102' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '102' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '102' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '102' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '102' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '103' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '103' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '103' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '103' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '103' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '103' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '103' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '104' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '104' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '104' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '104' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '104' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '104' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '104' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '105' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '105' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '105' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '105' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '105' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '105' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '105' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '106' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '106' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '106' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '106' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '106' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '106' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '106' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '107' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '107' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '107' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '107' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '107' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '107' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '107' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '108' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '108' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '108' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '108' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '108' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '108' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '108' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT longName, cityID, pix FROM university WHERE universityID = '9'
SELECT * FROM pic WHERE ID='20'
SELECT cityID, longName, pix FROM city WHERE cityID='17'
SELECT * FROM pic WHERE ID='2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '109' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '109' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '109' AND ratingType = '3'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '109' AND ratingType = '1'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '109' AND ratingType = '2'
SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '109' AND ratingType = '3'
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '109' AND scoreYear = (2014 - 1)
SELECT hide FROM university_scoring WHERE university_scoringID = ''
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '43'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '45'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '46'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '48'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '49'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '50'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '54'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '55'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '111'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1095'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1094'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '61'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '62'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '63'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '64'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '65'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '66'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '67'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1096'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1097'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '68'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '69'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1111'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '71'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1098'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1105'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '73'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '74'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '90'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '72'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '91'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '92'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '93'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '94'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '95'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1099'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1100'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '428'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1112'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '96'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '97'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '98'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '99'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '100'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '101'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1101'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1102'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1103'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1104'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '102'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '103'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '104'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '105'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '106'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '107'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '108'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '109'
SELECT url FROM university WHERE universityID = '9'
SELECT url FROM university WHERE universityID = '9'
|
support@unichoice.bg