Edições revertidas em agosto de 2020

SQL

USE ptwiki_p;
SELECT
  COUNT(actor_user) EDIÇÕES_REG,
  SUM(actor_user IS NULL) EDIÇÕES_IP
 FROM revision
 INNER JOIN actor ON rev_actor = actor_id
 WHERE rev_timestamp LIKE '202008%';

SELECT
  SUM(actor_user IS NOT NULL AND r2.rev_timestamp LIKE '202008%') REG_REVERTIDA,
  SUM(actor_user IS NULL AND r2.rev_timestamp LIKE '202008%') IP_REVERTIDA
 FROM revision r3
 INNER JOIN revision r2 ON r3.rev_parent_id = r2.rev_id
 INNER JOIN revision r1 ON r1.rev_id = r2.rev_parent_id
 INNER JOIN actor ON r2.rev_actor = actor_id
 WHERE
  r3.rev_timestamp BETWEEN 20200800000000 AND 202020930600000
  AND r1.rev_sha1 = r3.rev_sha1
  AND (actor_user IS NULL OR actor_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot'));
SQL

Checking query status...
