| Profile for: |
dx |
|
| Status: |
Full & verified
|
| Joined: |
3 years ago |
| Registered: |
Basic
|
|
| Fitness factor: |
238.4 |
Highest achieved: 328.0
on 23 Sep 2007
|
|
|
| Progress: |
|
|
186.9 of 200
|
|
| 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 |
|
|
|
{{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='dx'
GROUP BY
A.id
ORDER BY
A.date DESC
LIMIT 0,10
" : Got error 28 from storage engine }}
|
