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 = 'unibit-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 = '41' AND hide = '0'  ORDER BY longName  
SELECT * FROM university_labels WHERE universityID = '41' AND (hide = '0' OR hide = '3')    

info

university

Array
(
    [siteCountry] => 
)
1

Array
(
)
1

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

Array
(
    [universityID] => 41
    [hide] => 2
    [position] => 0
    [longName] => Университет  по библиотекознание и информационни технологии
    [shortName] => УниБИТ-София
    [address] => 
гр. София, п.к. 1784,
бул. “Цариградско шосе” № 119
    [contacts] => 
Учебен отдел
Тел.: +359 (0) 2 971 80 69
Тел.: +359 (0) 2 970 85 88
Имейл: ucheben.otdel@unibit.
    [website] => http://www.unibit.bg
    [cityID] => 1
    [pix] => 
    [examDate] => 2013-12-15 00:00:00
    [balDate] => 2013-12-15 00:00:00
    [zapDate] => 2013-12-15 00:00:00
    [obDate] => 2013-12-15 00:00:00
    [url] => unibit-sofia
    [hits] => 814
)
1