עורכים פעילים

SQL

use hewiki_p;
select rev_user_text as "משתמש/ת",  
sum(if(rev_timestamp >CURRENT_DATE - INTERVAL 1 MONTH,1,0)) as "עריכות בחודש האחרון",
sum(if((rev_timestamp >CURRENT_DATE - INTERVAL 2 MONTH) and (rev_timestamp <CURRENT_DATE - INTERVAL 1 MONTH),1,0)) as "עריכות בחודש הקודם",
sum(if((rev_timestamp >CURRENT_DATE - INTERVAL 3 MONTH) and (rev_timestamp <CURRENT_DATE - INTERVAL 2 MONTH),1,0)) as "עריכות בחודש הקודם קודם",
count(*)
from revision
where 
	rev_user>0 and 
	/*not exists(select * from user_groups where ug_user=rev_user and ug_group='bot')*/
    rev_timestamp >CURRENT_DATE - INTERVAL 3 MONTH
 group by rev_user
 having count(*)>5
 order by count(*) desc;
SQL

Checking query status...
