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;  # editcountN (son N gündeki katkı sayısı) üst sınırı

SELECT CONCAT("[[User:",user_name,"|]]") as kullanici, latest.last_edit, latest.editcount-latest1.editcount as ec_sonNgun, 
latest.editcount, ug_group as grup
	FROM ((SELECT *, max(rev_timestamp) as last_edit, count(rev_timestamp) AS editcount FROM revision WHERE rev_user > 0 
          and rev_timestamp < DATE_ADD(NOW(), INTERVAL @N DAY) GROUP BY rev_user) as latest1
          left join
          (SELECT *, max(rev_timestamp) as last_edit, count(rev_timestamp) AS editcount FROM revision WHERE rev_user > 0 
          GROUP BY rev_user) AS latest 
          on latest.rev_user = latest1.rev_user
          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 (latest.editcount < @M OR (latest1.last_edit is not null and latest.editcount < latest1.editcount + @M) )
ORDER BY latest.last_edit ASC, latest.editcount desc
;
SQL

Checking query status...
