SELECT

    CONCAT("# [[Special:Contributions/", actor_name, "]]") AS rev_user_text,

    COUNT(r.rev_actor) AS recent_user_editcount,

    (SELECT COUNT(*) FROM revision r2 WHERE r2.rev_actor = actor_id) AS total_user_editcount

FROM actor

LEFT JOIN revision r ON r.rev_actor = actor_id

LEFT JOIN page ON r.rev_page = page_id

WHERE actor_user IS NOT NULL

  AND page_namespace IN ('0', '104', '106', '250', '252', '102', '828')

  AND (r.rev_timestamp BETWEEN 20240101000000 AND 20251231235959 OR r.rev_timestamp IS NULL)

GROUP BY actor_id

ORDER BY recent_user_editcount DESC

LIMIT 10;

​