(Dab)pages without incoming links from primary topic

SQL

with article_redirect as (
  select p1.page_title, rd_title, p2.page_id as rd_id from redirect
  join page p1 on rd_from = p1.page_id and p1.page_namespace = 0 and p1.page_is_redirect = 1
  join page p2 on rd_title = p2.page_title and p2.page_namespace = 0 and p2.page_is_redirect = 0
  where rd_namespace = 0
)

/*
(select p1.page_title as disamb_title, p2.page_title as primary_topic from page p1
join page p2 on 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)
where p1.page_title like '%\_(disambiguation)' and p1.page_namespace = 0 and p1.page_is_redirect = 0
and not exists (
  select 1 from pagelinks where pl_from = p2.page_id and pl_namespace = 0 and pl_from_namespace = 0
  and (pl_title = p1.page_title or pl_title in (
    select ar1.page_title from article_redirect ar1 where ar1.rd_title = p1.page_title
  ))
)
limit 1)
union
*/

(select p1.page_title as disamb_title, ar1.rd_title as primary_topic from page p1
join article_redirect ar1 on ar1.page_title = substring(p1.page_title, 1, INSTR(p1.page_title, "_(disambiguation)")-1)
where p1.page_title like '%\_(disambiguation)' and p1.page_namespace = 0 and p1.page_is_redirect = 0
and not exists (
  select 1 from pagelinks
  -- join page p3 on ar1.rd_title = p3.page_title and p3.page_namespace = 0 and p3.page_is_redirect = 0
  where pl_from = ar1.rd_id and pl_namespace = 0 and pl_from_namespace = 0
  and (pl_title = p1.page_title or pl_title in (
    select ar2.page_title from article_redirect ar2 where ar2.rd_title = p1.page_title
  ))
)
limit 1)


/*
SELECT page_title FROM page
WHERE page_title NOT IN (select pl_title from pagelinks where pl_namespace = 0 and pl_from_namespace = 0)
AND page_is_redirect = 0 AND page_namespace = 0 AND page_title like "%\_(disambiguation)";
*/

/*
select page_title from page
where page_title like "%\_(disambiguation)" and page_namespace = 0 and page_is_redirect = 0
and page_id not in (select cl_from from categorylinks where cl_to = "All_disambiguation_pages");
*/

/*
select p1.page_title, p2.page_title from redirect
join page p1 on p1.page_id = rd_from and p1.page_is_redirect = 1 and p1.page_namespace = 0
join page p2 on p2.page_title = rd_title and p2.page_namespace = rd_namespace
and p2.page_is_redirect = 0 and p2.page_namespace = 0
where rd_namespace = 0 and p1.page_title like "%\_(disambiguation)"
and p2.page_id not in (
  select cl_from from categorylinks
  where cl_to in ("All_disambiguation_pages", "All_set_index_articles") and cl_type = 'page'
);
*/
SQL

Checking query status...
