Main pl.wiki query 3

SQL

USE plwiki_p;
SELECT CONCAT("{{Lw|",user_name,"}}") AS user_name, actor_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
/*LEFT OUTER JOIN logging ON log_title = user_name*/
WHERE page_namespace = 0
AND actor_user IS NOT NULL
AND user_editcount > 200
AND revactor_timestamp BETWEEN 20200320000000 AND 20200620000000
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)
AND user_name NOT IN (SELECT log_title FROM plwiki_p.logging WHERE log_type LIKE 'block' AND log_action LIKE 'block' AND log_timestamp > 20100101000000)
AND user_name NOT IN (SELECT log_title FROM plwiki_p.logging WHERE log_type LIKE 'rights' AND log_action LIKE 'rights' AND log_timestamp > 20100101000000)
AND user_name IN (SELECT log_title FROM plwiki_p.logging WHERE log_type LIKE 'newusers' AND log_timestamp < 20200320000000)


GROUP BY user_name
HAVING recent_user_editcount > 25
ORDER BY ug_group DESC, user_editcount DESC
LIMIT 300;
SQL

Checking query status...
