Untitled query #76391

SQL

select actor_name as name, COUNT(*) as score
from logging
INNER JOIN actor on logging.log_actor = actor_id
where log_timestamp BETWEEN 20230828000000 AND 20230903235959
and log_type in ("block", "protect", "delete", "rights")
and actor_name IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'sysop')
and actor_name not in (SELECT replace(pl_title,"_"," ")
FROM pagelinks
where pagelinks.pl_from = 7352181
and pl_namespace = 2)
group by logging.log_actor
having COUNT(*)>1
ORDER BY score DESC,name
LIMIT 10;
SQL

Checking query status...
