Short articles in top-level categories on enwiki

This query is marked as a draft This query has been published by Mr. Stradivarius.

Articles less than 3000 bytes in categories which are great-grandchildren of Category:Articles. The category list is hardcoded, as I couldn't work out a way to do it efficiently otherwise.

SQL

USE enwiki_p;
SELECT DISTINCT article.page_title
FROM page AS article
JOIN categorylinks AS articlecat
ON articlecat.cl_from = article.page_id
WHERE article.page_namespace = 0
AND article.page_is_redirect = 0
AND article.page_len < 3000
AND NOT EXISTS (SELECT 1
  FROM categorylinks
  WHERE cl_from = article.page_id
  AND cl_to = 'All_disambiguation_pages'
)
AND EXISTS (SELECT 1
  FROM categorylinks
  WHERE cl_from = article.page_id
  AND cl_to in (
    'Principles',
    'Statements',
    'Information',
    'Conceptualism',
    'Symbols',
    'Conceptual_models',
    'Systems',
    'Conceptions_of_self',
    'Abstraction',
    'Conceptual_distinctions',
    'Quantity',
    'Conceptual_systems',
    'Thought',
    'Concepts_by_field',
    'Language',
    'Conceptions_of_Heaven',
    'Technology_in_society',
    'Disability',
    'Communication',
    'Home',
    'Organizations',
    'Science_in_society',
    'Society-related_lists',
    'Social_history',
    'Society_in_fiction',
    'Sexuality_and_society',
    'Religion_and_society',
    'Feminism_and_society',
    'Social_institutions',
    'Socioeconomics',
    'Water_and_society',
    'Medicine_in_society',
    'Wikipedia_books_on_society',
    'Philosophy_and_society',
    'Race_and_society',
    'Scares',
    'Women_in_society',
    'Community',
    'Environment_and_society',
    'Agriculture_in_society',
    'Conflict_in_society',
    'Culture',
    'Social_groups',
    'Movements',
    'Competition',
    'Economies',
    'Society_by_ethnicity',
    'Social_media',
    'Social_philosophy',
    'Social_sciences',
    'People',
    'Ethnicity',
    'Judiciaries',
    'Mass_media',
    'Social_concepts',
    'International_relations',
    'Schools_of_thought',
    'Infrastructure',
    'Environment',
    'Age_and_society',
    'Group_processes',
    'Interpersonal_relationships',
    'Society_by_location',
    'Politics',
    'Bibliographies_of_subcultures',
    'Society_by_nationality',
    'Social_change',
    'Sociology',
    'Fictional_society',
    'Business',
    'Public_sphere',
    'Popularity',
    'Employment',
    'Society_blogs',
    'Artificial_life',
    'Death',
    'Prehistoric_life',
    'Extraterrestrial_life',
    'Reproduction',
    'Behavior',
    'Fictional_life_forms',
    'Hypothetical_life_forms',
    'Life_in_space',
    'Speculative_evolution',
    'Births_by_year',
    'Tree_of_life_(biology)',
    'Taxonomic_categories',
    'Organisms',
    'Life_sciences',
    'Matter',
    'Energy',
    'Nature',
    'Space',
    'Rhetoric',
    'Museology',
    'Philosophy',
    'Gender_studies',
    'Arts',
    'Area_studies',
    'Humanities_awards',
    'Drama',
    'Ethnic_studies',
    'Humor_research',
    'Study_of_religion',
    'Media_studies',
    'Comedy',
    'Tragedies_(dramas)',
    'Humanities_education',
    'Chronology',
    'Digital_humanities',
    'Linguistics',
    'Disability_studies',
    'Environmental_humanities',
    'Entertainment',
    'History',
    'Medical_humanities',
    'Law',
    'Jurisprudence',
    'Archaeology',
    'Anthropology',
    'Humanities_journals',
    'Humanities_occupations',
    'Humanities_organizations',
    'Scientific_method',
    'Scientific_terminology',
    'Science_and_engineering_awards',
    'Scientific_folklore',
    'Fictional_science',
    'Scientific_instruments',
    'Images_by_scientific_discipline',
    'Natural_history',
    'Science_occupations',
    'Scientific_buildings',
    'Facilities_and_organizations_of_science',
    'Science_stubs',
    'Science_education',
    'Scientific_works',
    'Works_about_science',
    'Philosophy_of_science',
    'Protoscience',
    'Scientific_disciplines',
    'Scientific_exploration',
    'Scientific_classification',
    'Scientific_phenomena',
    'Scientific_speculation',
    'Scientific_theories',
    'Scientific_laws',
    'History_of_science',
    'Science_commemorations',
    'Natural_philosophy',
    'Science_and_technology_by_location',
    'Science-related_lists',
    'Women_and_science',
    'Scientific_problems',
    'Open_science',
    'Scientific_comparisons',
    'Pseudoscience',
    'Fringe_science',
    'Popular_science',
    'Health_law',
    'Health_economics',
    'Health_education',
    'People_in_health_professions',
    'Health_deities',
    'Health_research',
    'Health_activists',
    'Health_sciences',
    'Health_by_country',
    'Hygiene',
    'Health_by_continent',
    'Health_movements',
    'Diseases_and_disorders',
    'Health_by_individual',
    'Health_policy',
    'Health_officials',
    'Health_informatics',
    'Mountaineering_and_health',
    'Health_stubs',
    'Health-related_lists',
    'Works_about_health',
    'Medical_and_health_organizations',
    'Determinants_of_health',
    'Alcohol_and_health',
    'Race_and_health',
    'Health_care',
    'Public_health',
    'Mental_health',
    'Quality_of_life',
    'Nutrition',
    'Global_health',
    'Medicine',
    'Children''s_health',
    'Environmental_health',
    'Men''s_health',
    'Occupational_safety_and_health',
    'Sexual_health',
    'Women''s_health',
    'Youth_health',
    'Health_and_medical_activism',
    'Health_effects_by_subject',
    'Midwifery',
    'History_of_technology',
    'Technology_images',
    'High-technology_business_districts',
    'Technology_neologisms',
    'Science_and_technology_studies',
    'Technology_strategy',
    'Technology_companies',
    'Science_parks',
    'Technology_transfer',
    'Philosophy_of_technology',
    'Technology_evangelism',
    'Technology_folklore',
    'Technological_comparison',
    'Mobile_technology',
    'Technical_communication',
    'Hypothetical_technology',
    'Wikipedia_books_on_technology',
    'Obsolete_technologies',
    'Real-time_technology',
    'Technology_stubs',
    'Technology_development',
    'Technological_change',
    'Technical_specifications',
    'Technology_systems',
    'Technology_events',
    'Technology_by_type',
    'Technological_pollution',
    'Appropriate_technology',
    'Engineering',
    'Technology_organizations',
    'Works_about_technology',
    'Educational_technology',
    'Regulation_of_technologies',
    'Technology-related_lists',
    'People_associated_with_technology',
    'Technology_by_century',
    'Technology_by_year',
    'People_in_technology',
    'History_organizations',
    'History_by_topic',
    'History_by_ethnic_group',
    'History_by_location',
    'History_awards',
    'History_images',
    'Legacies',
    'Events',
    'Philosophy_of_history',
    'History_education',
    'Historiography',
    'Historical_timelines',
    'Historic_preservation',
    'Historical_documents',
    'Historical_controversies',
    'Historical_geography',
    'Works_about_history',
    'Historical_works',
    'History_stubs',
    'Wikipedia_books_on_history',
    'Historical_eras',
    'Oral_history',
    'Pseudohistory',
    'Theories_of_history',
    'Sacred_history',
    'History_by_period',
    'Historians',
    'Historical_reenactment',
    'Historical_painting',
    'History-related_lists',
    'Fields_of_history',
    'Historicity',
    'Philosophy_of_mathematics',
    'Mathematicians',
    'Mathematics_and_culture',
    'Mathematics_literature',
    'Applied_mathematics',
    'Elementary_mathematics',
    'Mathematical_problem_solving',
    'Fields_of_mathematics',
    'Mathematical_notation',
    'Mathematical_terminology',
    'Mathematical_tools',
    'Mathematical_concepts',
    'Mathematics_stubs',
    'History_of_mathematics',
    'Mathematics-related_lists',
    'Mathematical_examples',
    'Pseudomathematics',
    'Wikipedia_books_on_mathematics',
    'Set_indices_on_mathematics',
    'Women_in_mathematics',
    'Philosophical_concepts',
    'Philosophy_by_region',
    'Religious_philosophy',
    'Philosophy-related_lists',
    'Philosophy_images',
    'Women_and_philosophy',
    'Philosophy_stubs',
    'Philosophy_writers',
    'Branches_of_philosophy',
    'Philosophy_by_period',
    'History_of_philosophy',
    'Philosophy_by_field',
    'Works_about_philosophy',
    'Philosophers',
    'Philosophy_schools',
    'Philosophical_literature',
    'Philosophical_theories',
    'Cosmology',
    'Geocodes',
    'Geographers',
    'Exploration',
    'Surveying',
    'History_of_geography',
    'Geography_education',
    'Geography-related_lists',
    'Geographic_literature',
    'Geographical_technology',
    'Geography_organizations',
    'Geography_awards_and_competitions',
    'Geographic_images',
    'Vernacular_geography',
    'Branches_of_geography',
    'Wikipedia_books_on_geography',
    'Geography_stubs',
    'Landscape',
    'Places',
    'Land_systems',
    'Environmental_studies',
    'Geography_by_place',
    'Geography_terminology',
    'Geopolitical_corridors',
    'Navigation',
    'Geographical_zones',
    'Geography_conferences',
    'Geography_of_dwarf_planets',
    'Geography_of_planets',
    'Categories_by_location',
    'Lists_of_countries_by_geography',
    'Encyclopedias',
    'Atlases',
    'Style_guides',
    'Handbooks_and_manuals',
    'Directories',
    'Bibliographies',
    'Pharmacopoeias',
    'Film_guides',
    'Trivia_books',
    'Online_databases',
    'Books_of_quotations',
    'Gazetteers',
    'Citation_indices',
    'Dictionaries',
    'Almanacs',
    'Music_guides',
    'Bodies_of_knowledge',
    'Chronicles',
    'Thesauri',
    'Reference_book_stubs',
    'Travel_guide_books',
    'Stamp_catalogs',
    'Numismatic_catalogs',
    'Consumer_guides',
    'Road_user_guides',
    'Concordances_(publishing)',
    'Reference_works_in_the_public_domain',
    'Guinness_World_Records',
    'References_on_Greek_mythology',
    'Natural_monuments',
    'Earth',
    'Phenomena',
    'Natural_materials',
    'Evolution',
    'Natural_events',
    'Nature_writers',
    'Wikipedia_books_on_nature',
    'Naturalism_(philosophy)',
    'Physical_phenomena',
    'Life',
    'Nature_and_religion',
    'Nature-related_lists',
    'Works_about_nature',
    'Natural_sciences',
    'Vacuum',
    'Natural_hazards',
    'Narratology',
    'History_of_literature',
    'Literary_awards',
    'Literary_concepts',
    'Literary_societies',
    'Literature_lists',
    'Literary_hoaxes',
    'References_in_literary_works',
    'Literary_techniques',
    'Literary_circles',
    'Literary_collaborations',
    'Literature_timelines',
    'Images_of_literature',
    'Literary_agencies',
    'Literary_museums',
    'Literary_terms',
    'Creative_writing_programs',
    'Literary_genres',
    'Oral_literature',
    'People_in_literature',
    'Literary_festivals',
    'Literary_characters',
    'Literary_motifs',
    'Literary_series',
    'Literary_archives',
    'Literature_databases',
    'Literature_stubs',
    'Works_based_on_literature',
    'Wikipedia_categories_named_after_literary_texts',
    'Literature_in_popular_culture',
    'Professorships_in_literature',
    'Works_about_literature',
    'Literature_by_period',
    'Literature_by_genre',
    'Literature_by_language',
    'Literature_by_medium',
    'Literature_by_nationality',
    'Works_by_writer',
    'Literature_by_form',
    'Literature_by_women',
    'Literature_records',
    'Literature_by_topic',
    'Literary_fandom',
    'Comics',
    'Films_based_on_literature',
    'Topics_in_literature',
    'Poetry',
    'Literature_by_continent',
    'Literature_first_published_in_serial_form',
    'Reading_(process)',
    'Writers''_conferences',
    'Literary_publishing_companies',
    'Traditions',
    'Clothing',
    'Languages',
    'Cultural_anthropology',
    'Humanities',
    'Cultural_history',
    'Science_and_culture',
    'Ritual',
    'Religion',
    'Cultural_critics',
    'Cultural_trends',
    'Cultural_generations',
    'Sociology_of_culture',
    'Cultural_education',
    'Culture_by_location',
    'Luxury',
    'Cultural_organizations',
    'Cultural_media',
    'Cultures',
    'Cultural_concepts',
    'Anthrozoology',
    'Cultural_events',
    'Cultural_aspects_of_death',
    'Culture-related_controversies',
    'Cultural_exchange',
    'Cultural_lists',
    'Cultural_spheres_of_influence',
    'Political_culture',
    'Culture-bound_syndromes',
    'Philosophy_and_culture',
    'Culture_stubs',
    'Encyclopedias_of_culture_and_ethnicity',
    'Biology_and_culture',
    'Art_and_culture_law',
    'Tourism',
    'Wikipedia_books_on_culture',
    'Food_and_drink',
    'Transport_culture',
    'Cultural_hegemony',
    'Cultural_studies',
    'Words_and_phrases_by_culture',
    'Sports_culture',
    'Libre_culture',
    'Winter_in_culture'
  )
)
ORDER BY article.page_title;

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.

SQL

Checking query status...