Untitled query #19347

This query is marked as a draft This query has been published by Yahelcarmon.
SQL

 SELECT * FROM( select page_title FROM enwiki_p.categorylinks JOIN enwiki_p.page ON cl_from=page_id
  where cl_to IN('2011_deaths') 
  )d
  JOIN
  (
     select page_title FROM enwiki_p.categorylinks JOIN enwiki_p.page ON cl_from=page_id
  where cl_to IN("20th-century_British_actresses", "20th-century_British_architects", "20th-century_British_dramatists_and_playwrights", "20th-century_British_historians", "20th-century_British_male_actors", "20th-century_British_mathematicians", "20th-century_British_medical_doctors", "20th-century_British_musicians", "20th-century_British_newspaper_founders", "20th-century_British_newspaper_publishers_(people)", "20th-century_British_novelists", "20th-century_British_painters", "20th-century_British_poets", "20th-century_British_printmakers", "20th-century_British_scientists", "20th-century_British_singers", "20th-century_British_women_writers", "20th-century_British_writers", "20th-century_Irish_dramatists_and_playwrights", "20th-century_Irish_male_actors", "20th-century_Irish_novelists", "20th-century_Irish_painters", "20th-century_Irish_people", "20th-century_Irish_poets", "20th-century_Irish_sculptors", "20th-century_Irish_writers", "20th-century_Scottish_musicians", "20th-century_Scottish_novelists", "20th-century_Scottish_singers", "20th-century_Scottish_writers", "20th-century_Welsh_novelists", "20th-century_Welsh_poets", "21st-century_British_businesspeople", "21st-century_British_historians", "21st-century_British_mathematicians", "21st-century_British_novelists", "21st-century_British_painters", "21st-century_British_politicians", "21st-century_Irish_male_actors", "21st-century_Irish_novelists", "21st-century_Irish_painters", "21st-century_Irish_people", "21st-century_Irish_writers", "21st-century_Scottish_singers", "21st-century_Scottish_writers", "21st-century_Welsh_male_actors", "Abbotsford,_British_Columbia", "Actresses_awarded_British_damehoods", "All_Wikipedia_articles_written_in_Irish_English", "Alumni_of_the_Royal_Scottish_Academy_of_Music_and_Drama", "American_mobsters_of_Irish_descent", "American_people_of_Irish_descent", "American_people_of_Scottish_descent", "American_people_of_Welsh_descent", "Anglo-Welsh_poets", "Argentine_people_of_British_descent", "Argentine_people_of_Irish_descent", "Articles_containing_Irish-language_text", "Athletes_(track_and_field)_at_the_1934_British_Empire_Games", "Athletes_(track_and_field)_at_the_1950_British_Empire_Games", "Athletes_(track_and_field)_at_the_1954_British_Empire_and_Commonwealth_Games", "Athletes_(track_and_field)_at_the_1958_British_Empire_and_Commonwealth_Games", "Athletes_(track_and_field)_at_the_1962_British_Empire_and_Commonwealth_Games", "Athletes_(track_and_field)_at_the_1966_British_Empire_and_Commonwealth_Games", "Athletes_(track_and_field)_at_the_1970_British_Commonwealth_Games", "Attorneys_General_of_British_Columbia", "Australian_Commanders_of_the_Order_of_the_British_Empire", "Australian_Knights_Commander_of_the_Order_of_the_British_Empire", "Australian_Members_of_the_Order_of_the_British_Empire", "Australian_Officers_of_the_Order_of_the_British_Empire", "Australian_people_of_Irish_descent", "B-Class_British_Columbia_articles", "B-Class_British_military_history_articles", "Basketball_people_from_British_Columbia", "Best_British_Actress_BAFTA_Award_winners", "Black_British_academics", "Black_British_musicians", "Black_British_rock_musicians", "Black_British_sportspeople", "Black_British_writers", "Brazilian_people_of_British_descent", "British_Army_Commandos_soldiers", "British_Army_General_List_officers", "British_Army_generals", "British_Army_officers", "British_Army_personnel_of_World_War_II", "British_Army_personnel_of_the_Korean_War", "British_Army_personnel_of_the_Malayan_Emergency", "British_Army_personnel_of_the_War_in_Afghanistan_(2001–2014)", "British_Army_personnel_stubs", "British_Army_soldiers", "British_Chief_Constables", "British_Christian_clergy_stubs", "British_Columbia_Co-operative_Commonwealth_Federation_MLAs", "British_Columbia_Conservative_Party_MLAs", "British_Columbia_Conservative_Party_leaders", "British_Columbia_Liberal_Party_MLAs", "British_Columbia_New_Democratic_Party_MLAs", "British_Columbia_Social_Credit_Party_MLAs", "British_Columbia_municipal_councillors", "British_Columbia_politician_stubs", "British_Columbia_school_board_members", "British_DJs", "British_Egyptologists", "British_Empire_rugby_league_team_players", "British_Eurovision_Song_Contest_entrants", "British_Formula_Renault_2.0_drivers", "British_Formula_Three_Championship_drivers", "British_Guiana_people", "British_Ice_Hockey_Hall_of_Fame_inductees", "British_Indian_Army_officers", "British_Indian_Army_soldiers", "British_Indian_Ocean_Territory_people", "British_Jews", "British_Marxist_historians", "British_Merchant_Navy_officers", "British_Merchant_Navy_personnel", "British_Merchant_Navy_personnel_of_World_War_II", "British_National_Party_politicians", "British_Olympic_medallist_stubs", "British_Parachute_Regiment_officers", "British_Poetry_Revival", "British_Queen's_Counsel", "British_Rail_people", "British_Roman_Catholic_bishop_stubs", "British_Roman_Catholics", "British_Salafis", "British_Trotskyists", "British_World_War_II_flying_aces", "British_World_War_II_pilots", "British_World_War_II_prisoners_of_war", "British_Zen_Buddhists", "British_academic_biography_stubs", "British_academics", "British_activists", "British_actor_stubs", "British_and_Irish_Lions_rugby_union_players_from_England", "British_anti-war_activists", "British_archaeologist_stubs", "British_archaeologists", "British_architects", "British_architectural_historians", "British_art_collectors", "British_art_historians", "British_artist_stubs", "British_artists", "British_association_football_commentators", "British_astronomer_stubs", "British_atheism_activists", "British_athletics_biography_stubs", "British_autobiographers", "British_automobile_designers", "British_aviators", "British_bandleaders", "British_barristers", "British_bass_guitarist_stubs", "British_biblical_scholars", "British_bibliographers", "British_biochemists", "British_biographers", "British_bishop_stubs", "British_blues_(genre)_musicians", "British_blues_guitarists", "British_blues_musicians", "British_blues_singers", "British_botanist_stubs", "British_botanists", "British_bowls_biography_stubs", "British_broadcasters", "British_business_biography,_20th-century_birth_stubs", "British_business_biography_stubs", "British_business_executives", "British_business_theorists", "British_businesspeople", "British_businesspeople_in_the_oil_industry", "British_cannabis_activists", "British_canoeist_stubs", "British_cartoonist_stubs", "British_cartoonists", "British_chairmen_of_corporations", "British_chemical_engineers", "British_chemists", "British_children's_writer_stubs", "British_children's_writers", "British_civil_servants", "British_classical_guitarists", "British_classical_musician_stubs", "British_classical_pianists", "British_classical_scholars", "British_colonial_army_soldiers", "British_colonial_governors_and_administrators_in_Africa", "British_comics_work_group_articles", "British_communists", "British_composer_stubs", "British_composers", "British_conductors_(music)", "British_conscientious_objectors", "British_conservationists", "British_contemporary_artists", "British_contract_bridge_players", "British_countesses", "British_criminologists", "British_cryptographers", "British_cycling_biography_stubs", "British_cycling_road_race_champions", "British_designers", "British_diplomat_stubs", "British_diplomats", "British_documentary_film_directors", "British_documentary_filmmakers", "British_dramatist_and_playwright_stubs", "British_dressage_riders", "British_drummers", "British_duchesses_by_marriage", "British_ecologists", "British_economists", "British_editors", "British_educational_theorists", "British_electrical_engineers", "British_electronics_engineers", "British_emigrants_to_Australia", "British_emigrants_to_France", "British_emigrants_to_the_United_States", "British_engineers", "British_entomologist_stubs", "British_entomologists", "British_ethicists", "British_expatriate_sportspeople_in_the_United_States", "British_expatriates_in_Australia", "British_expatriates_in_Belgium", "British_expatriates_in_Canada", "British_expatriates_in_China", "British_expatriates_in_Fiji", "British_expatriates_in_France", "British_expatriates_in_Greece", "British_expatriates_in_Ireland", "British_expatriates_in_Nigeria", "British_expatriates_in_Switzerland", "British_expatriates_in_the_United_Arab_Emirates", "British_expatriates_in_the_United_States", "British_fantasy_writers", "British_female_aviators", "British_female_composers", "British_female_equestrians", "British_female_rowers", "British_female_singers", "British_fencing_biography_stubs", "British_field_hockey_Olympic_medallist_stubs", "British_figure_skating_coaches", "British_film_actors_of_Pakistani_descent", "British_film_actresses", "British_film_designers", "British_film_director_navigational_boxes", "British_film_director_stubs", "British_film_directors", "British_film_editors", "British_film_producers", "British_folk_guitarists", "British_folk_rock_musicians", "British_folk_singers", "British_foreign_policy_writers", "British_foresters", "British_former_Christians", "British_general_practitioners", "British_geochemists", "British_geologists", "British_golf_instructors", "British_government_biography_stubs", "British_graphic_designers", "British_guitarists", "British_hairdressers", "British_harpsichordists", "British_historian_stubs", "British_historians", "British_historical_novelists", "British_horse_racing_biography_stubs", "British_horse_trainers", "British_horticulturists", "British_ice_hockey_biography_stubs", "British_illustrators", "British_interior_designers", "British_jazz_bandleaders", "British_jazz_pianists", "British_jazz_saxophonists", "British_jazz_singers", "British_jockeys", "British_journalist_stubs", "British_journalists", "British_judges", "British_law_biography_stubs", "British_lexicographers", "British_librarians", "British_linguist_stubs", "British_linguists", "British_literary_critics", "British_logicians", "British_magazine_editors", "British_magazine_writers", "British_malacologists", "British_male_alpine_skiers", "British_male_canoeists", "British_male_classical_composers", "British_male_cyclists", "British_male_dramatists_and_playwrights", "British_male_fencers", "British_male_field_hockey_players", "British_male_film_actors", "British_male_hurdlers", "British_male_journalists", "British_male_long-distance_runners", "British_male_marathon_runners", "British_male_models", "British_male_novelists", "British_male_painters", "British_male_poets", "British_male_sailors_(sport)", "British_male_screenwriters", "British_male_sculptors", "British_male_short_story_writers", "British_male_singers", "British_male_stage_actors", "British_male_swimmers", "British_male_television_actors", "British_male_tennis_players", "British_male_voice_actors", "British_male_writers", "British_mathematician_stubs", "British_medical_biography_stubs", "British_medical_researchers", "British_microbiologists", "British_military_historians", "British_military_history_articles_needing_attention_to_coverage_and_accuracy", "British_military_history_articles_needing_attention_to_grammar", "British_military_history_articles_needing_attention_to_referencing_and_citation", "British_military_history_articles_needing_attention_to_structure", "British_military_history_articles_needing_attention_to_supporting_materials", "British_military_history_task_force_articles", "British_military_personnel_killed_in_the_War_in_Afghanistan_(2001–2014)", "British_military_personnel_of_World_War_II", "British_military_personnel_of_the_Aden_Emergency", "British_military_personnel_of_the_Cyprus_Emergency", "British_military_personnel_of_the_Malayan_Emergency", "British_military_personnel_stubs", "British_military_writers", "British_mineralogists", "British_motoring_journalists", "British_motorsport_designers", "British_motorsport_people", "British_music_arrangers", "British_music_biography_stubs", "British_music_critics", "British_music_educators", "British_music_industry_executives", "British_musical_theatre_composers", "British_musician_stubs", "British_mystery_writers", "British_neuroscientists", "British_newspaper_editors", "British_newspaper_executives", "British_nobility_stubs", "British_non-fiction_writers", "British_novelist_stubs", "British_novelty_song_performers", "British_nuclear_physicists", "British_numismatists", "British_oncologists", "British_opera_singer_stubs", "British_opera_singers", "British_ophthalmologists", "British_orientalists", "British_orienteers", "British_painter_stubs", "British_palaeontologists", "British_parasitologists", "British_pathologists", "British_people", "British_people_associated_with_Heritage_Railways", "British_people_convicted_of_burglary", "British_people_convicted_of_kidnapping", "British_people_imprisoned_abroad", "British_people_murdered_abroad", "British_people_of_Austrian-Jewish_descent", "British_people_of_Belgian-Jewish_descent", "British_people_of_Crimean_Tatar_descent", "British_people_of_Georgian_descent", "British_people_of_German-Jewish_descent", "British_people_of_German_descent", "British_people_of_Greek_descent", "British_people_of_Irish_descent", "British_people_of_Maltese_descent", "British_people_of_New_Zealand_descent", "British_people_of_Polish-Jewish_descent", "British_people_of_Polish_descent", "British_people_of_Portuguese_descent", "British_people_of_Romanian_descent", "British_people_of_Scottish_descent", "British_people_of_Somali_descent", "British_people_of_Spanish_descent", "British_people_of_Swiss_descent", "British_people_of_Tibetan_descent", "British_people_of_Trinidad_and_Tobago_descent", "British_people_of_World_War_II", "British_people_stubs", "British_people_who_died_in_prison_custody", "British_pharmacologists", "British_philanthropists", "British_philhellenes", "British_philosopher_stubs", "British_philosophers", "British_photographer_stubs", "British_photographers", "British_physicist_stubs", "British_physicists", "British_physiologists", "British_pianists", "British_poet_stubs", "British_poets", "British_police_officers", "British_police_officers_in_India", "British_political_consultants", "British_pop_artists", "British_pop_singers", "British_printmakers", "British_psychoanalysts", "British_psychologist_stubs", "British_psychologists", "British_public_transport_executives", "British_publicans", "British_racehorse_owners_and_breeders", "British_radio_DJs", "British_radio_executives", "British_radio_people_stubs", "British_radio_personalities", "British_radio_writers", "British_radiologists", "British_railway_mechanical_engineers", "British_record_producers", "British_recorder_players", "British_reporters_and_correspondents", "British_rhythm_and_blues_boom_musicians", "British_robbers", "British_roboticists", "British_rock_musicians_templates", "British_rock_singers", "British_rowing_biography_stubs", "British_sailors", "British_sceptics", "British_schoolteachers", "British_science_fiction_writers", "British_scientists", "British_screen_actor_stubs", "British_screenwriters", "British_sculptors", "British_secularists", "British_short_story_writers", "British_singers", "British_soap_opera_actresses", "British_social_commentators", "British_socialists", "British_sociologists", "British_soft_rock_musicians", "British_songwriters", "British_spies", "British_spies_against_the_Soviet_Union", "British_sports_broadcasters", "British_sports_executives_and_administrators", "British_sportspeople_stubs", "British_sportswriters", "British_stage_actor_stubs", "British_stage_actresses", "British_stained_glass_artists_and_manufacturers", "British_surrealist_writers", "British_swimming_biography_stubs", "British_taxonomists", "British_television_actor,_1950s_birth_stubs", "British_television_actor_stubs", "British_television_actresses", "British_television_biography_stubs", "British_television_composers", "British_television_directors", "British_television_executives", "British_television_presenters", "British_television_producers", "British_television_writers", "British_test_pilots", "British_textbook_writers", "British_textile_designers", "British_theatre_critics", "British_theatre_directors", "British_theatre_managers_and_producers", "British_trade_unionist_stubs", "British_trade_unionists", "British_translator_stubs", "British_translators", "British_travel_writers", "British_ultramarathon_runners", "British_underwater_divers", "British_video_game_designers", "British_virologists", "British_viscountesses", "British_war_artists", "British_women", "British_women_activists", "British_women_dramatists_and_playwrights", "British_women_historians", "British_women_in_business", "British_women_medical_doctors", "British_women_painters", "British_women_photographers", "British_women_police_officers", "British_women_scientists", "British_women_short_story_writers", "British_women_writers", "British_writer_stubs", "British_writers", "British_writers_of_young_adult_literature", "British_yacht_racing_biography_stubs", "Businesspeople_from_British_Columbia", "C-Class_British_Columbia_articles", "C-Class_British_comics_articles", "C-Class_British_crime-related_articles", "C-Class_British_military_history_articles", "Canadian_people_of_British_descent", "Canadian_people_of_Irish_descent", "Canadian_people_of_Scottish_descent", "Canadian_people_of_Ulster-Scottish_descent", "Chief_executives_of_the_Scottish_Football_Association", "Commanders_of_the_Order_of_the_British_Empire", "Contestants_on_British_game_shows", "Crime_in_British_Columbia", "Cyclists_at_the_1950_British_Empire_Games", "Cyclists_at_the_1958_British_Empire_and_Commonwealth_Games", "Dames_Commander_of_the_Order_of_the_British_Empire", "Deaths_from_cancer_in_British_Columbia", "Deputy_premiers_of_British_Columbia", "Disease-related_deaths_in_British_Columbia", "Divers_at_the_1974_British_Commonwealth_Games", "English_people_of_Irish_descent", "English_people_of_Scottish_descent", "Fellows_of_the_British_Academy", "Fellows_of_the_British_Computer_Society", "Fencers_at_the_1950_British_Empire_Games", "Finance_ministers_of_British_Columbia", "French_people_of_Irish_descent", "General_Secretaries_of_British_trade_unions", "General_Secretaries_of_the_Scottish_Trades_Union_Congress", "Governors_of_British_Saint_Christopher_and_Nevis", "Governors_of_British_Saint_Lucia", "Governors_of_British_Seychelles", "Historians_of_the_British_Empire", "Honorary_Knights_Commander_of_the_Order_of_the_British_Empire", "Honorary_Members_of_the_Order_of_the_British_Empire", "Irish_Army_officers", "Irish_Eurovision_Song_Contest_entrants", "Irish_Guards_officers", "Irish_Guards_soldiers", "Irish_Jesuits", "Irish_Jews", "Irish_League_representative_players", "Irish_Republican_Army_(1922–69)_members", "Irish_Roman_Catholic_bishop_stubs", "Irish_Roman_Catholic_priests", "Irish_Roman_Catholic_theologians", "Irish_academic_biography_stubs", "Irish_activists", "Irish_actor_stubs", "Irish_anti-communists", "Irish_architectural_historians", "Irish_artist_stubs", "Irish_association_football_commentators", "Irish_association_football_managers", "Irish_auctioneers", "Irish_autobiographers", "Irish_aviators", "Irish_barristers", "Irish_biographers", "Irish_botanists", "Irish_broadcasters", "Irish_business_biography_stubs", "Irish_businesspeople", "Irish_cartoonists", "Irish_centenarians", "Irish_classical_scholars", "Irish_computer_programmers", "Irish_computer_scientists", "Irish_country_singers", "Irish_culture", "Irish_diaspora_politicians", "Irish_economists", "Irish_emigrants_to_Italy", "Irish_emigrants_to_New_Zealand", "Irish_emigrants_to_the_United_Kingdom", "Irish_emigrants_to_the_United_States", "Irish_expatriates_in_the_United_Kingdom", "Irish_female_singers", "Irish_feminists", "Irish_film_directors", "Irish_flautists", "Irish_gardeners", "Irish_historian_stubs", "Irish_historians", "Irish_impressionists_(entertainers)", "Irish_jockeys", "Irish_journalist_stubs", "Irish_journalists", "Irish_knights", "Irish_language", "Irish_lawyers", "Irish_male_dramatists_and_playwrights", "Irish_male_fencers", "Irish_male_film_actors", "Irish_male_poets", "Irish_male_radio_actors", "Irish_male_singers", "Irish_male_stage_actors", "Irish_male_television_actors", "Irish_male_voice_actors", "Irish_male_writers", "Irish_mayor_stubs", "Irish_medical_doctors", "Irish_military_personnel", "Irish_mountain_climbers", "Irish_murder_victims", "Irish_musician_navigational_boxes", "Irish_newspaper_editors", "Irish_newspaper_founders", "Irish_people_murdered_abroad", "Irish_people_of_Breton_descent", "Irish_people_stubs", "Irish_photographers", "Irish_photojournalists", "Irish_physicists", "Irish_players_of_Australian_rules_football", "Irish_political_scientists", "Irish_politician_stubs", "Irish_pop_singers", "Irish_producers", "Irish_radio_presenters", "Irish_republicans_imprisoned_for_criminal_damage", "Irish_rock_climbers", "Irish_rock_guitarists", "Irish_rock_musicians", "Irish_rock_singers", "Irish_scholars_and_academics", "Irish_schoolteachers", "Irish_scientists", "Irish_sculptors", "Irish_solicitors", "Irish_sports_broadcasters", "Irish_sports_journalists", "Irish_sportspeople_stubs", "Irish_stage_actresses", "Irish_technology_writers", "Irish_television_actresses", "Irish_television_presenters", "Irish_theatre_directors", "Irish_theatre_managers_and_producers", "Irish_translators", "Irish_women_scientists", "Irish_writer_stubs", "Irish_writers", "Italian_people_of_Irish_descent", "Jewish_British_politicians", "Journalists_from_British_Columbia", "Judges_in_British_Columbia", "Knights_Commander_of_the_Order_of_the_British_Empire", "Knights_Grand_Cross_of_the_Order_of_the_British_Empire", "Lawyers_in_British_Columbia", "Leaders_of_British_trade_unions", "Low-importance_British_Columbia_articles", "Low-importance_British_Overseas_Territories_articles", "Low-importance_British_crime-related_articles", "Low-importance_Irish_music_articles", "Mayors_of_places_in_British_Columbia", "Member_of_the_Scottish_Parliament_stubs", "Members_of_the_Executive_Council_of_British_Columbia", "Members_of_the_House_of_Commons_of_Canada_from_British_Columbia", "Members_of_the_Order_of_British_Columbia", "Members_of_the_Order_of_the_British_Empire", "Members_of_the_Parliament_of_the_United_Kingdom_for_Scottish_constituencies", "Members_of_the_Royal_Irish_Academy", "Members_of_the_Scottish_Parliament_1999–2003", "Members_of_the_Scottish_Parliament_2003–07", "Metropolitans_of_British_Columbia", "Mexican_people_of_Irish_descent", "Mid-importance_British_Columbia_articles", "Mid-importance_Irish_Republicanism_articles", "Monegasque_people_of_Scottish_descent", "Murdered_British_police_officers", "New_Zealand_Commanders_of_the_Order_of_the_British_Empire", "New_Zealand_Dames_Commander_of_the_Order_of_the_British_Empire", "New_Zealand_Members_of_the_Order_of_the_British_Empire", "New_Zealand_Officers_of_the_Order_of_the_British_Empire", "Northern_Irish_football_biography_stubs", "Northern_Irish_people_stubs", "Notre_Dame_Fighting_Irish_football_coaches", "Notre_Dame_Fighting_Irish_football_players", "Notre_Dame_Fighting_Irish_men's_basketball_players", "Notre_Dame_Fighting_Irish_track_and_field_athletes", "Officers_of_the_Order_of_the_British_Empire", "People_from_Richmond,_British_Columbia", "People_from_the_Scottish_Borders", "People_murdered_in_British_Columbia", "People_of_British_Ceylon", "People_of_British_India", "Players_in_the_Welsh_Premier_League", "Players_of_Canadian_football_from_British_Columbia", "Post-2008_Irish_economic_downturn", "Prisoners_and_detainees_of_British_India", "Private_secretaries_in_the_British_Civil_Service", "Protestant_Irish_nationalists", "Quebec_people_of_Irish_descent", "Recipients_of_the_British_Empire_Medal", "Rowers_at_the_1950_British_Empire_Games", "Scottish_Anglican_priests", "Scottish_Church_College,_Calcutta_alumni", "Scottish_Church_Collegiate_School_alumni", "Scottish_Conservative_Party_councillors", "Scottish_Conservative_and_Unionist_MP_stubs", "Scottish_Episcopalian_priests", "Scottish_Episcopalians", "Scottish_Football_Hall_of_Fame_inductees", "Scottish_Football_League_managers", "Scottish_Football_League_players", "Scottish_Football_League_representative_players", "Scottish_Gaelic_singers", "Scottish_Green_Party_politicians", "Scottish_Junior_Football_Association_players", "Scottish_Labour_Party_MPs", "Scottish_Labour_Party_politicians", "Scottish_National_Party_politicians", "Scottish_Queen's_Counsel", "Scottish_Roman_Catholic_priests", "Scottish_Roman_Catholics", "Scottish_Romani_people", "Scottish_activists", "Scottish_artists", "Scottish_biologists", "Scottish_businesspeople", "Scottish_buskers", "Scottish_centenarians", "Scottish_classical_composers", "Scottish_communists", "Scottish_country_musicians", "Scottish_cricket_biography_stubs", "Scottish_cricketers", "Scottish_educational_theorists", "Scottish_educators", "Scottish_electrical_engineers", "Scottish_emigrants_to_Australia", "Scottish_emigrants_to_Canada", "Scottish_emigrants_to_New_Zealand", "Scottish_emigrants_to_the_United_States", "Scottish_expatriate_footballers", "Scottish_expatriates_in_the_United_States", "Scottish_female_models", "Scottish_female_singers", "Scottish_fiddlers", "Scottish_film_actresses", "Scottish_film_critics", "Scottish_film_directors", "Scottish_folk_musicians", "Scottish_folk_singers", "Scottish_football_biography_stubs", "Scottish_football_chairmen_and_investors", "Scottish_football_defender_stubs", "Scottish_football_forward_stubs", "Scottish_football_managers", "Scottish_football_midfielder_stubs", "Scottish_footballers", "Scottish_guitarists", "Scottish_horror_writers", "Scottish_ice_hockey_players", "Scottish_impressionists_(entertainers)", "Scottish_interior_designers", "Scottish_jazz_singers", "Scottish_journalists", "Scottish_male_bowls_players", "Scottish_male_curlers", "Scottish_male_golfers", "Scottish_male_novelists", "Scottish_male_singers", "Scottish_male_stage_actors", "Scottish_male_television_actors", "Scottish_mathematicians", "Scottish_medical_biography_stubs", "Scottish_musicians_templates", "Scottish_nobility_stubs", "Scottish_novelists", "Scottish_opera_singers", "Scottish_people_of_Danish_descent", "Scottish_people_of_German-Jewish_descent", "Scottish_people_of_Irish_descent", "Scottish_people_stubs", "Scottish_pharmacologists", "Scottish_players_of_Australian_rules_football", "Scottish_police_officers", "Scottish_politician_stubs", "Scottish_pop_singers", "Scottish_radio_personalities", "Scottish_religious_biography_stubs", "Scottish_rock_guitarists", "Scottish_rock_singers", "Scottish_romantic_fiction_writers", "Scottish_scholars_and_academics", "Scottish_schoolteachers", "Scottish_screenwriters", "Scottish_short_story_writers", "Scottish_singer-songwriters", "Scottish_solicitor_advocates", "Scottish_solicitors", "Scottish_songwriters", "Scottish_sports_broadcasters", "Scottish_sportspeople_stubs", "Scottish_stage_actresses", "Scottish_television_actresses", "Scottish_television_directors", "Scottish_television_personalities", "Scottish_trade_unionists", "Scottish_translators", "Scottish_veterinarians", "Scottish_women", "Scottish_women_comedians", "South_African_people_of_British_descent", "South_African_people_of_Irish_descent", "Spouses_of_Irish_politicians", "Start-Class_British_Columbia_articles", "Start-Class_British_comics_articles", "Start-Class_British_crime-related_articles", "Start-Class_British_military_history_articles", "Start-Class_Irish_Republicanism_articles", "Start-Class_Irish_music_articles", "Stub-Class_British_Columbia_articles", "Stub-Class_British_Overseas_Territories_articles", "Stub-Class_British_comics_articles", "Stub-Class_British_military_history_articles", "Stub-Class_British_television_articles", "Stub-Class_Irish_music_articles", "Suicides_in_British_Columbia", "Swimmers_at_the_1938_British_Empire_Games", "The_Irish_Press_people", "The_Irish_Times_people", "Top-importance_British_crime-related_articles", "Trinidad_and_Tobago_people_of_British_descent", "Trinidad_and_Tobago_people_of_Scottish_descent", "Unassessed_British_Empire_articles", "Unassessed_British_crime-related_articles", "Unassessed_British_military_history_articles", "University_of_British_Columbia_alumni", "University_of_British_Columbia_faculty", "Unknown-importance_British_Empire_articles", "Unknown-importance_British_crime-related_articles", "Unknown-importance_British_television_articles", "Unknown-importance_Irish_Republicanism_articles", "Unknown-importance_Irish_music_articles", "Use_British_English_from_April_2012", "Use_British_English_from_April_2016", "Use_British_English_from_April_2017", "Use_British_English_from_August_2010", "Use_British_English_from_August_2011", "Use_British_English_from_August_2012", "Use_British_English_from_August_2013", "Use_British_English_from_August_2014", "Use_British_English_from_August_2015", "Use_British_English_from_August_2016", "Use_British_English_from_December_2012", "Use_British_English_from_December_2013", "Use_British_English_from_December_2015", "Use_British_English_from_December_2016", "Use_British_English_from_February_2012", "Use_British_English_from_February_2013", "Use_British_English_from_February_2014", "Use_British_English_from_February_2015", "Use_British_English_from_February_2016", "Use_British_English_from_February_2017", "Use_British_English_from_January_2012", "Use_British_English_from_January_2013", "Use_British_English_from_January_2014", "Use_British_English_from_January_2015", "Use_British_English_from_January_2017", "Use_British_English_from_July_2011", "Use_British_English_from_July_2012", "Use_British_English_from_July_2013", "Use_British_English_from_July_2014", "Use_British_English_from_July_2016", "Use_British_English_from_June_2011", "Use_British_English_from_June_2012", "Use_British_English_from_June_2013", "Use_British_English_from_June_2014", "Use_British_English_from_June_2015", "Use_British_English_from_June_2016", "Use_British_English_from_June_2017", "Use_British_English_from_March_2012", "Use_British_English_from_March_2013", "Use_British_English_from_March_2015", "Use_British_English_from_March_2016", "Use_British_English_from_March_2017", "Use_British_English_from_May_2011", "Use_British_English_from_May_2012", "Use_British_English_from_May_2013", "Use_British_English_from_May_2015", "Use_British_English_from_May_2016", "Use_British_English_from_May_2017", "Use_British_English_from_November_2010", "Use_British_English_from_November_2011", "Use_British_English_from_November_2012", "Use_British_English_from_November_2013", "Use_British_English_from_November_2014", "Use_British_English_from_November_2015", "Use_British_English_from_November_2016", "Use_British_English_from_October_2011", "Use_British_English_from_October_2012", "Use_British_English_from_October_2013", "Use_British_English_from_October_2014", "Use_British_English_from_October_2015", "Use_British_English_from_October_2016", "Use_British_English_from_September_2011", "Use_British_English_from_September_2012", "Use_British_English_from_September_2013", "Use_British_English_from_September_2014", "Use_British_English_from_September_2015", "Use_British_English_from_September_2016", "Use_Irish_English_from_August_2013", "Use_Irish_English_from_December_2013", "Use_Irish_English_from_February_2013", "Use_Irish_English_from_February_2017", "Use_Irish_English_from_July_2015", "Use_Irish_English_from_May_2015", "Use_Irish_English_from_May_2016", "Use_Irish_English_from_November_2014", "Water_polo_players_at_the_1950_British_Empire_Games", "Weightlifters_at_the_1954_British_Empire_and_Commonwealth_Games", "Weightlifters_at_the_1958_British_Empire_and_Commonwealth_Games", "Welsh-language_poets", "Welsh-language_television_presenters", "Welsh-language_writers", "Welsh-speaking_academics", "Welsh-speaking_actors", "Welsh_Anglicans", "Welsh_Baptist_ministers", "Welsh_Eisteddfod_archdruids", "Welsh_Eisteddfod_winners", "Welsh_Jews", "Welsh_Labour_Party_MPs", "Welsh_Roman_Catholics", "Welsh_agnostics", "Welsh_art_directors", "Welsh_conductors_(music)", "Welsh_cricket_coaches", "Welsh_cricketers", "Welsh_educators", "Welsh_emigrants_to_Australia", "Welsh_emigrants_to_Canada", "Welsh_film_actresses", "Welsh_football_biography_stubs", "Welsh_football_chairmen_and_investors", "Welsh_football_defender_stubs", "Welsh_football_managers", "Welsh_footballers", "Welsh_journalists", "Welsh_judges", "Welsh_librarians", "Welsh_male_film_actors", "Welsh_male_poets", "Welsh_male_radio_actors", "Welsh_male_soap_opera_actors", "Welsh_male_television_actors", "Welsh_miners", "Welsh_novelists", "Welsh_opera_singers", "Welsh_people_stubs", "Welsh_philanthropists", "Welsh_poets", "Welsh_radio_actresses", "Welsh_rugby_league_players", "Welsh_rugby_union_players", "Welsh_schoolteachers", "Welsh_sopranos", "Welsh_stage_actresses", "Welsh_television_actresses", "Welsh_television_presenters", "Welsh_tenors", "Welsh_women_writers", "Welsh_writer_stubs", "WikiProject_British_Motorsport_articles", "WikiProject_British_TV_shows_articles", "WikiProject_Irish_Music", "WikiProject_Irish_Republicanism_articles", "Wikipedia_articles_that_use_British_English", "Wikipedia_categories_named_after_British_musicians", "Wikipedia_categories_named_after_British_writers", "Wikipedia_requested_images_of_British_comics", "Women_MLAs_in_British_Columbia", "Women_in_the_British_Army", "Zimbabwean_people_of_British_descent", "Zimbabwean_people_of_Scottish_descent")
    )b
    USING(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...
