Untitled query #71106

SQL

/*
select actor.* from user 
inner join actor on user_id = actor_user
where user_name in ("LokasBot");
*/


select actor_name as name, COUNT(*) as score
from logging
INNER JOIN actor on logging.log_actor = actor_id
where log_type in ("block", "protect", "delete", "rights")
and actor_name not in (SELECT replace(pl_title,"_"," ")
FROM pagelinks
where pagelinks.pl_from = 7352181 and actor_id = 3532199
and pl_namespace = 2)
group by logging.log_actor
having COUNT(*)>1
ORDER BY score DESC,name
LIMIT 10;
SQL

Checking query status...
