SELECT t4.* FROM (SELECT t3.*, a.ar, a.kiszereles_ara, a.kedvezmenyes_ar FROM (SELECT t2.*, nl.url as termUrl, nl.titl, nl.keyw, nl.descr, nl.name, nl.description, nl.short_description FROM (SELECT t1.*, DISTINCT t.id, t.image_address, t.kod, t.keszlet, t.egyseg, t.gyarto, t.allapot, t.uj, t.sorrend, t.eladott_darab, t.afa_id, t.ingyenes_szallitas,t.suly, t.ar_megjelenites, t.ar_bejelentkezeshez_kotve, t.kosarba_rakhato FROM (SELECT ttk.termek_id, ttk.termek_kategoria_id as kat_id, klt.url_lepcso as katUrl FROM zoldhokft_termek_to_kategoria as ttk INNER JOIN zoldhokft_kategoria_leiras as klt ON klt.kat_id = ttk.termek_kategoria_id WHERE (ttk.termek_kategoria_id=2187) ) as t1 INNER JOIN zoldhokft_termek as t ON t1.termek_id=t.id WHERE t.status='igen' AND t.gongyoleg = 'n' ) as t2 INNER JOIN zoldhokft_nev_leiras as nl ON nl.termek_id = t2.id WHERE nl.language_id= 4) as t3 INNER JOIN zoldhokft_arak as a ON t3.id = a.termek_id WHERE a.arforma_id = 1) as t4 ORDER BY t4.ar ASC LIMIT 0, 20
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DISTINCT t.id, t.image_address, t.kod, t.keszlet, t.egyseg, t.gyarto, t.allap...' at line 3
Fájl: /web/kazanplaza/kazanplaza.hu/include/center/termekek.php sor: 132