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

/home/kozerus/public_html/ko_center/sql

-- jk.sql from defrag_fromcabs_sum.sql

	select  distinct(cab1) cab1_png 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;