Fehlende Einträge im Nekrolog /Däne, Schauspieler)

SQL

WITH RECURSIVE Cat AS (
     SELECT page_title, page_id, 0 AS level
       FROM page
      WHERE page_title = 'Schauspieler'
        AND page_namespace = 14
      UNION
     SELECT SubCat.page_title, SubCat.page_id, Cat.level + 1
       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'
        AND Cat.level < 5
     )
SELECT CONCAT('[[ ', REPLACE(Person.page_title, '_', ' '), ' ]]') AS Artikel, Gestorben.cl_to,
       GROUP_CONCAT(CONCAT('[[:Kategorie:', REPLACE(Cat.page_title, '_', ' '), ']]') ORDER BY Cat.page_title SEPARATOR ' ') AS "Beruf(e)"
  FROM categorylinks AS Gestorben, categorylinks AS Land, Cat, categorylinks AS Job,
       page AS Person LEFT JOIN (pagelinks, linktarget, page AS Nekrolog)
                        ON lt_title = Person.page_title
                       AND lt_namespace = 0
                       AND pl_target_id = lt_id
                       AND Nekrolog.page_id = pl_from
                       AND Nekrolog.page_title LIKE 'Nekrolog_%'
 WHERE Person.page_namespace = 0
   AND Person.page_id = Gestorben.cl_from
   AND Gestorben.cl_to LIKE 'Gestorben%'
   AND Person.page_id = Land.cl_from
   AND Land.cl_to = 'Däne'
   AND Person.page_id = Job.cl_from
   AND Job.cl_to = Cat.page_title
   AND Nekrolog.page_id IS NULL
 GROUP BY Person.page_title
SQL

Checking query status...
