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 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 ('Redirecttalk', 'Talkredirected', 'Talkredirect', 'Talkpage_of_redirected_article',
                      'Talkpage_of_a_redirect', 'Redirected', 'Tpr', 'Talkpage_of_redirect', 'Old_talk_on_redirect'
                      'Talk_page_of_a_redirect', 'Redirect_talk', 'Talk_page_redirect', 'TPR', 'Tpor') and lt_namespace = 10
  )
)
SQL

Checking query status...
