This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

AخA
 
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...