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 = 'btu-burgas' SELECT * FROM pic WHERE ID='42' SELECT * FROM city WHERE cityID='10' SELECT * FROM pic WHERE ID='3' SELECT * FROM university_specialty WHERE universityID = '17' AND hide = '0' ORDER BY longName SELECT * FROM university_labels WHERE universityID = '17' AND (hide = '0' OR hide = '3') SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '510' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '509' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '510' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '524' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '454' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '524' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '525' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '521' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '525' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '528' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '515' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '528' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '515' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '514' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '515' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '518' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '517' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '518' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '514' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '588' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '514' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '517' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '516' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '517' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '526' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '522' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '526' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '521' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '519' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '521' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '511' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '510' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '511' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '509' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '508' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '509' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '522' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '520' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '522' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '520' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '519' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '520' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '523' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '520' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '523' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '516' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '516' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '516' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '513' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '511' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '513' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '519' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '589' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '519' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '512' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '512' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '512' SELECT url FROM university WHERE universityID = '17' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '527' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '587' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '527' SELECT url FROM university WHERE universityID = '17'
|