Missing disambiguation redirect templates

SQL

/*
select page_namespace, page_title from page
where page_namespace = 5 and page_id in (
  select cl_from from categorylinks where cl_to = 'Redirects_from_unnecessary_disambiguation' and cl_type = 'page'
)
*/

with WPT_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 = 5 and p2.page_is_redirect = 1
  where p2.page_id in (
    select cl_from from categorylinks where cl_to = 'Redirects_from_unnecessary_disambiguation' and cl_type = 'page'
  )
  and p1.page_is_redirect = 0 and p1.page_namespace = 0
),
A_redirect as (
  select p1.page_title as rdt_title, p2.page_title as rdf_title, p2.page_id as rdf_id 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 p2.page_id not in (
    select cl_from from categorylinks where cl_to = 'Redirects_from_unnecessary_disambiguation' and cl_type = 'page'
  )
  and p1.page_is_redirect = 0 and p1.page_namespace = 0
)

select A.rdt_title, A.rdf_title, WPT.rdt_title, WPT.rdf_title from A_redirect A, WPT_redirect WPT
where WPT.rdf_title = concat('Articles_for_creation/', A.rdf_title)
and substring(A.rdf_title, 1, length(A.rdt_title)) = A.rdt_title
and A.rdf_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title in ('Redirect_category_shell') and lt_namespace = 10
  )
)
and A.rdf_title not like '%\_(disambiguation)'
and
SQL

Checking query status...
