gistfile1.txt

mysql> select id,name,state from agent where id in (137,138,139)
    -> ;
+-----+------+--------------+
| id  | name | state        |
+-----+------+--------------+
| 137 | NULL | reconnecting |
| 138 | NULL | reconnecting |
| 139 | NULL | reconnecting |
+-----+------+--------------+
3 rows in set (0.01 sec)

mysql> select id,name,state,removed from agent where id in (137,138,139);
+-----+------+--------------+---------+
| id  | name | state        | removed |
+-----+------+--------------+---------+
| 137 | NULL | reconnecting | NULL    |
| 138 | NULL | reconnecting | NULL    |
| 139 | NULL | reconnecting | NULL    |
+-----+------+--------------+---------+
3 rows in set (0.00 sec)

mysql> select id,name,state,removed,uri from agent where id in (137,138,139);
+-----+------+--------------+---------+----------------------------------------------+
| id  | name | state        | removed | uri                                          |
+-----+------+--------------+---------+----------------------------------------------+
| 137 | NULL | reconnecting | NULL    | event://98520099-31e0-4aca-850a-601bae5f6eb8 |
| 138 | NULL | reconnecting | NULL    | event://5d5035c6-f115-46a6-ac58-e90b33821ad1 |
| 139 | NULL | reconnecting | NULL    | event://756c42cf-5277-440e-8117-1ad94a82253e |
+-----+------+--------------+---------+----------------------------------------------+
3 rows in set (0.00 sec)

mysql> select id, name, state, kind from instance where agent_id in (137,138,139);
Empty set (0.00 sec)

mysql> select id, name, state, kind from host where agent_id in (137,138,139);
Empty set (0.01 sec)

mysql>