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
|
|
|
The Bradford Run 10 Mile (10Mile)
|
Rate this information
| Not rated |
| No feedback available for this area |
WITH resultSet AS (SELECT Results.ResultId FROM Results WHERE Results.RaceId=973)
, spt10858 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=10858 And Splits.Duration Is Not NULL), spt10857 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=10857 And Splits.Duration Is Not NULL), spt10859 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=10859 And Splits.Duration Is Not NULL), spt10860 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=10860 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, spt10858.Duration AS [Splt_10858]
, spt10857.Duration AS [Splt_10857]
, spt10859.Duration AS [Splt_10859]
, spt10860.Duration AS [Splt_10860]
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 spt10858 ON spt10858.ResultId=Results.ResultId
LEFT OUTER JOIN spt10857 ON spt10857.ResultId=Results.ResultId
LEFT OUTER JOIN spt10859 ON spt10859.ResultId=Results.ResultId
LEFT OUTER JOIN spt10860 ON spt10860.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
|