CONTENIDO Forum

Code: Alles auswählen

'AND d.is_start = 0'

Code: Alles auswählen

SELECT c.idcat, d.idart, e.idartlang, e.created, DATE_FORMAT(e.lastmodified,'%d.%m.%Y') AS erstellungsdatum 
                FROM {$cfg['tab']['cat']} AS a, 
                {$cfg['tab']['cat']} AS b, 
                {$cfg['tab']['cat']} AS c 
                LEFT JOIN {$cfg['tab']['cat_art']} AS d ON c.idcat = d.idcat 
                LEFT JOIN {$cfg['tab']['art_lang']} AS e ON d.idart = e.idart 
                WHERE 
                    ( 
                        ( 
                            c.idcat = b.idcat 
                            AND b.parentid = a.idcat 
                        ) 
                        OR 
                        ( 
                            c.idcat = b.idcat 
                            AND b.idcat = a.idcat 
                        ) 
                    ) 
                    AND a.idcat = $categorie 
                    AND e.online = 1 
                    AND e.redirect = 0 
                    AND e.external_redirect = 0 
                    AND e.idlang = $lang 
                    
                    /* AND d.is_start = 0 (Geht nicht) */

                ORDER BY $strSort $strRichtung 
                LIMIT $limit, $angezeigte_anzahl