Edições revertidas em agosto de 2020

SQL

USE ptwiki_p;
SELECT
 EDIÇÕES_REG,
 CONCAT(r_reg, ' (', ROUND(r_reg * 100 / EDIÇÕES_REG, 1) , '%)') REG_REVERTIDAS,
 EDIÇÕES_IP,
 CONCAT(r_ip, ' (', ROUND(r_ip * 100 / EDIÇÕES_IP, 1) , '%)') IP_REVERTIDAS
FROM
 (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%'
 ) edits
 CROSS JOIN
 (SELECT
   SUM(actor_user IS NOT NULL AND r2.rev_timestamp LIKE '202008%') r_reg,
   SUM(actor_user IS NULL AND r2.rev_timestamp LIKE '202008%') r_ip
  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'))
 ) reverted
SQL

Checking query status...
