SELECT termek.termek_id, termek_nev, termek_leiras, termek_rovidleiras, termek_nev, termek_ar, termek_azonosito FROM (termek LEFT JOIN termek_alkategoria ON termek_alkategoria.termek_id=termek.termek_id) LEFT JOIN termek_fokategoria ON termek_fokategoria.termek_id=termek.termek_id WHERE termek.isActive='1' AND t.termek_azonosito='bide_csaptelep_22595' ORDER BY termek_nev;