ويكيبيديا:مستخدمو الأسبوع الأكثر نشاطا/بوتات

SQL

SELECT actor_name as name, COUNT(rev.rev_id) as score
FROM revision rev
INNER JOIN actor on rev.rev_actor = actor_id
AND rev.rev_timestamp BETWEEN 20230227000000 AND 20230305235959
AND actor_name  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)
and actor_name not in (
	"New user message",
  	"MediaWiki message delivery",
  	"Flow talk page manager"
)
GROUP BY actor_name
HAVING score > 0
ORDER BY score DESC,name
LIMIT 15;

SQL

Checking query status...