Untitled query #65532

SQL

SELECT user_id, user_name, user_registration,
        SUM(DATEDIFF(rev_timestamp, user_registration) < 30 ) AS early_main_edits,
        SUM(DATEDIFF(rev_timestamp, user_registration) BETWEEN 60 AND 180) AS surviving_edits
FROM user
INNER JOIN actor ON actor_user = user_id AND user_id != 0 
INNER JOIN revision ON rev_actor = actor_id AND rev_actor != 0
INNER JOIN categorylinks ON rev_page = cl_from

WHERE rev_timestamp <= DATE_FORMAT(DATE_ADD(user_registration, INTERVAL 180 DAY), "%Y%m%d%H%i%s") AND cl_to = "Images_from_Wiki_Loves_Monuments_2018" AND cl_type = "file"
SQL

Checking query status...
