mysql> select * from 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 |
+--------------------------------------+----------------------------------------------------------+--------------------------------------+--------------------------------------+----------------+------------+----------------------+---------------------+--------------------------------------+-------------------+---------------------+--------------------------------------+-------------------+--------+----------+------+-------+--------------+---------------+---------------+
| 309c3031-9c22-4fc8-8e62-00925da0a148 | com.thesearchagency/309c3031-9c22-4fc8-8e62-00925da0a148 | 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      |          |      |       |              |               |               |
| 4be27727-03ac-426b-91cb-c513a0618402 | com.thesearchagency/4be27727-03ac-426b-91cb-c513a0618402 | 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      |          |      |       |              |               |               |
| a5d95cc4-f617-45cf-82ff-c5ff235bf616 | com.thesearchagency/a5d95cc4-f617-45cf-82ff-c5ff235bf616 | 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      |          |      |       |              |               |               |
| c41dc636-c3b1-413e-b7e1-6c7b69c8702d | com.thesearchagency/c41dc636-c3b1-413e-b7e1-6c7b69c8702d | 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      |          |      |       |              |               |               |
+--------------------------------------+----------------------------------------------------------+--------------------------------------+--------------------------------------+----------------+------------+----------------------+---------------------+--------------------------------------+-------------------+---------------------+--------------------------------------+-------------------+--------+----------+------+-------+--------------+---------------+---------------+
4 rows in set (0.06 sec)