Untitled query #47515

SQL

USE arwiki_p
select CONCAT(actor_name), COUNT(*)
    from recentchanges_userindex
    INNER JOIN page ON rc_title = page_title
    INNER JOIN actor_logging ON rc_actor = actor_logging.actor_id
    where rc_timestamp BETWEEN 202008010000000 AND 202008017000000
    and rc_log_action = "approve-i"
    and rc_namespace = 0
    and page_is_redirect = 0
    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
    group by actor_name
    having COUNT(*)>1
    ORDER BY COUNT(*) DESC
    LIMIT 50;
SQL

Checking query status...
