SET NAMES UTF8
SELECT napID, name FROM au_nap WHERE hide = 0 AND url = 'veterinarna-medicina'   ORDER BY name  
SELECT url FROM au_nap WHERE napID = '40'    
UPDATE au_nap SET hits = (hits + 1) WHERE napID = '40'

	SELECT sp.longName, sp.name, usp.*, DATE(usp.fDate1) AS fDate1, DATE(usp.tDate1) AS tDate1, DATE(usp.fDate2) AS fDate2, DATE(usp.tDate2) AS tDate2 FROM au_university_specialty AS usp 
	LEFT JOIN au_specialty AS sp 
	ON sp.specialtyID = usp.specialtyID
	WHERE sp.napID = '40' AND usp.hide = '0' ORDER BY sp.longName
	
	
SELECT url FROM au_nap WHERE napID = '40'    
SELECT txt FROM au_txt WHERE txtID = '8' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '26' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '27' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '28' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '39' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '35' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '31' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '30' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '32' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '33' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '28' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '45' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '44' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '39' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '30' AND hide = 0    
SELECT txt FROM au_txt WHERE txtID = '31' AND hide = 0    

search

search/demo

Array
(
    [siteCountry] => au
)
1

Array
(
)
1

Array
(
    [step] => newdemo
    [napID] => veterinarna-medicina
)
1

1