MariaDB [centralauth_p]> SELECT gu_id, gu_name FROM globaluser JOIN global_user_groups ON gu_id=gug_user WHERE gug_group = 'steward';
+----------+-----------------+
| gu_id | gu_name |
+----------+-----------------+
| 217 | DerHexer |
| 293 | Masti |
| 327 | Melos |
| 344 | Vituzzu |
| 1091 | Wim b |
| 7061 | Linedwell |
| 25549 | Ruslik0 |
| 133478 | Cromium |
| 200064 | Schniggendiller |
| 754815 | MarcGarver |
| 1127005 | RadiX |
| 1284147 | Bsadowski1 |
| 1330592 | Operator873 |
| 1577168 | Sotiale |
| 2769878 | Tegel |
| 3003335 | Trijnstel |
| 3173603 | Hoo man |
| 5422243 | Teles |
| 7108377 | AmandaNP |
| 7270407 | -revi |
| 8015849 | علاء |
| 8083616 | Stryn |
| 9429345 | Matanya |
| 10180704 | Base |
| 10528483 | Wiki13 |
| 10584730 | MusikAnimal |
| 11117413 | MarcoAurelio |
| 11390199 | Defender |
| 32086292 | Stanglavine |
| 33521456 | Tks4Fish |
| 34722510 | Martin Urbanec |
| 38085868 | Sakretsu |
| 40996903 | HakanIST |
| 48513248 | Jon Kolbert |
+----------+-----------------+
34 rows in set (0.01 sec)
MariaDB [centralauth_p]> SELECT * FROM global_user_groups WHERE gug_group = 'steward';
+----------+-----------+------------+
| gug_user | gug_group | gug_expiry |
+----------+-----------+------------+
| 99 | steward | NULL |
| 217 | steward | NULL |
| 293 | steward | NULL |
| 327 | steward | NULL |
| 344 | steward | NULL |
| 456 | steward | NULL |
| 1091 | steward | NULL |
| 7061 | steward | NULL |
| 25549 | steward | NULL |
| 133478 | steward | NULL |
| 200064 | steward | NULL |
| 754815 | steward | NULL |
| 1127005 | steward | NULL |
| 1284147 | steward | NULL |
| 1330592 | steward | NULL |
| 1498691 | steward | NULL |
| 1577168 | steward | NULL |
| 2769878 | steward | NULL |
| 3003335 | steward | NULL |
| 3173603 | steward | NULL |
| 5422243 | steward | NULL |
| 7108377 | steward | NULL |
| 7270407 | steward | NULL |
| 8015849 | steward | NULL |
| 8083616 | steward | NULL |
| 9429345 | steward | NULL |
| 10180704 | steward | NULL |
| 10528483 | steward | NULL |
| 10584730 | steward | NULL |
| 11117413 | steward | NULL |
| 11390199 | steward | NULL |
| 32086292 | steward | NULL |
| 33521456 | steward | NULL |
| 34722510 | steward | NULL |
| 38085868 | steward | NULL |
| 40996903 | steward | NULL |
| 48513248 | steward | NULL |
+----------+-----------+------------+
37 rows in set (0.00 sec)
MariaDB [centralauth_p]> SELECT * FROM globaluser WHERE gu_id = '99';
Empty set (0.00 sec)
MariaDB [centralauth_p]> SELECT * FROM globaluser WHERE gu_id = '456';
Empty set (0.00 sec)
MariaDB [centralauth_p]> SELECT * FROM globaluser WHERE gu_id = '1498691';
Empty set (0.00 sec)
MariaDB [centralauth_p]> SELECT DISTINCT gug_group from global_user_groups;
+-------------------------+
| gug_group |
+-------------------------+
| Cabal |
| abusefilter-helper |
| abusefilter-maintainer |
| apihighlimits-requestor |
| captcha-exempt |
| founder |
| global-bot |
| global-deleter |
| global-flow-create |
| global-interface-editor |
| global-ipblock-exempt |
| global-rollbacker |
| global-sysop |
| new-wikis-importer |
| oathauth-tester |
| ombuds |
| staff |
| steward |
| sysadmin |
| vrt-permissions |
| wmf-ops-monitoring |
| wmf-researcher |
+-------------------------+
22 rows in set (0.01 sec)
Note: 'Cabal' was deleted ages ago (joke global group), and is still listed. And:
MariaDB [centralauth_p]> select * from global_user_groups WHERE gug_group = 'Cabal';
+----------+-----------+------------+
| gug_user | gug_group | gug_expiry |
+----------+-----------+------------+
| 99 | Cabal | NULL |
+----------+-----------+------------+
1 row in set (0.00 sec)