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
Stuartyeates
.
Toggle Highlighting
SQL
SELECT p.page_title, concat(" [[", p.page_title, "]] "), concat(" [[Talk:", p.page_title, "]] ") FROM page AS p WHERE p.page_namespace = 0 AND p.page_is_redirect = 0 AND -- p.page_title like "%County%" AND p.page_title NOT IN (SELECT page_title FROM page WHERE page_namespace = 1) AND NOT p.page_id IN (SELECT tl_from FROM templatelinks WHERE tl_title in ('dab', 'Dab', 'Disamb', 'disamb', 'Geodis', 'geodis', 'Geodab', 'geodab', 'hndis','Hndis', 'surname','Surname', 'wi','Wi', 'wt','Wt', 'Rfd-NPF', 'given_name', 'Given_name', 'given-name-stub', 'Given-name-stub', 'surname-stub', 'Surname-stub' ) OR tl_title like "Db-%" OR tl_title like "%isambig%" OR tl_title like "%_name" OR tl_title like "%index_article" OR tl_title like "%_redirect" OR tl_title like "%index" ) LIMIT 200
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...