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 = 'uasg'    
SELECT * FROM pic WHERE ID='41'    
SELECT * FROM city WHERE cityID='1'    
SELECT * FROM pic WHERE ID='6'    
SELECT * FROM university_specialty WHERE universityID = '22' AND hide = '0'  ORDER BY longName  
SELECT * FROM university_labels WHERE universityID = '22' AND (hide = '0' OR hide = '3')    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '593' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '0'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '593'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '601' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '601'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '592' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '592'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '594' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '594'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '595' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '595'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '596' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '596'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '597' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '597'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '599' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '457'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '599'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '600' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '600'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '603' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '603'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '598' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '598'    
SELECT url FROM university WHERE universityID = '22'    
SELECT university_scoringID FROM university_specialty_score_type WHERE university_specialtyID = '602' AND scoreYear = (2014 - 1)    
SELECT hide FROM university_scoring WHERE university_scoringID = '458'    
SELECT url,universityID FROM university_specialty WHERE university_specialtyID = '602'    
SELECT url FROM university WHERE universityID = '22'    

info

university

Array
(
    [siteCountry] => 
)
1

Array
(
)
1

Array
(
    [p1] => info
    [uID] => uasg
)
1

Array
(
    [universityID] => 22
    [hide] => 0
    [position] => 21
    [longName] => Университет по архитектура строителство и геодезия
    [shortName] => УАСГ - София
    [address] => 
София 1046, бул. Христо Смирненски № 1
    [contacts] => 
Учебен отдел: инж. Светлана Василева
тел.: 02/865 49 40 и 02/963 52 45
електронна поща: umo_adm@uacg.bg 
    [website] => uacg.bg/
    [cityID] => 1
    [pix] => Array
        (
            [ID] => 41
            [type] => 0
            [name] => n3f391374670938.jpg
            [title] => 
            [txt] => 
            [addDate] => 2013-07-24 16:02:35
        )

    [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] => uasg
    [hits] => 811
)
1