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

SQL

USE arwiki_p;
SET @rank=0;
SELECT CONCAT('{{ويكيبيديا:إحصاءات العام/بطاقة جدول/عنصر|',@rank:=@rank+1,'|') AS "المركز", s.*
FROM (
select CONCAT('[[مستخدم:',user_name,'|',user_name,']]'), CONCAT("|",COUNT(*),"}}")
from logging
inner join user
on user.user_id = logging.log_user
where log_timestamp BETWEEN 20170101000000 AND 20180101000000
and log_action IN ("move"/*, "block", "protect", "rights"*/) 
AND user_name NOT LIKE ucase ("%BOT") COLLATE utf8_general_ci AND user_name NOT LIKE ("%New_user_message") AND user_name NOT LIKE ("%Flow_talk_page_manager")
group by logging.log_user
having COUNT(*)>1
ORDER BY COUNT(*) DESC
LIMIT 10) s;

SQL

Checking query status...