ويكيبيديا:إحصاءات العام/2022| تعديلات (بوت)

SQL

USE arwiki_p;
SELECT CONCAT("[[مستخدم:",actor_name,"|",actor_name,"]]") AS "المستخدم", COUNT(actor_name) AS "عدد التعديلات"
FROM revision
INNER JOIN actor on rev_actor = actor_id
WHERE rev_timestamp BETWEEN 20210101000000 AND 20211231235959
and (
 ucase(actor_name) like ucase("%BOT") COLLATE utf8mb4_general_ci
  or actor_name like "%بوت%" collate utf8mb4_general_ci
  or actor_name  IN (SELECT user_name
                         FROM user_groups
                                  INNER JOIN user ON user_id = ug_user
                         WHERE ug_group = "bot")
 
)
and actor_id NOT IN ("2579643")
GROUP BY actor_name
ORDER BY COUNT(actor_name) DESC
LIMIT 50

SQL

Checking query status...