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 ('Anti-cannabis_media', 'Drugs_in_the_United_States', 'English-language_films', 'Films_adapted_into_plays', 'Films_directed_by_Louis_J._Gasnier', 'Suicide_in_film', '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', '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', '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)', 'California_Democrats', 'California_state_senators', 'Deaths_by_firearm_in_California', 'Harvey_Milk', 'Mayors_of_San_Francisco', 'Murdered_American_politicians', 'People_murdered_in_California', 'Peoples_Temple', 'San_Francisco_Board_of_Supervisors_members', 'United_States_Navy_personnel');
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...