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 "2022%"  AND ctd_name in ('wikieditor',
'visualeditor',
'visualeditor-wikitext',
'mobile edit',	
'mobile web edit',	
'advanced mobile edit',	
'visualeditor-switched')
AND actor_user in (
  Select
    user_id,
  from  user
  where LEFT(user_registration,8) > "20201231" and LEFT(user_registration,8) < "20220000" 
  )   

GROUP BY ctd_name
ORDER BY actor_name
LIMIT 1000

SQL

Checking query status...