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 ('Olympic_gold_medalists_for_the_United_States_in_swimming', 'Olympic_swimmers_of_the_United_States', 'Pan_American_Games_gold_medalists_for_the_United_States', 'Pan_American_Games_medalists_in_swimming', 'SMU_Mustangs_men\'s_swimmers', 'Sportspeople_from_Rochester,_New_York', 'Swimmers_at_the_1983_Pan_American_Games', 'Swimmers_at_the_1984_Summer_Olympics', 'Universiade_medalists_in_swimming', 'Universiade_silver_medalists_for_the_United_States', 'World_Aquatics_Championships_medalists_in_swimming', 'World_record_setters_in_swimming', '1898_births', '1970_deaths', '20th-century_American_novelists', '20th-century_German_male_writers', '20th-century_German_novelists', 'American_male_novelists', 'Commanders_Crosses_of_the_Order_of_Merit_of_the_Federal_Republic_of_Germany', 'Disease-related_deaths_in_Switzerland', 'Exilliteratur_writers', 'German_Roman_Catholics', 'German_emigrants_to_the_United_States', 'German_male_novelists', 'German_military_personnel_of_World_War_I', 'German_people_of_French_descent', 'People_from_Osnabrück', 'People_from_Wietmarschen', 'People_from_the_Province_of_Hanover', 'People_with_acquired_American_citizenship', 'Prussian_Army_personnel', 'Roman_Catholic_writers', 'War_writers', '1688_births', '1740_deaths', '18th-century_German_people', '18th-century_Kings_of_Prussia', 'Brandenburgian_nobility', 'Electors_of_Brandenburg', 'German_Calvinist_and_Reformed_Christians', 'House_of_Hohenzollern', 'Kings_of_Prussia', 'People_from_Berlin', 'Princes_of_Neuchâtel', 'Protestant_monarchs', 'Recipients_of_the_Order_of_the_Black_Eagle', 'Sons_of_kings', 'Activism', 'Activism_by_issue', 'Community_organizing');
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...