MariaDB [srwikinews_p]> SELECT * FROM user_groups WHERE ug_group='autoreview';
+---------+------------+-----------+
| ug_user | ug_group   | ug_expiry |
+---------+------------+-----------+
|       7 | autoreview | NULL      |
|      34 | autoreview | NULL      |
|      84 | autoreview | NULL      |
|     280 | autoreview | NULL      |
|     452 | autoreview | NULL      |
|     628 | autoreview | NULL      |
|     730 | autoreview | NULL      |
|     799 | autoreview | NULL      |
|    2414 | autoreview | NULL      |
|    2497 | autoreview | NULL      |
|    2520 | autoreview | NULL      |
|    2523 | autoreview | NULL      |
|    2524 | autoreview | NULL      |
|    2527 | autoreview | NULL      |
|    2774 | autoreview | NULL      |
|    4151 | autoreview | NULL      |
|    5552 | autoreview | NULL      |
+---------+------------+-----------+
17 rows in set (0.00 sec)

MariaDB [srwikinews_p]>

MariaDB [srwikinews_p]> SELECT * FROM user_groups WHERE ug_group='reviewer';
+---------+----------+-----------+
| ug_user | ug_group | ug_expiry |
+---------+----------+-----------+
|       4 | reviewer | NULL      |
|       6 | reviewer | NULL      |
|      10 | reviewer | NULL      |
|     162 | reviewer | NULL      |
|     232 | reviewer | NULL      |
|     280 | reviewer | NULL      |
|     317 | reviewer | NULL      |
|     452 | reviewer | NULL      |
|     620 | reviewer | NULL      |
|     628 | reviewer | NULL      |
|     732 | reviewer | NULL      |
|    2497 | reviewer | NULL      |
|    5552 | reviewer | NULL      |
+---------+----------+-----------+
13 rows in set (0.01 sec)

MariaDB [srwikinews_p]>

MariaDB [srwikinews_p]> SELECT * FROM user_groups WHERE ug_group='editor';
+---------+----------+-----------+
| ug_user | ug_group | ug_expiry |
+---------+----------+-----------+
|       4 | editor   | NULL      |
|       6 | editor   | NULL      |
|      10 | editor   | NULL      |
|      34 | editor   | NULL      |
|     105 | editor   | NULL      |
|     162 | editor   | NULL      |
|     232 | editor   | NULL      |
|     317 | editor   | NULL      |
|     452 | editor   | NULL      |
|     620 | editor   | NULL      |
|     628 | editor   | NULL      |
|     656 | editor   | NULL      |
|     708 | editor   | NULL      |
|     732 | editor   | NULL      |
|    2414 | editor   | NULL      |
|    4151 | editor   | NULL      |
|    5552 | editor   | NULL      |
+---------+----------+-----------+
17 rows in set (0.00 sec)

MariaDB [srwikinews_p]>