Untitled query #83411

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(lt_title, "_", " ")
     FROM pagelinks
     inner join linktarget ON lt_id = pl_target_id
     WHERE pagelinks.pl_from = 7352181
       AND lt_namespace = 2)
GROUP BY actor_name
HAVING COUNT(*) > 1
ORDER BY score DESC,
         name
LIMIT 10;
SQL

Checking query status...
