-- prijate hovory delsi nez 5s
SELECT `calldate`,`src`,`dst`,`duration`,`uniqueid`,`note` FROM `cdr` WHERE `dst` IN (310,312,314) AND `duration` >= 5 AND `disposition` = 'ANSWERED' ORDER BY `calldate` DESC;

-- neprijate hovory v pracovni dobe
SELECT `calldate`,`src`,`dst`,`duration`,`uniqueid`,`note` FROM `cdr` WHERE `dst` = 's' AND `dcontext` = 'app-announcement-3' ORDER BY `calldate` DESC;

-- odchozi hovory
SELECT `calldate`,`src`,`dst`,`duration`,`uniqueid`,`note` FROM `cdr` WHERE `src` IN (310,312,314) AND `duration` >= 5 AND `disposition` = 'ANSWERED' ORDER BY `calldate` DESC;