Changed redirect for tpr tagging

SQL

/*
select page_title, actor_name, recentchanges_userindex.* from recentchanges_userindex
join page on rc_cur_id = page_id
join actor_revision on actor_id = rc_actor
where page_title = 'Oggarane_(film)'
*/

/*
select count(distinct page_title) from page
join recentchanges_userindex on rc_cur_id = page_id and rc_new = 0 and rc_namespace = 0
join change_tag on ct_rc_id = rc_id
join change_tag_def on ctd_id = ct_tag_id and ctd_name in ('mw-removed-redirect', 'mw-new-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
    )
  )
)
*/

select page_title from recentchanges_userindex
join change_tag on ct_rc_id = rc_id
join change_tag_def on ctd_id = ct_tag_id and ctd_name in ('mw-removed-redirect', 'mw-new-redirect')
join page on rc_cur_id = page_id and page_namespace = 0 and page_is_redirect = 1
where rc_new = 0 and rc_namespace = 0
and rc_cur_id not in (
  select rc_cur_id from recentchanges_userindex
  join change_tag on ct_rc_id = rc_id
  join change_tag_def on ctd_id = ct_tag_id and ctd_name = 'mw-new-redirect'
  join page on rc_cur_id = page_id and page_namespace = 0 and page_is_redirect = 1
  where rc_new = 0 and rc_namespace = 0
)


-- select * from change_tag_def order by ctd_count desc
SQL

Checking query status...
