Eligible by ukwiki voters

SQL

USE ukwiki_p;

select user.user_name, Gt20, Gt300 from 
(SELECT  r1.rev_user, count(*) as Gt20 
from revision r1 
WHERE 
    		20161001 * 1000000 <= r1.rev_timestamp  AND 
    		r1.rev_timestamp < 20170401 * 1000000 
            group by r1.rev_user_text
            having Gt20 >= 20) t1,
(SELECT  r2.rev_user, count(*) as Gt300 
from revision r2 
WHERE 
    		r2.rev_timestamp < 20170401 * 1000000 
            group by r2.rev_user_text
            having Gt300 >= 300) t2,
            user
            where t1.rev_user = t2.rev_user AND
            user.user_id = t1.rev_user AND
            user.user_editcount >= 300 AND 
            NOT EXISTS (SELECT 1 FROM user_groups WHERE
            	user_groups.ug_user = user.user_id AND
            	user_groups.ug_group = 'bot')
                ORDER BY Gt300 DESC
SQL

Checking query status...
