T295516 What percentage of talk page edits are made with DiscussionTools? (after WikiEditor tag)

SQL

select *
from (
	select tags, count(*) as count
	from (
		select rev_id, COALESCE(group_concat(ctd_name),'[NO INTERESTING TAGS]') 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
			-- Ignore this tag because it would be listed in every entry
			and ctd_name != 'discussiontools-added-comment'
			-- Ignore other DiscussionTools tags to group everything under 'discussiontools'
			and ctd_name not like 'discussiontools-%'
			-- Ignore some tags based on the content of the edit, rather than the editor software
			and ctd_name not in (
				'mw-add-media', 'mw-remove-media', 'mw-reverted', 'mw-manual-revert',
				'mw-removed-redirect', 'mw-replace', 'disambiguator-link-added'
			)
		where rev_timestamp between '20211220' and '20211223'
		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 count desc
SQL

Checking query status...
