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

SQL

SET @rank=0;
SELECT @rank:=@rank+1 AS "المركز", s.*
FROM (
  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 actor_name  LIKE ucase ("%BOT") COLLATE utf8_general_ci AND actor_name NOT  ("%New_user_message")
AND actor_name LIKE ucase ("%بوت") COLLATE utf8_general_ci
GROUP BY actor_name
ORDER BY COUNT(actor_name) DESC
LIMIT 100) s;

SQL

Checking query status...