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_timestamp BETWEEN START_WEEK_DATE AND END_WEEK_DATE
where log_type in ("block", "protect", "delete", "rights")
and actor_name not in (SELECT replace(pl_title,"_"," ")
                       and actor_name in  ("LokasBot")
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...
