Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fawiki_p; select actor_name, count(*) as total_edits, 100.0 * sum(midnight) / count(*) as midnight_percent from ( select actor_name, case when mid(rev_timestamp, 9, 2) in ('01', '02', '03', '04') then 1 else 0 end as midnight from revision join actor on rev_actor = actor_id and actor_user <> 0 left join user_groups on ug_user = actor_user and ug_group = 'bot' where ug_user is null and actor_name <> 'پیام به کاربر جدید' and rev_timestamp > '20191001000000' ) m group by actor_name having count(*) > 10 order by midnight_percent desc
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