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_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 actor_user in (104188, 106628, 108226,104671, 106698, 108253,106536) AND ctd_name in ('wikieditor',
'visualeditor',
'mobile edit',	
'mobile web edit',	
'advanced mobile edit',	
                                                                                                                           'visualeditor-switched')
GROUP BY ctd_name
ORDER BY actor_name
LIMIT 1000

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...