Untitled query #77931

SQL

SELECTSELECT 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 20230901000000 and 20231201000000
    and r.rev_parent_id=0
     and ucase(actor_name) not like ucase("%BOT")
  and actor_name not like "%بوت%"
  and actor_name Not IN (SELECT user_name
                         FROM user_groups
                                  INNER JOIN user ON user_id = ug_user
                         WHERE ug_group = "bot")
                         
    GROUP BY actor_name
    having COUNT(*) > 1
    ORDER BY score DESC,name
    LIMIT 10;
SQL

Checking query status...
