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

SQL

USE arwiki_p;
SET @rank=0;
SELECT CONCAT('{{ويكيبيديا:إحصاءات العام/بطاقة جدول/عنصر|',@rank:=@rank+1,'|') AS "المركز", s.*
FROM (
  SELECT CONCAT("[[",rev_user_text,"]]") AS "المقالة", CONCAT('|',COUNT(*),'}}') AS "عدد التعديلات"
FROM revision
JOIN page
ON page_id = rev_page
WHERE rev_timestamp BETWEEN 20170101000000 AND 20180101000000 AND page_namespace=0
GROUP BY page_namespace, page_title
ORDER BY COUNT(*) DESC, page_title ASC
LIMIT 10) s;

SQL

Checking query status...