[Wiki Loves Monuments] Statistics - list of usernames?

[Erik Zachte]

Could you please provide user names, like in earlier years?

Then I can plug the new data file into existing code.

 

Wikistats works with user names anyway, and later this month, when all dumps
are in, 

we also want to find user names that did not occur earlier on any wiki.

 

Cheers,

Erik

 

 

From: effeietsanders at gmail.com [mailto:effeietsanders at gmail.com] On Behalf
Of Lodewijk
Sent: Monday, October 01, 2012 11:00 PM
To: Wiki Loves Monuments Photograph Competition
Cc: Erik Zachte
Subject: Re: [Wiki Loves Monuments] Statistics - list of usernames?

 

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/3cd38687/attachment.html>