Untitled query #83659

SQL

with excluded_templates as (select id from page where 
page_namespace = 10 and
(  title = 'Disambiguation'
or title = 'Surname'
or title = 'Shipname'
or title = 'Disambiguation'
or title = 'Shipindex'
or title = 'School disambiguation'
or title = 'Roadindex'
or title = 'Mountain index'
or title = 'Wikipedia disambiguation'
or title = 'Dmbox'
or title = 'Airport disambiguation'
or title = 'Biology disambiguation'
or title = 'Call sign disambiguation'
or title = 'Chinese title disambiguation'
or title = 'Disambiguation cleanup'
or title = 'Genus disambiguation'
or title = 'Geodis'
or title = 'Hndis'
or title = 'Hndis-cleanup'
or title = 'Hospital disambiguation'
or title = 'Hurricane disambiguation'
or title = 'Letter disambiguation'
or title = 'Letter-Number Combination Disambiguation'
or title = 'Mathematical disambiguation'
or title = 'Mil-unit-dis'
or title = 'Numberdis'
or title = 'Disambig-plants'
or title = 'Wiktionary redirect'
or title = 'wtr'
))

select page_title
from page
where page_namespace = 0
and not exists (
  select * from templatelinks
	where page.page_id = templatelinks.tl_from and templatelinks.tl_target not in excluded_templates

)
and page_title not in (
  select page_title from page where page_namespace = 1
)
and page_is_redirect = 0
and page_title not like '%(disambiguation)'
limit 20000;
SQL

Checking query status...
