dewiki editors during the blackout

The users with the most edits during the German Wikipedia blackout on 2019-03-21, compared to the users with the most edits one week earlier.

SQL

USE dewiki_p;

SELECT actor_name AS "user name", COUNT(*) AS "blackout day edits"
FROM revision
JOIN actor ON rev_actor = actor_id
WHERE rev_timestamp >= "20190320230000"
AND rev_timestamp < "20190321230000"
GROUP BY actor_name
ORDER BY "blackout day edits" DESC
LIMIT 10;

SELECT actor_name AS "user name", COUNT(*) AS "week earlier edits"
FROM revision
JOIN actor ON rev_actor = actor_id
WHERE rev_timestamp >= "20190313230000"
AND rev_timestamp < "20190314230000"
GROUP BY actor_name
ORDER BY "week earlier edits" DESC
LIMIT 10;

SQL

Checking query status...