SQL
AخA
USE orwikisource_p;
SELECT
CONCAT("# {{target | user =",actor_name,"| site = or.wikisource.org }}") 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,250)
AND rev_timestamp BETWEEN 20180101000000 AND 20210630235959
GROUP BY actor_id
ORDER BY recent_user_editcount DESC
LIMIT 200;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.