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 = 'ru' UPDATE university SET hits = (hits + 1) WHERE universityID = '4' SELECT * FROM university_specialty WHERE hide = 0 AND universityID = '4' ORDER BY longName SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1109' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1109' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1109' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1109' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1109' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1109' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1109' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '385' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '385' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '385' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '423' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '423' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '423' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '423' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '423' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '423' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '423' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '278' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '407' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '407' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '407' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '407' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '407' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '291' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '705' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '705' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '705' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '275' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '416' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '416' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '416' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '416' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '416' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '298' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '406' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '406' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '406' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '295' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '405' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '405' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '405' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '294' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '387' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '387' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '387' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '274' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '393' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '393' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '393' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '704' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '704' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '704' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '395' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '395' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '395' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '421' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '421' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '421' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '277' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '382' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '382' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '382' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '404' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '404' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '404' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '291' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '409' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '409' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '409' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '291' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '392' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '392' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '392' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '414' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '414' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '414' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '300' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '398' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '398' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '398' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1071' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1071' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1071' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1071' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1071' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1071' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1071' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '420' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '420' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '420' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '276' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '384' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '384' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '384' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '413' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '413' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '413' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '300' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '396' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '396' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '396' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '394' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '394' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '394' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '394' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '394' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '402' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '402' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '402' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '291' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '415' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '415' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '415' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '415' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '415' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '300' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '391' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '391' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '391' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '391' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '391' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '388' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '388' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '388' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '422' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '422' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '422' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '278' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '403' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '403' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '403' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '296' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '383' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '383' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '383' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '390' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '390' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '390' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '389' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '389' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '389' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '410' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '410' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '410' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '299' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1070' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1070' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1070' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1070' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1070' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1070' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1070' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1069' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1069' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1069' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1069' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1069' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1069' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1069' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '418' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '418' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '418' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '304' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '411' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '411' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '411' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '411' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '411' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '298' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '386' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '386' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '386' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '279' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '408' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '408' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '408' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '291' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1110' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1110' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1110' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1110' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1110' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1110' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1110' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '412' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '412' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '412' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '298' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '419' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '419' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '419' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '419' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '419' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '293' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1068' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1068' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1068' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1068' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1068' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1068' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1068' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '397' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '397' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '397' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1067' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1067' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1067' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1067' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1067' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1067' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1067' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '400' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '400' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '400' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '706' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '706' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '706' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '275' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '399' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '399' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '399' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '273' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '417' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '417' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '417' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '417' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '417' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '301' SELECT longName, cityID, pix FROM university WHERE universityID = '4' SELECT * FROM pic WHERE ID='15' SELECT cityID, longName, pix FROM city WHERE cityID='14' SELECT * FROM pic WHERE ID='5' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '707' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '707' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '707' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '275' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1109' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1109' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '385' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '385' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '423' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '423' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '407' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '407' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '705' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '705' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '416' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '416' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '406' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '406' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '405' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '405' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '387' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '387' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '393' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '393' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '704' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '704' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '395' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '395' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '421' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '421' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '382' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '382' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '404' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '404' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '409' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '409' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '392' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '392' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '414' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '414' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '398' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '398' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1071' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1071' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '420' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '420' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '384' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '384' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '413' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '413' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '396' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '396' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '394' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '394' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '402' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '402' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '415' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '415' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '391' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '391' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '388' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '388' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '422' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '422' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '403' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '403' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '383' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '383' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '390' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '390' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '389' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '389' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '410' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '410' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1070' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1070' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1069' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1069' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '418' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '418' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '411' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '411' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '386' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '386' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '408' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '408' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1110' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1110' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '412' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '412' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '419' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '419' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1068' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1068' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '397' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '397' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1067' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1067' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '400' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '400' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '706' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '706' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '399' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '399' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '417' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '417' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '707' SELECT url FROM university WHERE universityID = '4' SELECT url FROM university WHERE universityID = '4' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '707'
|