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

SQL

select page_title  from page where page_namespace = 0
-- and page_id not in (select tl_from from templatelinks
-- where 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)'
order by page_touched
limit 1000;
SQL

Checking query status...
