Admins w/ <100 edits since 2018

Admins with fewer than 100 edits since 1 January 2018.  They are currently on track to be desysopped on 1 January 2023 as per item 2 at [[WP:INACTIVITY]] ("(2) (Effective 01 January 2023) Has made fewer than 100 edits over a 60 month period").

For [[WP:BN#Query]] circa 8 August 2022.

See query 67277 for a version also counting deleted edits.

I accidentally reran this query on 11 September, which removed the old results, hence the new check against maximum timestamp.  (It seems old query results are only kept in History if the query changes.)  There was one additional admin in the old results, Staxringold, who does not appear here because he was desysopped on September 10.

SQL

SELECT user_name, COUNT(rev_id)
FROM user
JOIN user_groups ON ug_user = user_id
JOIN actor_revision ON actor_user = user_id
JOIN revision_userindex ON rev_actor = actor_id
WHERE ug_group = 'sysop'
  AND rev_timestamp >= '2018'
  AND rev_timestamp <= '202208080051' -- timestamp of my comment saying 'down to 180', since I accidentally reran this query a month later
GROUP BY user_name
HAVING COUNT(rev_id) < 100
ORDER BY COUNT(rev_id) ASC;

AخA
 
SELECT user_name, COUNT(rev_id)FROM userJOIN user_groups ON ug_user = user_idJOIN actor_revision ON actor_user = user_idJOIN revision_userindex ON rev_actor = actor_idWHERE ug_group = 'sysop'  AND rev_timestamp >= '2018'  AND rev_timestamp <= '202208080051' -- timestamp of my comment saying 'down to 180', since I accidentally reran this query a month laterGROUP BY user_nameHAVING COUNT(rev_id) < 100ORDER BY COUNT(rev_id) ASC;

SQL

Checking query status...