USE bnwikisource_p;

SELECT

CONCAT("#") AS number, actor_user,

CONCAT("[[user:",actor_name,"|",actor_name,"]]") AS rev_user_text,

COUNT(actor_id) AS recent_user_editcount

/*user_editcount*/

FROM revision

JOIN actor ON rev_actor=actor_id

JOIN page ON rev_page=page_id

WHERE actor_user IS NOT NULL

  AND page_namespace IN ('0','104')

  AND rev_timestamp BETWEEN 20200322000000 AND 20200423235959

GROUP BY actor_id

ORDER BY recent_user_editcount DESC

LIMIT 500;