Last modified: 2014-01-03 15:51:13 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-96. Summary: Request for user information Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: EdoDodo <dodo.wikipedia@gmail.com> ------------------------------------------------------------------------------- From: Riccardo Tasso <riccardo.tasso@gmail.com> Date: Wed, 21 Jul 2010 16:19:13 ------------------------------------------------------------------------------- For research purpose, they should all be public data: (on english wikipedia) SELECT user_name, user_editcount, ug_group FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY ' ' LINES TERMINATED BY '\n' FROM user LEFT JOIN user_groups ON ug_user = user_id ORDER BY user_name
------------------------------------------------------------------------------- From: EdoDodo <dodo.wikipedia@gmail.com> Date: Thu, 22 Jul 2010 10:45:35 ------------------------------------------------------------------------------- The query the user posted didn't seem to work as desired, so after some discussion on IRC we put together a query that works. I am running it now and will upload the result soon.
------------------------------------------------------------------------------- From: EdoDodo <dodo.wikipedia@gmail.com> Date: Thu, 22 Jul 2010 14:50:41 ------------------------------------------------------------------------------- I ran this query: SELECT user_name, user_editcount, user_registration, ug_group FROM user LEFT JOIN user_groups ON ug_user = user_id The resulting data was exported to a CSV file, as requested. The file is extremely large (nearly 500MB uncompressed, and 120MB compressed), so I cannot upload it to JIRA. Instead, the file can be downloaded here: http://toolserver.org/~dodo/usersreport.csv (Plain text) http://toolserver.org/~dodo/usersreport.csv.bz2 (Compressed) Once you've downloaded it and if it is as needed, please leave a comment here so that I can remove the file. Thanks, Dodo
------------------------------------------------------------------------------- From: Riccardo Tasso <riccardo.tasso@gmail.com> Date: Thu, 22 Jul 2010 15:41:50 ------------------------------------------------------------------------------- File downloaded, you can delete them. Thank you again. Riccardo
------------------------------------------------------------------------------- From: EdoDodo <dodo.wikipedia@gmail.com> Date: Thu, 22 Jul 2010 16:16:06 ------------------------------------------------------------------------------- You're welcome.
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: dodo.wikipedia@gmail.com CC list: dodo.wikipedia@gmail.com