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

SQL

AخA
 
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
All SQL code is licensed under CC0 License.

Checking query status...