Untitled query #85678

SQL

select
  actor_name as name,
  COUNT(*) as score
from
  logging
  INNER JOIN actor ON log_actor = actor.actor_id
where
  log_timestamp BETWEEN 20240210040227 and 20240810040227
#  and ucase(actor_name) not like ucase("%BOT") COLLATE utf8mb4_general_ci
 # and actor_name not like "%بوت%" collate utf8mb4_general_ci
  and actor_name Not IN (SELECT user_name
                         FROM user_groups
                                  INNER JOIN user ON user_id = ug_user
                         WHERE ug_group = "bot")
  and log_action = "approve-i"
  and log_namespace = 0
  and actor_name not in (SELECT replace(pl_title,"_"," ")
FROM pagelinks
where pagelinks.pl_from = 7352181
and pl_namespace = 2)
group by actor_name
having COUNT(*) > 1
ORDER BY score DESC,name
LIMIT 10;
SQL

Checking query status...
