Kamelopedia:Qualitätssicherung/Fachbereich

aus Kamelopedia, der wüsten Enzyklopädie
Wechseln zu: Navigation, Suche

Gefährdete Artikel aus dem Fachbereich Mode

The DPL extension (version 2.01) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT cl_head.cl_to, `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, rev_user, rev_user_text, rev_comment, rev_timestamp, GROUP_CONCAT(DISTINCT cl_gc.cl_to ORDER BY cl_gc.cl_to ASC SEPARATOR ' | ') AS cats FROM `revision` AS rev, `page` LEFT OUTER JOIN `categorylinks` AS cl_head, `categorylinks` AS cl_gc ON (page_id=cl_head.cl_from AND page_id=cl_gc.cl_from) INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to='Aus_2_mach_1' OR cl0.cl_to='Hufschmiede' OR cl0.cl_to='Humorlose_Artikel' OR cl0.cl_to='Magere_Artikel' OR cl0.cl_to='Stub' OR cl0.cl_to='Text_fehlt' OR cl0.cl_to='Zur_Beerdigung_vorgeschlagener_Artikel' OR cl0.cl_to='Überarbeiten') INNER JOIN `categorylinks` AS cl1 ON `page`.page_id=cl1.cl_from AND (cl1.cl_to='Mode' OR cl1.cl_to='Frisuren' OR cl1.cl_to='Kleidung' OR cl1.cl_to='Kosmetik' OR cl1.cl_to='Textilien' OR cl1.cl_to='Accessoires') WHERE 1=1 AND cl_head.cl_to IN ('Aus_2_mach_1','Hufschmiede','Humorlose_Artikel','Magere_Artikel','Stub','Text_fehlt','Zur_Beerdigung_vorgeschlagener_Artikel','Überarbeiten') AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) GROUP BY cl_head.cl_to, `page`.page_id ORDER BY cl_head.cl_to, rev_timestamp ASC LIMIT 0, 500

Error message is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `categorylinks` AS cl_gc ON (page_id=cl_head.cl_from AND page_id=cl_gc.cl_from)' at line 1 (localhost)