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

/home/kozerus/public_html/ko_center/sql

-- defrag_plans_items_amps

	select 'defrag_plans_items_amps', date('now'), planid, item, cab, cab2, sum(amps) amps from koplans
	group by planid, cab, cab2, item
	order by planid, amps desc, cab, cab2;