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 = 'tu-sofiya' UPDATE university SET hits = (hits + 1) WHERE universityID = '7' SELECT * FROM university_specialty WHERE hide = 0 AND universityID = '7' ORDER BY longName SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '149' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '149' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '149' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '149' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '149' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '149' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '149' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '346' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '150' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '150' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '150' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '150' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '150' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '150' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '150' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '347' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '151' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '151' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '151' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '151' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '151' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '151' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '151' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '348' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '14' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '14' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '14' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '14' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '14' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '14' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '14' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '370' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '152' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '152' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '152' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '152' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '152' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '152' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '152' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '349' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '153' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '153' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '153' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '153' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '153' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '153' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '153' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '350' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '154' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '154' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '154' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '154' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '154' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '154' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '154' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '351' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '155' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '155' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '155' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '155' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '155' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '155' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '155' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '418' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '156' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '156' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '156' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '156' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '156' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '156' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '156' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '353' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1075' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1075' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1075' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1075' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1075' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1075' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1075' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '603' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1076' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1076' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1076' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1076' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1076' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1076' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1076' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1077' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1077' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1077' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1077' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1077' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1077' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1077' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1078' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1078' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '1078' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1078' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1078' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '1078' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1078' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '158' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '158' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '158' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '158' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '158' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '158' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '158' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '354' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '159' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '159' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '159' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '159' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '159' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '159' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '159' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '355' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '161' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '161' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '161' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '161' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '161' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '161' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '161' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '356' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '433' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '433' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '433' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '433' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '433' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '433' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '433' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '357' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '163' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '163' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '163' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '163' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '163' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '163' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '163' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '358' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '164' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '164' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '164' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '164' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '164' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '164' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '164' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '359' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '165' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '165' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '165' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '165' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '165' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '165' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '165' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '362' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '166' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '166' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '166' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '166' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '166' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '166' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '166' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '363' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '432' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '432' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '432' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '432' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '432' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '432' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '432' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '371' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '431' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '431' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '431' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '431' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '431' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '431' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '431' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '364' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '167' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '167' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '167' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '167' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '167' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '167' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '167' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '365' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '168' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '168' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '168' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '168' AND ratingType = '1' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '168' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '366' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '169' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '169' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '169' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '169' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '169' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '169' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '169' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '367' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '170' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '170' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '170' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '170' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '170' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '170' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '170' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '368' SELECT longName, cityID, pix FROM university WHERE universityID = '7' SELECT * FROM pic WHERE ID='18' SELECT cityID, longName, pix FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '171' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '171' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2013' AND minmax = '' AND university_specialtyID = '171' AND ratingType = '3' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '171' AND ratingType = '1' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '171' AND ratingType = '2' SELECT ratingValue FROM university_specialty_score WHERE scoreYear = '2012' AND minmax = '' AND university_specialtyID = '171' AND ratingType = '3' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '171' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '369' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '149' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '149' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '150' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '150' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '151' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '151' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '14' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '14' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '152' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '152' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '153' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '153' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '154' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '154' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '155' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '155' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '156' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '156' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1075' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1075' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1076' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1076' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1077' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1077' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1078' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '1078' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '158' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '158' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '159' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '159' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '161' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '161' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '433' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '433' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '163' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '163' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '164' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '164' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '165' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '165' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '166' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '166' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '432' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '432' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '431' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '431' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '167' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '167' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '168' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '168' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '169' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '169' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '170' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '170' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '171' SELECT url FROM university WHERE universityID = '7' SELECT url FROM university WHERE universityID = '7' SELECT forbidenAppl FROM university_specialty WHERE university_specialtyID = '171'
|