Replicas browser and optimizer
This query is marked as a draft
This query has been published
use fawiki_p; select user_name, count(*) active_days from ( select distinct rev_user, left(rev_timestamp, 8) from revision where rev_timestamp > CONCAT(DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 1 YEAR), '%Y%m%d'), '000000') ) rev_days join user on rev_user = user_id left join user_groups on user_id = ug_user and ug_group = 'bot' where ug_user is null group by rev_user having count(*) > 100 order by active_days 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