Navigationsleisten fehlen eventuell

SQL

WITH RECURSIVE Cat AS (SELECT page_title, page_id
                         FROM page
                        WHERE page_title = 'Vorlage:Navigationsleiste_Verwaltungsgliederung_(Vereinigte_Staaten)'
                          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 Ort.page_title, Navi.page_title
  FROM page AS Navi, pagelinks, page AS Ort, Cat, categorylinks
 WHERE Ort.page_namespace = 0
   AND Navi.page_namespace = 10
   AND Cat.page_title = cl_to
   AND cl_from = Navi.page_id
   AND Navi.page_title LIKE "Navi%leiste%"
   # AND Navi.page_title != "NaviBlock"
   # AND Navi.page_title NOT LIKE "%/Doku"
   # AND Navi.page_title NOT LIKE "%/Test"
   AND pl_from = Navi.page_id
   AND pl_title = Ort.page_title
   AND pl_namespace = Ort.page_namespace
   AND Ort.page_title NOT IN ('County_(Vereinigte_Staaten)',
                              'Bundesstaat_der_Vereinigten_Staaten',
                              'Metropolitan_Statistical_Area',
                              'Census-designated_place',
                              'City_(Vereinigte_Staaten)',
                              'Town_(Vereinigte_Staaten)',
                              'County_Seat',
                              'Village_(Vereinigte_Staaten)',
                              'Gemeindefreies_Gebiet',
                              'Indianerreservat',
                              'Virginia',
                              'Oregon',
                              'Pennsylvania',
                              'Florida',
                              'Texas',
                              'South_Carolina',
                              'North_Carolina',
                              'New_Hampshire',
                              'Nevada',
                              'New_York_(Bundesstaat)'
                             )
   AND Navi.page_title != CONCAT('Navigationsleiste_Orte_im_', Ort.page_title)
   AND Ort.page_title NOT LIKE "Liste%"
   AND NOT EXISTS (SELECT 1
                     FROM templatelinks, linktarget
                    WHERE tl_from = Ort.page_id
                      AND tl_target_id = lt_id
                      AND lt_title = Navi.page_title
                      AND lt_namespace = Navi.page_namespace
                  )
SQL

Checking query status...
