Cleanup WikiProject templates on talk page of redirects

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 ('WikiProject_Disambiguation') and lt_namespace = 10
  )
)

/*
select page_title from page where page_namespace = 0 and page_is_redirect = 1
and page_id in (
  select cl_from from categorylinks where cl_to in ('All_disambiguation_pages') and cl_type = 'page'
)
*/

select count(cl_to) from categorylinks
join page on cl_from = page_id and cl_type = 'page'
where page_namespace = 0 and page_is_redirect = 1

SQL

Checking query status...