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 ('United_States_federal_taxation_legislation', '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', 'Novels_set_in_Alabama', 'Novels_set_in_the_1930s', 'Pulitzer_Prize_for_Fiction-winning_works', 'Southern_Gothic_novels', 'To_Kill_a_Mockingbird', 'Pricing', '1949_establishments_in_California', 'Buildings_and_structures_on_the_National_Register_of_Historic_Places_in_Los_Angeles_County,_California', 'California_State_University,_Long_Beach', 'Education_in_Long_Beach,_California', 'Educational_institutions_established_in_1949', 'School_buildings_on_the_National_Register_of_Historic_Places_in_California', 'Universities_and_colleges_in_Los_Angeles_County,_California', 'Flagship_universities_in_the_United_States', 'Public_university_systems_in_the_United_States', 'Types_of_university_or_college', 'Universities_and_colleges_in_the_United_States_by_type_by_state', '1930s_drama_films', '1930s_independent_films', '1936_films', '1936_in_cannabis', 'American_black-and-white_films', 'American_drama_films', 'American_exploitation_films', 'American_films_about_cannabis', 'American_independent_films', 'American_social_guidance_and_drug_education_films', 'Anti-cannabis_media', 'Drugs_in_the_United_States', 'Films_adapted_into_plays', 'Films_directed_by_Louis_J._Gasnier', 'Suicide_in_film', '1970s_in_the_United_States', '1978_murders_in_the_United_States', '1979_murders_in_the_United_States', '1980_murders_in_the_United_States', '1980s_in_the_United_States', '1981_murders_in_the_United_States');
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...