DIR : /home/kozerus/public_html/ko_center/sql/sm3_20121129_065844.sql

/home/kozerus/public_html/ko_center/sql

--	select 'defrag_plans_sum', date('now'), planid, loadmode, cabnum,cablim, sum(amps) samps --	from koplans--	where loadmode == ''--	group by planid, cabnum, cablim--	order by planid, cabnum, cablim--	;--	select 'defrag_plans_sumcab', date('now'), planid, loadmode, cabnum,cablim, cab,cab1,cab2, sum(amps) samps --	from koplans--	where loadmode==''--	group by planid, cabnum, cablim, cab, cab1, cab2--	order by planid, cabnum, cablim, cab, cab1, cab2--	;	select 'defrag_plans_sumcab', date('now'), planid, loadmode, cabnum,cablim, cab,cab1,cab2, amps, hostname, sn, hrctag, ip 	from koplans	where loadmode==''--	group by planid, cabnum, cablim, cab, cab1, cab2	order by planid, cabnum, cablim, cab, cab1, cab2, amps, hostname, sn, hrctag, ip	;