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

SQL

select *
from (
	select tags, count(*) as countt
	from (
		select rev_id, COALESCE(group_concat(ctd_name),'') as tags
		from revision revision1
		left outer join change_tag on rev_id=ct_rev_id
		left outer join change_tag_def on ct_tag_id=ctd_id and (
			ctd_name != 'discussiontools-added-comment'
		)
		where rev_timestamp between '202110' and '202111'
		and (ctd_name is null or ( ctd_name = 'discussiontools'
			-- and ctd_name not like 'mw-%'
		) )
		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
	group by tags with rollup
) y
order by countt desc

SQL

Checking query status...