Untitled query #77931

SQL

SELECT actor_name as name, COUNT(*) as score
    FROM revision r
    INNER JOIN actor ON r.rev_actor = actor.actor_id
    INNER JOIN page p on r.rev_page = p.page_id
    WHERE p.page_namespace=0
    and p.page_is_redirect=0
    and r.rev_timestamp between START_WEEK_DATE and END_WEEK_DATE
    and r.rev_parent_id=0
     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 user_name
                         FROM user_groups
                                  INNER JOIN user ON user_id = ug_user
                         WHERE ug_group = "bot")
                         and actor_name not in (SELECT replace(pl_title,"_"," ")
FROM pagelinks
where pagelinks.pl_from = 7352181
and pl_namespace = 2)
    GROUP BY actor_name
    having COUNT(*) > 1
    ORDER BY score DESC,name
    LIMIT 10;
SQL

Checking query status...
