Revert rates by edit tags

This query is marked as a draft This query has been published by Matma Rex.

SQL

select *, reverted_cnt/cnt
from (

select ctd_id, ctd_name, count(*) as cnt, count(t.reverted_rev_id) as reverted_cnt
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 ( 
	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 rev_timestamp > '20211223'
group by ctd_id
order by cnt desc
limit 50
  
) y

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...