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

WHERE actor_user NOT REGEXP "(B|b)(O|o)(T|t)"

  AND page_namespace IN ('0','10', '100', '2', '828', '14')

  AND rev_timestamp BETWEEN 20240101000000 AND 20241231000000

GROUP BY actor_id

ORDER BY recent_user_editcount DESC

LIMIT 100;