patrollers that have made less than M edits in the last N days(tekrar çalıştımak için forklandı)

Fork of patrollers that have made less than M edits in the last N days by Bulgu

This query is marked as a draft This query has been published by By erdo can.

SQL

USE trwiki_p;
SELECT NOW() as updated;

SET @N = -700;
SET @M = 30;

SELECT CONCAT("[[User:",user_name,"|]]") as kullanici, last_edit as son_katki, user_editcount as katki_sayisi, DATEDIFF(NOW(), last_edit) as gun, ug_group as grup
	FROM (SELECT *, MAX(rev_timestamp) AS last_edit FROM revision WHERE rev_user > 0 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 = 'patroller')
AND (last_edit < DATE_ADD(NOW(), INTERVAL @N DAY) OR user_id in 
(SELECT rev_user from revision where rev_user>0 and rev_timestamp > DATE_ADD(NOW(), INTERVAL @N DAY) 
 group by rev_user having count(rev_timestamp)<@M))
ORDER BY last_edit ASC
;

SQL

Checking query status...