Untitled query #86471

SQL

SELECT
  YEAR(STR_TO_DATE(rev_timestamp, '%Y%m%d%H%i%s')) AS year,
  MONTH(STR_TO_DATE(rev_timestamp, '%Y%m%d%H%i%s')) AS month,
  actor_name,
  COUNT(rev_id) AS edit_count
FROM
  revision
JOIN
  actor ON revision.rev_actor = actor.actor_id
WHERE
  STR_TO_DATE(rev_timestamp, '%Y%m%d%H%i%s') BETWEEN '2024-01-01' AND '2024-12-31'
  AND actor_user IS NOT NULL  -- Exclude anonymous users
GROUP BY
  actor_name,
  YEAR(STR_TO_DATE(rev_timestamp, '%Y%m%d%H%i%s')),
  MONTH(STR_TO_DATE(rev_timestamp, '%Y%m%d%H%i%s'))
HAVING
  COUNT(rev_id) >= 5
ORDER BY
  year, month;
SQL

Checking query status...
