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

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	20	243	Joshua Lawless	C		02:02:45	00:16:57	00:00:50	01:04:34	00:00:54	00:12:44	00:14:12	00:12:32	00:39:28

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=599 AND Results.Category = 'C') , 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

Results Navigation

Competitor Search

Detail level

Race Search

Contact us about these results

Additional information

Mk Triathlon 2009 (1500m swim/40km bike/10km run)

Rate this information