Jump to content

User:Slivicon/CCATS

From Wikipedia, the free encyclopedia

Overview

[edit]

This report lists categories that are members of Category:Container categories that themselves contain non-category members. The number beside each entry indicates how many non-category members that category contains.



Regenerating

[edit]

https://quarry.wmflabs.org/query/45814

SELECT concat( '*[[:Category:', cat_title, ']] - ', cat_pages - cat_subcats )
FROM enwiki_p.categorylinks
INNER JOIN enwiki_p.page ON cl_from = page_id
INNER JOIN enwiki_p.category on cat_title = page_title
WHERE cl_to = 'Container_categories'
AND  cl_type = 'subcat'
AND  cat_pages > cat_subcats
ORDER BY (cat_pages - cat_subcats) DESC, cat_title ASC;