SELECT count(al.kat_id) as almenu, kl.nev, k.*
FROM myshop_kategoria as k LEFT JOIN myshop_kategoria al ON k.kat_id = al.parent_id, myshop_kategoria_leiras as kl
WHERE kl.kat_id = k.kat_id
AND k.parent_id=0
AND kl.nyelv_id = 4
GROUP BY k.kat_sorrend, kl.nev ASC, k.parent_id
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, k.parent_id' at line 6
Fájl: /premium/beatishu/public_html/katalogus/pdf/index.php sor: 24