Untitled query #54463

SQL

WITH RECURSIVE Cat AS (SELECT page_title
                        FROM page
                       WHERE page_title = 'Person_(Augsburg)'
                         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 Count(DISTINCT page.page_id) as "Unterschiedliche Seiten", Count(page.page_id) as "Seiten, manche mehrfach gezählt"
  FROM Cat, categorylinks, page
 WHERE cl_to = Cat.page_title
   AND page_id = cl_from
   AND page_namespace = 0
   AND cl_type = "page"
SQL

Checking query status...
