SQL
x
USE plwiki_p;
SELECT
CONCAT("#") AS number, actor_user, CONCAT("[[user:",actor_name,"|",actor_name,"]]") AS actor_name,
SUM(CASE WHEN revactor_timestamp BETWEEN 20190701000000 AND 20191231235959 THEN 1 ELSE 0 END) AS recent_user_editcount,
user_editcount
FROM user, page, actor, revision_actor_temp
WHERE revactor_actor=actor_id
AND actor_user=user_id
AND page_namespace = 0
GROUP BY actor_user
ORDER BY recent_user_editcount DESC
LIMIT 500;
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.