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

all

allSpec

Array
(
    [siteCountry] => 
)
1

Array
(
)
1

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

Array
(
    [0] => Array
        (
            [specialtyID] => 462
            [longName] => Целулоза,хартия и опаковки
            [url] => celulozahartia-i-opakovki
        )

    [1] => Array
        (
            [specialtyID] => 540
            [longName] => Цигулка
            [url] => cigulka
        )

    [2] => Array
        (
            [specialtyID] => 552
            [longName] => Цугтромбон
            [url] => cugtrombon
        )

    [3] => Array
        (
            [specialtyID] => 569
            [longName] => Църковна живопис
            [url] => carkovna-jivopis
        )

    [4] => Array
        (
            [specialtyID] => 324
            [longName] => Църковни изкуства
            [url] => carkovni-izkustva
        )

    [5] => Array
        (
            [specialtyID] => 325
            [longName] => Чужд език и етнология
            [url] => chujd-ezik-i-etnologiya
        )

    [6] => Array
        (
            [specialtyID] => 290
            [longName] => Южна, Източна и Югоизточна Азия
            [url] => yujna-iztochna-i-yugoiztochna-aziya
        )

    [7] => Array
        (
            [specialtyID] => 326
            [longName] => Ядрена техника и ядрена енергетика
            [url] => yadrena-tehnika-i-yadrena-energetika
        )

    [8] => Array
        (
            [specialtyID] => 327
            [longName] => Ядрена химия
            [url] => yadrena-himiya
        )

    [9] => Array
        (
            [specialtyID] => 292
            [longName] => Японистика
            [url] => yaponistika
        )

)
1