rendered paste body# SELECT calldate, clid, src, dst, dcontext, channel, dstchannel,lastapp, duration, uniqueid,userfield from tb_cdr order by calldate;
calldate | clid | src | dst | dcontext | channel | dstchannel | lastapp | duration | uniqueid | userfield
---------------------+------+------+------+------------+------------------------------+-------------------+---------+----------+--------------+-----------
2007-05-16 16:49:37 | | | 5050 | extensions | SIP/115-085aa6b0 | SIP/5050-0859d7a0 | Dial | 22 | 1179344977.6 | Entrante
2007-05-16 16:49:53 | 5050 | 5050 | 1111 | extensions | Local/1111@extensions-ffae,2 | SIP/1111-0850dd18 | Dial | 9 | 1179344993.9 | Entrante
2007-05-16 16:49:59 | 5050 | 5050 | s | extensions | Local/1111@extensions-ffae,1 | SIP/115-085aa6b0 | Dial | 3 | 1179344993.8 |
2007-05-16 16:50:42 | | | 1111 | extensions | SIP/5050-08595f40 | SIP/1111-085974c0 | Dial | 21 | 1179345042.0 | Entrante
2007-05-16 16:50:49 | 1111 | 1111 | 115 | extensions | Local/115@extensions-eefc,2 | SIP/115-085bc820 | Dial | 17 | 1179345049.3 | Entrante
2007-05-16 16:51:03 | 1111 | 1111 | s | extensions | Local/115@extensions-eefc,1 | SIP/5050-08595f40 | Dial | 3 | 1179345049.2 |
2007-05-16 16:51:33 | | | 5050 | extensions | SIP/1111-08595f40 | SIP/5050-085974c0 | Dial | 18 | 1179345093.6 | Entrante
2007-05-16 16:51:40 | 5050 | 5050 | 115 | extensions | Local/115@extensions-175d,2 | SIP/115-085b5488 | Dial | 15 | 1179345100.9 | Entrante
2007-05-16 16:51:51 | 5050 | 5050 | s | extensions | Local/115@extensions-175d,1 | SIP/1111-08595f40 | Dial | 4 | 1179345100.8 |