Untitled query #70379

SQL

select
  actor_name as name,
  COUNT(*) as score
from
  logging
  INNER JOIN actor ON log_actor = actor.actor_id
where
  #and ucase(actor_name) not like ucase("%BOT") COLLATE utf8_general_ci
  #and actor_name not like "%بوت%" collate utf8_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 = "patrol"
  log_action = "approve-i"
  and log_namespace = 0
group by actor_name
having COUNT(*) > 1
ORDER BY score DESC,name
LIMIT 10;
SQL

Checking query status...
