DIR : /home/kozerus/public_html/ko_center/sql/jk_20121204_092959.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 item_png, amps, cab, cab1, cab2 from ko_plans where planid=='plan1' 
	group by item, amps, cab, cab1, cab2
        order by item, amps, 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 o
rder
 by cab );

--	update leds set led_color='red', led_sp
eed='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;