SQL
AخA
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.
All SQL code is licensed under CC0 License.