use arwiki_p;

select rev_user_text as "اسم المستخدم", count(*) as "عدد الأيام" from(

select rev_user_text, count(*)

from revision

where rev_timestamp like "2018%"

and rev_user_text in (select user_name 

                      from user

                      where user_name = rev_user_text

                      and user_id in (select ug_user from user_groups 

                                      where ug_user = user_id

                                      and ug_group like "editor"))

group by rev_user_text, (DAY(rev_timestamp)), (MONTH(rev_timestamp))) as x

group by rev_user_text

order by count(*) desc

limit 100;