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, last_editN as sonkatki_sonNgun, 
editcountN as katkisayisi_sonNgun, ug_group as grup
	FROM (SELECT *, max(rev_timestamp) as last_editN, count(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 (latest.editcountN < @M OR latest.last_editN is null)
ORDER BY latest.last_editN ASC, latest.editcountN desc
;

SQL

Checking query status...