Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Airklizz
.
Toggle Highlighting
SQL
select cat_title, cat_pages-cat_subcats from category where cat_title in ('Illegal_drug_trade', 'West_Africa', 'Justice', 'Social_inequality', 'Social_justice', 'Social_liberalism', 'Media_industry', 'Publishing', 'Human_behavior', 'Public_health', 'Sanitation', '2000s_children\'s_animated_films', '2000s_children\'s_fantasy_films', '2000s_coming-of-age_films', '2001_anime_films', '2001_fantasy_films', '2001_films', 'Animated_coming-of-age_films', 'Animated_films_about_dragons', 'Animated_films_featuring_female_antagonists', 'Anime_with_original_screenplays', 'Annie_Award_winners', 'Best_Animated_Feature_Academy_Award_winners', 'Best_Animated_Feature_Annie_Award_winners', 'Best_Animated_Feature_Broadcast_Film_Critics_Association_Award_winners', 'Coming-of-age_anime_and_manga', 'Fantasy_anime_and_manga', 'Fiction_about_curses', 'Films_about_curses', 'Films_about_families', 'Films_about_frogs', 'Films_about_kidnapping', 'Films_about_parallel_universes', 'Films_about_shapeshifting', 'Films_about_witchcraft', 'Films_directed_by_Hayao_Miyazaki', 'Films_featuring_anthropomorphic_characters', 'Films_scored_by_Joe_Hisaishi', 'Films_set_in_Japan', 'Films_set_in_the_2000s', 'Golden_Bear_winners', 'Isekai_anime_and_manga', 'Japanese-language_films', 'Japanese_animated_fantasy_films', 'Japanese_coming-of-age_films', 'Japanese_fantasy_adventure_films', 'Japanese_films', 'Japanese_ghost_films', 'Japanese_mythology_in_anime_and_manga', 'Picture_of_the_Year_Japan_Academy_Prize_winners');
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
.
Checking query status...