Mögliche Personen ohne PD

SQL

WITH RECURSIVE Cat AS (
                  SELECT page_title, page_id
                    FROM page
                   WHERE page_title IN ('Wikipedia:Liste',
                                        'Liste',
                                        'Familienname',
                                        'Sportveranstaltungen',
                                        'Personengruppe',
                                        'Ort',
                                        'Spiel',
                                        'Geographie_nach_Staat',
                                        'Organisation',
                                        'Konflikt_nach_Jahr',
                                        'Konflikt_nach_Jahrhundert',
                                        'Musik_nach_Jahr',
                                        'Werk_nach_Jahr',
                                        'Werk_nach_Jahrhundert',
                                        'Astronomisches_Objekt',
                                        'Top-Level-Domain',
                                        'Flugunfall_nach_Jahr',
                                        'Vertrag_nach_Jahrhundert',
                                        'Vertrag',
                                        'Raumfahrtmission',
                                        'Orden_und_Ehrenzeichen_nach_Staat',
                                        'Literarische_Figur',
                                        'Individuelles_Säugetier',
                                        'Naturkatastrophe_nach_Jahr',
                                        'Literarisches_Werk',
                                        'Fernsehsendungen',
                                        'Kulturdenkmal_nach_Staat',
                                        'Wahl_nach_Staat',
                                        'Zeitung_nach_Staat',
                                        'Schiff_nach_Staat',
                                        'Veranstaltung_nach_Jahr'
                                       )
                     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 DISTINCT PP.page_title
  FROM pagelinks AS JPL, page AS J, categorylinks AS JC,
       pagelinks AS TPL, page as T, categorylinks AS TC,
       page AS PP LEFT JOIN (templatelinks, linktarget)
                    ON PP.page_id = tl_from
                   AND tl_target_id = lt_id
                   AND lt_title = 'Personendaten'
                   AND lt_namespace = 10
                  LEFT JOIN (categorylinks AS PPC, Cat)
                    ON PP.page_id = PPC.cl_from
                   AND PPC.cl_to = Cat.page_title
 WHERE PP.page_namespace = 0
   #AND PP.page_is_redirect = 0
   #AND PP.page_title = 'Antonia_Maria_von_Portugal'
   AND PP.page_title NOT RLIKE '^[0-9]'
   AND PP.page_title NOT LIKE '%/%'
   AND tl_from IS NULL
   AND PPC.cl_from IS NULL

   AND PP.page_id = JPL.pl_from
   AND JPL.pl_title = J.page_title
   AND JPL.pl_namespace = J.page_namespace
   AND JC.cl_from = J.page_id
   AND JC.cl_to LIKE 'Jahr_(%'
   AND J.page_title RLIKE '^[1-9][0-9]+$'
   AND J.page_namespace = 0

   AND PP.page_id = TPL.pl_from
   AND TPL.pl_title = T.page_title
   AND TPL.pl_namespace = T.page_namespace
   AND TC.cl_from = T.page_id
   AND TC.cl_to = 'Tag'
   AND T.page_title != 'Historische_Jahrestage'
SQL

Checking query status...
