Untitled query #40190

SQL

use arwiki_p;
select CONCAT(actor_name), COUNT(*)
        from logging
        INNER JOIN actor ON logging.log_actor = actor.actor_id
        LEFT JOIN page ON log_title = page_title
        where log_action = "approve-i"
        and log_namespace = 0
        and page_is_redirect = 0
        and actor_name Not IN (SELECT actor_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 actor_name not like _utf8"بوت %" collate utf8_general_ci
        group by actor_name
        having COUNT(*)>1
        ORDER BY COUNT(*) DESC
        LIMIT 100;
SQL

Checking query status...
