Recently active mw crats

SQL

USE metawiki_p;
SELECT log_type, log_action, actor.actor_name, COUNT(*) AS 'Count in the last year' FROM logging_userindex
RIGHT JOIN actor ON logging_userindex.log_actor = actor.actor_id
WHERE actor.actor_user IS NOT NULL
AND log_timestamp > (DATE_FORMAT((NOW() - INTERVAL 365 DAY),'%Y%m%d%H%i%S'))
AND log_type NOT IN ('spamblacklist', 'thanks')
AND actor_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')
GROUP BY CONCAT(actor_name, log_type, log_action)
HAVING COUNT(*) > 10
ORDER BY COUNT(*) DESC
SQL

Checking query status...
