Results Navigation
Use the controls below to drill down into these results
|
|
May
24
2009
|
Big Cow Sprint Tri 1 2009 (750m swim/20km bike/5km run)
|
Rate this information
| Not rated |
| No feedback available for this area |
WITH resultSet AS (SELECT Results.ResultId FROM Results WHERE Results.RaceId=586)
, spt9303 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, ROW_NUMBER() OVER (ORDER BY Splits.Duration) AS SplitRank FROM Splits INNER JOIN ResultSet ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9303 And Splits.Duration Is Not NULL), spt9304 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, ROW_NUMBER() OVER (ORDER BY Splits.Duration) AS SplitRank FROM Splits INNER JOIN ResultSet ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9304 And Splits.Duration Is Not NULL), spt9305 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, ROW_NUMBER() OVER (ORDER BY Splits.Duration) AS SplitRank FROM Splits INNER JOIN ResultSet ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9305 And Splits.Duration Is Not NULL), spt9306 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, ROW_NUMBER() OVER (ORDER BY Splits.Duration) AS SplitRank FROM Splits INNER JOIN ResultSet ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9306 And Splits.Duration Is Not NULL), spt9307 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, ROW_NUMBER() OVER (ORDER BY Splits.Duration) AS SplitRank FROM Splits INNER JOIN ResultSet ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9307 And Splits.Duration Is Not NULL), spt9308 AS (SELECT Splits.ResultId, Splits.SplitId, Splits.Duration, Splits.RaceSplitId, ROW_NUMBER() OVER (ORDER BY Splits.Duration) AS SplitRank FROM Splits INNER JOIN ResultSet ON resultSet.ResultId=Splits.ResultId WHERE Splits.RaceSplitId=9308 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, spt9303.Duration AS [Splt_9303]
, spt9304.Duration AS [Splt_9304]
, spt9305.Duration AS [Splt_9305]
, spt9306.Duration AS [Splt_9306]
, spt9307.Duration AS [Splt_9307]
, spt9308.Duration AS [Splt_9308]
FROM Results INNER JOIN Races ON Races.RaceId=Results.RaceId INNER JOIN resultSet ON resultSet.ResultId=Results.ResultId INNER JOIN Events ON Events.EventId=Races.EventId
LEFT OUTER JOIN Keywords Gender ON Gender.KeywordId=Results.Gender AND Gender.Language='English' AND Gender.GroupName='Gender'
LEFT OUTER JOIN spt9303 ON spt9303.ResultId=Results.ResultId
LEFT OUTER JOIN spt9304 ON spt9304.ResultId=Results.ResultId
LEFT OUTER JOIN spt9305 ON spt9305.ResultId=Results.ResultId
LEFT OUTER JOIN spt9306 ON spt9306.ResultId=Results.ResultId
LEFT OUTER JOIN spt9307 ON spt9307.ResultId=Results.ResultId
LEFT OUTER JOIN spt9308 ON spt9308.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
|