use arwiki_p;

​

select user_name, COUNT(*)

from logging

inner join user

on user.user_id = logging.log_user

where log_timestamp BETWEEN 20180101000000 AND 20181228000000

and log_action IN ("mw-undo"/*"delete", "block", "protect", "rights"*/)

and log_user not in (select ug_user from user_groups where ug_user= rev_user and ug_group like "%rollbacker%")

and log_user not in (select ug_user from user_groups where ug_user= rev_user and ug_group like "%sysop%")

group by user_name

order by count(*) desc

limit 100;

​

/*

​

select rev_user_text, COUNT(*)

from revision

where rev_timestamp BETWEEN 20180601000000 AND 20181201000000

and rev_comment like "%رجوع%"

and rev_user not in (select ug_user from user_groups where ug_user= rev_user and ug_group like "%rollbacker%")

and rev_user not in (select ug_user from user_groups where ug_user= rev_user and ug_group like "%sysop%")

group by rev_user

order by count(*) desc

limit 100;*/