Replicas browser and optimizer
This query is marked as a draft
This query has been published
use hewiki_p; select rev_user_text as "משתמש/ת", count(*) as "עריכות ב180 הימים האחרונים", CURRENT_DATE as "נכון ל" from revision where rev_user>0 and not exists(select * from user_groups where ug_user=rev_user and ug_group='bot') and rev_timestamp >CURRENT_DATE - INTERVAL 180 DAY group by rev_user having count(*)>=100 order by count(*) 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