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

/home/kozerus/public_html/ko_center/sql

--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip --	from kohw--	where cab in ( select cab from koplans where planid == 'plan1' )--	order by cab, amps desc;	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 	group by planid, cab	order by planid, cab;--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip --	from kohw--	where cab in ( select distinct( cab ) from koplans )--	order by cab, amps desc;--	where cab in ( select cab from koplans where planid == 'plan1' )