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", IP.page_title AS "Person nicht in <onlyinclude>"
  FROM page AS InclBKS, page_props AS InclPP, linktarget AS InclLT, templatelinks AS InclTL, # Included BKS
       linktarget AS PDLT, templatelinks AS PDTL, # Template Personendaten
       pagelinks AS IPP, linktarget AS IPLT, # inkludierte Personenseite
       pagelinks AS BKSPL, linktarget AS BKSLT, page AS BKS, # Including BKS
       page AS IP LEFT JOIN page AS BKSP # Person aus inkludierter BKS nicht in Person aus inkludierender BKS
                    ON IP.page_id = BKSP.page_id
 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 = BKSPL.pl_from
   AND BKSPL.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

   AND BKS.page_id = InclTL.tl_from
   AND BKS.page_namespace = 0

   AND BKSP.page_id IS NULL
LIMIT 100
SQL

Checking query status...
