Mögliche Personen ohne PD

SQL

SELECT DISTINCT PP.page_title, J.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
 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 tl_from IS NOT NULL

   AND PP.page_id = JPL.pl_from
   AND JPL.pl_title = J.page_title
   AND JPL.pl_namespace = PP.page_namespace
   AND JC.cl_from = JPL.pl_from
   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 = PP.page_namespace
   AND TC.cl_from = TPL.pl_from
   AND TC.cl_to = 'Tag'
   AND T.page_title != 'Historische_Jahrestage'
  LIMIT 10
SQL

Checking query status...
