Page count in cat tree by namespace

Overview of pages in the [[Category:Stub-Class articles]] tree, by namespace.

For [[WP:RAQ#Stub-class articles not tagged with a stub template]] circa 2023 November 25.

SQL

SET @basecat = 'Stub-Class articles';
SET max_recursive_iterations = 3; -- current maximum depth for this tree; 2504 categories, 8883596 pages

SET @basecat = REPLACE(@basecat, ' ', '_');
WITH RECURSIVE deepcat (subcat) AS
(
  SELECT @basecat

  UNION DISTINCT

  SELECT page_title
  FROM categorylinks
  JOIN page ON page_id = cl_from AND page_namespace = 14
  JOIN deepcat ON cl_to = subcat
)
SELECT page_namespace, COUNT(DISTINCT page_title)
FROM page
JOIN categorylinks ON cl_from = page_id
JOIN deepcat ON cl_to = subcat
GROUP BY page_namespace;

SQL

Checking query status...