use hewiki_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;