GNR top of hill Point description	to	Brockett Hall (centre of golf course)		1.047  mi
Sector owner: bigfoot

{{Portal::Render::Engine::sqlcall - Bad SQL statement: " SELECT R.id, R.routeName, (SUM(ASP.clockedTime)*(S.unit=1) + SUM(S.distance)*(S.unit=2)) AS totalTime, round((SUM(S.distance)*(S.unit=1) + SUM(ASP.clockedTime)*(S.unit=2))/1609.344,2) AS distance, round((SUM(S.distance)*(S.unit=1) + SUM(ASP.clockedTime)*(S.unit=2)),-1) AS distm, A.id, A.description, date_format(A.date,'%e %b %Y') AS d, date_format(A.date,'%k:%i') AS t, R.routeName AS course, A.weight AS weight, round( (3600000/1609.344)*((sum(S.distance)*(S.unit=1) + sum(ASP.clockedTime)*(S.unit=2)) / (sum(ASP.clockedTime)*(S.unit=1) + sum(S.distance)*(S.unit=2))) ,2) AS speed, round( ( (1+0.3*((3600000*sum(S.distance)/(1609*sum(ASP.clockedTime)))-6)/6)* 0.75 * (sum(S.distance)/1609) * A.weight ) * (S.unit=1)*(A.sport=1 OR A.sport=12) + (15.933*(POW( ( SUM(ASP.clockedTime)*(S.unit=2) + SUM(S.distance)*(S.unit=1)) ,2)/( SUM(S.distance)*(S.unit=2)+SUM(ASP.clockedTime)*(S.unit=1) ) ))*(A.sport=4) + ( 1 + 0.4 * ( ( 3600000 * sum(S.distance) / (1609 * sum(ASP.clockedTime) ) ) - 13 ) / 13 ) * 0.000184 * sum(S.distance) * A.weight * (S.unit=1) * (A.sport=2) + ( 1 + 0.3 * ( ( 3600000 * sum(S.distance) / (1609 * sum(ASP.clockedTime) ) ) - 2.50 ) / 2.50 ) * 0.001625 * sum(S.distance) * A.weight * (S.unit=1) * (A.sport=5) ,0) AS energy, round( ( ( (1+0.3*((3600000*sum(S.distance)/(1609*sum(ASP.clockedTime)))-6)/6) * 0.75 * (sum(S.distance)/1609)*A.weight ) * (S.unit=1) * (A.sport=1 OR A.sport=12) + (15.933*(POW( ( SUM(ASP.clockedTime)*(S.unit=2) + SUM(S.distance)*(S.unit=1)) ,2)/( SUM(S.distance)*(S.unit=2)+SUM(ASP.clockedTime)*(S.unit=1) ) ))*(A.sport=4) + ( 1 + 0.4 * ( ( 3600000 * sum(S.distance) / (1609 * sum(ASP.clockedTime) ) ) - 13 ) / 13 ) * 0.000184*sum(S.distance)*A.weight*(S.unit=1)*(A.sport=2) + ( 1 + 0.3 * ( ( 3600000 * sum(S.distance) / (1609 * sum(ASP.clockedTime) ) ) - 2.50 ) / 2.50 ) * 0.001625 * sum(S.distance) * A.weight * (S.unit=1) * (A.sport=5) ) / ((SUM(ASP.clockedTime)*(S.unit=1) + SUM(S.distance)*(S.unit=2))/3600000) ,0) AS burn , S.unit, A.sport, ASP.sector, UD.username FROM activities AS A, routes AS R, activitySplits AS ASP, sectors AS S, sports AS SP, userData AS UD WHERE A.sport=SP.id AND abs(ASP.sector)=S.id AND ASP.activity=A.id AND abs(A.route)=R.id AND abs(S.id)=2477 AND A.owner=UD.user GROUP BY ASP.id ORDER BY totalTime " : Got error 28 from storage engine }}

Date	Route	Av speed	Weight	Energy use	Energy burn	Performance