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 = 'minno-geolojki-universitet-sv-ivan-rilski' SELECT * FROM pic WHERE ID='39' SELECT * FROM city WHERE cityID='1' SELECT * FROM pic WHERE ID='6' SELECT * FROM university_specialty WHERE universityID = '18' AND hide = '0' ORDER BY longName SELECT * FROM university_labels WHERE universityID = '18' AND (hide = '0' OR hide = '3') SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '553' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '553' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '558' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '558' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '554' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '554' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '559' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '559' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '560' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '560' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '561' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '438' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '561' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '555' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '555' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '556' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '556' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '547' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '547' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '557' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '557' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '548' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '438' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '548' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '550' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '550' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '562' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '562' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '551' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '551' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '563' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '563' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '552' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '436' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '552' SELECT url FROM university WHERE universityID = '18' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '564' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '437' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '564' SELECT url FROM university WHERE universityID = '18'
|
$data |
Array
(
[universityID] => 18
[hide] => 0
[position] => 17
[longName] => Минно-геоложки университет ''Св. Иван Рилски''
[shortName] => МГУ - София
[address] => Адрес: Студентски град, ул."проф. Боян Каменов", София 1700
[contacts] => тел. 02 / 8060300 - Ректорски кабинет
[website] => www.mgu.bg
[cityID] => 1
[pix] => Array
(
[ID] => 39
[type] => 0
[name] => 5fit1374670856.jpg
[title] =>
[txt] =>
[addDate] => 2013-07-24 16:01:02
)
[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] => minno-geolojki-universitet-sv-ivan-rilski
[hits] => 1061
)
1 |