CONTENIDO Forum

Code: Alles auswählen

[31-Oct-2005 16:13:59] MySQL error 1054: Unknown column 'b.idtplcfg' in 'on clause'
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
        FROM
            con_cat AS a,
            con_cat_lang AS b,
            con_cat_tree AS c
        LEFT JOIN
            con_template_conf AS d
            ON d.idtplcfg = b.idtplcfg
        WHERE
            a.idclient  = '1' AND
            b.idlang    = '1' AND
            c.idcat     = b.idcat AND
            b.idcat     = a.idcat
        ORDER BY
            c.idtree ASC
[31-Oct-2005 16:13:59] next_record called with no query pending.