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 ('2016_California_ballot_propositions', '2016_cannabis_law_reform', '2018_in_cannabis', 'Cannabis_ballot_measures_in_the_United_States', 'Cannabis_law_in_California', 'Proposed_laws_of_the_United_States', 'Health', 'Personal_life', 'Causes_of_death', 'Drug_overdose', 'Medical_emergencies', 'Opioids', 'Poisoning_by_drugs,_medicaments_and_biological_substances', '1788_establishments_in_the_United_States', 'Former_British_colonies', 'Georgia_(U.S._state)', 'Gullah_country', 'Southern_United_States', 'States_and_territories_established_in_1788', 'States_of_the_Confederate_States', 'States_of_the_East_Coast_of_the_United_States', 'States_of_the_United_States', 'Ballot_measures', 'Direct_democracy', 'Initiatives', 'Right_to_petition', 'Sources_of_law', 'California_law', 'California_statutes', 'Cannabis_in_California', 'Set_indices', 'Public_health_organizations', 'State_agencies_of_the_United_States', 'State_departments_of_health_of_the_United_States', 'Counties', 'Types_of_country_subdivisions', '2012_films', '2012_horror_films', 'American_films', 'American_supernatural_horror_films', 'Demons_in_film', 'Films_about_Jews_and_Judaism', 'Films_about_exorcism', 'Films_about_spirit_possession', 'Films_directed_by_Ole_Bornedal', 'Films_produced_by_Sam_Raimi', 'Films_shot_in_Vancouver', 'Ghost_House_Pictures_films', 'Religious_horror_films', 'Natural_opium_alkaloids');
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...