active users not in review group

SQL

SELECT user_name, autoreview, user_editcount, tmp2.c AS editcount_2014 FROM
(SELECT user_id, user.user_name, user.user_editcount, editor,bot, autoreview FROM user 
 LEFT JOIN (SELECT ug_user, (ug_user IS NOT NULL) as editor FROM user_groups WHERE ug_group='editor') AS ug_editor ON user.user_id=ug_editor.ug_user 
 LEFT JOIN (SELECT ug_user, (ug_user IS NOT NULL) as bot FROM user_groups WHERE ug_group='bot') AS ug_bot ON user.user_id=ug_bot.ug_user  
 LEFT JOIN (SELECT ug_user, (ug_user IS NOT NULL) as autoreview FROM user_groups WHERE ug_group='autoreview') AS ug_autoreview ON user.user_id=ug_autoreview.ug_user 
 WHERE user_editcount > 100 AND user_editcount < 15000 AND editor IS NULL AND bot IS NULL
) as tmp, 
( 
   SELECT sum(1) as c,rev_user FROM revision 
   WHERE  rev_timestamp > 20140000000000 AND rev_timestamp < 20141200000000 GROUP BY rev_user
) as tmp2 
WHERE tmp.user_id=tmp2.rev_user  order by c desc;
SQL

Checking query status...
