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

all

allSpec

Array
(
    [siteCountry] => 
)
1

Array
(
)
1

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

Array
(
    [0] => Array
        (
            [specialtyID] => 253
            [longName] => Логистика
            [url] => logistika
        )

    [1] => Array
        (
            [specialtyID] => 595
            [longName] => Логистика на сигурността
            [url] => logistika-na-sigurnostta
        )

    [2] => Array
        (
            [specialtyID] => 159
            [longName] => Логопедия
            [url] => logopediya
        )

    [3] => Array
        (
            [specialtyID] => 160
            [longName] => Макроикономика
            [url] => makroikonomika
        )

    [4] => Array
        (
            [specialtyID] => 353
            [longName] => Маркетинг
            [url] => marketing
        )

    [5] => Array
        (
            [specialtyID] => 674
            [longName] => Маркетинг и стратегическо планиране
            [url] => marketing-i-strategichesko-planirane
        )

    [6] => Array
        (
            [specialtyID] => 390
            [longName] => Маркшайдерство и геодезия
            [url] => markshayderstvo-i-geodeziya
        )

    [7] => Array
        (
            [specialtyID] => 364
            [longName] => Математика
            [url] => matematika
        )

    [8] => Array
        (
            [specialtyID] => 161
            [longName] => Математика и информатика
            [url] => matematika-i-informatika
        )

    [9] => Array
        (
            [specialtyID] => 469
            [longName] => Материали и мениджмънт
            [url] => materiali-i-menidjmant
        )

    [10] => Array
        (
            [specialtyID] => 163
            [longName] => Материалознание и технологии
            [url] => materialoznanie-i-tehnologii
        )

    [11] => Array
        (
            [specialtyID] => 164
            [longName] => Машинно инженерство
            [url] => mashinno-injenerstvo
        )

    [12] => Array
        (
            [specialtyID] => 209
            [longName] => Машиностроене
            [url] => mashinostroene
        )

    [13] => Array
        (
            [specialtyID] => 166
            [longName] => Машиностроителна техника и технологии
            [url] => mashinostroitelna-tehnika-i-tehnologii
        )

    [14] => Array
        (
            [specialtyID] => 167
            [longName] => Медии и журналистика
            [url] => medii-i-jurnalistika
        )

    [15] => Array
        (
            [specialtyID] => 168
            [longName] => Медицина
            [url] => medicina
        )

    [16] => Array
        (
            [specialtyID] => 170
            [longName] => Медицинска биология
            [url] => medicinska-biologiya
        )

    [17] => Array
        (
            [specialtyID] => 171
            [longName] => Медицинска рехабилитация и ерготерапия
            [url] => medicinska-rehabilitaciya-i-ergoterapiya
        )

    [18] => Array
        (
            [specialtyID] => 172
            [longName] => Медицинска сестра
            [url] => medicinska-sestra
        )

    [19] => Array
        (
            [specialtyID] => 173
            [longName] => Медицинска физика
            [url] => medicinska-fizika
        )

    [20] => Array
        (
            [specialtyID] => 174
            [longName] => Медицинска химия
            [url] => medicinska-himiya
        )

    [21] => Array
        (
            [specialtyID] => 651
            [longName] => Международен туризъм - на Руски език
            [url] => mejdunaroden-turizam-na-re
        )

    [22] => Array
        (
            [specialtyID] => 613
            [longName] => Международна икономика и финанси на английски език
            [url] => mejdunarodna-ikonomika-i-finansi-na-angliyski-ezik
        )

    [23] => Array
        (
            [specialtyID] => 612
            [longName] => Международна икономика и финанси на български език
            [url] => mejdunarodna-ikonomika-i-finansi-na-balgarski-ezik
        )

    [24] => Array
        (
            [specialtyID] => 179
            [longName] => Международна политика
            [url] => mejdunarodna-politika
        )

    [25] => Array
        (
            [specialtyID] => 176
            [longName] => Международни икономически отношения
            [url] => mejdunarodni-ikonomicheski-otnosheniya
        )

    [26] => Array
        (
            [specialtyID] => 185
            [longName] => Международни отношения
            [url] => mejdunarodni-otnosheniya
        )

    [27] => Array
        (
            [specialtyID] => 180
            [longName] => Международни отношения и право
            [url] => mejdunarodni-otnosheniya-i-pravo
        )

    [28] => Array
        (
            [specialtyID] => 636
            [longName] => Международно право
            [url] => mejdunarodno-pravo
        )

    [29] => Array
        (
            [specialtyID] => 366
            [longName] => Мениджмънт
            [url] => menidjmant
        )

)
1