Fehlverlinkungen von Skispringern

SQL

WITH RECURSIVE Cat AS (SELECT page_title, page_id
                         FROM page
                        WHERE page_title IN ('Skispringer_nach_Staat'
                                            )
                          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 springerList.page_title, springer.page_title
  FROM page AS springerList,
       pagelinks, linktarget AS springerTarget, templatelinks, linktarget AS PDtarget,
       page AS springer LEFT JOIN (categorylinks, Cat)
                         ON springer.page_id = cl_from
                        AND cl_to = Cat.page_title
 WHERE springerList.page_namespace = 0
   AND springerList.page_title = 'Skiflugweltrekord'
   AND pl_from = springerList.page_id
   AND pl_target_id = springerTarget.lt_id
   AND springerTarget.lt_title = springer.page_title
   AND springerTarget.lt_namespace = springer.page_namespace
   AND springer.page_namespace = 0
   AND tl_from = springer.page_id
   AND tl_target_id = PDtarget.lt_id
   AND PDtarget.lt_namespace = 10
   AND PDtarget.lt_title = 'Personendaten'
   AND Cat.page_id IS NULL
SQL

Checking query status...
