Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement