Replicas browser and optimizer
This query is marked as a draft
This query has been published
use urwiki_p; select rev_user_text as "משתמש/ת", count(*) as "עריכות ב90 הימים האחרונים",CURRENT_DATE as "נכון ל" from revision inner join page on rev_page=page_id where page_namespace in (0,6,8,10,12,100, 108,828) and rev_user>0 and rev_timestamp >CURRENT_DATE - INTERVAL 90 DAY and not exists(select * from user where user_id=rev_user and user_registration>CURRENT_DATE - INTERVAL 30 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