[Wiki Loves Monuments] Statistics - list of usernames?

[Lodewijk]

Erik, does this help you to help us? :)

Thanks,

Lodewijk

2012/10/1 Platonides <platonides at 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 at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
> http://www.wikilovesmonuments.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/mailman/private/wikilovesmonuments/attachments/20121001/ab7f29a6/attachment.html>