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 30, 30

all

allSpec

Array
(
    [siteCountry] => 
)
1

Array
(
)
1

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

Array
(
    [0] => Array
        (
            [specialtyID] => 15
            [longName] => Анимационно кино
            [url] => animacionno-kino
        )

    [1] => Array
        (
            [specialtyID] => 561
            [longName] => Анимация
            [url] => animacia
        )

    [2] => Array
        (
            [specialtyID] => 16
            [longName] => Антропология
            [url] => antropologiya
        )

    [3] => Array
        (
            [specialtyID] => 17
            [longName] => Арабистика
            [url] => arabistika
        )

    [4] => Array
        (
            [specialtyID] => 18
            [longName] => Арменистика и кавказология
            [url] => armenistika-i-kavkazologiya
        )

    [5] => Array
        (
            [specialtyID] => 545
            [longName] => Арфа
            [url] => arfa
        )

    [6] => Array
        (
            [specialtyID] => 19
            [longName] => Археология
            [url] => arheologiya
        )

    [7] => Array
        (
            [specialtyID] => 20
            [longName] => Архивистика и документалистика
            [url] => arhivistika-i-dokumentalistika
        )

    [8] => Array
        (
            [specialtyID] => 21
            [longName] => Архитектура
            [url] => arhitektura
        )

    [9] => Array
        (
            [specialtyID] => 446
            [longName] => Астрономия
            [url] => astronomiya
        )

    [10] => Array
        (
            [specialtyID] => 22
            [longName] => Астрофизика, метеорология и геофизика
            [url] => astrofizika-meteorologiya-i-geofizika
        )

    [11] => Array
        (
            [specialtyID] => 527
            [longName] => Балетна педагогика
            [url] => baletna-pedagogika
        )

    [12] => Array
        (
            [specialtyID] => 567
            [longName] => Балетно изкуство(балетна педагогика или балетна режисура)
            [url] => baletno-izkustvobaletna-pedagogika-ili-baletna-rejisura
        )

    [13] => Array
        (
            [specialtyID] => 23
            [longName] => Балканистика
            [url] => balkanistika
        )

    [14] => Array
        (
            [specialtyID] => 624
            [longName] => Безжични комуникации и разпръскване
            [url] => bezjichni-komunikacii-i-razpraskvane
        )

    [15] => Array
        (
            [specialtyID] => 467
            [longName] => Безопасност на производствата и защита при бедствия и аварии
            [url] => bezopasnost-na-proizvodstvata-i-zashtita-pri-bedstvia-i-avarii
        )

    [16] => Array
        (
            [specialtyID] => 626
            [longName] => Библиотекознание и библиография
            [url] => bibliotekoznanie-i-bibliografia
        )

    [17] => Array
        (
            [specialtyID] => 627
            [longName] => Библиотечен и информационен мениджмънт
            [url] => bibliotechen-i-informacionen-menidjmant
        )

    [18] => Array
        (
            [specialtyID] => 24
            [longName] => Библиотечно-информационни дейности
            [url] => bibliotechno-informacionni-deynosti
        )

    [19] => Array
        (
            [specialtyID] => 25
            [longName] => Библиотечно-информационни науки
            [url] => bibliotechno-informacionni-nauki
        )

    [20] => Array
        (
            [specialtyID] => 26
            [longName] => Бизнес администрация
            [url] => biznes-adiministraciya
        )

    [21] => Array
        (
            [specialtyID] => 27
            [longName] => Бизнес икономика
            [url] => biznes-ikonomika
        )

    [22] => Array
        (
            [specialtyID] => 28
            [longName] => Бизнес информатика
            [url] => biznes-informatika
        )

    [23] => Array
        (
            [specialtyID] => 29
            [longName] => Бизнес информатика и комуникации
            [url] => biznes-informatika-i-komunikacii
        )

    [24] => Array
        (
            [specialtyID] => 30
            [longName] => Бизнес информационни системи
            [url] => biznes-informacionni-sistemi
        )

    [25] => Array
        (
            [specialtyID] => 31
            [longName] => Бизнес информационни технологии
            [url] => biznes-informacionni-tehnologii
        )

    [26] => Array
        (
            [specialtyID] => 614
            [longName] => Бизнес маркетинг
            [url] => biznes-marketing
        )

    [27] => Array
        (
            [specialtyID] => 32
            [longName] => Бизнес математика
            [url] => biznes-matematika
        )

    [28] => Array
        (
            [specialtyID] => 33
            [longName] => Бизнес мениджмънт
            [url] => biznes-menidjmant
        )

    [29] => Array
        (
            [specialtyID] => 615
            [longName] => Бизнес счетоводство и финанси
            [url] => biznes-schetovodstvo-i-finansi
        )

)
1