Untitled query #61447

SQL

WITH RECURSIVE Cat AS (SELECT page_title, page_id
                        FROM page
                       WHERE page_title = 'Sportler'
                         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 count(DISTINCT P.page_id) AS "Nicht-Deutsche"
  FROM page AS P, categorylinks AS Wart
 WHERE EXISTS (SELECT 1
                     FROM categorylinks AS Autoren, Cat
                    WHERE Autoren.cl_from = P.page_id
                      AND Autoren.cl_to = Cat.page_title
                   )
   AND Wart.cl_from = P.page_id
   AND Wart.cl_to = 'Wikipedia:GND_fehlt_2001-01'
   AND NOT EXISTS (SELECT 1
                     FROM categorylinks AS Land
                    WHERE Land.cl_from = P.page_id
                      AND Land.cl_to IN ('Deutscher', 'Österreicher', 'Schweizer', 'Liechtensteiner', 'DDR-Bürger')
                  );

WITH RECURSIVE Cat AS (SELECT page_title, page_id
                        FROM page
                       WHERE page_title = 'Sportler'
                         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 count(DISTINCT P.page_id)  AS "Deutsche"
  FROM page AS P, categorylinks AS Wart
 WHERE EXISTS (SELECT 1
                     FROM categorylinks AS Autoren, Cat
                    WHERE Autoren.cl_from = P.page_id
                      AND Autoren.cl_to = Cat.page_title
                   )
   AND Wart.cl_from = P.page_id
   AND Wart.cl_to = 'Wikipedia:GND_fehlt_2001-01'
   AND EXISTS (SELECT 1
                 FROM categorylinks AS Land
                WHERE Land.cl_from = P.page_id
                  AND Land.cl_to IN ('Deutscher', 'Österreicher', 'Schweizer', 'Liechtensteiner', 'DDR-Bürger')
              )
SQL

Checking query status...
