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 = 'stopanska-akademiya-dimitar-cenov' SELECT * FROM pic WHERE ID='16' SELECT * FROM city WHERE cityID='16' SELECT * FROM pic WHERE ID='7' SELECT * FROM university_specialty WHERE universityID = '6' AND hide = '0' ORDER BY longName SELECT * FROM university_labels WHERE universityID = '6' AND (hide = '0' OR hide = '3') SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '313' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '313' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '314' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '314' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '315' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '315' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '316' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '316' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '317' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '317' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '318' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '318' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '319' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '319' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '320' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '320' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '321' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '321' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '322' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '322' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '323' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '323' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '324' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '324' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '325' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '325' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '326' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '326' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '327' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '327' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '328' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '328' SELECT url FROM university WHERE universityID = '6' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '12' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '12' SELECT url FROM university WHERE universityID = '6'
|
$data |
Array
(
[universityID] => 6
[hide] => 0
[position] => 6
[longName] => Стопанска академия ''Димитър Ценов''
[shortName] => СА - Свищов
[address] => Адрес: град Свищов, ул." Емануил Чакъров" 2
[contacts] => Телефон: (0631) 66 201,0882 552509 КСК ЦЕНТЪР:(0631) 66 381, 66 367, 66 382, 66 385 Факс:(0631) 87 355, 0882 612736 E-mail: rectorat@uni-svishtov.bg
[website] => www.uni-svishtov.bg/
[cityID] => 16
[pix] => Array
(
[ID] => 16
[type] => 0
[name] => 5conh1369236723.jpg
[title] =>
[txt] =>
[addDate] => 2013-05-22 18:32:08
)
[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] => stopanska-akademiya-dimitar-cenov
[hits] => 1556
)
1 |