Erik, does this help you to help us? :)
Thanks,
Lodewijk
2012/10/1 Platonides <platonides(a)gmail.com>
On 01/10/12 19:04, Lodewijk wrote:
Hi all,
Like last year, we would like to run some statistics again. I know we're
only very short after the competition, but could someone create a list
of all usernames that participated in WLM2012? Erik Zachte would like to
run some early stats on that. I realize we need to make corrections and
all, but we can do that later and make the list again. If you could give
the list in a csv/txt I think that would be most convenient.
Thanks a lot!
Lodewijk
time sql commonswiki_p "SELECT distinct wlm_author FROM
u_platonides_wlm_p.wlm2012 WHERE wlm_source = 'commons' and wlm_author
<> 0" > wlmUsers.txt
http://toolserver.org/~platonides/sandbox/wlmUsers.txt
They are user ids, not user names, but that's equivalent for the stats.
Uploads from 123POI, flickr etc. are excluded from that list.
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org