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.editcnt - latest1.editcnt) as ec_sonNgun, 
latest.editcnt, ug_group as grup
	FROM  (SELECT *, max(rev_timestamp) as last_edit, count(rev_timestamp) AS editcnt FROM revision WHERE rev_user > 0 
          GROUP BY rev_user) AS latest 
          JOIN user u ON u.user_id = latest.rev_user
          JOIN user_groups ug ON ug.ug_user = latest.rev_user
          left join
          ((SELECT *, max(rev_timestamp) as last_edi, count(rev_timestamp) AS editcn FROM revision rr WHERE rr.rev_user > 0 
          and rr.rev_timestamp < DATE_ADD(NOW(), INTERVAL @N DAY) GROUP BY rr.rev_user) as lates
          on lates.rr.rev_user = latest.rev_user
WHERE (ug.ug_group = 'sysop')
AND (latest.editcnt < @M OR ((lates.last_edi is not null) and latest.editcnt < lates.editcn + @M) )
ORDER BY latest.last_edit ASC, latest.editcnt desc
;
SQL

Checking query status...
