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 user on actor_user=user_id
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   user_registration LIKE "2021%" AND ctd_name in ('wikieditor',
'visualeditor',
'visualeditor-wikitext',
'mobile edit',	
'mobile web edit',	
'advanced mobile edit',	
'visualeditor-switched')
GROUP BY actor_user, ctd_name
ORDER BY actor_name
LIMIT 1000

SQL

Checking query status...