CONTENIDO Forum

Code: Alles auswählen

 $sql = "SELECT
                        a.preid AS preid,
                        a.postid AS postid,
                        a.parentid AS parentid,
                c.idcat AS idcat,
                c.level AS level,
                b.name AS name,
                b.public AS public,
                b.visible AS online,
                d.idtpl AS idtpl,
                                b.idlang AS idlang
            FROM
               (".$cfg["tab"]["cat"]." AS a,
                ".$cfg["tab"]["cat_lang"]." AS b,
                ".$cfg["tab"]["cat_tree"]." AS c)
            LEFT JOIN
                ".$cfg["tab"]["tpl_conf"]." AS d
                ON d.idtplcfg = b.idtplcfg
            WHERE
                a.idclient  = '".$client."' AND
                (b.idlang    = '".$lang."' OR
                                 b.idlang        = '".$syncoptions."') AND
                c.idcat     = b.idcat AND
                b.idcat     = a.idcat
            ORDER BY
                c.idtree ASC";