Main pl.wiki query 3

SQL

USE plwiki_p;
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
WHERE actor_user IS NOT NULL
AND ug_group IN ('autoreview','editor')
AND user_name IN (SELECT REPLACE(log_title, '_',' ') AS log_title FROM plwiki_p.logging WHERE log_type LIKE 'block' AND log_action LIKE 'block' AND log_params LIKE '%infinite%')
GROUP BY user_name
LIMIT 300;
SQL

Checking query status...
