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 ('Cities_in_Los_Angeles_County,_California', 'Communities_in_the_San_Fernando_Valley', 'Incorporated_cities_and_towns_in_California', 'Populated_places_established_in_1887', 'Populated_places_established_in_1911', 'Sundown_towns_in_California', 'Joints', 'Skeletal_system', 'Social_constructionism', 'Youth', 'Civil_rights_and_liberties', 'Drug_policy_reform', 'Deficit_spending', 'Government_spending', 'Keynesian_economics', '2020s_in_Paris', '2024_Summer_Olympics', '2024_in_French_sport', '2024_in_multi-sport_events', 'August_2024_sports_events', 'July_2024_sports_events', 'Scheduled_multi-sport_events', 'Summer_Olympics_by_year', 'Summer_Olympics_in_Paris', 'Psychoactive_drugs', '1928_births', '1965_in_spaceflight', '1966_in_spaceflight', '1968_in_spaceflight', '1970_in_spaceflight', 'American_astronauts', 'American_people_of_Czech_descent', 'American_test_pilots', 'Apollo_13', 'Apollo_8', 'Apollo_program_astronauts', 'Aviators_from_Ohio', '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');
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...