Articles frequently turned into redirect

SQL

select page_title, count(rev_id) from page
join revision_userindex on rev_page = page_id -- and rev_parent_id != 0
join change_tag on ct_rev_id = rev_id
join change_tag_def on ctd_id = ct_tag_id and ctd_name = 'mw-removed-redirect'
where page_namespace = 0 and page_is_redirect = 1
and page_title in (
  select page_title from page where page_namespace = 1 and page_is_redirect = 0
  and page_id not in (
    select tl_from from templatelinks where tl_target_id in (
      select lt_id from linktarget 
      where lt_title = '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
    )
  )
  */
)
group by rev_page
having count(rev_id) > 2
order by count(rev_id) desc
SQL

Checking query status...
