المستخدمون حسب أيام تواجدهم خلال العام

SQL

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;

SQL

Checking query status...