Profile for:	trevorx
Status:	Full & verified
Joined:	3 years ago
Registered:	Basic
Fitness factor:	200.0
Progress:
	0.0 of 2
Progress rating:	0 - 2 Just started 2 - 5 Trainer 5 - 10 Performer 10 - 25 Qualifier 25 - 50 Bronze medallist 50 - 100 Silver medallist 100 - 200 Gold medallist 200 - 500 Undisputed champion 500 + All-time legend

Dorchester Spur	6.43
By dx [22 Dec 2006] favourited 3 years ago

trevorx has added no routes yet

{{Portal::Render::Engine::sqlcall - Bad SQL statement: " SELECT (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, getTimeAgo(A.date), date_format(A.date,'%e %b %Y') AS d, date_format(A.date,'%k:%i') AS t, R.id AS routeId, 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, S.unit, A.sport, UD.username FROM activitySplits AS ASP, routes AS R, sectors AS S, activities AS A LEFT JOIN userData AS UD ON A.owner=UD.user WHERE abs(ASP.sector)=S.id AND ASP.activity=A.id AND abs(A.route)=R.id AND UD.username='trevorx' GROUP BY A.id ORDER BY A.date DESC LIMIT 0,10 " : Got error 28 from storage engine }}