USE trwiki_p;

SELECT NOW() as updated;

​

SET @N = -731;

​

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

, replace(ufg_group,'editor', null) as eski_grup, round(DATEDIFF(NOW(), last_edit)/365.24,2) as yil

    FROM (SELECT *, MAX(rev_timestamp) AS last_edit FROM revision_userindex WHERE rev_user > 0 GROUP BY rev_user) AS latest

    JOIN user  ON user_id = latest.rev_user

     JOIN user_groups  ON ug_user = user_id

     LEFT JOIN user_former_groups ON ufg_user= ug_user

WHERE (ug_group = 'patroller')

AND last_edit < DATE_ADD(NOW(), INTERVAL @N DAY)

ORDER BY last_edit ASC

;

SELECT NOW();