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 * from change_tag
join revision_userindex on ct_rev_id = rev_id
join page on rev_page = page_id
join actor_revision on actor_id = rev_actor
where ct_tag_id in (
  select ctd_id from change_tag_def where ctd_name in ('mw-removed-redirect', 'mw-new-redirect')
)
limit 100

-- select * from change_tag_def order by ctd_count desc

SQL

Checking query status...