At 13:09 18.09.2002, Andre Engels wrote:
I wanted to see who is the most active contributor at the moment. To do so, I counted (or rather, had the database count) the numbers of edits per registered user.
If possible, could you give us a hint about what query you used? I'm almost SQL-illiterate as you see;-)
So am I, I had not used SQL at all outside Wikipedia; however I used Enchanter's formula for creating Wikipedia:Disambiguation_pages_with_links as my model, and used that I came up with:
SELECT user_name, COUNT(*) as co FROM cur, user WHERE cur_user=user_id GROUP BY user_id ORDER BY co DESC LIMIT 500
plus:
SELECT user_name, COUNT(*) as co FROM old, user WHERE old_user=user_id GROUP BY user_id ORDER BY co DESC LIMIT 500
And then sorted them using Unix commands, and added the numbers by hand. I suppose that someone who knows more about SQL will be able to tell me how I could have done the addition within the sorting.
Andre Engels