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
limit 100

-- select * from change_tag_def order by ctd_count desc
SQL

Checking query status...
