[Wiki Loves Monuments] Statistics - list of usernames?
platonides at gmail.com
Tue Oct 2 10:00:15 UTC 2012
On 01/10/12 23:06, Erik Zachte wrote:
> 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.
I use userids for tracking who was each user, because they sometimes
provide different "pretty names" (I show the name they provided in the
There go commons usernames:
> time sql commonswiki_p "SELECT DISTINCT user_name FROM u_platonides_wlm_p.wlm2012 JOIN user ON (user_id=wlm_author) WHERE wlm_source = 'commons';" > wlmUsernames.txt
Or if we restrict to valid submissions (182 users less):
> time sql commonswiki_p "SELECT DISTINCT user_name FROM u_platonides_wlm_p.wlm2012 JOIN user ON (user_id=wlm_author) WHERE wlm_source = 'commons' AND wlm_status='Participating';" > wlmParticipatingUsernames.txt
More information about the WikiLovesMonuments