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 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 join WPT_redirect WPT
where WPT.rdf_title = concat('Articles_for_creation/', A.rdf_title)
limit 1
SQL

Checking query status...
