Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Cryptic
.
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.
Toggle Highlighting
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;
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
.
Checking query status...