CONTENIDO Forum

Code: Alles auswählen

$sql = "SELECT DISTINCT ARTLANG.title, ARTLANG.lastmodified, ARTLANG.idart, CAT.idcat 
           FROM {$cfg['tab']['art_lang']} AS ARTLANG, 
                    {$cfg['tab']['cat_art']} AS CATART, 
                    {$cfg['tab']['cat']} AS CAT, 
                    {$cfg['tab']['content']} AS CONTENT,
                    {$cfg['tab']['cat_lang']} AS CATLANG
           WHERE ARTLANG.online = '1' AND ARTLANG.idlang= '$lang' 
                      AND ARTLANG.idart = CATART.idart 
                      AND CATART.idcat = CAT.idcat 
                      AND ARTLANG.idartlang = CONTENT.idartlang 
                      AND CATLANG.idcat = CAT.idcat
                      AND CATLANG.idlang = ARTLANG.idlang
                      AND CAT.idclient = '$client' 
                      AND CATLANG.public = '1'
                      AND CATLANG.visible = '1'
           ORDER BY lastmodified desc 
           LIMIT 0,".$anzahl;