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 ('1986_murders_in_the_United_States', '20th-century_American_criminals', 'American_male_criminals', 'American_rapists', 'American_serial_killers', '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', 'Male_serial_killers', 'Murder_in_California', 'Rapes_in_the_United_States', 'Stalking', 'Ventura,_California', 'Violence_against_women_in_the_United_States', '1957_establishments_in_India', 'Kerala_Legislative_Assembly', 'State_legislatures_of_India', 'Unicameral_legislatures', '2009_in_California', '2009_in_cannabis', 'Proposed_laws_of_California', '1986_California_ballot_propositions', 'HIV/AIDS_in_the_United_States', 'Initiatives_in_the_United_States', 'LaRouche_movement', '1990_in_Canadian_case_law', 'Canadian_administrative_case_law', 'Canadian_law_stubs', 'Maize_production', 'Supreme_Court_of_Canada_cases', 'Medical_and_health_organizations_based_in_California', 'State_agencies_of_California', 'Evaluation_methods', 'Internet_service_providers', 'Lawyers_by_type', 'Prosecution', '1929_births', '1978_deaths', '20th-century_American_politicians', 'American_manslaughter_victims', 'American_people_of_Italian_descent', 'Assassinated_American_politicians', 'Assassinated_mayors', 'Burials_at_Holy_Cross_Cemetery_(Colma,_California)');
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...