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 ('Arabic_architecture', 'Azulejos_in_buildings_in_Andalusia', 'Bien_de_Interés_Cultural_landmarks_in_the_Province_of_Granada', 'Buildings_and_structures_completed_in_1333', 'Buildings_and_structures_in_Granada', 'Castles_in_Andalusia', 'Gardens_in_Spain', 'Granada', 'Islamic_art_of_Spain', 'Islamic_gardens', 'Landscape_design_history_of_Spain', 'Nasrid_dynasty', 'Open-air_museums_in_Spain', 'Palaces_in_Andalusia', 'Royal_residences_in_Spain', 'Spanish_gardens', 'Visionary_environments', 'World_Heritage_Sites_in_Spain', '1996_establishments_in_California', '1999_mergers_and_acquisitions', 'Amazon.com_acquisitions', 'Companies_based_in_San_Francisco', 'Digital_marketing_companies_of_the_United_States', 'Internet_properties_established_in_1996', 'Internet_search_engines', 'Marketing_companies_established_in_1996', 'Marketing_research_companies_of_the_United_States', 'Technology_companies_based_in_the_San_Francisco_Bay_Area', 'Telecommunications_companies_established_in_1996', 'Web_analytics', 'Companies_established_in_1994', 'Electronic_music_event_management_companies', 'Days_of_the_year', 'January', 'Orientation_(geometry)', '1958_births', 'American_politicians_of_Mexican_descent', 'California_Attorneys_General', 'Democratic_Party_members_of_the_United_States_House_of_Representatives', 'Hispanic_and_Latino_American_members_of_the_United_States_Congress', 'Members_of_the_California_State_Assembly', 'Members_of_the_United_States_House_of_Representatives_from_California', 'Politicians_from_Los_Angeles', 'Politicians_from_Sacramento,_California', 'Stanford_Law_School_alumni', 'University_of_Salamanca_alumni', 'Attorneys_general', 'Law_of_the_United_Kingdom', 'Legal_ethics', 'Legal_professions');
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...