CONTENIDO Forum

Code: Alles auswählen

  $myStrSQL = "
          SELECT
             E . idcat ,
             E . idart ,
             E . is_start ,
             C . name ,
             UNIX_TIMESTAMP( D . lastmodified ) AS lastmodified
          FROM
             ".$cfg["tab"]["cat_tree"]." AS A ,
             ".$cfg["tab"]["cat_lang"]." AS C ,
             ".$cfg["tab"]["cat"]." AS B ,
             ".$cfg["tab"]["cat_art"]." AS E
            INNER JOIN  ".$cfg["tab"]["art_lang"]." AS D  ON ( E . idart  =  D . idart )
          WHERE
            A . idcat  =  B . idcat AND
            B . idcat  =  C . idcat AND
            C . idcat  =  E . idcat AND
            B . idclient  = '".$client."' AND
            C . idlang  = '".$lang."' AND
            D . idlang  = '".$lang."' AND
            C . visible  = '1' AND
            E . idcatart IS NOT NULL AND
            C . public  = '1' AND
            D . online = '1'
          ORDER BY
            A . idtree";