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 ('1846_establishments_in_Prussia', 'Art_museums_and_galleries_in_Berlin', 'Modern_art_museums_in_Germany', 'Railway_stations_in_Berlin', 'Railway_stations_opened_in_1846', 'Repurposed_railway_stations_in_Europe', '1989_births', 'Vietnamese_female_models', 'Vietnamese_film_actresses', 'Vietnamese_television_actresses', 'Geometric_shapes', 'Glossaries_of_mathematics', 'Lists_of_shapes', 'Mathematics-related_lists', 'Wikipedia_glossaries', 'Bavaria', 'Boii', 'States_of_the_Weimar_Republic', 'Conflicts_in_1939', 'Conflicts_in_1940', 'Conflicts_in_1941', 'Conflicts_in_1942', 'Conflicts_in_1943', 'Conflicts_in_1944', 'Conflicts_in_1945', 'Global_conflicts', 'Modern_Europe', 'Modern_history', 'Nuclear_warfare', 'War', 'Wars_involving_Albania', 'Wars_involving_Australia', 'Wars_involving_Austria', 'Wars_involving_Belgium', 'Wars_involving_Bolivia', 'Wars_involving_Brazil', 'Wars_involving_British_India', 'Wars_involving_Bulgaria', 'Wars_involving_Cambodia', 'Wars_involving_Canada', 'Wars_involving_Chile', 'Wars_involving_Colombia', 'Wars_involving_Costa_Rica', 'Wars_involving_Croatia', 'Wars_involving_Cuba', 'Wars_involving_Czechoslovakia', 'Wars_involving_Denmark', 'Wars_involving_Ecuador', 'Wars_involving_Egypt', 'Wars_involving_El_Salvador');
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...