Folgende Abfrage löst mein Problem:
Code: Alles auswählen
$sql = "SELECT
A.idcat,
B.parentid,
C.name,
C.public,
C.idcatlang
FROM
".$cfg["tab"]["cat_tree"]." AS A,
".$cfg["tab"]["cat"]." AS B,
".$cfg["tab"]["cat_lang"]." AS C
WHERE
A.idcat = B.idcat AND
B.idcat = C.idcat AND
B.idclient = '$client' AND
C.idlang = '$lang' AND
C.visible = '1' AND
C.startidartlang != '0' AND
B.parentid = '$cat'
ORDER BY
A.idtree";
Thomas