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