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 @a:=0;
SELECT  @a:=@a+1 serial_number,
   actor_user,
   actor_name,
   LEFT(user_registration,8) as regdate, 
   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',
'mobile app edit',
'android app edit',
'ios app edit',
'advanced mobile edit',	
'visualeditor-switched' ) 
GROUP BY actor_user, ctd_name
ORDER BY actor_name
LIMIT 10000

SQL

Checking query status...