SET NAMES UTF8
SELECT count(distinct n.napID) FROM au_nap n INNER JOIN au_specialty s ON (s.napID = n.napID) INNER JOIN au_university_specialty AS us ON (s.specialtyID = us.specialtyID)  WHERE s.hide = 0 AND us.hide=0 
SELECT n.* FROM au_nap n INNER JOIN au_specialty s ON (s.napID = n.napID)  INNER JOIN au_university_specialty AS us ON (s.specialtyID = us.specialtyID)  WHERE s.hide = 0 AND us.hide=0  GROUP BY n.napID ORDER BY n.name  LIMIT 0, 30

all

allNap

Array
(
    [siteCountry] => au
)
1

Array
(
)
1

Array
(
    [country] => au
    [p1] => all
)
1

Array
(
    [0] => Array
        (
            [napID] => 35
            [hide] => 0
            [position] => 1
            [name] => Аграрни науки и горско стопанство
            [nameDe] => DE 1
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1758
            [url] => agrarni-nauki-i-gorsko-stopanstvo
        )

    [1] => Array
        (
            [napID] => 3
            [hide] => 0
            [position] => 1
            [name] => Архитектура и ландшафтна архитектура
            [nameDe] => Architektur und Landschaftsarchitektur
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 1
            [hits] => 2880
            [url] => arhitektura-i-landshaftna-arhitektura
        )

    [2] => Array
        (
            [napID] => 36
            [hide] => 0
            [position] => 1
            [name] => Биология, Молекулярна биология и биотехнологии
            [nameDe] => DE
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 1
            [hits] => 1690
            [url] => biologia-molekulyarna-biologia-i-biotehnologii
        )

    [3] => Array
        (
            [napID] => 5
            [hide] => 0
            [position] => 1
            [name] => География
            [nameDe] => Geographie
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 966
            [url] => geografia
        )

    [4] => Array
        (
            [napID] => 20
            [hide] => 0
            [position] => 1
            [name] => Геология и метеорология
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 956
            [url] => geologia-i-meteorologia
        )

    [5] => Array
        (
            [napID] => 34
            [hide] => 0
            [position] => 1
            [name] => Езикознание, лингвистика и преводи
            [nameDe] => DE
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1578
            [url] => ezikoznanie-lingvistika-i-prevodi
        )

    [6] => Array
        (
            [napID] => 6
            [hide] => 0
            [position] => 1
            [name] => Екология и мениджмънт на околнта среда и ресурсите
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1150
            [url] => ekologia-i-menidjmant-na-okolnta-sreda-i-resursite
        )

    [7] => Array
        (
            [napID] => 7
            [hide] => 0
            [position] => 1
            [name] => Електротехника, електроника и информационна техника
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 1
            [hits] => 931
            [url] => elektrotehnika-elektronika-i-informacionna-tehnika
        )

    [8] => Array
        (
            [napID] => 8
            [hide] => 0
            [position] => 1
            [name] => Етнология
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1183
            [url] => etnologia
        )

    [9] => Array
        (
            [napID] => 9
            [hide] => 0
            [position] => 1
            [name] => Икономика
            [nameDe] => DE
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 1
            [hits] => 2489
            [url] => ikonomika
        )

    [10] => Array
        (
            [napID] => 10
            [hide] => 0
            [position] => 1
            [name] => Информатика
            [nameDe] => Informatik
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 3404
            [url] => informatika
        )

    [11] => Array
        (
            [napID] => 21
            [hide] => 0
            [position] => 1
            [name] => История на изкуството
            [nameDe] => Kunstgeschichte
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1296
            [url] => istoria-na-izkustvoto
        )

    [12] => Array
        (
            [napID] => 33
            [hide] => 0
            [position] => 1
            [name] => История, археология и класическа филология
            [nameDe] => DE
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 895
            [url] => istoria-arheologia-i-klasicheska-filologia
        )

    [13] => Array
        (
            [napID] => 23
            [hide] => 0
            [position] => 1
            [name] => Математика и статистика
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1048
            [url] => matematika-i-statistika
        )

    [14] => Array
        (
            [napID] => 24
            [hide] => 0
            [position] => 1
            [name] => Машиностроене, мехатроника и инженерен мениджмънт
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1463
            [url] => mashinostroene-mehatronika-i-injeneren-menidjmant
        )

    [15] => Array
        (
            [napID] => 11
            [hide] => 0
            [position] => 1
            [name] => Медии и комуникации
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 1
            [hits] => 1818
            [url] => medii-i-komunikacii
        )

    [16] => Array
        (
            [napID] => 22
            [hide] => 1
            [position] => 1
            [name] => Медицински специалности
            [nameDe] => DE
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 16
            [url] => medicinski-specialnosti
        )

    [17] => Array
        (
            [napID] => 12
            [hide] => 0
            [position] => 1
            [name] => Музика
            [nameDe] => Musik
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 1
            [hits] => 839
            [url] => muzika
        )

    [18] => Array
        (
            [napID] => 13
            [hide] => 0
            [position] => 1
            [name] => Педагогика
            [nameDe] => Pädagogik
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 944
            [url] => pedagogika
        )

    [19] => Array
        (
            [napID] => 25
            [hide] => 0
            [position] => 1
            [name] => Политология, социология и културология
            [nameDe] => DE
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 992
            [url] => politologia-sociologia-i-kulturologia
        )

    [20] => Array
        (
            [napID] => 14
            [hide] => 0
            [position] => 1
            [name] => Право и бизнес - право
            [nameDe] => DE
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1459
            [url] => pravo-i-biznes-pravo
        )

    [21] => Array
        (
            [napID] => 15
            [hide] => 0
            [position] => 1
            [name] => Психология
            [nameDe] => Psychologie
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 1
            [hits] => 948
            [url] => psihologia
        )

    [22] => Array
        (
            [napID] => 16
            [hide] => 0
            [position] => 1
            [name] => Спорт
            [nameDe] => Sport
            [txt] => 
            [price] => 59.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1108
            [url] => sport
        )

    [23] => Array
        (
            [napID] => 17
            [hide] => 0
            [position] => 1
            [name] => Строително инженерство и геодезия
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1286
            [url] => stroitelno-injenerstvo-i-geodezia
        )

    [24] => Array
        (
            [napID] => 37
            [hide] => 0
            [position] => 1
            [name] => Фармация
            [nameDe] => Фармация
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 2209
            [url] => farmacia
        )

    [25] => Array
        (
            [napID] => 26
            [hide] => 0
            [position] => 1
            [name] => Физика и астрономия
            [nameDe] => Physik und Astronomie
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1064
            [url] => fizika-i-astronomia
        )

    [26] => Array
        (
            [napID] => 27
            [hide] => 0
            [position] => 1
            [name] => Филология - Английски език
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 811
            [url] => filologia-angliyski-ezik
        )

    [27] => Array
        (
            [napID] => 30
            [hide] => 0
            [position] => 1
            [name] => Филология - други европейски езици
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 1629
            [url] => filologia-drugi-evropeyski-ezici
        )

    [28] => Array
        (
            [napID] => 31
            [hide] => 0
            [position] => 1
            [name] => Филология - Източни езици
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 900
            [url] => filologia-iztochni-ezici
        )

    [29] => Array
        (
            [napID] => 28
            [hide] => 0
            [position] => 1
            [name] => Филология - Немски език
            [nameDe] => DE
            [txt] => 
            [price] => 29.00
            [txt1] => 
            [txt2] => 
            [ogr] => 0
            [hits] => 982
            [url] => filologia-nemski-ezik
        )

)
1