Rotverlinkte Vornamensträger

SQL

USE dewiki_p;
SELECT REPLACE(P.page_title, '_', ' '), GROUP_CONCAT(REPLACE(pl_title, '_', ' ') SEPARATOR ', ')
  FROM page AS P, categorylinks, pagelinks LEFT JOIN page AS rotlink
                                                  ON pl_namespace = rotlink.page_namespace
                                                 AND pl_title = rotlink.page_title
 WHERE P.page_namespace = 0
   AND P.page_id = cl_from
   AND (cl_to = 'Vorname'
        OR cl_to LIKE '%\_Vorname'
       )
   AND pl_from = P.page_id
   AND pl_namespace = 0
   AND pl_title LIKE CONCAT(SUBSTRING_INDEX(P.page_title, '_(', 1), '\_%')
   AND pl_title NOT LIKE CONCAT(SUBSTRING_INDEX(P.page_title, '_(', 1), '\_(%')
   AND rotlink.page_id IS NULL
 GROUP BY P.page_title
 LIMIT 10
SQL

Checking query status...
