أكثر المستخدمين حسب النقل

SQL

USE arwiki_p;
SET @rank=0;
SELECT CONCAT('{{ويكيبيديا:إحصاءات العام/بطاقة جدول/عنصر|',@rank:=@rank+1,'|') AS "المركز", s.*
FROM (
  SELECT CONCAT("[[مستخدم:",rev_user_text,"|",rev_user_text,"]]|") AS "المستخدم", CONCAT('|',COUNT(rev_user_text),'}}' AS "عدد التعديلات"
FROM revision 
WHERE rev_timestamp BETWEEN 20170101000000 AND 20180101000000 
AND rev_user_text NOT LIKE ucase ("%BOT") COLLATE utf8_general_ci AND rev_user_text NOT LIKE ("%New_user_message")
GROUP BY rev_user_text
ORDER BY COUNT(rev_user_text) DESC
LIMIT 10) s;

SQL

Checking query status...