Untitled query #74299

SQL

USE arywiki_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 page ON rev_page = page_id
INNER JOIN actor on rev_actor = actor_id
WHERE page_namespace = 0
AND rev_parent_id = 0
AND rev_timestamp BETWEEN 20090101000000 AND 20231231235959
AND page.page_is_redirect = 0
GROUP BY actor_name
ORDER BY COUNT(actor_name) DESC
LIMIT 100) s;
SQL

Checking query status...
