Container categories w/articles

This query is marked as a draft This query has been published by Cryptic.

Direct subcategories of [[Category:Container categories]] with at least one member page in mainspace.

For [[WP:RAQ#Displaying all categories in [Category:Container categories] which also have mainspace pages in them.]] circa 23 November 2022.

SQL

SELECT CONCAT('Category:', catpage.page_title), COUNT(*)
FROM page AS catpage
JOIN categorylinks AS parentcat ON parentcat.cl_from = catpage.page_id
JOIN categorylinks AS childcat ON childcat.cl_to = catpage.page_title
JOIN page AS childpage ON childpage.page_id = childcat.cl_from
WHERE catpage.page_namespace = 14
  AND parentcat.cl_to = 'Container_categories'
  AND childpage.page_namespace = 0
GROUP BY catpage.page_title;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...