Most active editors @ WP:Peer review/*

Users most active at pages with titles beginning 'Wikipedia:Peer review/' in the last six months.

#/edits is the total number of edits.
Added chars is the sum of the change sizes they've made, counting only edits that added characters.
Delta chars is the sum of the change sizes they've made, including both positive and negative changes of characters.

For [[WP:RAQ#Active editors at Peer review]] circa 17 October 2023.

SQL

SELECT actor_name,
       COUNT(*) AS '#/edits',
       SUM(CASE
             WHEN cur.rev_len - COALESCE(prev.rev_len, 0) < 0 THEN 0
             ELSE cur.rev_len - COALESCE(prev.rev_len, 0)
           END) AS 'Added chars',
       SUM(cur.rev_len - COALESCE(prev.rev_len, 0)) AS 'Delta chars'
FROM revision AS cur
JOIN actor_revision ON actor_id = cur.rev_actor
JOIN page ON page_id = cur.rev_page
LEFT JOIN revision AS prev ON prev.rev_id = cur.rev_parent_id
WHERE page_namespace = 4
  AND page_title LIKE 'Peer_review/%'
  AND cur.rev_timestamp >= DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -6 MONTH), '%Y%m%d%H%i%s')
GROUP BY actor_name
ORDER BY COUNT(*) DESC;

SQL

Checking query status...