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
.
The number of edits made each hour by Cewbot and Qwerfjkl (bot) in February 2024, grouped in one-hour increments. Should be below 360/hour (6/minute, or once every 10 seconds) for non-urgent tasks or 720/hour (12/minute, or once every 5 seconds) for urgent ones per [[WP:BOTPERF]]. Sorted by default by time, most recent first. For [[WP:BOTN#Please block Cewbot]] circa 16 February 2024.
Toggle Highlighting
SQL
SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS 'hour', SUM(actor_name = 'Cewbot') AS 'Cewbot edits/hr', SUM(actor_name = 'Cewbot') / 60 AS 'Cewbot avg edits/min', SUM(actor_name = 'Qwerfjkl (bot)') AS 'Qwerfjkl (bot) edits/hr', SUM(actor_name = 'Qwerfjkl (bot)') / 60 AS 'Qwerfjkl (bot) avg edits/min' FROM revision_userindex JOIN actor_revision ON actor_id = rev_actor AND actor_name IN ('Cewbot', 'Qwerfjkl (bot)') WHERE rev_timestamp BETWEEN '202402' AND '2024021705' -- omit partial data from final hour GROUP BY LEFT(rev_timestamp, 10) DESC;
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...