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