Stolen bike. £500 reward
This bike was amongst some other items stolen from our offices in Milton Keynes in the early hours of Monday 7-Dec-2009.
A £500 reward is offered for information leading to it's safe return. Click here for more information
Results Navigation
Use the controls below to drill down into these results
Contact us about these results
|
|
|
209 Cheltenham 10K (10K Run)
|
Rate this information
| Not rated |
| No feedback available for this area |
WITH resultSet AS (SELECT Results.ResultId FROM Results WHERE Results.RaceId=925)
, spt10680 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=10680 And Splits.Duration Is Not NULL), spt10679 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=10679 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, spt10680.Duration AS [Splt_10680]
, spt10679.Duration AS [Splt_10679]
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 spt10680 ON spt10680.ResultId=Results.ResultId
LEFT OUTER JOIN spt10679 ON spt10679.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
|