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_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", "21st-century_Irish_male_actors", "21st-century_Irish_novelists", "21st-century_Irish_painters", "21st-century_Irish_people", "21st-century_Irish_writers", "All_Wikipedia_articles_written_in_Irish_English", "American_mobsters_of_Irish_descent", "American_people_of_Irish_descent", "Argentine_people_of_Irish_descent", "Articles_containing_Irish-language_text", "Australian_people_of_Irish_descent", "British_and_Irish_Lions_rugby_union_players_from_England", "British_people_of_Irish_descent", "Canadian_people_of_Irish_descent", "English_people_of_Irish_descent", "French_people_of_Irish_descent", "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", "Low-importance_Irish_music_articles", "Members_of_the_Royal_Irish_Academy", "Mexican_people_of_Irish_descent", "Mid-importance_Irish_Republicanism_articles", "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", "Post-2008_Irish_economic_downturn", "Protestant_Irish_nationalists", "Quebec_people_of_Irish_descent", "Scottish_people_of_Irish_descent", "South_African_people_of_Irish_descent", "Spouses_of_Irish_politicians", "Start-Class_Irish_Republicanism_articles", "Start-Class_Irish_music_articles", "Stub-Class_Irish_music_articles", "The_Irish_Press_people", "The_Irish_Times_people", "Unknown-importance_Irish_Republicanism_articles", "Unknown-importance_Irish_music_articles", "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", "WikiProject_Irish_Music", "WikiProject_Irish_Republicanism_articles")
    )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...
