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 ('Strategy_video_games', 'Upcoming_video_games_scheduled_for_2020', 'Video_games_developed_in_Ireland', 'Video_games_set_in_Chicago', 'Video_games_set_in_the_1920s', 'Xbox_One_games', '1965_films', 'American_war_films', 'Films_about_amnesia', 'Films_based_on_short_fiction', 'Films_based_on_works_by_Roald_Dahl', 'Films_directed_by_George_Seaton', 'Films_scored_by_Dimitri_Tiomkin', 'Films_set_in_1944', 'Metro-Goldwyn-Mayer_films', 'Operation_Overlord_films', 'World_War_II_prisoner_of_war_films', '1984_births', '20th-century_American_male_musicians', 'Arista_Nashville_artists', 'Country_musicians_from_Arkansas', 'Singers_from_Arkansas', 'Songwriters_from_Arkansas', '1938_births', '2020_deaths', '20th-century_American_dramatists_and_playwrights', '20th-century_American_male_writers', 'Actors_Studio_alumni', 'American_male_dramatists_and_playwrights', 'American_male_screenwriters', 'American_musical_theatre_librettists', 'American_opera_librettists', 'Columbia_University_alumni', 'Deaths_from_the_2020_coronavirus_pandemic_in_Florida', 'Drama_Desk_Award_winners', 'Gay_writers', 'LGBT_dramatists_and_playwrights', 'LGBT_people_from_Florida', 'LGBT_people_from_Texas', 'LGBT_screenwriters', 'LGBT_writers_from_the_United_States', 'Obie_Award_recipients', 'People_from_Corpus_Christi,_Texas', 'Primetime_Emmy_Award_winners', 'Screenwriters_from_Florida', 'Screenwriters_from_New_York_(state)', 'Screenwriters_from_Texas', 'Tony_Award_winners', 'Writers_from_St._Petersburg,_Florida', 'English_male_singers');
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...