Replicas browser and optimizer
المستخدمون حسب أيام تواجدهم خلال العام
This query is marked as a draft
This query has been published
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;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in