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

/home/kozerus/public_html/ko_center/sql

-- defrag_plans_items_sum

--	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, sum(amps) samps 
--	from koplans
--	where loadmode == ''
--	group by planid, cabnum, cablim
--	order by planid, cabnum, cablim
--	;


	select 'defrag_plans_items_sum', date('now'), planid, 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
	;