SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.