This query request is old. If you no longer require this query to be run, please close this bug as WONTFIX. Thanks!

This is still relevant. It would be easy to do, if only I knew how to list all dbnames with a query: a bash loop similar to

for dbname in $WIKIS;
do

sql $dbname "select user_name from user JOIN user_groups on user_id = ug_user WHERE ug_group = 'sysop';"

done;

etc.

I'm interested to work on this. If you can provide a format (like "{| ! Username wiki edits !! rights |- | $username || $wiki || $edits || rights", please excuse me if that format isn't correct, but I don't really understand the one you provided), I'll try to generate a list.

(In reply to Southparkfan from comment #3)

I'm interested to work on this.

Thanks!

If you can provide a format (like "{| !
Username wiki edits !! rights |- | $username || $wiki || $edits ||
rights", please excuse me if that format isn't correct, but I don't really
understand the one you provided), I'll try to generate a list.

Any format is fine, a table as in your example is perfect.

Stats for all Wikipedias + Wiktionaries + Wikisources + Wikiquotes and Wikinews are done, see http://tools.wmflabs.org/southparkfan/w/index.php?title=Bug_59498 - I'll do the others soon.

@Nemo: all wikis done at http://tools.wmflabs.org/southparkfan/w/index.php?title=Bug_59498. Please let me know if you need something extra, or close this bug as fixed.

(In reply to Southparkfan from comment #6)

@Nemo: all wikis done at
http://tools.wmflabs.org/southparkfan/w/index.php?title=Bug_59498. Please
let me know if you need something extra, or close this bug as fixed.

Thank you! There is something wrong in your counts, I'm pretty sure "MediaWiki message delivery" doesn't edit ns8; you probably counted ns9 too.

If possible, it would be really helpful to have the wiki name repeated in each row, as you had proposed in comment 3. Otherwise I'll have to add it myself.

(In reply to Nemo from comment #7)

(In reply to Southparkfan from comment #6)

@Nemo: all wikis done at
http://tools.wmflabs.org/southparkfan/w/index.php?title=Bug_59498. Please
let me know if you need something extra, or close this bug as fixed.

Thank you! There is something wrong in your counts, I'm pretty sure
"MediaWiki message delivery" doesn't edit ns8; you probably counted ns9 too.

It counted User(_talk):*.(css|js), so both ns8 and ns9.. fixing this.

If possible, it would be really helpful to have the wiki name repeated in
each row, as you had proposed in comment 3. Otherwise I'll have to add it
myself.

Doing.

(In reply to Southparkfan from comment #8)

It counted User(_talk):*.(css|js), so both ns8 and ns9.. fixing this.

Not really any of my business, but just pointing out that ns8 is MediaWiki:. User/User talk are ns2/ns3.