Big Cow Duathlon 1 - 2010 20-Feb-10 Results - Big Cow Events - - Triathlon Events - Triathlon - Event Management - Duathlon - Aquathon - Trifest - Cowman - Emberton - The Bowl - Open water swim - open water swimming - competition

Feb 20 2010

Big Cow Duathlon 1 - 2010 (4.4k Run/13.2k Bike/4.2k Run)

Tension at the start line.

Status	Pos	Overall	Bib	Competitor	Category	Club	Finish	Run1	T1	Cycle	T2	Run2
Finished	1	9	211	Scott Wiseman	Senior	TEAM MILTON KEYNES	00:51:02	00:14:55	00:00:22	00:20:24	00:00:26	00:14:52
Finished	2	10	143	Daniel Murphy	Juniors	TEAM MILTON KEYNES	00:51:04	00:14:59	00:01:10	00:19:30	00:00:35	00:14:48
Finished	3	22	88	Jamie Hawthorn	Senior	TEAM MILTON KEYNES	00:54:07	00:16:15	00:00:30	00:21:14	00:00:26	00:15:39
Finished	4	69	144	Frank Murphy	Veteran	TEAM MILTON KEYNES	01:01:23	00:18:29	00:00:56	00:22:29	00:00:44	00:18:42

Rate this information

Not rated

Name	Rating	12345
Email
Comments (optional)

No feedback available for this area

WITH resultSet AS (SELECT Results.ResultId FROM Results WITH (NOLOCK) WHERE Results.RaceId=1035 AND Results.Club = 'TEAM MILTON KEYNES') , spt11060 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=11060 And Splits.Duration Is Not NULL), spt11061 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=11061 And Splits.Duration Is Not NULL), spt11062 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=11062 And Splits.Duration Is Not NULL), spt11063 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=11063 And Splits.Duration Is Not NULL), spt11064 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=11064 And Splits.Duration Is Not NULL), spt11065 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=11065 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, spt11060.Duration AS [Splt_11060] , spt11061.Duration AS [Splt_11061] , spt11062.Duration AS [Splt_11062] , spt11063.Duration AS [Splt_11063] , spt11064.Duration AS [Splt_11064] , spt11065.Duration AS [Splt_11065] 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 spt11060 WITH (NOLOCK) ON spt11060.ResultId=Results.ResultId LEFT OUTER JOIN spt11061 WITH (NOLOCK) ON spt11061.ResultId=Results.ResultId LEFT OUTER JOIN spt11062 WITH (NOLOCK) ON spt11062.ResultId=Results.ResultId LEFT OUTER JOIN spt11063 WITH (NOLOCK) ON spt11063.ResultId=Results.ResultId LEFT OUTER JOIN spt11064 WITH (NOLOCK) ON spt11064.ResultId=Results.ResultId LEFT OUTER JOIN spt11065 WITH (NOLOCK) ON spt11065.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

Results Navigation

Competitor Search

Detail level

Race Search

Contact us about these results

Additional information

Big Cow Duathlon 1 - 2010 (4.4k Run/13.2k Bike/4.2k Run)

Rate this information