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 = 'shu' SELECT * FROM pic WHERE ID='44' SELECT * FROM city WHERE cityID='29' SELECT * FROM pic WHERE ID='23' SELECT * FROM university_specialty WHERE universityID = '24' AND hide = '0' ORDER BY longName SELECT * FROM university_labels WHERE universityID = '24' AND (hide = '0' OR hide = '3') SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '629' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '472' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '629' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '634' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '476' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '634' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '641' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '480' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '641' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '653' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '489' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '653' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '658' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '580' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '658' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '657' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '493' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '657' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '628' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '471' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '628' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1113' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1113' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '638' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '479' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '638' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '637' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '478' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '637' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '644' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '477' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '644' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '659' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '492' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '659' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '680' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '503' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '680' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '656' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '579' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '656' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '643' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '477' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '643' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '672' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '500' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '672' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '651' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '488' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '651' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '650' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '487' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '650' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '681' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '505' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '681' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '639' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '480' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '639' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '640' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '481' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '640' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '648' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '486' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '648' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '649' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '486' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '649' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1091' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1091' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '675' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '504' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '675' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '645' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '486' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '645' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '647' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '486' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '647' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '671' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '499' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '671' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '666' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '498' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '666' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '662' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '662' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '663' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '663' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '664' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '664' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '631' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '473' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '631' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1092' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1092' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '661' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '495' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '661' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '632' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '473' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '632' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '676' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '504' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '676' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '682' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '506' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '682' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '669' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '669' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '670' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '670' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1093' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '497' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1093' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '646' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '487' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '646' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '642' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '485' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '642' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '674' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '501' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '674' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '660' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '496' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '660' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '633' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '474' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '633' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '652' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '489' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '652' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '673' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '502' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '673' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '654' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '490' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '654' SELECT url FROM university WHERE universityID = '24' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '655' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '490' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '655' SELECT url FROM university WHERE universityID = '24'
|