Код: Выделить всё
2013-06-14 11:41:57 LOG_ERR: []
select
sum((sent + 4294967296 * acct_output_gigawords) + (recv + 4294967296 * acct_input_gigawords) ) / 1048576,
sum(sent2 + recv2) / 1048576,
DATE_FORMAT(start, '%Y-%m'),
1
FROM dv_log
WHERE l.uid='640' and tp_id='2' and
( DATE_FORMAT(start, '%Y-%m-%d')>='2013-06-01' - INTERVAL 0 MONTH
)
GROUP BY 4
;
--1054
--Unknown column 'l.uid' in 'where clause'
2013-06-14 11:41:57 LOG_ERR: []
select
0 - sum(acct_input_octets + acct_output_octets) / 1048576,
0 - sum(ex_input_octets + ex_output_octets) / 1048576,
1
FROM dv_calls
WHERE l.uid='640'
GROUP BY 3;
--1054
--Unknown column 'l.uid' in 'where clause'
2013-06-14 11:42:32 LOG_ERR: []
select
sum((sent + 4294967296 * acct_output_gigawords) + (recv + 4294967296 * acct_input_gigawords) ) / 1048576,
sum(sent2 + recv2) / 1048576,
DATE_FORMAT(start, '%Y-%m'),
1
FROM dv_log
WHERE l.uid='640' and tp_id='2' and
( DATE_FORMAT(start, '%Y-%m-%d')>='2013-06-01' - INTERVAL 0 MONTH
)
GROUP BY 4
;
--1054
--Unknown column 'l.uid' in 'where clause'
2013-06-14 11:42:32 LOG_ERR: []
select
0 - sum(acct_input_octets + acct_output_octets) / 1048576,
0 - sum(ex_input_octets + ex_output_octets) / 1048576,
1
FROM dv_calls
WHERE l.uid='640'
GROUP BY 3;
--1054
--Unknown column 'l.uid' in 'where clause'