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 ('Nintendo_Switch_games', 'PlayStation_4_games', 'PlayStation_Network_games', 'PlayStation_Vita_games', 'Point-and-click_adventure_games', 'Telltale_Games_games', 'The_Walking_Dead_video_games', 'Video_game_sequels', 'Video_games_developed_in_the_United_States', 'Video_games_featuring_female_antagonists', 'Video_games_featuring_female_protagonists', 'Video_games_scored_by_Jared_Emerson-Johnson', 'Video_games_set_in_Maryland', 'Video_games_set_in_Virginia', 'Video_games_with_alternate_endings', 'Video_games_with_cel-shaded_animation', 'Windows_games', 'Xbox_One_games', 'Business_law', 'Currency', 'Monetary_reform', 'Dioecious_plants', 'Entheogens', 'Euphoriants', 'Herbs', 'Rosales_genera', 'Taxa_named_by_Carl_Linnaeus', 'Gross_domestic_product', '1909_establishments_in_California', '1909_in_the_environment', 'Environment_of_California', 'Government_agencies_established_in_1909', 'State_law_enforcement_agencies_of_California', 'State_wildlife_and_natural_resource_agencies_of_the_United_States', 'Communes_of_Manche', 'Manche_geography_stubs', 'Biofuels', 'Cannabis_smoking', 'Fiber_plants', 'Hemp', 'Herbalism', 'Non-food_crops', 'Association_Club_Sparta_Praha', 'Hokejové_kluby_v_Praze', 'Conflict_of_laws', 'International_law', 'Jurisdiction', 'Ethnicity', 'National_identity', 'Nationality');
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...