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
Od Mishehu
.
Unambiguous US places
Toggle Highlighting
SQL
use enwiki_p; SELECT CONCAT('[[',page_title,']]') AS 'Redirect', CONCAT('[[',rd_title,']]') AS 'Target' FROM redirect JOIN page ON rd_from=page_id WHERE (rd_title=CONCAT(page_title,',_Alabama') OR rd_title=CONCAT(page_title,',_Alaska') OR rd_title=CONCAT(page_title,',_Arizona') OR rd_title=CONCAT(page_title,',_Arkansas') OR rd_title=CONCAT(page_title,',_California') OR rd_title=CONCAT(page_title,',_Colorado') OR rd_title=CONCAT(page_title,',_Connecticut') OR rd_title=CONCAT(page_title,',_Delaware') OR rd_title=CONCAT(page_title,',_Florida') OR rd_title=CONCAT(page_title,',_Georgia') OR rd_title=CONCAT(page_title,',_Hawaii') OR rd_title=CONCAT(page_title,',_Idaho') OR rd_title=CONCAT(page_title,',_Illinois') OR rd_title=CONCAT(page_title,',_Indiana') OR rd_title=CONCAT(page_title,',_Iowa') OR rd_title=CONCAT(page_title,',_Kansas') OR rd_title=CONCAT(page_title,',_Kentucky') OR rd_title=CONCAT(page_title,',_Louisiana') OR rd_title=CONCAT(page_title,',_Maine') OR rd_title=CONCAT(page_title,',_Maryland') OR rd_title=CONCAT(page_title,',_Massachusetts') OR rd_title=CONCAT(page_title,',_Michigan') OR rd_title=CONCAT(page_title,',_Minnesota') OR rd_title=CONCAT(page_title,',_Mississippi') OR rd_title=CONCAT(page_title,',_Missouri') OR rd_title=CONCAT(page_title,',_Montana') OR rd_title=CONCAT(page_title,',_Nebraska') OR rd_title=CONCAT(page_title,',_Nevada') OR rd_title=CONCAT(page_title,',_New_Hampshire') OR rd_title=CONCAT(page_title,',_New_Jersey') OR rd_title=CONCAT(page_title,',_New_Mexico') OR rd_title=CONCAT(page_title,',_New_York')) AND rd_namespace=0 AND page_namespace=0
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...