(Dab)pages without outgoing links to primary topic

SQL

select * from page p1
where p1.page_title like '%\_(disambiguation)' and p1.page_namespace = 0 and p1.page_is_redirect = 0
and exists (
  select 1 from page p2 where p2.page_namespace = 0 and p2.page_is_redirect = 0
  and p2.page_title = substring(p1.page_title, 1, INSTR(p1.page_title, "_(disambiguation)")-1) 
)
and not exists (
  select 1 from pagelinks where pl_from = p1.page_id and pl_namespace = 0 and pl_from_namespace = 0
  and pl_title = substring(p1.page_title, 1, INSTR(p1.page_title, "_(disambiguation)")-1)
)
and not exists (
  select 1 from pagelinks where pl_from = p1.page_id and pl_namespace = 0 and pl_from_namespace = 0
  and pl_title in (select page_title from redirect, page where page_id = rd_from and rd_namespace = 0
                   and rd_title = substring(p1.page_title, 1, INSTR(p1.page_title, "_(disambiguation)")-1))
)
limit 1;

-- select * from pagelinks limit 1;
SQL

Checking query status...
