Soft redirect on talk pages of redirect

SQL

/*
select count(p1.page_title) from page p1
join page p2 on p2.page_title = p1.page_title and p2.page_namespace = 14
where p1.page_namespace = 15 and p1.page_len = 0
and p2.page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'Category_redirect' and lt_namespace = 10
  )
)
*/

select count(*) from page p2 where p2.page_namespace = 14 and p2.page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'Category_redirect' and lt_namespace = 10
  )
)

SQL

Checking query status...