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

SQL

use hewiki_p;
select rc_user_text as "משתמש/ת",  
/*
count(rev_timestamp >CURRENT_DATE - INTERVAL 1 MONTH) as "עריכות בחודש האחרון",
count((rev_timestamp >CURRENT_DATE - INTERVAL 2 MONTH) and (rev_timestamp <CURRENT_DATE - INTERVAL 1 MONTH)) as "עריכות בחודש הקודם",
count((rev_timestamp >CURRENT_DATE - INTERVAL 3 MONTH) and (rev_timestamp <CURRENT_DATE - INTERVAL 2 MONTH))as "עריכות בחודש הקודם קודם",
*/
count(*)
from recentchanges
where 
	rc_user>0 and 
	rc_bot=0
    and rc_timestamp >CURRENT_DATE - INTERVAL 3 MONTH
 group by rev_user
 order by count(*) desc;
SQL

Checking query status...
