<mode>image</mode>
title=>Route Usage 
legend=>Route Usage 
xlabel=>Route Index
ylabel=>Total Active Duration (in Hours) during Specified Time Range 
rmode=>bar-st
data=>1,2
map=>routehops

<mode>ascii</mode>
col_names=>Route ID,Active Duration
col_numbers=>1,2
map=>routehops

<mode>query</mode>
WITH 
NodePair(id) as 
( 
SELECT np.id as id 
FROM {schema_name}nodepairs np 
WHERE np.srcnodeid = {srcid} AND np.destnodeid = {destid}  
) 
SELECT 	ri.routeid as "Route ID",
 	sum( (ri.endtime-ri.starttime)/3600 ) as "Active Duration"  
FROM {schema_name}routes r, {schema_name}route_intervals ri, NodePair n 
WHERE 	r.routeid=ri.routeid AND ri.starttime >= {start_time} AND 
	ri.starttime <= {end_time} AND r.nodepairid=n.id
GROUP BY ri.routeid  
ORDER BY ri.routeid
<mode>endquery</mode> 

