Soft redirect on talk pages of redirect

SQL

/*
select 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_is_redirect = 0 and
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 page_title from page where page_namespace = 7 and page_len < 6

/*
select p1.page_title, rd_title from page p1
join page p2 on p1.page_title = p2.page_title and p2.page_namespace = 0 and p2.page_is_redirect = 1
join redirect on rd_from = p2.page_id and rd_namespace = 0
where p1.page_namespace = 1 and p1.page_is_redirect = 0
and p1.page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'Soft_redirect' and lt_namespace = 10
  )
)
and p1.page_id in (
  select pl_from from pagelinks where pl_from_namespace = 1 and pl_namespace = 1 and pl_title = rd_title
)
*/

select p1.page_title from page p1 where p1.page_namespace = 1 and p1.page_is_redirect = 0
and p1.page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget where lt_title = 'Soft_redirect' and lt_namespace = 10
  )
)
and p1.page_title in (
  select page_title from page where page_namespace = 0 and page_is_redirect = 1
)

/*
and p1.page_id not in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget 
    where lt_title = 'WikiProject_banner' and lt_namespace = 828
    or lt_title in ('Old_CfD') and lt_namespace = 10 
  )
)
*/
SQL

Checking query status...
