Untitled query #63768

SQL

SELECT DISTINCT user_name, user_registration, SUM(DATEDIFF(rev_timestamp, user_registration) =< 30) AS thirtyday_edits,
				SUM(DATEDIFF(rev_timestamp, user_registration) =< 60 and DATEDIFF(rev_timestamp, user_registration) > 30) AS sixtyday_edits,
                SUM(DATEDIFF(rev_timestamp, user_registration) =< 90 and DATEDIFF(rev_timestamp, user_registration) > 60) AS nintyday_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 page ON rev_page = page_id
INNER JOIN categorylinks ON rev_page = cl_from

WHERE cl_to = "Images_from_Wiki_Loves_Monuments_2018" AND cl_type = "file" AND user_name NOT LIKE '%Bot%' AND rev_parent_id = 0 
GROUP BY user_name
SQL

Checking query status...
