Monthly Revert Rate

SQL

select *, reverted_edit_count/edit_count*100 as percent_reverted
from (

  select LEFT(rev_timestamp, 6) AS year_month, count(1) as edit_count, count(t.reverted_rev_id) as reverted_edit_count
  from change_tag
  left join change_tag_def on ct_tag_id=ctd_id
  left join revision on ct_rev_id=rev_id
  left join page on rev_page=page_id
  
  left join (
    select ct_rev_id as reverted_rev_id
    from change_tag
    left join change_tag_def on ct_tag_id=ctd_id
    where ctd_name='mw-reverted'
  ) t on ct_rev_id=reverted_rev_id

  where ct_rev_id is not null
  and page_namespace = 0
  group by LEFT(rev_timestamp, 6)
) y
order by year_month ASC
SQL

Checking query status...
