SQL
AخA
USE bnwikisource_p;
SELECT
CONCAT AS actor_user,
CONCAT("user:",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 page_namespace = 104
AND actor_user IS NOT NULL
AND rev_timestamp BETWEEN 20190101000000 AND 20201231235959
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.