Big Cow - Cowman 2009 28-Jun-09 Results - Big Cow Events - - Triathlon Events - Triathlon - Event Management - Duathlon - Aquathon - Trifest - Cowman - Emberton - The Bowl - Open water swim - open water swimming - competition

Jun 28 2009

Big Cow - Cowman 2009 (1.9km swim/92km bike/21km run)

Status	Pos	Overall	Bib	Competitor	Category	Team	Finish	Swim	T1	Cycle	T1	Run1	Run2	Run3	Run4	Run
	1	29	90	David Freeman	Vet	PSOF	04:52:40	00:45:13	00:01:48	02:40:50	00:01:35	00:19:35	00:20:15	00:21:09	00:22:15	01:23:14

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=597 AND Results.Team = 'PSOF') , spt9356 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=9356 And Splits.Duration Is Not NULL), spt9357 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=9357 And Splits.Duration Is Not NULL), spt9358 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=9358 And Splits.Duration Is Not NULL), spt9359 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=9359 And Splits.Duration Is Not NULL), spt9360 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=9360 And Splits.Duration Is Not NULL), spt10134 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=10134 And Splits.Duration Is Not NULL), spt10135 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=10135 And Splits.Duration Is Not NULL), spt10136 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=10136 And Splits.Duration Is Not NULL), spt10137 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=10137 And Splits.Duration Is Not NULL), spt9361 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=9361 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, spt9356.Duration AS [Splt_9356] , spt9357.Duration AS [Splt_9357] , spt9358.Duration AS [Splt_9358] , spt9359.Duration AS [Splt_9359] , spt9360.Duration AS [Splt_9360] , spt10134.Duration AS [Splt_10134] , spt10135.Duration AS [Splt_10135] , spt10136.Duration AS [Splt_10136] , spt10137.Duration AS [Splt_10137] , spt9361.Duration AS [Splt_9361] 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 spt9356 WITH (NOLOCK) ON spt9356.ResultId=Results.ResultId LEFT OUTER JOIN spt9357 WITH (NOLOCK) ON spt9357.ResultId=Results.ResultId LEFT OUTER JOIN spt9358 WITH (NOLOCK) ON spt9358.ResultId=Results.ResultId LEFT OUTER JOIN spt9359 WITH (NOLOCK) ON spt9359.ResultId=Results.ResultId LEFT OUTER JOIN spt9360 WITH (NOLOCK) ON spt9360.ResultId=Results.ResultId LEFT OUTER JOIN spt10134 WITH (NOLOCK) ON spt10134.ResultId=Results.ResultId LEFT OUTER JOIN spt10135 WITH (NOLOCK) ON spt10135.ResultId=Results.ResultId LEFT OUTER JOIN spt10136 WITH (NOLOCK) ON spt10136.ResultId=Results.ResultId LEFT OUTER JOIN spt10137 WITH (NOLOCK) ON spt10137.ResultId=Results.ResultId LEFT OUTER JOIN spt9361 WITH (NOLOCK) ON spt9361.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 - Cowman 2009 (1.9km swim/92km bike/21km run)

Rate this information