User edit tool usage

Fork of User edits for users in a registration period by Arjunaraoc

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

 Users registered in a year and editing in a  year with different tools to know the prevalence of tool usage like wikitext, visual editor etc.

SQL

Select
   actor_user,
   actor_name,
   ctd_name,
   COUNT(*) as tagcount
from revision
join actor on actor_id=rev_actor
join page on rev_page=page_id
JOIN change_tag ON rev_id = ct_rev_id
JOIN change_tag_def ON ct_tag_id=ctd_id
WHERE rev_timestamp like "2021%"  AND ctd_name in ('wikieditor',
'visualeditor',
'mobile edit',	
'mobile web edit',	
'advanced mobile edit',	
'visualeditor-switched')
AND actor_user in (
106628,
104188,
105587,
104852,
106984,
104639,
109974,
106267,
107518,
106909,
104671,
108226,
107127,
107443,
106879,
110405,
107564,
106379,
107525,
106156,
108234,
107984,
109472,
110217,
107544,
106992
)
GROUP BY ctd_name
ORDER BY actor_name
LIMIT 1000

SQL

Checking query status...