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), rev_id, 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_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...
