Most active users without autoreview right on plwiki

SQL

SELECT CONCAT("{{Lw|",user_name,"}}") AS user_name, user_editcount, ug_group, COUNT(actor_id) AS recent_user_editcount
FROM user
LEFT OUTER JOIN actor ON actor_user = user_id
LEFT OUTER JOIN revision_actor_temp ON revactor_actor = actor_id
LEFT OUTER JOIN user_groups ON ug_user = actor_user
LEFT OUTER JOIN page ON page_id = revactor_page
WHERE page_namespace = 0
AND actor_user IS NOT NULL
AND user_editcount > 300
AND revactor_timestamp >= DATE_ADD(NOW(), INTERVAL -7 DAY)
AND (ug_group NOT IN ('arbcom',/*'autoreview',*/'sysop','editor','interface-admin','abusefilter','oversight','ipblock-exempt',
                      'accountcreator','bureaucrat','bot','checkuser','flood','flow-bot') or ug_group IS NULL)
AND user_name NOT IN (SELECT REPLACE(log_title, '_',' ') AS log_title FROM plwiki_p.logging WHERE log_type LIKE 'block' 
                      AND log_action LIKE 'block' AND log_timestamp >= DATE_ADD(NOW(), INTERVAL -90 DAY))
AND user_name IN (SELECT REPLACE(log_title, '_',' ') AS log_title FROM plwiki_p.logging WHERE log_type LIKE 'newusers' 
                  AND log_timestamp <= DATE_ADD(NOW(), INTERVAL -30 DAY))
AND user_name NOT IN (SELECT REPLACE(log_title, '_',' ') AS log_title FROM plwiki_p.logging WHERE log_type LIKE 'rights' 
                      AND log_action LIKE 'rights' AND log_timestamp >= DATE_ADD(NOW(), INTERVAL -90 DAY))
AND user_name NOT IN ('JerzyM77','Elster','Macuk','Бучач-Львів','Andrew J.Kurbiko','Krecik-79','Apopix','Nikodem62','Olek47','Temuera','Krzysio.szubzda.1',
                     'Blunsiofficial','Per excellence','Jgwikid','Krzysio.szubzda.1','RALFFPL','Perico','Habibi Hajwan','M.Tomma',
                     'Frankenhagen76','Eznik92','Leonardo.official','Kuba2654','M.Tomma','Guccee','Tomek320','Andy3684','DrKumpelek',
                     'Лобачев Владимир','Stephan1000000','94pb','Donatus Polonorum','Matrix1552','Jakubborys','Bartex820','TVShowFan122',
                     'TVShowFan122','KaMGe','Mirela63','Marcin. Wierdak')
GROUP BY user_name
HAVING recent_user_editcount > 20
ORDER BY recent_user_editcount DESC
LIMIT 300;
SQL

Checking query status...
