Untitled query #73311

SQL

select rev_actor as "اسم المستخدم", COUNT(*) as "عدد عمليات الرجوع"
from revision
inner join comment
on comment_id = rev_comment_id
where rev_timestamp between SUBDATE(NOW(),100) and NOW()
and (comment_text like "%رجوع%")
and rev_actor not in (select rev_actor from user_groups where ug_user= rev_actor and ug_group like "%rollbacker%")
and rev_actor not in (select rev_actor from user_groups where ug_user= rev_actor and ug_group like "%sysop%")
group by rev_user
order by count(*) desc
limit 100;
SQL

Checking query status...
