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