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
MSUGRA
.
Toggle Highlighting
SQL
SELECT t_pl.* FROM ( SELECT pl_title AS title, COUNT(1) AS refcount FROM pagelinks WHERE pl_namespace = 0 AND pl_from_namespace = 0 AND ( pl_title = "United_States" OR pl_title = "'merica" OR pl_title = "'murica" OR pl_title = "(US)" OR pl_title = "(USA)" OR pl_title = "Amarica" OR pl_title = "Amercia" OR pl_title = "America" OR pl_title = "America,_United_States_of" OR pl_title = "America_(country)" OR pl_title = "America_(United_States)" OR pl_title = "America_(United_States_of)" OR pl_title = "America_(US)" OR pl_title = "America_(USA)" OR pl_title = "Americaland" OR pl_title = "American_occupation_of_the_United_States" OR pl_title = "American_United_States" OR pl_title = "Americia" OR pl_title = "Americophile" OR pl_title = "Amerka" OR pl_title = "Amiercan" OR pl_title = "Amurica" OR pl_title = "Amurika" OR pl_title = "EE._UU." OR pl_title = "EE.UU." OR pl_title = "EE_UU" OR pl_title = "EEUU" OR pl_title = "Estados_unidos" OR pl_title = "Estados_Unidos" OR pl_title = "Estados_Unidos_de_America" OR pl_title = "Estados_Unidos_de_América" OR pl_title = "Estaos_Unios" OR pl_title = "Estaos_Uníos" OR pl_title = "Estatos_Unitos" OR pl_title = "Etats-Unis" OR pl_title = "Etats-Unis_d'Amerique" OR pl_title = "Etymology_of_the_United_States" OR pl_title = "Federal_United_States" OR pl_title = "ISO_3166-1:US" OR pl_title = "Los_Estados_Unidos" OR pl_title = "Los_Estados_Unidos_de_America" OR pl_title = "Los_Estados_Unidos_de_América" OR pl_title = "Nagkaisang_mga_Estado" OR pl_title = "Name_of_the_United_States" OR pl_title = "Nited_States" OR pl_title = "States_of_America" OR pl_title = "Stati_Uniti_d'America" OR pl_title = "THE_AMERICAN_UNITED_STATES" OR pl_title = "The_U-S" OR pl_title = "The_U-S-A" OR pl_title = "The_U.-S." OR pl_title = "The_U.-S." OR pl_title = "The_U._S." OR pl_title = "The_U._S._A." OR pl_title = "The_U._S._of_A" OR pl_title = "The_U._S._of_America" OR pl_title = "The_U._States_of_America" OR pl_title = "The_U.S." OR pl_title = "The_U.S._of_A" OR pl_title = "The_U.S._of_America" OR pl_title = "The_U.S.A." OR pl_title = "The_U.–S." OR pl_title = "The_U.–S.–A." OR pl_title = "The_U_S" OR pl_title = "The_U_S_A" OR pl_title = "The_U_S_of_A" OR pl_title = "The_U_S_of_America" OR pl_title = "The_United-States" OR pl_title = "The_United_States" OR pl_title = "The_United_States_of_America" OR pl_title = "The_United_States_Of_America" OR pl_title = "The_united_states_of_america" OR pl_title = "THE_UNITED_STATES_OF_AMERICA" OR pl_title = "The_United_States_of_America." OR pl_title = "The_United–States" OR pl_title = "The_Unites_States_of_America" OR pl_title = "The_US" OR pl_title = "The_Us" OR pl_title = "The_US_of_A" OR pl_title = "The_US_of_America" OR pl_title = "The_US_of_america" OR pl_title = "The_USA" OR pl_title = "The_Usa" OR pl_title = "The_U–S" OR pl_title = "The_U–S–A" OR pl_title = "These_United_States_of_America" OR pl_title = "U,S," OR pl_title = "U-S" OR pl_title = "U-S-A" OR pl_title = "U.-S." OR pl_title = "U.-S.-A." OR pl_title = "U._S." OR pl_title = "U._S._A." OR pl_title = "U._S._of_A" OR pl_title = "U._S._of_A." OR pl_title = "U._S._of_America" OR pl_title = "U.S" OR pl_title = "U.S." OR pl_title = "U.s." OR pl_title = "U.S._A" OR pl_title = "U.S._America" OR pl_title = "U.S._of_A" OR pl_title = "U.S._OF_A" OR pl_title = "U.S._of_A." OR pl_title = "U.S._of_America" OR pl_title = "U.S.A" OR pl_title = "U.S.A." OR pl_title = "U.s.a." OR pl_title = "U.S.A.)" OR pl_title = "U.S.American" OR pl_title = "U.–S." OR pl_title = "U.–S.–A." OR pl_title = "U_S" OR pl_title = "U_S_A" OR pl_title = "U_S_of_A" OR pl_title = "U_S_of_America" OR pl_title = "Unietd_States" OR pl_title = "Unitd_states" OR pl_title = "Unite_States" OR pl_title = "Unite_states_of_america" OR pl_title = "United+States" OR pl_title = "United+States+of+America" OR pl_title = "United-States" OR pl_title = "United_sates" OR pl_title = "United_Sates" OR pl_title = "United_Staets_of_America" OR pl_title = "United_state_of_america" OR pl_title = "United_State_of_America" OR pl_title = "United_Stated" OR pl_title = "United_states" OR pl_title = "UNited_States" OR pl_title = "UNITED_STATES" OR pl_title = "United_States/Introduction" OR pl_title = "United_States_(country)" OR pl_title = "United_States_(of_America)" OR pl_title = "United_States_(U.S.)" OR pl_title = "United_States_(U.S.A.)" OR pl_title = "United_States_(US)" OR pl_title = "United_States_America" OR pl_title = "United_States_Of_Amerca" OR pl_title = "United_States_of_America" OR pl_title = "United_states_of_america" OR pl_title = "United_States_Of_America" OR pl_title = "United_states_of_America" OR pl_title = "UNITED_STATES_OF_AMERICA" OR pl_title = "United_States_of_America." OR pl_title = "United_States_of_America/Introduction" OR pl_title = "United_States_of_America/OldPage" OR pl_title = "United_States_of_America_(redirect)" OR pl_title = "United_States_of_America_(U.S.A.)" OR pl_title = "United_States_of_America_(USA)" OR pl_title = "United_States_of_American" OR pl_title = "UnitedStates" OR pl_title = "United–States" OR pl_title = "Unites_States" OR pl_title = "Unitesd_states" OR pl_title = "Untied_States" OR pl_title = "Untied_States_of_America" OR pl_title = "US" OR pl_title = "US_(country)" OR pl_title = "US_America" OR pl_title = "US_and_A" OR pl_title = "US_of_A" OR pl_title = "Us_of_a" OR pl_title = "US_of_America" OR pl_title = "US_of_america" OR pl_title = "USA" OR pl_title = "Usa" OR pl_title = "USoA" OR pl_title = "USofA" OR pl_title = "U–S" OR pl_title = "U–S–A" OR pl_title = "V.S._America" OR pl_title = "V.S._Amerika" OR pl_title = "Vereinigte_Staaten" OR pl_title = "VS_America" OR pl_title = "VS_Amerika" OR pl_title = "Yankee_land" OR pl_title = "États-Unis" OR pl_title = "États-Unis_d'Amérique" ) GROUP BY title ) AS t_pl;
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...