| 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 = 'iu-varna' SELECT * FROM pic WHERE ID='13' SELECT * FROM city WHERE cityID='8' SELECT * FROM pic WHERE ID='9' SELECT * FROM university_specialty WHERE universityID = '2' AND hide = '0' ORDER BY longName SELECT * FROM university_labels WHERE universityID = '2' AND (hide = '0' OR hide = '3') SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '275' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '275' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '276' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '276' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '278' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '278' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '279' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '279' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '280' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '280' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '281' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '281' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1029' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1029' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '282' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '282' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '284' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '284' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1030' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1030' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '283' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '283' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '287' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '287' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1031' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '0' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1031' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '288' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '288' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '289' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '289' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '291' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '291' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '294' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '294' SELECT url FROM university WHERE universityID = '2' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '295' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '568' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '295' SELECT url FROM university WHERE universityID = '2'
|
| $data |
Array
(
[universityID] => 2
[hide] => 0
[position] => 2
[longName] => Икономически университет - Варна
[shortName] => ИУ - Варна
[address] => 9002, Варна, бул. "Княз Борис I" 77
[contacts] => Сектор "Студенти" Ръководител сектор: инж. Георги Петров Фиксиран номер:052-830801 GSM:0886608460 e-mail: g.dobrev.petrov@ue-varna.bg
Сектор "Уче
[website] => www.ue-varna.bg
[cityID] => 8
[pix] => Array
(
[ID] => 13
[type] => 0
[name] => g8io1369236531.jpg
[title] =>
[txt] =>
[addDate] => 2013-05-22 18:28:54
)
[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] => iu-varna
[hits] => 1458
)
1 |