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:",u.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_edit1, count(rev_timestamp) AS editcnt1 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 editcnt FROM revision WHERE rev_user > 0 
          GROUP BY rev_user) AS latest 
          on latest.rev_user = latest1.rev_user
          JOIN user u ON u.user_id = latest.rev_user
          JOIN user_groups ug ON ug.ug_user = latest.rev_user
WHERE (ug.ug_group = 'sysop' OR ug.ug_group = 'bureaucrat')
AND (latest.editcnt < @M OR (latest1.last_edit1 is not null and latest.editcnt < latest1.editcnt1 + @M) )
ORDER BY latest.last_edit ASC, latest.editcnt desc
;
SQL

Checking query status...
