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 = 'au-plovdiv' SELECT * FROM pic WHERE ID='0' SELECT * FROM city WHERE cityID='2' SELECT * FROM pic WHERE ID='4' SELECT * FROM university_specialty WHERE universityID = '30' AND hide = '0' ORDER BY longName SELECT * FROM university_labels WHERE universityID = '30' AND (hide = '0' OR hide = '3') SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '809' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '809' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '795' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '795' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '793' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '793' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '797' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '797' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '807' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '807' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '805' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '805' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '802' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '802' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '796' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '796' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '798' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '798' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '804' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '804' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '806' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '806' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '794' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '794' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '801' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '801' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '800' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '800' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '803' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '803' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '799' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '799' SELECT url FROM university WHERE universityID = '30' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '808' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '808' SELECT url FROM university WHERE universityID = '30'
|
$data |
Array
(
[universityID] => 30
[hide] => 0
[position] => 29
[longName] => Аграрен университет-Пловдив
[shortName] => АУ-Пловдив
[address] => Пловдив 4000,ул."Менделеев"12
[contacts] => Тел.: 032/633-232, 032/654-200 Факс: 032/633-157
[website] => www.au-plovdiv.bg
[cityID] => 2
[pix] =>
[examDate] => 2013-12-13 00:00:00
[balDate] => 2013-12-13 00:00:00
[zapDate] => 2013-12-13 00:00:00
[obDate] => 2013-12-13 00:00:00
[url] => au-plovdiv
[hits] => 1202
)
1 |