SQL
AخA
use lvwiki_p;
SELECT concat('* [[User:',u.user_name,']]'), COUNT(*) AS num_edits
FROM recentchanges r, user u
WHERE /*rc_namespace = 0 and*/ u.user_id=r.rc_user
GROUP BY 1 ORDER BY 2 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.