Untitled query #47633

SQL

USE arwiki_p;
select CONCAT(actor_name), COUNT(*)
from logging_userindex
INNER JOIN actor_logging ON log_actor = actor_logging.actor_id
where log_action = "approve-i"
and log_timestamp BETWEEN 20200817000000 AND 20200824000000
and actor_name Not IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
and ucase (actor_name) not like ucase (_utf8"%BOT") COLLATE utf8_general_ci
and actor_name not like( _utf8"بوت %") collate utf8_general_ci
and log_namespace = 0
and log_title IN (SELECT page_title FROM page WHERE page_title = log_title and page_namespace = 0 and page_is_redirect = 0)
group by actor_name
having COUNT(*) > 1
ORDER BY COUNT(*) DESC
LIMIT 50;
SQL

Checking query status...
