bsmoo

mysql> SELECT user_login,user_registered,meta_value FROM wp_users INNER JOIN wp_usermeta ON wp_users.id = wp_usermeta.user_id and meta_key = 'wp_capabilities';

+---------------+---------------------+---------------------------------+
| user_login    | user_registered     | meta_value                      |
+---------------+---------------------+---------------------------------+
| administrator | 2013-12-21 10:36:30 | a:1:{s:13:"administrator";b:1;} |
| author        | 2014-11-25 15:50:34 | a:1:{s:6:"author";b:1;}         |
| editor        | 2014-11-25 15:51:18 | a:1:{s:6:"editor";b:1;}         |
| contributor   | 2014-11-25 15:51:48 | a:1:{s:11:"contributor";b:1;}   |
| subscriber    | 2014-11-25 15:52:11 | a:1:{s:10:"subscriber";b:1;}    |