Untitled query #47515

SQL

USE arwiki_p;
select CONCAT(actor_name), COUNT(*)
    from recentchanges_userindex
    INNER JOIN actor_recentchanges ON rc_actor = actor_id
    INNER JOIN page ON rc_title = page_title
    where rc_timestamp BETWEEN 202008010000000 AND 202008017000000

    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 5;
SQL

Checking query status...
