Number of links leading to "United_States" and its redirects

Fork of Pages in pagelinks (ns=0) redirecting to "United States" by MSUGRA
This query is marked as a draft This query has been published by MSUGRA.
SQL

select
  pl_title as title,
  count(*) as refcount
from
  pagelinks
where
  pl_namespace = 0
  and pl_from_namespace = 0
  and (
    pl_title = "United_States"
    or pl_title = "AmericA"
    or pl_title = "UnitedStates"
    or pl_title = "US"
    or pl_title = "United_States/Introduction"
    or pl_title = "USA"
    or pl_title = "U.S."
    or pl_title = "United_States_of_America/OldPage"
    or pl_title = "United_States_of_America/Introduction"
    or pl_title = "U.S.A."
    or pl_title = "United_States_of_America"
    or pl_title = "The_United_States_of_America"
    or pl_title = "The_USA"
    or pl_title = "ISO_3166-1:US"
    or pl_title = "United_states_of_america"
    or pl_title = "America_(United_States)"
    or pl_title = "U.S.A"
    or pl_title = "Usa"
    or pl_title = "The_United_States"
    or pl_title = "United_States_Of_America"
    or pl_title = "U.S"
    or pl_title = "The_United_States_Of_America"
    or pl_title = "The_US"
    or pl_title = "US_of_A"
    or pl_title = "United_states"
    or pl_title = "U,S,"
    or pl_title = "Los_Estados_Unidos"
    or pl_title = "Estados_unidos"
    or pl_title = "U.s."
    or pl_title = "Untied_States"
    or pl_title = "United_sates"
    or pl_title = "U._S."
    or pl_title = "U_S"
    or pl_title = "Americia"
    or pl_title = "America_(US)"
    or pl_title = "UNITED_STATES"
    or pl_title = "États-Unis_d'Amérique"
    or pl_title = "Estados_Unidos"
    or pl_title = "EEUU"
    or pl_title = "United_states_of_America"
    or pl_title = "Estatos_Unitos"
    or pl_title = "America_(USA)"
    or pl_title = "America_(country)"
    or pl_title = "U._S._A."
    or pl_title = "United_States_(of_America)"
    or pl_title = "U.s.a."
    or pl_title = "Estados_Unidos_de_América"
    or pl_title = "Estados_Unidos_de_America"
    or pl_title = "Etats-Unis"
    or pl_title = "Federal_United_States"
    or pl_title = "The_U.S."
    or pl_title = "US_and_A"
    or pl_title = "AMERICA"
    or pl_title = "United_Sates"
    or pl_title = "The_Unites_States_of_America"
    or pl_title = "USofA"
    or pl_title = "Americaland"
    or pl_title = "United_state_of_america"
    or pl_title = "U.S.American"
    or pl_title = "Unitd_states"
    or pl_title = "U.S._A"
    or pl_title = "Amarica"
    or pl_title = "Us_of_a"
    or pl_title = "Untied_States_of_America"
    or pl_title = "The_united_states_of_america"
    or pl_title = "U_S_A"
    or pl_title = "United_States_of_American"
    or pl_title = "Etats-Unis_d'Amerique"
    or pl_title = "États-Unis"
    or pl_title = "Stati_Uniti_d'America"
    or pl_title = "UNITED_STATES_OF_AMERICA"
    or pl_title = "THE_UNITED_STATES_OF_AMERICA"
    or pl_title = "(US)"
    or pl_title = "Name_of_the_United_States"
    or pl_title = "Etymology_of_the_United_States"
    or pl_title = "EE._UU."
    or pl_title = "EE.UU."
    or pl_title = "Los_Estados_Unidos_de_América"
    or pl_title = "The_US_of_A"
    or pl_title = "The_Us"
    or pl_title = "The_Usa"
    or pl_title = "US_of_America"
    or pl_title = "US_of_america"
    or pl_title = "The_US_of_America"
    or pl_title = "The_US_of_america"
    or pl_title = "United_State_of_America"
    or pl_title = "Us."
    or pl_title = "THE_AMERICAN_UNITED_STATES"
    or pl_title = "U.S._of_America"
    or pl_title = "(USA)"
    or pl_title = "United_States_(country)"
    or pl_title = "Amercia"
    or pl_title = "U.S._of_A"
    or pl_title = "U.S._OF_A"
    or pl_title = "US_America"
    or pl_title = "U.S._America"
    or pl_title = "Amerka"
    or pl_title = "Amurika"
    or pl_title = "Unietd_States"
    or pl_title = "Nited_States"
    or pl_title = "EE_UU"
    or pl_title = "United_States_of_America_(USA)"
    or pl_title = "United_States_of_America_(U.S.A.)"
    or pl_title = "United_States_(U.S.A.)"
    or pl_title = "United_States_(US)"
    or pl_title = "United_States_(U.S.)"
    or pl_title = "United_Staets_of_America"
    or pl_title = "United_Stated"
    or pl_title = "Unites_States"
    or pl_title = "United_States_America"
    or pl_title = "US_(country)"
    or pl_title = "These_United_States_of_America"
    or pl_title = "United-States"
    or pl_title = "Unite_states_of_america"
    or pl_title = "American_United_States"
    or pl_title = "America,_United_States_of"
    or pl_title = "Unite_States"
    or pl_title = "America_(United_States_of)"
    or pl_title = "Nagkaisang_mga_Estado"
    or pl_title = "America"
    or pl_title = "Amurica"
    or pl_title = "U._S._of_A."
    or pl_title = "U.S._of_A."
    or pl_title = "The_U._States_of_America"
    or pl_title = "Etats-unis_d'amerique"
    or pl_title = "Civitates_Foederatae_Americae"
    or pl_title = "United_Satates"
    or pl_title = "ISO_3166-2:us"
    or pl_title = "美国"
    or pl_title = "美國"
  )
group by
  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...
