draft space - Quarry

SQL

WITH actor_uploaders_tocat AS (
SELECT actor_user
FROM revision
JOIN categorylinks  ON rev_page = cl_from
JOIN actor ON rev_actor = actor_id AND actor_user IS NOT NULL
WHERE rev_parent_id = 0
AND cl_to = "Images_from_Wiki_Loves_Earth_2014"),

user_join AS (
SELECT actor_user, user_id, user_name, user_registration
FROM actor_uploaders_tocat
JOIN user
ON actor_user = user_id),

new_users AS (
SELECT DISTINCT user_name, user_registration, actor_user
FROM user_join
WHERE user_registration >= '20140501000000'
  AND user_registration <= '20140630235959'),

edits_3M AS (
SELECT rev_id, rev_timestamp, rev_minor_edit, page_title, actor_user
FROM revision
JOIN new_users ON rev_actor = actor_user
JOIN page ON rev_page = page_id
WHERE rev_timestamp >= '20140601000000'
  AND rev_timestamp <= '20150831235959'),

edits_by_user AS (
SELECT actor_user, COUNT(DISTINCT rev_id) AS edit_count_3M
  FROM edits_3M
GROUP BY actor_user)
  
SELECT COUNT(DISTINCT actor_user)
FROM edits_by_user
WHERE edit_count_3M >= 5
SQL

Checking query status...
