Missing talk page of redirect templates

SQL

select count(*) from page where page_namespace = 1 and page_is_redirect = 0
and page_title in (select page_title from page where page_namespace = 0 and page_is_redirect = 1)
and page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget 
    where lt_title in ('BLP', 'BLP_others') and lt_namespace = 10
  )
)
and page_id not in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget 
    where lt_title in ('Talk_page_of_redirect') and lt_namespace = 10
  )
)

/*
select count(*) from page where page_namespace = 1 and page_is_redirect = 0
and page_title in (select page_title from page where page_namespace = 0 and page_is_redirect = 1)
and page_id not in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget 
    where lt_title in ('Talk_page_of_redirect') and lt_namespace = 10
  )
)
and page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget 
    where lt_title in ('Old_RfD', 'Old_XfD_multi', 'Old_MfD') and lt_namespace = 10 
    or lt_title = 'WikiProject_banner' and lt_namespace = 828
  )
)
*/
/*
and page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget 
    where lt_title in ('Archive') and lt_namespace = 10
  )
)
*/
SQL

Checking query status...
