Users without autoreview right on plwiki by last edit

SQL

USE plwiki_p;
SELECT CONCAT("[[Wikipedysta:",user_name,"|",user_name,"]]") AS user_name, user_editcount, ug_group
FROM user, actor a
LEFT OUTER JOIN revision_actor_temp ON revactor_actor = a.actor_id
LEFT OUTER JOIN user_groups ON user_id = ug_user
WHERE user_editcount > 500
AND revactor_timestamp > 20200101000000
AND a.actor_id = user_id
AND ug_group NOT LIKE 'sysop'
AND ug_group NOT LIKE 'editor'
AND ug_group NOT LIKE 'interface-admin'
AND ug_group NOT LIKE 'abusefilter'
AND ug_group NOT LIKE 'oversight'
AND ug_group NOT LIKE 'ipblock-exempt'
AND ug_group NOT LIKE 'accountcreator'
AND ug_group NOT LIKE 'bureaucrat'
AND ug_group NOT LIKE 'bot'
AND ug_group NOT LIKE 'checkuser'
AND ug_group NOT LIKE 'flood'
AND ug_group NOT LIKE 'flow-bot'
/*GROUP BY user_name*/
limit 100;
SQL

Checking query status...
