Benutzerseiten in Kategorien

SQL

SELECT IF(page_is_redirect = 1,
          CONCAT('[{{fullurl:', REPLACE(page_title, '_', ' '), '|redirect=no}} ', REPLACE(page_title, '_', ' '), ']'),
          CONCAT('[[Benutzer:', REPLACE(page_title, '_', ' '), ']]')) as Benutzerseite,
       GROUP_CONCAT(CONCAT('[[:Kategorie:', REPLACE(cl_to, '_', ' '), ']]') SEPARATOR ', ') as Kategorie
  FROM page, categorylinks
 WHERE page_namespace = 2
   AND cl_from = page_id
   AND cl_to NOT LIKE "Benutzer:%"
   AND cl_to NOT LIKE "Benutzerin:%"
   AND cl_to NOT LIKE "User_%"
   AND cl_to NOT LIKE "Wikipedia:%"
   AND cl_to NOT LIKE "Portal:%"
   AND cl_to NOT LIKE "Vorlage:%"
 GROUP BY page_title
SQL

Checking query status...
