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

/home/kozerus/public_html/ko_center/sql

-- jk.sql from defrag_fromcabs_sum.sql







--	select cab,cab1,cab2,count(*) cnt, sum(amps) samps, max(amps) mamps, group_concat(item,' ') items 

--	select cab cab_png,cab1,cab2,count(*) cnt, sum(amps) samps, max(amps) mamps, group_concat(sn,' ') sns

select item, amps, cab, cab1, cab2 from ko_plans where planid=='plan1' 
	order by cab,cab1,cab2
--	limit 6
	;


--	select  distinct(cab1) cab1_png, amps from koplans where planid == 'plan1' and loadmode=='';

--	select  distinct(cab1) cab1_png_big, amps from koplans where planid == 'plan1' and loadmode=='';

--	select  distinct(cab2) cab2_png_small, amps from koplans where planid == 'plan1' and loadmode=='';

--	select  distinct(cab2) cab2_png_tiny, amps from koplans where planid == 'plan1' and loadmode=='';





--	update leds set led_color='blu', led_speed='50' where led_code in
	( select cab1 from koplans where planid == 'plan1' and loadmode=='' group by cab order by cab );

--	update leds set led_color='red', led_speed='50' where led_code in
	( select cab2 from koplans where planid == 
'plan1' and loadmode=='' group by cab order by cab );



--  select cab from koplans where planid =='plan1' and loadmode=='' group by cab  order by cab;