enwiki: count pages without talkpages

SQL

select count(*)
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...
