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...
