Results Navigation
Use the controls below to drill down into these results
|
|
Jul
26
2009
|
Mk Triathlon 2009 (1500m swim/40km bike/10km run)
|
| Status | Pos | Overall | Bib | Competitor | Category | Team | Finish | Swim | T1 | Cycle | T2 | Run1 | Run2 | Run3 | Run Total |
|
| 1 | 0 | 425 | Patrick Waldron |
K
|
| 02:13:18 | 00:13:46 | 00:02:36 | 01:14:54 | 00:00:50 | 00:13:51 | 00:13:44 | 00:13:34 | 00:41:09 |
|
| 2 | 59 | 80 | Kevin Chesham |
K
|
| 02:12:08 | 00:20:52 | 00:01:40 | 01:09:02 | 00:01:04 | 00:13:19 | 00:13:19 | 00:12:50 | 00:39:28 |
|
| 3 | 123 | 63 | Nigel Burvill |
K
|
| 02:20:32 | 00:25:14 | 00:01:34 | 01:09:31 | 00:01:22 | 00:14:08 | 00:14:31 | 00:14:09 | 00:42:48 |
|
| 4 | 131 | 195 | Lee Holdaway |
K
|
| 02:21:10 | 00:25:56 | 00:01:22 | 01:11:21 | 00:00:44 | 00:13:50 | 00:13:52 | 00:14:02 | 00:41:44 |
|
| 5 | 158 | 225 | Chris Jordan |
K
|
| 02:22:43 | 00:22:32 | 00:01:02 | 01:11:06 | 00:00:51 | 00:15:26 | 00:15:46 | 00:15:58 | 00:47:10 |
|
| 6 | 230 | 180 | Fred Harbottle |
K
|
| 02:29:46 | 00:24:21 | 00:01:47 | 01:13:09 | 00:01:12 | 00:15:46 | 00:16:35 | 00:16:53 | 00:49:14 |
|
| 7 | 304 | 380 | Len Shapiro |
K
|
| 02:40:49 | 00:22:24 | 00:02:41 | 01:20:48 | 00:01:07 | 00:17:46 | 00:18:08 | 00:17:53 | 00:53:47 |
|
| 8 | 333 | 385 | John Shone |
K
|
| 02:47:25 | 00:27:48 | 00:02:56 | 01:19:06 | 00:01:53 | 00:17:26 | 00:18:48 | 00:19:25 | 00:55:39 |
|
| 9 | 365 | 113 | Jo Dipple |
K
|
| 03:04:15 | 00:27:05 | 00:01:18 | 01:32:03 | 00:01:07 | 00:19:31 | 00:21:03 | 00:22:05 | 01:02:39 |
Rate this information
| Not rated |
| No feedback available for this area |
WITH resultSet AS (SELECT Results.ResultId FROM Results WITH (NOLOCK) WHERE Results.RaceId=599 AND Results.Category = 'K')
, spt9368 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, Splits.Placing AS SplitRank FROM Splits WITH (NOLOCK) INNER JOIN ResultSet WITH (NOLOCK) ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9368 And Splits.Duration Is Not NULL), spt9369 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, Splits.Placing AS SplitRank FROM Splits WITH (NOLOCK) INNER JOIN ResultSet WITH (NOLOCK) ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9369 And Splits.Duration Is Not NULL), spt9370 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, Splits.Placing AS SplitRank FROM Splits WITH (NOLOCK) INNER JOIN ResultSet WITH (NOLOCK) ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9370 And Splits.Duration Is Not NULL), spt9371 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, Splits.Placing AS SplitRank FROM Splits WITH (NOLOCK) INNER JOIN ResultSet WITH (NOLOCK) ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9371 And Splits.Duration Is Not NULL), spt9372 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, Splits.Placing AS SplitRank FROM Splits WITH (NOLOCK) INNER JOIN ResultSet WITH (NOLOCK) ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9372 And Splits.Duration Is Not NULL), spt10436 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, Splits.Placing AS SplitRank FROM Splits WITH (NOLOCK) INNER JOIN ResultSet WITH (NOLOCK) ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=10436 And Splits.Duration Is Not NULL), spt10437 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, Splits.Placing AS SplitRank FROM Splits WITH (NOLOCK) INNER JOIN ResultSet WITH (NOLOCK) ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=10437 And Splits.Duration Is Not NULL), spt10438 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, Splits.Placing AS SplitRank FROM Splits WITH (NOLOCK) INNER JOIN ResultSet WITH (NOLOCK) ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=10438 And Splits.Duration Is Not NULL), spt9373 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, Splits.Placing AS SplitRank FROM Splits WITH (NOLOCK) INNER JOIN ResultSet WITH (NOLOCK) ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9373 And Splits.Duration Is Not NULL)
SELECT
ROW_NUMBER() OVER( ORDER BY CASE WHEN Placing IS NULL THEN 1 ELSE 0 END, Placing ASC
, CASE WHEN Finish IS NULL THEN 1 ELSE 0 END, Finish ASC
) AS RowNumber ,ISNULL(Results.Status,'') AS Status
,ISNULL(Results.Laps,0) AS Laps
,Results.Firstname
,Results.Lastname
,Results.Firstname + ' ' + Results.Lastname AS Competitor
,Results.RaceNumber
,ISNULL(Results.Category, '') AS Category
,ISNULL(Results.Team,'') AS Team
,ISNULL(Results.Club, '') AS Club
,Results.Gender
,Gender.Keyword AS GenderStr
,Results.ResultId
,Results.Placing
,Results.RaceId
,Events.EventManagerId
,ISNULL(Results.Notes,'') AS Notes
,'' AS StaticData, spt9368.Duration AS [Splt_9368]
, spt9369.Duration AS [Splt_9369]
, spt9370.Duration AS [Splt_9370]
, spt9371.Duration AS [Splt_9371]
, spt9372.Duration AS [Splt_9372]
, spt10436.Duration AS [Splt_10436]
, spt10437.Duration AS [Splt_10437]
, spt10438.Duration AS [Splt_10438]
, spt9373.Duration AS [Splt_9373]
FROM Results WITH (NOLOCK) INNER JOIN Races WITH (NOLOCK) ON Races.RaceId=Results.RaceId INNER JOIN resultSet WITH (NOLOCK) ON resultSet.ResultId=Results.ResultId INNER JOIN Events WITH (NOLOCK) ON Events.EventId=Races.EventId
LEFT OUTER JOIN Keywords Gender WITH (NOLOCK) ON Gender.KeywordId=Results.Gender AND Gender.Language='English' AND Gender.GroupName='Gender'
LEFT OUTER JOIN spt9368 WITH (NOLOCK) ON spt9368.ResultId=Results.ResultId
LEFT OUTER JOIN spt9369 WITH (NOLOCK) ON spt9369.ResultId=Results.ResultId
LEFT OUTER JOIN spt9370 WITH (NOLOCK) ON spt9370.ResultId=Results.ResultId
LEFT OUTER JOIN spt9371 WITH (NOLOCK) ON spt9371.ResultId=Results.ResultId
LEFT OUTER JOIN spt9372 WITH (NOLOCK) ON spt9372.ResultId=Results.ResultId
LEFT OUTER JOIN spt10436 WITH (NOLOCK) ON spt10436.ResultId=Results.ResultId
LEFT OUTER JOIN spt10437 WITH (NOLOCK) ON spt10437.ResultId=Results.ResultId
LEFT OUTER JOIN spt10438 WITH (NOLOCK) ON spt10438.ResultId=Results.ResultId
LEFT OUTER JOIN spt9373 WITH (NOLOCK) ON spt9373.ResultId=Results.ResultId
ORDER BY CASE WHEN Placing IS NULL THEN 1 ELSE 0 END, Placing ASC
, CASE WHEN Finish IS NULL THEN 1 ELSE 0 END, Finish ASC
|