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 DESC(`blackout day edits`)
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 DESC(`week earlier edits`)
LIMIT 10;

SQL

Checking query status...