sandbox 3 - Quarry

SQL

WITH active_editors AS (
  SELECT rev_actor, COUNT(rev_id) AS edit_count
  FROM revision
  WHERE
	rev_timestamp > '20210101000000'
	AND rev_timestamp < '20210331235959'
  GROUP BY rev_actor
  HAVING COUNT(rev_id) >= 5),
  
  non_bot_editors AS (
  SELECT actor_id, user_id, user_name, user_editcount
  FROM actor
  JOIN user
  ON actor.actor_user = user.user_id
  LEFT JOIN user_groups
  ON ug_user = user_id
  WHERE user_editcount>0
  AND (ug_group NOT IN ('bot', 'flow-bot')
       OR ug_group IS NULL))

SELECT COUNT(DISTINCT non_bot_editors.user_name)
FROM non_bot_editors
LIMIT 10
SQL

Checking query status...
