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 count(distinct us.specialtyID) as c FROM university_specialty AS us 
            LEFT JOIN specialty s ON (s.specialtyID = us.specialtyID) 
            WHERE s.hide = 0 AND us.hide=0 
SELECT s.specialtyID, s.longName, s.url FROM specialty as s INNER JOIN university_specialty AS us ON (s.specialtyID = us.specialtyID) WHERE s.hide = 0 AND us.hide=0 GROUP BY s.specialtyID ORDER BY s.longName LIMIT 420, 30

all

allSpec

Array
(
    [siteCountry] => 
)
1

Array
(
)
1

Array
(
    [p1] => all
    [a] => spec
    [page] => 15
)
1

Array
(
    [0] => Array
        (
            [specialtyID] => 589
            [longName] => Реставрация
            [url] => restavracia
        )

    [1] => Array
        (
            [specialtyID] => 602
            [longName] => Речно корабоплаване(с допълнителна специализация корабоводене)
            [url] => rechno-koraboplavanes-dopalnitelna-specializacia-korabovodene
        )

    [2] => Array
        (
            [specialtyID] => 517
            [longName] => Рибовъдство и аквакултури
            [url] => ribovadstvo-i-akvakulturi
        )

    [3] => Array
        (
            [specialtyID] => 484
            [longName] => Роботика и  мехатроника
            [url] => robotika-i-mehatronika
        )

    [4] => Array
        (
            [specialtyID] => 649
            [longName] => Романистика
            [url] => romanistika
        )

    [5] => Array
        (
            [specialtyID] => 389
            [longName] => Румънска филология
            [url] => rumanska-filologiya
        )

    [6] => Array
        (
            [specialtyID] => 240
            [longName] => Руска филология
            [url] => ruska-filologiya
        )

    [7] => Array
        (
            [specialtyID] => 504
            [longName] => Селекция и семепроизводство
            [url] => selekcia-i-semeproizvodstvo
        )

    [8] => Array
        (
            [specialtyID] => 450
            [longName] => Сигналоохранителни системи и технологии
            [url] => signaloohranitelni-sistemi-i-tehnologii
        )

    [9] => Array
        (
            [specialtyID] => 453
            [longName] => Системи за сигурност
            [url] => sistemi-za-sigurnost
        )

    [10] => Array
        (
            [specialtyID] => 241
            [longName] => Скандинавистика
            [url] => skandinavistika
        )

    [11] => Array
        (
            [specialtyID] => 577
            [longName] => Скулптура
            [url] => skulptura
        )

    [12] => Array
        (
            [specialtyID] => 242
            [longName] => Славянска филология
            [url] => slavyanska-filologiya
        )

    [13] => Array
        (
            [specialtyID] => 403
            [longName] => Сондиране и добив на нефт и газ
            [url] => sondirane-i-dobiv-na-neft-i-gaz
        )

    [14] => Array
        (
            [specialtyID] => 488
            [longName] => Софтуерни и интернет технологии
            [url] => softuerni-i-internet-tehnologii
        )

    [15] => Array
        (
            [specialtyID] => 244
            [longName] => Софтуерно инженерство
            [url] => softuerno-injenerstvo
        )

    [16] => Array
        (
            [specialtyID] => 487
            [longName] => Социален мениджмънт
            [url] => socialen-menidjmant
        )

    [17] => Array
        (
            [specialtyID] => 370
            [longName] => Социална антропология
            [url] => socialna-antropologiya
        )

    [18] => Array
        (
            [specialtyID] => 245
            [longName] => Социална педагогика
            [url] => socialna-pedagogika
        )

    [19] => Array
        (
            [specialtyID] => 246
            [longName] => Социална работа
            [url] => socialna-rabota
        )

    [20] => Array
        (
            [specialtyID] => 247
            [longName] => Социални дейности
            [url] => socialni-deynosti
        )

    [21] => Array
        (
            [specialtyID] => 248
            [longName] => Социология
            [url] => sociologiya
        )

    [22] => Array
        (
            [specialtyID] => 300
            [longName] => Социология и науки за човека
            [url] => sociologiya-i-nauki-za-choveka
        )

    [23] => Array
        (
            [specialtyID] => 301
            [longName] => Социология на правото, икономиката и иновациите
            [url] => sociologiya-na-pravoto-ikonomikata-i-inovaciite
        )

    [24] => Array
        (
            [specialtyID] => 249
            [longName] => Специална педагогика
            [url] => specialna-pedagogika
        )

    [25] => Array
        (
            [specialtyID] => 412
            [longName] => Спорт
            [url] => sport
        )

    [26] => Array
        (
            [specialtyID] => 657
            [longName] => Спортен коментатор
            [url] => sporten-komentator
        )

    [27] => Array
        (
            [specialtyID] => 413
            [longName] => Спортен мениджмънт
            [url] => sporten-menidjmant
        )

    [28] => Array
        (
            [specialtyID] => 414
            [longName] => Спортна анимация
            [url] => sportna-animaciya
        )

    [29] => Array
        (
            [specialtyID] => 251
            [longName] => Статистика
            [url] => statistika
        )

)
1