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 ('American_people_who_died_in_prison_custody', 'American_prisoners_sentenced_to_life_imprisonment', 'Depression-era_gangsters', 'Inmates_of_Alcatraz_Federal_Penitentiary', 'People_from_Memphis,_Tennessee', 'Prisoners_and_detainees_of_the_United_States_federal_government', 'Prisoners_sentenced_to_life_imprisonment_by_the_United_States_federal_government', 'Prisoners_who_died_in_United_States_federal_government_detention', '2006_albums', 'Albums_produced_by_David_Castell', 'Blue_October_albums', 'Universal_Records_albums', 'British_contemporary_R&B_musical_groups', 'English_girl_groups', 'English_vocal_groups', 'Musical_groups_established_in_2012', 'Musical_groups_from_London', '2010_establishments_in_California', 'American_companies_established_in_2010', 'Companies_based_in_Beverly_Hills,_California', 'Companies_formed_by_merger', 'Corporate_spin-offs', 'Electronic_music_event_management_companies', 'Entertainment_companies_established_in_2010', 'Festival_organizations', 'Live_Nation_Entertainment', 'Music_festival_organizations', 'Music_promoters', 'Sports_management_companies', 'Ticket_sales_companies', '1994_live_albums', 'Columbia_Records_live_albums', 'Dolly_Parton_live_albums', '1993_births', '21st-century_Sephardi_Jews', 'Ashkenazi_Jews', 'Eurovision_Song_Contest_entrants_of_2018', 'Eurovision_Song_Contest_winners', 'Israeli_Eurovision_Song_Contest_entrants', 'Israeli_Jewish_female_singers', 'Israeli_Jews', 'Israeli_dance_musicians', 'Israeli_expatriates_in_Nigeria', 'Israeli_military_musicians', 'Israeli_people_of_Libyan-Jewish_descent', 'Israeli_people_of_Moroccan-Jewish_descent', 'Israeli_people_of_Polish-Jewish_descent', 'Israeli_pop_singers', 'Mizrahi_Jews', 'People_from_Hod_HaSharon');
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...