Untitled query #74053

SQL

select actor_name as name, COUNT(*) as score
    from logging
    INNER JOIN actor ON actor.actor_id = logging.log_actor
    #where log_timestamp BETWEEN START_WEEK_DATE AND END_WEEK_DATE
    and log_action = "approve"
    and log_namespace = 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("%BOT") COLLATE utf8mb4_general_ci
      and actor_name not like "%بوت%" collate utf8mb4_general_ci
    and actor_name not in (SELECT replace(pl_title,"_"," ")
    and actor_user IS NOT NULL
    FROM pagelinks
    where pagelinks.pl_from = 7352181
    and pl_namespace = 2)
        group by logging.log_actor
        having COUNT(*)>1
        ORDER BY score DESC,name
        LIMIT 10;
SQL

Checking query status...
