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 ('Films_set_in_Los_Angeles', 'Films_shot_in_Los_Angeles', 'Films_shot_in_Los_Angeles_County', 'Organ_transplantation_in_fiction', 'Overbrook_Entertainment_films', 'Relativity_Media_films', '1958_establishments_in_the_United_States', 'Billboard_Hot_100_number-one_singles', 'Billboard_charts', 'Top_lists', '1995_in_cannabis', 'Cannabis_law_reform_organizations_based_in_the_United_States', 'Non-profit_organizations_based_in_Washington,_D.C.', 'Organizations_established_in_1995', 'Political_advocacy_groups_in_the_United_States', 'Economy-related_lists_of_superlatives', 'Mass_media_lists', 'Media_franchises', 'Media_industry', 'American_legal_terminology', 'Criminal_law', 'United_States_immigration_law', 'Health_care_occupations', 'Health_informatics', 'Information_privacy', 'Transcription_(linguistics)', '30th-century_BC_establishments', '3rd-millennium_BC_establishments_in_Egypt', 'Egyptian_inventions', 'Tax', '1996_establishments_in_Canada', 'Canadian_federal_departments_and_agencies', 'Centers_for_Disease_Control_and_Prevention', 'Federal_law_enforcement_agencies_of_Canada', 'Health_Canada', 'Health_ministries', 'Ministries_established_in_1996', 'Regulation_of_medical_devices', 'Regulators_of_biotechnology_products', 'Medical_and_health_organizations_based_in_California', 'State_departments_of_health_of_the_United_States', 'Cannabis_companies_of_the_United_States', 'Cannabis_shops', 'Health_care_companies_based_in_Nevada', 'Economic_inequality', 'Measurements_and_definitions_of_poverty', 'Social_issues', '1875_establishments_in_Alabama', 'Government_agencies_established_in_1875', 'Medical_and_health_organizations_based_in_Alabama');
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...