[Wiki Loves Monuments] Statistics - list of usernames?

Erik Zachte ezachte at wikimedia.org
Mon Oct 1 21:06:59 UTC 2012

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.






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? :) 






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


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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/mailman/private/wikilovesmonuments/attachments/20121001/3cd38687/attachment.html>

More information about the WikiLovesMonuments mailing list