Categories represented in All_articles_lacking_sources

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

Bare categories without subcategorisation.
RESULT SUMMARY 15 May 2024: 16,2628 categories including very small categories and tracking categories

SQL

SELECT c1.cat_title AS category, COUNT(DISTINCT cl1.cl_from) AS article_count
FROM categorylinks cl1
JOIN page p1 ON cl1.cl_from = p1.page_id
JOIN categorylinks cl2 ON cl1.cl_from = cl2.cl_from
JOIN page p2 ON cl2.cl_from = p2.page_id
JOIN category c1 ON cl1.cl_to = c1.cat_title
WHERE cl2.cl_to = 'All_articles_lacking_sources'
AND p1.page_namespace = 0
AND p2.page_namespace = 0
GROUP BY c1.cat_title
ORDER BY article_count DESC;

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...