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
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'
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, 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-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
    )
  )
  /*
  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

/*
select * 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
join comment on rc_comment_id = comment_id
where rc_new = 0 and page_title = 'Attorney-General_of_Alberta'
*/

-- select * from change_tag_def order by ctd_count desc
SQL

Checking query status...
