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 ('History_of_Seattle', 'Manufacturing_companies_established_in_1916', 'Multinational_companies_headquartered_in_the_United_States', 'Space_Act_Agreement_companies', 'Technology_companies_established_in_1916', 'Vehicle_manufacturing_companies_established_in_1916', 'Wind_turbine_manufacturers', 'Continents', 'Geography_of_Asia', 'Geography_of_South_Asia', 'Geology_of_Asia', 'Geology_of_India', 'Peninsulas_of_Asia', 'Regions_of_Asia', 'South_Asia', 'Biology-related_lists', 'Human_genes', 'WikiProject_Molecular_and_Cellular_Biology', 'Ethnicity', 'National_identity', 'Nationality', 'Political_geography', 'Political_science_terminology', 'Types_of_communities', '1876_establishments_in_the_United_States', 'Colorado', 'States_and_territories_established_in_1876', 'Gears', '1970s_in_the_United_States', '1978_murders_in_the_United_States', '1979_murders_in_the_United_States', '1980_murders_in_the_United_States', '1980s_in_the_United_States', '1981_murders_in_the_United_States', '1986_murders_in_the_United_States', '20th-century_American_criminals', 'American_male_criminals', 'American_rapists', 'Child_sexual_abuse_in_the_United_States', 'Crimes_in_California', 'Criminals_of_the_San_Francisco_Bay_Area', 'Golden_State_Killer', 'History_of_Contra_Costa_County,_California', 'History_of_Irvine,_California', 'History_of_Orange_County,_California', 'History_of_Sacramento_County,_California', 'History_of_Ventura_County,_California', 'Murder_in_California', 'Rapes_in_the_United_States', 'Stalking');
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...