Untitled query #50939

SQL

USE arwiki_p;
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.actor_id
WHERE rev_timestamp BETWEEN 20190101000000 AND 20181231235959
AND actor_name NOT LIKE ucase ("%BOT") COLLATE utf8_general_ci AND actor_name NOT LIKE ("%New_user_message")
GROUP BY actor_name
ORDER BY COUNT(actor_name) DESC
LIMIT 10) s;
SQL

Checking query status...
