Користувач:Kanzat/ActiveUsersNotAutoreview

Список найбільш активних користувачів, які не є патрульними

https://quarry.wmcloud.org/query/61370

       SELECT a.actor_name, COUNT(a.actor_user) CNT FROM revision AS r
       JOIN actor AS a ON (a.actor_id = r.rev_actor)
       WHERE r.rev_timestamp > 20210101000000 and r.rev_timestamp < 20220101000000
       AND a.actor_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group IN ('bot', 'autoreview', 'editor', 'sysop'))
       GROUP BY a.actor_name
       ORDER BY CNT DESC