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.