USE tawikisource_p;

SELECT

CONCAT("# [[Special:Contributions/",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', '106')

  AND rev_timestamp BETWEEN 20240801000000 AND 20241231235959

GROUP BY actor_id

ORDER BY recent_user_editcount DESC

LIMIT 100;