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, p.page_namespace, p.page_is_redirect FROM page AS p WHERE p.page_namespace = 0 AND p.page_is_redirect = 0 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', 'soft_redirect','Soft_redirect', 'animal_common_name','Animal_common_name', 'Set_index_article','set_index_article', 'Plant common name','Plant common name' ) OR tl_title like "Db-%" OR tl_title like "%isambig%" ) LIMIT 20
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...