Personen mit Klammerlemma und einem Staat in der Klammer

SQL

SELECT page_title
  FROM page, templatelinks
 WHERE page_namespace = 0
   AND page_title LIKE "%\\_(%)"
       /* ische bzw. ischer gefolgt von Leerzeichen (das wird in der Datenbank als Unterstreichung genommen */
   AND (
        page_title RLIKE "\\(.*ischer?_.*\\)"
     OR page_title RLIKE "\\(.*deutscher?_.*\\)"
     OR page_title RLIKE "\\(.*yscher?_.*\\)"
       )
   AND page_title NOT RLIKE "\\(Nordischer_Kombinierer(,_[0-9]*)?\\)" /* Nordischer Kombinierer, (Jahreszahl) rausnehemen */
   AND page_title NOT RLIKE "\\(.*atholischer_.*\\)" /* Katholischer rausnehmen */
   AND page_title NOT RLIKE "\\(.*uddhistischer_.*\\)" /* buddhistischer bzw. Buddhistischer rausnehmen */
   AND tl_from = page_id
   AND tl_namespace = 10
   AND tl_title = 'Personendaten';

WITH RECURSIVE Cat AS (SELECT page_title
                        FROM page
                       WHERE page_title = 'Staat'
                         AND page_namespace = 14
                       UNION
                      SELECT SubCat.page_title
                        FROM page AS SubCat, categorylinks, Cat
                       WHERE SubCat.page_namespace = 14
                         AND cl_from = SubCat.page_id
                         AND cl_to = Cat.page_title
                         AND cl_type = "subcat"
                     )
SELECT Person.page_title
  FROM Cat, categorylinks, page AS Staat, page AS Person, templatelinks
 WHERE cl_to = Cat.page_title
   AND Staat.page_id = cl_from
   AND Staat.page_namespace = 0
   AND cl_type = "page"
   AND Person.page_namespace = 0
   AND Person.page_title LIKE "%\\_(%)"
   AND Person.page_title RLIKE CONCAT("[(,]", Staat.page_title, "[,)]")
   AND tl_from = Person.page_id
   AND tl_namespace = 10
   AND tl_title = 'Personendaten';

WITH RECURSIVE Cat AS (SELECT page_title
                        FROM page
                       WHERE page_title = 'Staat'
                         AND page_namespace = 14
                       UNION
                      SELECT SubCat.page_title
                        FROM page AS SubCat, categorylinks, Cat
                       WHERE SubCat.page_namespace = 14
                         AND cl_from = SubCat.page_id
                         AND cl_to = Cat.page_title
                         AND cl_type = "subcat"
                     )
SELECT Person.page_title
  FROM Cat, categorylinks, page AS Staat, redirect, page AS RedirStaat, page AS Person, templatelinks
 WHERE cl_to = Cat.page_title
   AND Staat.page_id = cl_from
   AND Staat.page_namespace = 0
   AND cl_type = "page"
   AND RedirStaat.is_redirect = 1
   AND rd_from = RedirStaat.page_id
   AND rd_title = Staat.page_title
   AND rd_namespace = 0
   AND Person.page_namespace = 0
   AND Person.page_title LIKE "%\\_(%)"
   AND Person.page_title RLIKE CONCAT("[(,]", RedirStaat.page_title, "[,)]")
   AND tl_from = Person.page_id
   AND tl_namespace = 10
   AND tl_title = 'Personendaten';
SQL

Checking query status...
