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 ('State_agencies_of_Alabama', 'Federal_Communications_Commission', 'English_grammar', 'English_words', '2019_Pacific_Games', '2019_in_judo', 'Judo_at_the_Pacific_Games', 'Days_of_the_year', 'January', 'Geography_of_Northern_California', 'Metropolitan_areas_of_California', 'Regions_of_California', 'San_Francisco_Bay_Area', '2020_films', '2020s_LGBT-related_films', 'American_LGBT-related_films', 'American_high_school_films', 'American_romantic_comedy_films', 'American_teen_comedy_films', 'American_teen_drama_films', 'American_teen_romance_films', 'Films_about_interracial_romance', 'LGBT-related_drama_films', 'LGBT-related_romance_films', 'Upcoming_Netflix_original_films', 'Upcoming_films', 'Courts_by_type', 'Quasi-judicial_bodies', 'Legislatures', 'Political_institutions', 'Separation_of_powers', 'Given_names', 'Italian_feminine_given_names', 'Polish_feminine_given_names', 'Portuguese_feminine_given_names', 'Romanian_feminine_given_names', 'Spanish_feminine_given_names', 'Guides', 'Personal_care_and_service_occupations', '1960_American_novels', '1960_debut_novels', 'American_bildungsromans', 'American_novels_adapted_into_films', 'American_novels_adapted_into_plays', 'Books_about_human_rights', 'Fiction_with_false_allegations_of_sex_crimes', 'J._B._Lippincott_&_Co._books', 'Law_in_fiction', 'Novels_about_racism', 'Novels_by_Harper_Lee');
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...