Erik, does this help you to help us? :) Thanks,
Lodewijk 2012/10/1 Platonides <[email protected]> > 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.org >
_______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
