Enwiki edits by edit count for 2024-09-14

SQL

SELECT
  CASE WHEN user_editcount IS NULL THEN ' IP'
  	   WHEN user_editcount <= 10 THEN '0–10'
       WHEN user_editcount <= 100 THEN '11–100'
       WHEN user_editcount <= 1000 THEN '101–1000'
       WHEN user_editcount <= 10000 THEN '1001–10000'
       WHEN user_editcount <= 100000 THEN '10001–100000'
       WHEN user_editcount <= 1000000 THEN '100001–1000000'
       ELSE '>1000000'
  END as bucket,
  COUNT(DISTINCT user_id) AS editors
  COUNT(*) AS edits
FROM
  revision
  JOIN actor_revision ON rev_actor = actor_id
  JOIN user ON actor_user = user_id
WHERE
  rev_timestamp LIKE '202409140000%'
GROUP BY bucket;

SQL

Checking query status...