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 = 'vsu' SELECT * FROM pic WHERE ID='11' SELECT * FROM city WHERE cityID='8' SELECT * FROM pic WHERE ID='9' SELECT * FROM university_specialty WHERE universityID = '11' AND hide = '0' ORDER BY longName SELECT * FROM university_labels WHERE universityID = '11' AND (hide = '0' OR hide = '3') SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '28' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '28' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1001' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1001' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1002' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1002' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1012' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1012' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '52' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '52' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1003' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1003' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1004' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1004' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '31' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '31' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '32' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '32' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1005' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1005' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '76' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '76' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '60' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '60' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1006' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1006' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '51' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '51' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '53' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '53' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '56' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '56' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1000' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1000' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1007' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1007' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1008' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1008' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '35' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '35' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '59' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '59' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1009' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1009' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1010' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1010' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '34' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '34' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '39' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '39' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '77' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '77' SELECT url FROM university WHERE universityID = '11' SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '1011' AND scoreYear = (2014 - 1) SELECT hide FROM university_scoring WHERE university_scoringID = '' SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '1011' SELECT url FROM university WHERE universityID = '11'
|
$data |
Array
(
[universityID] => 11
[hide] => 0
[position] => 11
[longName] => Варненски свободен университет ''Черноризец Храбър''
[shortName] => ВСУ - Варна
[address] => гр. Варна 9007, к.к. Чайка, Варненски свободен университет "Черноризец Храбър"
[contacts] => Кандидатстудентски прием: тел.: 052/355-106 email: priem@vfu.bg
[website] => vfu.bg/
[cityID] => 8
[pix] => Array
(
[ID] => 11
[type] => 0
[name] => jdyg1369236462.jpg
[title] =>
[txt] =>
[addDate] => 2013-05-22 18:27:58
)
[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] => vsu
[hits] => 2005
)
1 |