Hewiki eligble voters 2024

SQL

use hewiki_p;
select user_name as "משתמש/ת", 
count(*) as "עריכות ב90 הימים האחרונים",
CURRENT_DATE as "נכון ל" 
from revision
inner join actor_user on actor_id=rev_actor
inner join user on user_id=actor_user
inner join page on rev_page=page_id
where page_namespace in (0,6,8,10,12,100, 108,828) and
rev_timestamp >CURRENT_DATE - INTERVAL 90 DAY and 
not exists(select * from user where user_id=actor_user and user_registration>CURRENT_DATE - INTERVAL 365 DAY)
group by user_name having count(*)>=100
order by count(*) desc;
SQL

Checking query status...
