SELECT
	ROUND(TIME_TO_SEC(TIMEDIFF((SELECT
			c.time + INTERVAL c.duration SECOND
		FROM customerdata.cdr_daba c
		WHERE c.type = 'N'
		AND c.time + INTERVAL c.duration SECOND BETWEEN (r.time + INTERVAL s.conversationduration - 100 SECOND) AND (r.time + INTERVAL s.conversationduration + 100 SECOND)
		AND c.date = '2014-03-08'
		AND c.anum = r.originatingAddr
		ORDER BY time
		LIMIT 1), r.time + INTERVAL s.conversationduration SECOND)) / 10) * 10 AS value
FROM	tfsurvey.sessions s
			INNER JOIN tfsurvey.entrypoints ep
				ON s.entrypointid = ep.id,
		tfsurvey.routeinfo r,
		tfsurvey.hangupcodes hc
WHERE s.hangupcode = hc.code
AND hc.pairable = 1
AND r.sessionid = s.id
AND r.event = 3
AND r.ingoing = 0
AND s.date = '2014-03-08'
AND s.serverId = 32
AND ep.serverId = 32
AND ep.pairToDefaultOUnit = 0
AND s.anum > 0
AND s.surveyid <> 795
AND s.surveyid <> 796
GROUP BY value
HAVING value IS NOT NULL
ORDER BY COUNT(*) DESC
LIMIT 1;

CREATE TABLE `cdr_daba` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(4) NOT NULL default '',
  `number` int(10) unsigned NOT NULL default '0',
  `customer` int(10) unsigned NOT NULL default '0',
  `origin` varchar(16) NOT NULL default '',
  `termination` varchar(16) NOT NULL default '',
  `auxid` varchar(45) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `duration` int(10) unsigned NOT NULL default '0' COMMENT 'in seconds',
  `digits` varchar(45) NOT NULL default '',
  `anum` bigint(20) unsigned NOT NULL default '0',
  `origindata1` varchar(16) NOT NULL default '0',
  `origindata2` varchar(16) NOT NULL default '0',
  `terminationdata1` varchar(16) NOT NULL default '0',
  `terminationdata2` varchar(16) NOT NULL default '0',
  `siteid` int(10) unsigned NOT NULL,
  `next` int(10) unsigned NOT NULL default '0',
  `sessionid` int(10) unsigned NOT NULL default '0',
  `date` date NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `cdr_daba_anum_etc_key` (`anum`,`origindata1`,`origindata2`,`time`),
  KEY `cdr_daba_terminationdata1_key` (`terminationdata1`),
  KEY `cdr_daba_date_anum_type_key` (`date`,`anum`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=4687503 DEFAULT CHARSET=utf8