Results Navigation
Use the controls below to drill down into these results
|
|
Jun
28
2009
|
Big Cow - Cowman 2009 (1.9km swim/92km bike/21km run)
|
Rate this information
| Not rated |
| No feedback available for this area |
WITH resultSet AS (SELECT Results.ResultId FROM Results WITH (NOLOCK) WHERE Results.RaceId=597)
, 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
|