Skip to content

Instantly share code, notes, and snippets.

@danbri
Created October 15, 2010 13:21
Show Gist options
  • Save danbri/628169 to your computer and use it in GitHub Desktop.
Save danbri/628169 to your computer and use it in GitHub Desktop.
mysql> select ug_group, ug_user, user_name, user_real_name from user_groups, user where user_id = ug_user;
+------------+---------+--------------------+----------------------------+
| ug_group | ug_user | user_name | user_real_name |
+------------+---------+--------------------+----------------------------+
| bot | 2 | Danbri.org | Dan Brickley |
| bot | 64 | LibbyMiller | Libby Miller |
| bot | 94 | Steevc | |
| bot | 213 | DanBri | Dan Brickley |
| bureaucrat | 1 | WikiSysop | |
| bureaucrat | 2 | Danbri.org | Dan Brickley |
| bureaucrat | 6 | Kidehen | Kingsley Uyi Idehen |
| bureaucrat | 7 | Mortenf | Morten Høybye Frederiksen |
| bureaucrat | 10 | Melvster.com | |
| bureaucrat | 16 | Tommorris | Tom Morris |
| bureaucrat | 20 | Masaka | |
| bureaucrat | 41 | Duck1123 | Daniel E. Renfer |
| bureaucrat | 42 | Alkarex | Alexandre Alapetite |
| bureaucrat | 59 | Sergey Chernyshev | Sergey Chernyshev |
| bureaucrat | 64 | LibbyMiller | Libby Miller |
| bureaucrat | 94 | Steevc | |
| bureaucrat | 213 | DanBri | Dan Brickley |
| bureaucrat | 216 | Ah1 | |
| bureaucrat | 218 | Ah2 | |
| bureaucrat | 223 | Akbarhossain.com | |
| bureaucrat | 225 | Melvincarvalho | |
| bureaucrat | 262 | Michael Hausenblas | Michael Hausenblas |
| coding | 2 | Danbri.org | Dan Brickley |
| sysop | 1 | WikiSysop | |
| sysop | 2 | Danbri.org | Dan Brickley |
| sysop | 64 | LibbyMiller | Libby Miller |
| sysop | 213 | DanBri | Dan Brickley |
+------------+---------+--------------------+----------------------------+
27 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment