BKS-Seiten zu Personen die in andere Namensseiten unvollständig inkludiert sind

SQL

SELECT InclBKS.page_title AS "Inkludierte BKS", BKS.page_title AS "Inkludierende BKS"
  FROM page AS InclBKS, page_props AS InclPP, linktarget AS InclLT, templatelinks AS InclTL, # Included BKS
       page AS IP, pagelinks AS IPP, linktarget AS IPLT, # inkludierte Personenseite
       linktarget AS PDLT, templatelinks AS PDTL, # Template Personendaten
       page AS BKS # Including BKS
            LEFT JOIN (pagelinks AS BKSP, linktarget AS BKSLT, page AS BKSP)
              ON BKS.page_id = BKSP.pl_from
             AND BKSP.pl_target_id = BKSLT.lt_id
             AND BKSLT.lt_title = BKSP.page_title
             AND BKSLT.lt_namespace = BKSP.page_namespace
             AND BKSP.page_namespace = 0
 WHERE InclBKS.page_namespace = 0
   AND InclBKS.page_id = InclPP.pp_page
   AND InclPP.pp_propname = 'disambiguation'
   AND InclLT.lt_title = InclBKS.page_title
   AND InclLT.lt_namespace = InclBKS.page_namespace
   AND InclLT.lt_id = InclTL.tl_target_id

   AND IPP.pl_from = InclBKS.page_id
   AND IPP.pl_target_id = IPLT.lt_id
   AND IPLT.lt_title = IP.page_title
   AND IPLT.lt_namespace = IP.page_namespace
   AND IP.page_namespace = 0
   AND IP.page_id = PDTL.tl_from
   AND PDTL.tl_target_id = PDLT.lt_id
   AND PDLT.lt_title = 'Personendaten'
   AND PDLT.lt_namespace = 10

   AND BKS.page_id = InclTL.tl_from
   AND BKS.page_namespace = 0
   
 LIMIT 10
SQL

Checking query status...
