Autoprzeglądajacy

SQL

USE plwiki_p;
SELECT CONCAT("[[User:",user_name,"]]") AS user_name, ug_group, user_editcount, 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
WHERE actor_user IS NOT NULL
AND revactor_timestamp BETWEEN 20200425000000 AND 20200525000000
AND ug_group LIKE 'autoreview'
/*AND (ug_group NOT IN ('autoreview','sysop', 'editor', 'interface-admin', 'abusefilter', 'oversight', 'ipblock-exempt', 'accountcreator', 'bureaucrat', 'bot', 'checkuser', 'flood', 'flow-bot') or ug_group IS NULL)*/
GROUP BY user_name
ORDER BY recent_user_editcount DESC;
SQL

Checking query status...
