User:Slivicon/CCATS
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.
- Category:People_from_Greater_Los_Angeles - 554
- Category:American_screenwriters - 517
- Category:American_women_of_Japanese_descent - 299
- Category:A-League_Women_players - 298
- Category:Indian_television_presenters - 294
- Category:American_chemists - 272
- Category:University_of_Texas_alumni - 262
- Category:Ethnicity_user_templates - 261
- Category:University_of_Nebraska_alumni - 254
- Category:American_rappers - 239
- Category:Historic_districts_on_the_National_Register_of_Historic_Places_in_Arkansas - 235
- Category:Handball-Bundesliga_players - 232
- Category:Spanish-language_television_shows - 227
- Category:American_women_of_Korean_descent - 214
- Category:African-American_women - 191
- Category:Lists_of_United_Kingdom_locations_by_name - 160
- Category:African-American_rappers - 159
- Category:Organizations_based_in_Chicago - 149
- Category:International_rankings_by_country - 139
- Category:British_people_of_English_descent - 137
- Category:Screenshots_of_software - 130
- Category:British_screenwriters - 125
- Category:Ghanaian_men - 124
- Category:University_of_Texas_faculty - 122
- Category:American_women_of_Taiwanese_descent - 121
- Category:Lists_by_country - 111
- Category:American_actors - 101
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;