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

/home/kozerus/public_html/ko_center/sql

-- jk.sql from defrag_fromcabs_sum.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 limit 4;
--	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' )