-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Guess Who? wrote: > --- On Wed, 10/29/08, Brion Vibber wrote: >> Figuring out how to get something other than a raw list of >> thousands of >> editors for a "nice" author list remains a harder >> task. :) > > wouldn't that be a snap using the group_by function? sorry, I don't > know the database structure, but generically: > > SELECT contributors, COUNT(*) FROM database GROUP BY contributors > > would return a list of all contributors and the number of > contributions they've made; it could be tweaked to return only those > contributors who've made over X contributions. of course, I've only > worked on small databases, so I have no idea what the overhead on > this would be...
Making a lot of edits to the page doesn't necessarily mean you've contributed a lot of text to it. It might mean you've vandalized it a lot (always reverted) or that you've reverted a lot of vandalism. - -- brion -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkkLQMsACgkQwRnhpk1wk472twCfVfr4chZnBPS/MBP31H7zI+p7 r/kAoKd40ULM0rBBMPF8ZwxqyHNO//hK =NdkQ -----END PGP SIGNATURE----- _______________________________________________ Mediawiki-api mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
