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