[Wiki Loves Monuments] Statistics - list of usernames?

Platonides platonides at gmail.com
Mon Oct 1 20:49:31 UTC 2012

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.

More information about the WikiLovesMonuments mailing list