TLDs ohne Vorlage TLD

SQL

WITH RECURSIVE Cat AS (SELECT page_title
                         FROM page
                        WHERE page_title = 'Top-Level-Domain'
                          AND page_namespace = 14
                        UNION
                       SELECT SubCat.page_title
                         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 CONCAT('[[', P.page_title, ']]')
  FROM page AS P, categorylinks, Cat
 WHERE page_namespace = 0
   AND cl_from = page_id
   AND cl_to = Cat.page_title
   AND NOT EXISTS ( SELECT 1
                      FROM templatelinks
                     WHERE tl_from = P.page_id
                       AND tl_title = 'Infobox_TLD'	
                       AND tl_namespace = 10
                  )
SQL

Checking query status...
