mysql> SELECT * FROM smb.resellers;
+--------------------------------------+----------------------------------------------------------+--------------------------------------+--------------------------------------+----------------+------------+----------------------+---------------------+--------------------------------------+-------------------+---------------------+--------------------------------------+-------------------+--------+----------+------+-------+--------------+---------------+---------------+
| id                                   | realm_id                                                 | group_id                             | user_id                              | name           | display    | description          | created_on          | created_by                           | created_by_name   | modified_on         | modified_by                          | modified_by_name  | active | comments | url  | phone | contact_name | contact_phone | contact_email |
+--------------------------------------+----------------------------------------------------------+--------------------------------------+--------------------------------------+----------------+------------+----------------------+---------------------+--------------------------------------+-------------------+---------------------+--------------------------------------+-------------------+--------+----------+------+-------+--------------+---------------+---------------+
| 45dc7d68-db27-45cb-95af-f98c906e88d1 | com.thesearchagency/839d3cff-6afd-4cc5-b9ed-37c10128dc2a | 839d3cff-6afd-4cc5-b9ed-37c10128dc2a | a8891656-6d18-4df3-9e6b-8114ab26099c | YB Demo        | YB Demo    |                      | 2013-01-16 15:53:09 | c7542d20-f6ba-4784-842b-9202a92190e2 | TSA Administrator | 2013-01-16 15:53:09 | c7542d20-f6ba-4784-842b-9202a92190e2 | TSA Administrator | T      |          |      |       |              |               |               |
| 7528cabd-62fd-4635-a65e-353f120fb4c7 | com.thesearchagency/1111a81e-1197-4a79-9111-a81e11973a79 | 1111a81e-1197-4a79-9111-a81e11973a79 | 675c1ffb-1109-4e3d-8e59-2b06c6b2ec77 | optusGroup     | Optus      | Optus reseller group | 1970-01-01 01:01:01 | c7542d20-f6ba-4784-842b-9202a92190e2 | TSA Administrator | 1970-01-01 01:01:01 | c7542d20-f6ba-4784-842b-9202a92190e2 | TSA Administrator | T      |          |      |       |              |               |               |
| 8b5166fb-b2c8-4cc5-89be-02f84ccf33d4 | com.thesearchagency/d2dadda1-2db9-485b-9904-890051338269 | d2dadda1-2db9-485b-9904-890051338269 | 6c3ac22b-36ef-4f29-bd56-da0151433044 | Hibu           | Hibu       |                      | 2013-01-24 17:38:32 | c7542d20-f6ba-4784-842b-9202a92190e2 | TSA Administrator | 2013-01-24 17:38:32 | c7542d20-f6ba-4784-842b-9202a92190e2 | TSA Administrator | T      |          |      |       |              |               |               |
| 9119f0dd-0298-46e2-99cb-be7a951378c5 | com.thesearchagency/4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59 | 4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59 | 7b4d76df-59d0-47de-afff-b239971f99a9 | reseller1Group | Reseller 1 | Reseller 1 group     | 1970-01-01 01:01:01 | c7542d20-f6ba-4784-842b-9202a92190e2 | TSA Administrator | 1970-01-01 01:01:01 | c7542d20-f6ba-4784-842b-9202a92190e2 | TSA Administrator | T      |          |      |       |              |               |               |
+--------------------------------------+----------------------------------------------------------+--------------------------------------+--------------------------------------+----------------+------------+----------------------+---------------------+--------------------------------------+-------------------+---------------------+--------------------------------------+-------------------+--------+----------+------+-------+--------------+---------------+---------------+
4 rows in set (0.07 sec)