Personen ohne PD

SQL

WITH RECURSIVE Cat AS (SELECT page_title, page_id
                         FROM page
                        WHERE page_title = 'Person_nach_Geschlecht'
                          AND page_namespace = 14
                        UNION
                       SELECT SubCat.page_title, SubCat.page_id
                         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 page.page_title FROM categorylinks, Cat, page LEFT JOIN (templatelinks, linktarget)
                                  ON tl_from = page.page_id
                                 AND tl_target_id = lt_id
                                 AND lt_title = 'Personendaten'
                                 AND lt_namespace = 10
 WHERE page.page_id = cl_from
   AND cl_title = Cat.page_title
   AND tl_from IS NULL
SQL

Checking query status...
