Users without autoreview right on plwiki by last edit

Fork of Users without autoreview right on plwiki by last edit by The Polish

This query is marked as a draft This query has been published by Wargo.

SQL

USE plwiki_p;
SELECT CONCAT("[[Wikipedysta:",user_name,"|",user_name,"]]") AS user_name, user_editcount, ug_group
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
WHERE user_editcount > 500
AND revactor_timestamp > 20200101000000
AND (ug_group NOT IN ('sysop', 'editor', 'interface-admin', 'abusefilter', 'oversight', 'ipblock-exempt', 'accountcreator', 'bureaucrat', 'bot', 'checkuser', 'flood', 'flow-bot') or ug_group IS NULL)
GROUP BY user_name
limit 100;

SQL

Checking query status...