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 ('1927_deaths', 'Burials_at_Uppsala_old_cemetery', 'Corresponding_Members_of_the_St_Petersburg_Academy_of_Sciences', 'Faraday_Lecturers', 'Fellows_of_the_American_Academy_of_Arts_and_Sciences', 'Foreign_Members_of_the_Royal_Society', 'Foreign_associates_of_the_National_Academy_of_Sciences', 'Honorary_Members_of_the_USSR_Academy_of_Sciences', 'Members_of_the_Royal_Academy_of_Belgium', 'Members_of_the_Royal_Netherlands_Academy_of_Arts_and_Sciences', 'Members_of_the_Royal_Society_of_Sciences_and_Letters_in_Gothenburg', 'Members_of_the_Royal_Swedish_Academy_of_Sciences', 'Nobel_laureates_in_Chemistry', 'Panspermia', 'People_from_Uppsala_Municipality', 'Riga_Technical_University_faculty', 'Stockholm_University_faculty', 'Swedish_Nobel_laureates', 'Swedish_astronomers', 'Swedish_physical_chemists', 'Uppsala_University_alumni', 'Awards_of_the_Royal_Swedish_Academy_of_Sciences', 'Chemistry_awards', 'Nobel_Prize', 'Nobel_Prize_in_Chemistry', '2020_films', '2020s_LGBT-related_films', 'American_LGBT-related_films', 'American_films', 'American_high_school_films', 'American_romantic_comedy_films', 'American_teen_comedy_films', 'American_teen_drama_films', 'American_teen_romance_films', 'English-language_films', 'Films_about_interracial_romance', 'LGBT-related_drama_films', 'LGBT-related_romance_films', 'Upcoming_Netflix_original_films', 'Upcoming_films', '2018_documents', '2018_in_science', 'Climate_change_assessment_and_attribution', 'Environmental_reports', '2010s_in_the_environment', 'Lists_of_speeches_by_speaker', 'Speeches_by_writer', 'Sweden-related_lists', 'Works_by_Greta_Thunberg', 'Trains');
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...