Disambiguation pages with external links

SQL

select page_title, count(el_id) as links from page
join externallinks on el_from = page_id and el_to_domain_index not like '%org.toolforge%'
where page_namespace = 0
and page_id in (
  select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type = 'page'
)
and page_id not in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_namespace = 10 and lt_title in (
      'Article_for_deletion/dated', 'Proposed_deletion/dated'
    )
  )
)
group by page_title
order by links desc

SQL

Checking query status...