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

SQL

use jawiki_p;

SELECT *
FROM `change_tag` as CT, `change_tag_def` as CTD, `recentchanges` as RC, `actor` as A
WHERE TRUE
-- mw-rollback
and UG.ug_group = 'rollbacker'
and UG
and CTD.ctd_id = 19
and CT.ct_tag_id = CTD.ctd_id
and CT.ct_rc_id = RC.rc_id
and RC.rc_actor = A.actor_id
LIMIT 1000
;

exit;

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...
