· 7 years ago · Dec 03, 2018, 07:12 PM
1use asterisk
2drop temporary table if exists t_mp3log
3
4create temporary table if not exists t_mp3log (
5 usern varchar(20),
6 url varchar(255),
7 extension varchar(100)
8)(select 'OUTBOUND' AS direction,
9 c.uniqueid,
10 c.type,
11 c.start_time,
12 c.number_dialed,
13 c.length_in_sec
14from call_log c
15where type in ('Local')
16#AND c.number_dialed in ('4073461117')
17);