CONTENIDO Forum

Code: Alles auswählen

[28-Apr-2008 13:54:08] /cms/front_content.php?client=1&idcat=0&idart=0&lang=1&error=1 next_record called with no query pending in Module ID 4.
[28-Apr-2008 13:54:20] /cms/front_content.php?client=1&idcat=0&idart=0&lang=1&error=1 MySQL error 1054: Unknown column 'b.idcat' in 'on clause'

                SELECT count(*) AS anzahl
                FROM con_cat AS a,
                     con_cat AS b,
                     con_cat AS c
                LEFT JOIN con_cat_art AS d ON b.idcat = d.idcat
                LEFT JOIN con_art_lang AS e ON d.idart = e.idart
                WHERE
                    (
                        (
                            c.idcat = b.idcat
                            AND b.idcat = a.idcat
                        )
                    )
                    AND a.idcat = 74
                    AND e.online = 1
                    AND e.redirect = 0
                    AND e.external_redirect = 0

Code: Alles auswählen

SELECT count(*) AS anzahl 
                FROM con_cat AS a, 
                     con_cat AS b, 
                     con_cat AS c 
                LEFT JOIN con_cat_art AS d ON b.idcat = d.idcat 
                LEFT JOIN con_art_lang AS e ON d.idart = e.idart 
                WHERE 
...

Code: Alles auswählen

SELECT count(*) AS anzahl 
                FROM (con_cat AS a, 
                     con_cat AS b, 
                     con_cat AS c) 
                LEFT JOIN con_cat_art AS d ON b.idcat = d.idcat 
                LEFT JOIN con_art_lang AS e ON d.idart = e.idart 
                WHERE 
...