Kamelopedia:Qualitätssicherung/Fachbereich

Gefährdete Artikel aus dem Fachbereich Biologie

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='Biologie' OR cl1.cl_to='Botanik' OR cl1.cl_to='Baum' OR cl1.cl_to='Obst_&_Gemüse' OR cl1.cl_to='Blumen' OR cl1.cl_to='Spezies' OR cl1.cl_to='Raubtier' OR cl1.cl_to='Kamele' OR cl1.cl_to='Vögel' OR cl1.cl_to='Fische' OR cl1.cl_to='Unterwasser' OR cl1.cl_to='Amphibien' OR cl1.cl_to='Mikroben' OR cl1.cl_to='Würmer' OR cl1.cl_to='Schlangen' OR cl1.cl_to='Saurier' OR cl1.cl_to='Ausgestorben' OR cl1.cl_to='Aliens' OR cl1.cl_to='Fabelwesen' OR cl1.cl_to='Mischwesen' OR cl1.cl_to='Krabbeltiere' OR cl1.cl_to='Schafe' OR cl1.cl_to='Bären' OR cl1.cl_to='Eulen' OR cl1.cl_to='Enten' OR cl1.cl_to='Schweine' OR cl1.cl_to='Rindviecher' OR cl1.cl_to='Hunde' OR cl1.cl_to='Pferde_&_Esel' OR cl1.cl_to='Katzen' OR cl1.cl_to='Insekten' OR cl1.cl_to='Nagetiere' OR cl1.cl_to='Dickhäuter' OR cl1.cl_to='Hornträger' OR cl1.cl_to='Wale' OR cl1.cl_to='Komische_Viecher' OR cl1.cl_to='Muscheln_&_Schnecken' OR cl1.cl_to='Komische_Typen' OR cl1.cl_to='Affen' OR cl1.cl_to='Sexualität' OR cl1.cl_to='Männer' OR cl1.cl_to='Frauen' OR cl1.cl_to='Fortpflanzung' OR cl1.cl_to='Eier' OR cl1.cl_to='Pilze' OR cl1.cl_to='Ausgestorben' OR cl1.cl_to='Landwirtschaft' OR cl1.cl_to='Fäkalien' OR cl1.cl_to='Anatomie' OR cl1.cl_to='Krankheiten' OR cl1.cl_to='Gesundheit' OR cl1.cl_to='Biophysik' OR cl1.cl_to='Spezies' OR cl1.cl_to='Raubtier' OR cl1.cl_to='Kamele' OR cl1.cl_to='Böses_Kamel' OR cl1.cl_to='Komische_Kamele' OR cl1.cl_to='Chamäleons' OR cl1.cl_to='Kamelkunde' OR cl1.cl_to='Gutes_Kamel' OR cl1.cl_to='K-Stadt' OR cl1.cl_to='Dromedar' OR cl1.cl_to='Ehrenkamele' OR cl1.cl_to='Kamele,_die_kein_Schwein_kennt' OR cl1.cl_to='Kamelzubehör' OR cl1.cl_to='Vögel' OR cl1.cl_to='Enten' OR cl1.cl_to='Eulen' OR cl1.cl_to='Fische' OR cl1.cl_to='Unterwasser' OR cl1.cl_to='Fische' OR cl1.cl_to='Wale' OR cl1.cl_to='Seehufer' OR cl1.cl_to='Fische' OR cl1.cl_to='Amphibien' OR cl1.cl_to='Mikroben' OR cl1.cl_to='Würmer' OR cl1.cl_to='Schlangen' OR cl1.cl_to='Saurier' OR cl1.cl_to='Ausgestorben' OR cl1.cl_to='Aliens' OR cl1.cl_to='Monster' OR cl1.cl_to='Fabelwesen' OR cl1.cl_to='Mischwesen' OR cl1.cl_to='Krabbeltiere' OR cl1.cl_to='Insekten' OR cl1.cl_to='Schafe' OR cl1.cl_to='Bären' OR cl1.cl_to='Eulen' OR cl1.cl_to='Enten' OR cl1.cl_to='Schweine' OR cl1.cl_to='Rindviecher' OR cl1.cl_to='Hunde' OR cl1.cl_to='Pudel' OR cl1.cl_to='Pferde_&_Esel' OR cl1.cl_to='Katzen' OR cl1.cl_to='Tiger' OR cl1.cl_to='Insekten' OR cl1.cl_to='Nagetiere' OR cl1.cl_to='Dickhäuter' OR cl1.cl_to='Hornträger' OR cl1.cl_to='Schafe' OR cl1.cl_to='Rindviecher' OR cl1.cl_to='Wale' OR cl1.cl_to='Komische_Viecher' OR cl1.cl_to='Muscheln_&_Schnecken' OR cl1.cl_to='Komische_Typen' OR cl1.cl_to='Komischer_Heiliger' OR cl1.cl_to='Nerd' OR cl1.cl_to='Visionär' OR cl1.cl_to='Affen') 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)