mysql> select * from acc where callid LIKE '088827BCD0738B6F@%'; +----+--------+------------------------------+------------------------------+--------------------------------+----------+------------+---------------------+---------------+-----------------+---------------+--------------+------------+--------+-------------+ | id | method | from_tag | to_tag | callid | sip_code | sip_reason | time | src_ip | dst_user | dst_domain | src_user | src_domain | cdr_id | caller_UUID | +----+--------+------------------------------+------------------------------+--------------------------------+----------+------------+---------------------+---------------+-----------------+---------------+--------------+------------+--------+-------------+ | 25 | PRACK | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 | 088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:29:44 | 111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net | 5 | | | 27 | PRACK | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 | 088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:29:45 | 111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net | 5 | | | 29 | INVITE | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 | 088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:29:47 | 111.11.111.11 | 0049xxxxxxxxxxx | 22.222.222.22 | 23yyyyy | 3u.net | 5 | 23yyyyy | | 31 | ACK | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 | 088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:29:47 | 111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net | 5 | 23yyyyy | | 33 | INVITE | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 | 088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:30:48 | 22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net | 7 | | | 35 | ACK | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 | 088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:30:48 | 22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net | 7 | | | 37 | INVITE | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 | 088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:31:15 | 22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net | 7 | | | 39 | ACK | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 | 088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:31:15 | 22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net | 7 | | | 41 | INVITE | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 | 088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:32:25 | 22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net | 7 | | | 43 | ACK | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 | 088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:32:25 | 22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net | 7 | | | 45 | INVITE | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 | 088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:33:28 | 22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net | 7 | | | 47 | ACK | 00E0F510042319395872000014D3 | 6ADBA6B6EDE00789 | 088827BCD0738B6F@111.11.111.11 | 200 | OK | 2011-09-06 01:33:28 | 22.222.222.22 | 23yyyyy | 111.11.111.11 | 064zzzzzzzzz | 3u.net | 7 | | | 49 | INFO | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 | 088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:42:11 | 111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net | 5 | | | 51 | BYE | 6ADBA6B6EDE00789 | 00E0F510042319395872000014D3 | 088827BCD0738B6F@111.11.111.11 | 200 | Ok | 2011-09-06 01:42:36 | 111.11.111.11 | | 22.222.222.22 | 23yyyyy | 3u.net | 5 | | +----+--------+------------------------------+------------------------------+--------------------------------+----------+------------+---------------------+---------------+-----------------+---------------+--------------+------------+--------+-------------+