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 = 'mu-sofia'    
SELECT * FROM pic WHERE ID='0'    
SELECT * FROM city WHERE cityID='1'    
SELECT * FROM pic WHERE ID='6'    
SELECT * FROM university_specialty WHERE universityID = '36' AND hide = '0'  ORDER BY longName  
SELECT * FROM university_labels WHERE universityID = '36' AND (hide = '0' OR hide = '3')    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '919' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '919'    
SELECT url FROM university WHERE universityID = '36'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '912' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '912'    
SELECT url FROM university WHERE universityID = '36'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '915' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '915'    
SELECT url FROM university WHERE universityID = '36'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '911' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '911'    
SELECT url FROM university WHERE universityID = '36'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '918' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '918'    
SELECT url FROM university WHERE universityID = '36'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '914' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '914'    
SELECT url FROM university WHERE universityID = '36'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '916' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '916'    
SELECT url FROM university WHERE universityID = '36'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '920' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '920'    
SELECT url FROM university WHERE universityID = '36'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '917' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '917'    
SELECT url FROM university WHERE universityID = '36'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '913' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = ''    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '913'    
SELECT url FROM university WHERE universityID = '36'    

info

university

Array
(
    [siteCountry] => 
)
1

Array
(
)
1

Array
(
    [p1] => info
    [uID] => mu-sofia
)
1

Array
(
    [universityID] => 36
    [hide] => 0
    [position] => 35
    [longName] => Медицински университет-София
    [shortName] => МУ-София
    [address] => 
София 1431,ул."Акад.Иван Гешов" 15
    [contacts] => 
Отдел "Студентско образование"
 Люба Йончева Кирилова   тел:(02) 9531 174
 Експерти тел: (02) 9152 149, (02) 9152 148, (02) 9152 123
    [website] => mu-sofia.bg
    [cityID] => 1
    [pix] => 
    [examDate] => 2013-12-14 00:00:00
    [balDate] => 2013-12-14 00:00:00
    [zapDate] => 2013-12-14 00:00:00
    [obDate] => 2013-12-14 00:00:00
    [url] => mu-sofia
    [hits] => 998
)
1