Bot-to-bot time to revert in English Wikipedia articles

Fork of Bot-to-bot reverts in English Wikipedia by Namespace by EpochFail

This query is marked as a draft This query has been published by EpochFail.

SQL

SELECT
	IF(TIMESTAMPDIFF(HOUR, reverted.reverting_timestamp, reverted.rev_timestamp) < 1, "< hour",
       IF(TIMESTAMPDIFF(DAY, reverted.reverting_timestamp, reverted.rev_timestamp) < 1, "hour-day",
       IF(TIMESTAMPDIFF(WEEK, reverted.reverting_timestamp, reverted.rev_timestamp) < 1, "day-week",
       IF(TIMESTAMPDIFF(MONTH, reverted.reverting_timestamp, reverted.rev_timestamp) < 1, "week-month",
       IF(TIMESTAMPDIFF(YEAR, reverted.reverting_timestamp, reverted.rev_timestamp) < 1, "month-year", "> year"))))) AS time_to_revert_block,
    COUNT(*),
    COUNT(DISTINCT rev_user),
    COUNT(DISTINCT reverting_user)
FROM u2041__botvbot_p.enwiki_bot2bot_reverted_20140820 AS reverted
WHERE page_namespace = 0
GROUP BY 1;

SQL

Checking query status...