Untitled query #65532

SQL

#SELECT (DATEDIFF("20180930000000", "20180901000000")) AS DateDiff
SET @Initial = "20181001000000";
SELECT DISTINCT user_name, user_registration, SUM(DATEDIFF(rev_timestamp, @Initial) BETWEEN 0 AND 30) AS after_thirty_days
#rev_id, rev_timestamp, @Initial
				#IF((DATEDIFF(rev_timestamp, @Initial) <= 30), COUNT(rev_timestamp), 0) AS after_thirty_days
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 cl_to = "Images_from_Wiki_Loves_Monuments_2018" AND cl_type = "file" AND user_name NOT LIKE '%Bot%' AND rev_parent_id = 0 AND user_name = "Susu Phisi" 
ORDER BY rev_timestamp ASC
# GROUP BY user_name
SQL

Checking query status...
