Welcome |
Click here to login
|
Your cart is empty.
Results
Race Timing Systems
Black Sheep Sports
Home
Events
Results
My Cow
News and Articles
Sponsors
About
You are here:
Home
...
Results
...
TriFest09 Aquathlon
Login to locate your results
Results Navigation
Use the controls below to drill down into these results
Competitor Search
Firstname
Lastname
Bib
Category
Any category
J
S
V
Team
Any team
-
4Life
Bedford Harriers
hereford couriers
NEW
--No Team--
olney runners
st albans striders
Thames valley triathletes
Tri-Force
Gender
Any
Male
Female
Sorting
Overall
Bib
Firstname
Lastname
Competitor
Category
Team
Club
Laps
Finish
Swim
T1
Run2
Direction
Ascending
Descending
Search complete
41 records found
Displayed in 0 pages
Click a competitors name for detailed information
Detail level
Choose the columns to view
Position
Competitor
Overall
Laps
Bib
Race Search
Race
Date
Any
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Any
2005
2006
2007
2008
Manager
Contact us about these results
From (email)
Type of enquiry
General enquiry
Missing result
Result wrong
Spelling mistake
Time my race
Message
Additional information
Bib
Finished near
Firstname
Lastname
Team
Any team
-
4Life
Bedford Harriers
hereford couriers
NEW
--No Team--
olney runners
st albans striders
Thames valley triathletes
Tri-Force
Category
Any category
J
S
V
Where did you wear your timing chip?
What number was on the timing chip?
Jun
06
2009
TriFest09 Aquathlon (750m swim/5km run)
Status
Pos
Overall
Bib
Competitor
Category
Team
Finish
Swim
T1
Run2
1
1
542
Adam Bowden
S
00:28:08
00:09:37
00:00:49
00:17:40
2
2
505
Deon Coetzee
S
00:30:04
00:09:47
00:00:55
00:19:20
3
3
504
Greg Cherry
S
00:30:37
00:09:28
00:00:41
00:20:26
4
4
513
Sharkie Jaggard
V
Thames valley triathletes
00:30:48
00:10:45
00:00:39
00:19:22
5
5
531
Nick Sturge
S
Tri-Force
00:30:55
00:10:48
00:00:40
00:19:25
6
6
529
Mark Sims
S
00:33:11
00:11:02
00:00:43
00:21:24
7
7
536
Ollie Williams
S
Tri-Force
00:33:33
00:11:04
00:01:17
00:21:11
8
8
532
Kai Timmermann
S
00:33:56
00:10:58
00:00:47
00:22:10
9
9
511
David Giles
S
4Life
00:34:32
00:10:55
00:00:47
00:22:48
10
10
540
Graham Murphy
S
00:34:38
00:11:01
00:00:43
00:22:51
11
11
541
Alan Wylie
S
00:35:11
00:11:18
00:00:49
00:23:02
12
12
509
Simon Fawcett
S
Bedford Harriers
00:35:22
00:14:43
00:00:55
00:19:42
13
13
506
Michael Donovan
V
st albans striders
00:35:52
00:12:57
00:00:56
00:21:58
14
14
543
Joshua Knight
S
00:35:58
00:12:12
00:01:40
00:22:04
15
15
501
David Bethell
V
00:37:22
00:12:10
00:01:30
00:23:40
16
16
525
Karen Price-lyall
S
00:37:27
00:11:11
00:00:53
00:25:21
17
17
535
Clive Williams
V
00:38:10
00:12:48
00:01:11
00:24:09
18
18
548
Keturah Hughes
S
00:38:19
00:12:08
00:01:30
00:24:40
19
19
507
Stephen Duddridge
S
00:38:23
00:15:59
00:01:04
00:21:18
20
20
526
Clare Scott
S
hereford couriers
00:38:23
00:14:21
00:00:40
00:23:20
21
21
502
Lisette Bonin-casey
V
Bedford Harriers
00:38:26
00:14:13
00:01:11
00:23:01
22
22
545
Peter Spinelli
V
00:39:55
00:14:46
00:01:01
00:24:05
23
23
503
Patrick Bonin-casey
S
00:41:23
00:16:51
00:00:56
00:23:35
24
24
523
Richard Olney
S
00:41:32
00:15:23
00:00:53
00:25:09
25
25
549
Guispee Buonocoreg
V
00:41:45
00:16:25
00:01:10
00:24:07
26
26
518
Alice Loft
S
--No Team--
00:42:34
00:15:08
00:01:59
00:25:26
27
27
538
Nick Young
V
00:43:21
00:19:58
00:01:34
00:21:47
28
28
539
John Ritchie
V
00:43:38
00:15:19
00:01:39
00:26:39
29
29
516
Alexandra Knight
S
00:43:51
00:15:13
00:01:59
00:26:37
30
30
547
John Risby
V
00:43:51
00:19:54
00:01:04
00:22:51
31
31
533
Serena Von der heyde
V
olney runners
00:44:01
00:19:16
00:01:09
00:23:34
32
32
527
Jennifer Shaw
S
00:44:40
00:18:48
00:01:08
00:24:42
33
33
517
Robert Lenton
S
-
00:45:33
00:16:41
00:02:11
00:26:39
34
34
534
Jacqueline Wells
S
00:45:35
00:14:51
00:00:57
00:29:45
35
35
544
Amy Booth
J
00:46:16
00:12:38
00:01:58
00:31:39
36
36
519
Jim Loft
V
--No Team--
00:47:37
00:16:53
00:02:48
00:27:55
37
37
530
Nick Stratton
S
00:48:18
00:19:26
00:01:28
00:27:23
38
38
528
Claire Shergold
S
NEW
00:49:22
00:12:51
00:02:14
00:34:15
39
39
524
Nicholas Pilbeam
S
00:50:56
00:14:58
00:02:23
00:33:33
40
40
512
Tom Hales
S
13:39:25
41
515
William Kirk-wilson
S
00:12:16
00:00:41
Rate this information
Not rated
Name
Rating
1
2
3
4
5
Email
Comments (optional)
No feedback available for this area
WITH resultSet AS (SELECT Results.ResultId FROM Results WITH (NOLOCK) WHERE Results.RaceId=592) , spt9326 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=9326 And Splits.Duration Is Not NULL), spt9329 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=9329 And Splits.Duration Is Not NULL), spt9330 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=9330 And Splits.Duration Is Not NULL), spt9331 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=9331 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, spt9326.Duration AS [Splt_9326] , spt9329.Duration AS [Splt_9329] , spt9330.Duration AS [Splt_9330] , spt9331.Duration AS [Splt_9331] 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 spt9326 WITH (NOLOCK) ON spt9326.ResultId=Results.ResultId LEFT OUTER JOIN spt9329 WITH (NOLOCK) ON spt9329.ResultId=Results.ResultId LEFT OUTER JOIN spt9330 WITH (NOLOCK) ON spt9330.ResultId=Results.ResultId LEFT OUTER JOIN spt9331 WITH (NOLOCK) ON spt9331.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
Copyright©Righteous Solutions Ltd
Customer Services
Privacy Policy
Delivery Policy
Returns & Cancellation Policy
Site Admin