Intentional disambiguation links of ambiguous qualified title without primary topic

SQL

with disamb_page as (
  select page_title from page
  where page_is_redirect = 0 and page_namespace = 0
  and page_id in (select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type = 'page')
),
disamb_redirect as (
  select p1.page_title as rdt_title, p2.page_title as rdf_title from page p1
  join redirect on rd_title = p1.page_title and rd_namespace = 0
  join page p2 on p2.page_id = rd_from and p2.page_namespace = 0 and p2.page_is_redirect = 1
  where p1.page_id in (select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type = 'page')
  and p1.page_is_redirect = 0 and p1.page_namespace = 0
)

select dr.rdf_title, dr.rdt_title from disamb_redirect dr
where dr.rdf_title like '%\_(%)\_(disambiguation)'
and substring(dr.rdf_title, 1, INSTR(dr.rdf_title, "_(disambiguation)")-1) in (
  select page_title from disamb_page
  union
  select rdf_title from disamb_redirect
)
order by dr.rdf_title;

SQL

Checking query status...