Untitled query #83659

SQL

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