30日以内に編集した巻き戻し者

SQL

use jawiki_p;

SELECT *
FROM `recentchanges` as RC, `actor` as A, `user_groups` as UG, `user` as U
WHERE TRUE
and (
  RC.rc_timestamp like '202006________'
)
and UG.ug_group = 'rollbacker'
and UG.ug_user = U.user_id
and RC.rc_actor = A.actor_id
and A.actor_user = U.user_id 
GROUP BY U.user_id, LEFT(RC.rc_timestamp, 8)
LIMIT 1000
;

/*
use enwiki_p
SELECT COUNT(*) as `rollbacker in enwp`
FROM `user` as U, `user_groups` as UG, `recentchanges` as RC, `actor` as A, `user` as U
WHERE TRUE
and UG.ug_group = 'rollbacker'

;

/*
SELECT U.user_name, U.user_editcount, UG.ug_group
FROM `user` as U, `user_groups` as UG, `recentchanges` as RC, `actor` as A
WHERE 1 = 1
and UG.ug_group = 'rollbacker'
and RC.rc_actor = A.actor_id
and A.actor_user = U.user_id
and UG.ug_user = U.user_id
;

/*
use enwiki_p;

SELECT COUNT(*) as `rollbacker in enwp`
FROM `user` as U, `user_groups` as UG
WHERE 1 = 1
and UG.ug_group = 'rollbacker'
and U.user_id = UG.ug_user;
*/
SQL

Checking query status...
