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 = 'tu-sofiya' SELECT * FROM pic WHERE ID='18' SELECT * FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT * FROM university_specialty WHERE universityID = '7' AND hide = '0' ORDER BY longName SELECT * FROM university_labels WHERE universityID = '7' AND (hide = '0' OR hide = '3') SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '149' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '346' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '149' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '150' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '347' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '150' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '151' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '348' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '151' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '14' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '370' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '14' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '152' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '349' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '152' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '153' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '350' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '153' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '154' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '351' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '154' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '155' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '418' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '155' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '156' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '353' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '156' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1075' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '603' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1075' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1076' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1076' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1077' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1077' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1078' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1078' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '158' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '354' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '158' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '159' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '355' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '159' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '161' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '356' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '161' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '433' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '357' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '433' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '163' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '358' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '163' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '164' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '359' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '164' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '165' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '362' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '165' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '166' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '363' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '166' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '432' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '371' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '432' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '431' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '364' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '431' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '167' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '365' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '167' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '168' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '366' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '168' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '169' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '367' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '169' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '170' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '368' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '170' SELECT url FROM university WHERE universityID = '7' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '171' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '369' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '171' SELECT url FROM university WHERE universityID = '7'
|
$data |
Array
(
[universityID] => 7
[hide] => 0
[position] => 7
[longName] => Технически университет - София
[shortName] => ТУ - София
[address] => София 1000, бул."Кл. Охридски" 8
[contacts] => ИНФОРМАЦИОНЕН ЦЕНТЪР: блок № 2, етаж 1, стая 2125 +359 2 965-2844; +359 2 965-2845 info@tu-sofia.bg ЗА КАНДИДАТ-СТУДЕНТИ: ksk@tu-sofia.bg
[website] => tu-sofia.bg
[cityID] => 1
[pix] => Array
(
[ID] => 18
[type] => 0
[name] => vkz3p1369236760.jpg
[title] =>
[txt] =>
[addDate] => 2013-05-22 18:32:50
)
[examDate] => 1899-11-30 00:00:00
[balDate] => 1899-11-30 00:00:00
[zapDate] => 1899-11-30 00:00:00
[obDate] => 1899-11-30 00:00:00
[url] => tu-sofiya
[hits] => 2179
)
1 |