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 ('Collier_Trophy_recipients', 'Distinguished_Eagle_Scouts', 'Harmon_Trophy_winners', 'Harvard_Business_School_Advanced_Management_Program_attendees', 'Jim_Lovell', 'Military_personnel_from_Cleveland', 'Military_personnel_from_Milwaukee', 'Presidential_Medal_of_Freedom_recipients', 'Project_Gemini_astronauts', 'Recipients_of_the_Air_Medal', 'Recipients_of_the_Congressional_Space_Medal_of_Honor', 'Recipients_of_the_Distinguished_Flying_Cross_(United_States)', 'Recipients_of_the_Legion_of_Honour', 'Recipients_of_the_NASA_Distinguished_Service_Medal', 'Recipients_of_the_NASA_Exceptional_Service_Medal', 'Recipients_of_the_Navy_Distinguished_Service_Medal', 'Recipients_of_the_Silver_Buffalo_Award', 'Toastmasters_members', 'United_States_Astronaut_Hall_of_Fame_inductees', 'United_States_Naval_Academy_alumni', 'United_States_Naval_Aviators', 'United_States_Naval_Test_Pilot_School_alumni', 'United_States_Navy_astronauts', 'United_States_Navy_officers', 'University_of_Southern_California_alumni', 'University_of_Wisconsin–Madison_alumni', 'Antiseptics', 'Disinfectants', 'Hand', 'Medical_hygiene', 'Personal_hygiene_products', 'Skin_care', 'World_Health_Organization_essential_medicines', '1869_establishments_in_Massachusetts', 'Medical_and_health_organizations_based_in_Massachusetts', 'State_agencies_of_Massachusetts', 'English_grammar', 'English_words', '2012_establishments_in_California', '2012_in_cannabis', 'California_university_stubs', 'Cannabis_research', 'Educational_institutions_established_in_2012', 'Bank_regulation', '1970_in_American_politics', '1970_in_cannabis', 'Controlled_Substances_Act', 'Drug_Enforcement_Administration', 'History_of_drug_control', 'United_States_federal_criminal_legislation');
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...