
Hat jemand einen tip wie man das besser realisieren könnte?
Appropo, wird bei contendio eigentlich gechached?
Gruss 2code
Code: Alles auswählen
SELECT *
FROM a_cat_tree AS A, a_cat AS B, a_cat_lang AS C, a_cat_lang AS D
WHERE A.idcat = B.idcat AND B.idcat = C.idcat AND C.idcat=D.idcat AND C.idlang = '1' AND D.idlang = C.idlang AND B.idclient = '1' AND B.parentid =1 AND
LEVEL <=10 AND C.visible =1
ORDER BY A.idtree