enwiki: pages without talkpages, with disambiguation (mostly) removed

SQL

select page_title from page where page_namespace = 0
and not exists (select * from templatelinks
where page.page_id = templatelinks.tl_from
and (tl_title = 'Disambiguation'
or tl_title = 'Surname'
or tl_title = 'Shipname'
or tl_title = 'Disambiguation'
or tl_title = 'Shipindex'
or tl_title = 'School disambiguation'
or tl_title = 'Roadindex'
or tl_title = 'Mountain index'
or tl_title = 'Wikipedia disambiguation'
or tl_title = 'Dmbox'
or tl_title = 'Airport disambiguation'
or tl_title = 'Biology disambiguation'
or tl_title = 'Call sign disambiguation'
or tl_title = 'Chinese title disambiguation'
or tl_title = 'Disambiguation cleanup'
or tl_title = 'Genus disambiguation'
or tl_title = 'Geodis'
or tl_title = 'Hndis'
or tl_title = 'Hndis-cleanup'
or tl_title = 'Hospital disambiguation'
or tl_title = 'Hurricane disambiguation'
or tl_title = 'Letter disambiguation'
or tl_title = 'Letter-Number Combination Disambiguation'
or tl_title = 'Mathematical disambiguation'
or tl_title = 'Mil-unit-dis'
or tl_title = 'Numberdis'
or tl_title = 'Disambig-plants'
or tl_title = 'Wiktionary redirect'
or tl_title = 'wtr'))
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)';
SQL

Checking query status...
