SET @rank=0;

SET @start_date = '20240713000000';

SET @end_date = '20240714000000';

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 @start_date and @end_date

    AND page.page_is_redirect = 0

    GROUP BY actor_name

    ORDER BY COUNT(actor_name) DESC

    LIMIT 50

) s;