Fork of
SELECT * FROM ukwikibooks_p.category
by Ilya
This query is marked as a draft
This query has been published
by Ilya.
SQL
x
USE ukwikibooks_p;
SELECT
cl_to,
count(1) as children
FROM categorylinks
WHERE
NOT EXISTS (
SELECT 1 FROM page
WHERE page_title = cl_to
)
GROUP BY cl_to
ORDER BY children
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.