T295516 What percentage of talk page edits are made with DiscussionTools?

SQL

select tags, count(*) as countt
from (select rev_id, group_concat(ctd_name) as tags
from revision revision1
left join change_tag on rev_id=ct_rev_id
left join change_tag_def on ct_tag_id=ctd_id
where rev_timestamp between '202110' and '202111'
and ct_id is not null
and ctd_name != 'discussiontools-added-comment'
and exists( 
    
select 1
from change_tag change_tag2
left join change_tag_def change_tag_def2 on change_tag2.ct_tag_id=change_tag_def2.ctd_id
where revision1.rev_id=change_tag2.ct_rev_id
and change_tag_def2.ctd_name = 'discussiontools-added-comment'
    
)
group by rev_id
     ) x
order by countt desc
group by tags with rollup

SQL

Checking query status...