sysops that have made less than M edits in the last N days

SQL

USE trwiki_p;
SELECT NOW() as updated;

SET @N = -100; # gün sayısı
SET @M = 30  # editcountM

SELECT CONCAT("[[User:",user_name,"|]]") as kullanici, last_editN as sonkatki_sonNgun, editcount as katkisayisi_sonNgun, ug_group as grup
	FROM (SELECT *, max(rev_timestamp) as last_editN, sum(rev_timestamp) AS editcountN FROM revision WHERE rev_user > 0 
          and rev_timestamp > DATE_ADD(NOW(), INTERVAL @N DAY) GROUP BY rev_user) AS latest
	JOIN user
		ON user_id = latest.rev_user
     JOIN user_groups
		ON ug_user = latest.rev_user
WHERE (ug_group = 'sysop' OR 'ug_group' = 'bureaucrat' OR ug_group = 'patroller')
AND editcountN < @M
ORDER BY last_editN ASC, editcountN desc
;

SQL

Checking query status...