At some point (when stats stop improving as quickly) I want to send some messages to local users for http://laxstrom.name/blag/2015/02/19/prioritizing-mediawikis-translation-strings/ , à la legendary Siebrand's and GerardM's 2007–2009 updates.
I've used a few times something like
```
for dbname in $WIKIS;
do
sql $dbname "select user_name from user JOIN user_groups on user_id = ug_user WHERE ug_group = 'sysop';" | sed 's/user_name//' | sed "s/^/$dbname /g";
done;
```
but it can easily be improved by using the "wiki" table:
```
MariaDB [meta_p]> describe wiki;
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| dbname | varchar(32) | NO | PRI | NULL | |
| lang | varchar(12) | NO | | en | |
| name | text | YES | | NULL | |
| family | text | YES | | NULL | |
| url | text | YES | | NULL | |
| size | decimal(1,0) | NO | | 1 | |
| slice | text | NO | | NULL | |
| is_closed | decimal(1,0) | NO | | 0 | |
| has_echo | decimal(1,0) | NO | | 0 | |
| has_flaggedrevs | decimal(1,0) | NO | | 0 | |
| has_visualeditor | decimal(1,0) | NO | | 0 | |
| has_wikidata | decimal(1,0) | NO | | 0 | |
+------------------+--------------+------+-----+---------+-------+
12 rows in set (0.00 sec)
```