INSERT INTO `calls` (`id`, `calldate` , `clid` ,`src` ,`dst` ,`dcontext` ,`channel` , `dstchannel`, `lastapp`, `lastdata`, `duration`, `billsec`, `disposition`, `amaflags`, `accountcode`, `uniqueid` , `userfield`, `src_device_id`, `dst_device_id`, `processed`, `did_price`, `card_id`, `provider_id`, `provider_rate`, `provider_billsec`, `provider_price`, `user_id`, `user_rate`, `user_billsec`, `user_price`, `reseller_id`, `reseller_rate`, `reseller_billsec`, `reseller_price`, `partner_id`, `partner_rate`,`partner_billsec`,`partner_price`, `prefix`, `server_id`, `hangupcause`, `callertype`, `peerip`, `recvip`, `sipfrom`, `uri`, `useragent`, `peername`, `t38passthrough`, `did_inc_price`, `did_prov_price`, `localized_dst`, `did_provider_id`, `did_id`, `originator_ip`, `terminator_ip`, `real_duration`, `real_billsec`, `did_billsec`)VALUES (410 ,'2010-10-21 19:20:32','\"10264\" <10264>','10264','59179395563' ,'' ,'SIP/10264-b7930cc0','' ,'' ,'' ,11 ,0 ,'NO ANSWER' ,0 ,'313' ,'1287685232.106420','' ,2 ,0 ,0 ,0 ,0 ,1 ,0.125064 ,0 ,0 ,2 ,0.1007 ,0 ,0 ,0 ,0 ,0 ,0 ,NULL ,NULL ,NULL ,NULL ,'59179' ,1 ,0 ,'Local' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,0 ,0 ,'59179395563' ,0 ,0 ,'89.128.83.159' ,'173.244.164.18',10.851035 ,0 ,0 ), (411,'2010-10-21 19:20:56','\"10264\" <10264>','10264','59179395563' ,'' ,'SIP/10264-b79260a8','','','',25,4, 'ANSWERED',0,'313','1287685256.106430','' ,2 ,0,0,0,0,1,0.0896,4,0.005973 ,2 ,0.1007,4,0.006713,0,0,0,0,NULL,NULL,NULL,NULL,'59179',1,16,'Local','','','','','','',0,0,0,'59179395563',0,0,'89.128.83.159','173.244.164.18',24.973564,3.552057,4), (412,'2010-10-21 19:38:44','\"10264\" <10264>','10264','212653055503','' ,'SIP/10264-b7900708','','','',47,0, 'NO ANSWER',0,'313','1287686324.106703','' ,2 ,0,0,0,0,1,0.208872,0,0, 2 ,0.2014,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'212653',1,0,'Local','','','','','','',0,0,0,'212653055503',0,0,'89.128.83.159','173.244.164.18',46.163583,0,0), (413,'2010-10-21 19:39:51','\"10264\" <10264>','10264','212651718817','' ,'SIP/10264-b792a1f0','','','',32,0, 'NO ANSWER',0,'313','1287686391.106723','' ,2 ,0,0,0,0,1,0.208872,0,0, 2 ,0.2014,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'212651',1,0,'Local','','','','','','',0,0,0,'212651718817',0,0,'89.128.83.159','173.244.164.18',31.650335,0,0), (414,'2010-10-21 19:41:10','\"10264\" <10264>','10264','212665947124','' ,'SIP/10264-b79a7900','','','',41,8, 'ANSWERED',0,'313','1287686470.106759','' ,2 ,0,0,0,0,1,0.179974,8,0.023997, 2 ,0.20299,8,0.027065,0,0,0,0,NULL,NULL,NULL,NULL,'212665',1,16,'Local','','','','','','',0,0,0,'212665947124',0,0,'89.128.83.159','173.244.164.18',40.33203,7.834998,8), (415,'2010-10-24 12:54:31','\"10264\" <10264>','10264','212678715807','' ,'SIP/10264-b7b68f28','','','',29,1, 'ANSWERED',0,'313','1287921271.127450','' ,2 ,0,0,0,0,1,0.149708,1,0.002495, 2 ,0.2014,1,0.003357,0,0,0,0,NULL,NULL,NULL,NULL,'212678',1,16,'Local','','','','','','',0,0,0,'212678715807',0,0,'83.39.121.175','173.244.164.18',28.964943,0.089153,1), (416,'2010-10-24 12:55:57','\"10264\" <10264>','10264','212678715807','' ,'SIP/10264-b7d0f670','','','',19,0, 'NO ANSWER',0,'313','1287921357.127469','' ,2 ,0,0,0,0,1,0.208872,0,0, 2 ,0.2014,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'212678',1,0,'Local','','','','','','',0,0,0,'212678715807',0,0,'83.39.121.175','173.244.164.18',18.982297,0,0), (417,'2010-10-24 13:02:11','\"10264\" <10264>','10264','212678715807','' ,'SIP/10264-b7bcba00','','','',14,13, 'ANSWERED',0,'313','1287921730.127579','' ,2 ,0,0,0,0,1,0.149708,13,0.032437, 2 ,0.2014,13,0.043637,0,0,0,0,NULL,NULL,NULL,NULL,'212678',1,16,'Local','','','','','','',0,0,0,'212678715807',0,0,'83.39.121.175','173.244.164.18',13.276185,12.102618,1), (418,'2010-10-24 13:02:33','\"10264\" <10264>','10264','212678715807','' ,'SIP/10264-b7dd1c08','','','',32,0, 'NO ANSWER',0,'313','1287921753.127581','' ,2 ,0,0,0,0,1,0.208872,0,0, 2 ,0.2014,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'212678',1,0,'Local','','','','','','',0,0,0,'212678715807',0,0,'83.39.121.175','173.244.164.18',31.60593,0,0), (419,'2010-10-24 20:03:34','\"10264\" <10264>','10264','212642964067','' ,'SIP/10264-09649a98','','','',8,7, 'ANSWERED',0,'313','1287947014.136223','' ,2 ,0,0,0,0,1,0.149708,7,0.017466, 2 ,0.2014,7,0.023497,0,0,0,0,NULL,NULL,NULL,NULL,'212642',1,16,'Local','','','','','','',0,0,0,'212642964067',0,0,'83.39.121.175','173.244.164.18',7.467852,6.156196,7), (420,'2010-10-24 20:04:06','' ,'10264','212642964067','' ,'','','','',0,0, 'FAILED',0,'313','1287947046.136233','' ,2 ,0,0,0,0,0,0,0,0 ,2 ,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'',1,221,'Local','','','','','','',0,0,0,'212642964067',0,0,'83.39.121.175','',0,0,0), (421,'2010-10-24 20:04:18','' ,'10264','212678715807','' ,'','','','',0,0, 'FAILED',0,'313','1287947058.136236','' ,2 ,0,0,0,0,0,0,0,0 ,2 ,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'',1,221,'Local','','','','','','',0,0,0,'212678715807',0,0,'83.39.121.175','',0,0,0), (422,'2010-10-24 20:04:45','' ,'10264','212678715807','' ,'','','','',0,0, 'FAILED',0,'313','1287947085.136245','' ,2 ,0,0,0,0,0,0,0,0 ,2 ,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'',1,221,'Local','','','','','','',0,0,0,'212678715807',0,0,'83.39.121.175','',0,0,0), (423,'2010-10-24 20:03:48','\"10264\" <10264>','10264','212642964067','' ,'SIP/10264-097dc7c8','','','',77,76, 'ANSWERED',0,'313','1287947028.136229','' ,2 ,0,0,0,0,1,0.149708,76,0.18963 ,2 ,0.2014,76,0.255107,0,0,0,0,NULL,NULL,NULL,NULL,'212642',1,16,'Local','','','','','','',0,0,0,'212642964067',0,0,'83.39.121.175','173.244.164.18',76.27015,75.303018,76), (424,'2010-10-24 20:05:25','\"10264\" <10264>','10264','212678715807','' ,'SIP/10264-0978cd90','','','',22,21, 'ANSWERED',0,'313','1287947125.136252','' ,2 ,0,0,0,0,1,0.149708,21,0.052398 ,2 ,0.2014,21,0.07049,0,0,0,0,NULL,NULL,NULL,NULL,'212678',1,16,'Local','','','','','','',0,0,0,'212678715807',0,0,'83.39.121.175','173.244.164.18',21.264258,20.270722,21), (425,'2010-10-26 15:40:56','\"10264\" <10264>','10264','59380063417' ,'' ,'SIP/10264-b79f7db0','','','',50,0, 'NO ANSWER',0,'313','1288104056.149918','' ,2 ,0,0,0,0,1,0.1782,0,0 ,2 ,0.14522,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'59380',1,0,'Local','','','','','','',0,0,0,'59380063417',0,0,'88.2.213.135','173.244.164.18',49.974578,0,0), (426,'2010-10-26 15:41:56','\"10264\" <10264>','10264','59395692108' ,'' ,'SIP/10264-b79c69d8','','','',24,0, 'NO ANSWER',0,'313','1288104116.149927','' ,2 ,0,0,0,0,1,0.16686,0,0 ,2 ,0.138224,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'59395',1,0,'Local','','','','','','',0,0,0,'59395692108',0,0,'88.2.213.135','173.244.164.18',23.485413,0,0), (427,'2010-10-26 15:44:08','\"10264\" <10264>','10264','213558971553','' ,'SIP/10264-b79a1f88','','','',19,0, 'NO ANSWER',0,'313','1288104248.149950','' ,2 ,0,0,0,0,1,0.222,0,0 ,2 ,0.191966,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'21355',1,0,'Local','','','','','','',0,0,0,'213558971553',0,0,'88.2.213.135','173.244.164.18',18.524898,0,0), (428,'2010-10-26 15:55:34','\"10264\" <10264>','10264','59392498376' ,'' ,'SIP/10264-b79420e0','','','',34,0, 'NO ANSWER',0,'313','1288104934.150143','' ,2 ,0,0,0,0,1,0.1782,0,0 ,2 ,0.14522,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'593924',1,0,'Local','','','','','','',0,0,0,'59392498376',0,0,'88.2.213.135','173.244.164.18',33.921532,0,0), (429,'2010-10-26 15:56:52','\"10264\" <10264>','10264','59174340795' ,'' ,'SIP/10264-b7900708','','','',0,0, 'FAILED',0,'313','1288105012.150168F39','' ,2 ,0,0,0,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'59174',1,34,'Local','','','','','','',0,0,0,'59174340795',0,NULL,'88.2.213.135','173.244.164.18',0,0,0), (430,'2010-10-26 15:56:52','\"10264\" <10264>','10264','59174340795' ,'' ,'SIP/10264-b7900708','','','',12,3, 'ANSWERED',0,'313','1288105012.150168','' ,2 ,0,0,0,0,1,0.082,3,0.0041 ,2 ,0.08692,3,0.004346,0,0,0,0,NULL,NULL,NULL,NULL,'59174',1,16,'Local','','','','','','',0,0,0,'59174340795',0,0,'88.2.213.135','109.169.28.148',11.582934,2.216114,3), (431,'2010-10-26 16:32:24','\"10264\" <10264>','10264','59391107120' ,'' ,'SIP/10264-b79b93d0','','','',24,2, 'ANSWERED',0,'313','1288107144.150698','' ,2 ,0,0,0,0,1,0.127714,2,0.004257 ,2 ,0.14522,2,0.004841,0,0,0,0,NULL,NULL,NULL,NULL,'59391',1,16,'Local','','','','','','',0,0,0,'59391107120',0,0,'88.2.213.135','173.244.164.18',23.133603,1.009141,2), (432,'2010-10-26 18:49:08','\"10264\" <10264>','10264','2209837560' ,'' ,'SIP/10264-b79e3bc0','','','',26,0, 'NO ANSWER',0,'313','1288115348.153300','' ,2 ,0,0,0,0,1,0.3402,0,0 ,2 ,0.266484,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'2209',1,0,'Local','','','','','','',0,0,0,'2209837560',0,0,'213.37.1.38','173.244.164.18',25.066015,0,0), (433,'2010-10-26 18:49:39','\"10264\" <10264>','10264','34671695235' ,'' ,'SIP/10264-b79bbdb8','','','',12,3, 'ANSWERED',0,'313','1288115379.153308','' ,2 ,0,0,0,0,1,0.050931,3,0.002547 ,2 ,0.06254,3,0.003127,0,0,0,0,NULL,NULL,NULL,NULL,'34671',1,16,'Local','','','','','','',0,0,0,'34671695235',0,0,'213.37.1.38','173.244.164.18',11.686027,2.973371,3), (434,'2010-10-26 18:49:57','\"10264\" <10264>','10264','2209837560' ,'' ,'SIP/10264-b7924c50','','','',58,0, 'NO ANSWER',0,'313','1288115397.153318','' ,2 ,0,0,0,0,1,0.3402,0,0 ,2 ,0.266484,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'2209',1,0,'Local','','','','','','',0,0,0,'2209837560',0,0,'213.37.1.38','173.244.164.18',57.257469,0,0), (435,'2010-10-26 18:52:18','\"10264\" <10264>','10264','2209837560' ,'' ,'SIP/10264-b79793b0','','','',5,0, 'BUSY',0,'313','1288115538.153367','' ,2 ,0,0,0,0,1,0.2514,0,0 ,2 ,0.266484,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'2209',1,17,'Local','','','','','','',0,0,0,'2209837560',0,0,'213.37.1.38','109.169.28.148',4.372274,0,0), (436,'2010-10-26 18:52:28','\"10264\" <10264>','10264','2209837560' ,'' ,'SIP/10264-b7954a10','','','',4,0, 'BUSY',0,'313','1288115548.153373','' ,2 ,0,0,0,0,1,0.2514,0,0 ,2 ,0.266484,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'2209',1,17,'Local','','','','','','',0,0,0,'2209837560',0,0,'213.37.1.38','109.169.28.148',3.947807,0,0), (437,'2010-10-26 18:52:55','\"10264\" <10264>','10264','2209837560' ,'' ,'SIP/10264-b7937e58','','','',4,0, 'BUSY',0,'313','1288115575.153383','' ,2 ,0,0,0,0,1,0.2514,0,0 ,2 ,0.266484,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'2209',1,17,'Local','','','','','','',0,0,0,'2209837560',0,0,'213.37.1.38','109.169.28.148',3.866728,0,0), (438,'2010-10-26 18:59:08','\"10264\" <10264>','10264','22376463460' ,'' ,'SIP/10264-b7932e98','','','',6,5, 'ANSWERED',0,'313','1288115948.153537','' ,2 ,0,0,0,0,1,0.136538,5,0.011378 ,2 ,0.16006,5,0.013338,0,0,0,0,NULL,NULL,NULL,NULL,'22376',1,16,'Local','','','','','','',0,0,0,'22376463460',0,0,'213.37.1.38','173.244.164.18',5.911623,4.888214,5), (439,'2010-10-26 18:59:19','\"10264\" <10264>','10264','22376463460' ,'' ,'SIP/10264-b79420e0','','','',19,0, 'NO ANSWER',0,'313','1288115959.153541','' ,2 ,0,0,0,0,1,0.190512,0,0 ,2 ,0.16006,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'22376',1,0,'Local','','','','','','',0,0,0,'22376463460',0,0,'213.37.1.38','173.244.164.18',18.331277,0,0), (440,'2010-10-26 18:59:39','\"10264\" <10264>','10264','22376463460' ,'' ,'SIP/10264-b791ccd0','','','',2,0, 'NO ANSWER',0,'313','1288115979.153556','' ,2 ,0,0,0,0,1,0.190512,0,0 ,2 ,0.16006,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'22376',1,0,'Local','','','','','','',0,0,0,'22376463460',0,0,'213.37.1.38','173.244.164.18',1.343373,0,0), (441,'2010-10-26 18:59:42','\"10264\" <10264>','10264','22376463460' ,'' ,'SIP/10264-b791ccd0','','','',8,7, 'ANSWERED',0,'313','1288115982.153558','' ,2 ,0,0,0,0,1,0.136538,7,0.015929 ,2 ,0.16006,7,0.018674,0,0,0,0,NULL,NULL,NULL,NULL,'22376',1,16,'Local','','','','','','',0,0,0,'22376463460',0,0,'213.37.1.38','173.244.164.18',7.666705,6.586998,7), (442,'2010-10-26 19:00:00','\"10264\" <10264>','10264','22376463460' ,'' ,'SIP/10264-b7932e98','','','',2,0, 'NO ANSWER',0,'313','1288116000.153571','' ,2 ,0,0,0,0,1,0.190512,0,0 ,2 ,0.16006,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'22376',1,0,'Local','','','','','','',0,0,0,'22376463460',0,0,'213.37.1.38','173.244.164.18',1.360245,0,0), (443,'2010-10-26 19:00:03','\"10264\" <10264>','10264','22376463460' ,'' ,'SIP/10264-b7985eb8','','','',3,2, 'ANSWERED',0,'313','1288116003.153573','' ,2 ,0,0,0,0,1,0.136538,2,0.004551 ,2 ,0.16006,2,0.005335,0,0,0,0,NULL,NULL,NULL,NULL,'22376',1,16,'Local','','','','','','',0,0,0,'22376463460',0,0,'213.37.1.38','173.244.164.18',2.561596,1.562669,2), (444,'2010-10-26 19:00:10','\"10264\" <10264>','10264','22376463460' ,'' ,'SIP/10264-b79a1f88','','','',3,2, 'ANSWERED',0,'313','1288116010.153577','' ,2 ,0,0,0,0,1,0.136538,2,0.004551 ,2 ,0.16006,2,0.005335,0,0,0,0,NULL,NULL,NULL,NULL,'22376',1,16,'Local','','','','','','',0,0,0,'22376463460',0,0,'213.37.1.38','173.244.164.18',2.786029,1.687803,2), (445,'2010-10-27 18:37:38','\"10264\" <10264>','10264','222377022152','' ,'SIP/10264-b79ce790','','','',5,4, 'ANSWERED',0,'313','1288201058.165940','' ,2 ,0,0,0,0,1,0.133266,4,0.008884 ,2 ,0.17808,4,0.011872,0,0,0,0,NULL,NULL,NULL,NULL,'2223',1,16,'Local','','','','','','',0,0,0,'222377022152',0,0,'88.12.3.166','173.244.164.18',4.148068,3.359067,4), (446,'2010-10-27 18:37:46','\"10264\" <10264>','10264','222377022152','' ,'SIP/10264-b772fce8','','','',10,4, 'ANSWERED',0,'313','1288201066.165944','' ,2 ,0,0,0,0,1,0.133266,4,0.008884 ,2 ,0.17808,4,0.011872,0,0,0,0,NULL,NULL,NULL,NULL,'2223',1,16,'Local','','','','','','',0,0,0,'222377022152',0,0,'88.12.3.166','173.244.164.18',9.76488,3.242036,4), (447,'2010-10-27 18:40:01','\"10264\" <10264>','10264','221339971166','' ,'SIP/10264-b772a7e0','','','',14,3, 'ANSWERED',0,'313','1288201201.165997','' ,2 ,0,0,0,0,1,0.221,3,0.01105 ,2 ,0.23426,3,0.011713,0,0,0,0,NULL,NULL,NULL,NULL,'221339',1,16,'Local','','','','','','',0,0,0,'221339971166',0,0,'88.12.3.166','109.169.28.148',13.84645,2.678201,3), (448,'2010-10-27 18:40:29','\"10264\" <10264>','10264','221777091408','' ,'SIP/10264-b77be160','','','',12,0, 'NO ANSWER',0,'313','1288201229.166009','' ,2 ,0,0,0,0,1,0.221,0,0 ,2 ,0.23426,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'22177',1,0,'Local','','','','','','',0,0,0,'221777091408',0,0,'88.12.3.166','109.169.28.148',11.97611,0,0), (449,'2010-10-27 18:40:40','\"10264\" <10264>','10264','221777091408','' ,'SIP/10264-b7954a10','','','',13,3, 'ANSWERED',0,'313','1288201245.166022','' ,2 ,0,0,0,0,1,0.221,3,0.01105 ,2 ,0.23426,3,0.011713,0,0,0,0,NULL,NULL,NULL,NULL,'22177',1,16,'Local','','','','','','',0,0,0,'221777091408',0,0,'88.12.3.166','109.169.28.148',12.573826,2.237086,3), (450,'2010-10-27 18:41:15','\"10264\" <10264>','10264','221771495988','' ,'SIP/10264-b798a178','','','',20,3, 'ANSWERED',0,'313','1288201275.166051','' ,2 ,0,0,0,0,1,0.221,3,0.01105 ,2 ,0.23426,3,0.011713,0,0,0,0,NULL,NULL,NULL,NULL,'22177',1,16,'Local','','','','','','',0,0,0,'221771495988',0,0,'88.12.3.166','109.169.28.148',19.23284,2.326423,3), (451,'2010-10-27 18:48:20','\"10264\" <10264>','10264','34671695235' ,'' ,'SIP/10264-b79e65a8','','','',8,0, 'BUSY',0,'313','1288201700.166257','' ,2 ,0,0,0,0,1,0.059,0,0 ,2 ,0.06254,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'34671',1,17,'Local','','','','','','',0,0,0,'34671695235',0,0,'88.12.3.166','109.169.28.148',7.598634,0,0), (452,'2010-10-27 18:49:05','\"10264\" <10264>','10264','2206410129' ,'' ,'SIP/10264-b79c1130','','','',23,0, 'NO ANSWER',0,'313','1288201745.166285','' ,2 ,0,0,0,0,1,0.343764,0,0 ,2 ,0.266484,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'2206',1,0,'Local','','','','','','',0,0,0,'2206410129',0,0,'88.12.3.166','173.244.164.18',22.227252,0,0); update `calls` set user_id = 4 where uniqueid = '1288105012.150168F39'; update `calls` set src_device_id = 9 where user_id = 4;