Results Navigation
Use the controls below to drill down into these results
|
|
Jul
26
2009
|
Mk Triathlon 2009 (1500m swim/40km bike/10km run)
|
| Status | Pos | Overall | Bib | Competitor | Category | Team | Finish | Swim | T1 | Cycle | T2 | Run1 | Run2 | Run3 | Run Total |
|
| 1 | 0 | 17 | Greg Ashmore |
E
|
| 02:07:46 | 00:05:30 | 00:01:41 | 01:14:25 | 00:01:01 | 00:15:20 | 00:15:10 | 00:14:37 | 00:45:07 |
|
| 2 | 0 | 425 | Patrick Waldron |
K
|
| 02:13:18 | 00:13:46 | 00:02:36 | 01:14:54 | 00:00:50 | 00:13:51 | 00:13:44 | 00:13:34 | 00:41:09 |
|
| 3 | 0 | 95 | Vanessa Crookes |
H
|
| 02:18:08 | 00:27:49 | 00:02:49 | 00:58:35 | 00:01:55 | 00:15:35 | 00:16:07 | 00:15:16 | 00:46:58 |
|
| 4 | 0 | 362 | Guy Rowson |
H
|
| 02:19:31 | | | 01:11:01 | 00:01:23 | 00:15:34 | 00:16:17 | 00:16:15 | 00:48:06 |
|
| 5 | 0 | 418 | Steven Turner |
I
|
| 02:38:07 | 00:32:40 | 00:01:54 | 01:21:45 | 00:00:43 | 00:19:06 | | | |
|
| 6 | 0 | 163 | Amanda Gopaul |
E
|
| | 00:27:48 | 00:00:58 | 01:24:41 | 00:00:44 | | | | |
|
| 7 | 0 | 308 | Sean Nicolle |
G
|
| | 00:20:58 | 00:01:14 | 01:07:56 | 00:00:50 | | | | |
|
| 8 | 0 | 393 | Deborah Smith |
E
|
| | | | 01:24:38 | 00:01:22 | | | | |
|
| 9 | 0 | 307 | Deb Newman |
I
|
| | | | 01:24:39 | 00:01:24 | | | | |
|
| 10 | 0 | 4 | Steve Adams |
J
|
| | 00:29:26 | 00:01:15 | 01:19:57 | 00:06:36 | | | | |
|
| 11 | 0 | 386 | Nigel Skinner |
I
|
| | 00:28:59 | 00:02:19 | 01:30:12 | | | | | |
|
| 12 | 0 | 328 | Kelly Paterson |
E
|
| | 00:24:37 | 00:02:39 | 01:54:22 | | | | | |
|
| 13 | 0 | 59 | Gill Brooks |
F
|
| | 00:30:49 | 00:01:35 | | | | | | |
|
| 14 | 0 | 447 | Edward Yabsley |
H
|
| | 00:21:51 | 00:01:57 | | | | | | |
|
| 15 | 0 | 25 | Veronica Banks |
F
|
| | 00:23:41 | 00:02:44 | | | | | | |
|
| 16 | 0 | 174 | Gary Halliday |
H
|
| | 00:27:06 | | | | | | | |
|
| 17 | 1 | 46 | Adam Bowden |
E
|
| 01:48:21 | 00:16:22 | 00:00:46 | 00:59:47 | 00:00:35 | 00:10:08 | 00:10:25 | 00:10:16 | 00:30:49 |
|
| 18 | 2 | 91 | Daniel Corner |
F
|
| 01:49:23 | 00:18:06 | 00:00:40 | 00:57:22 | 00:00:39 | 00:10:46 | 00:10:54 | 00:10:54 | 00:32:34 |
|
| 19 | 3 | 127 | Pete Eggleston |
H
|
| 01:57:40 | 00:19:56 | 00:00:52 | 00:59:38 | 00:00:42 | 00:12:01 | 00:12:13 | 00:12:16 | 00:36:30 |
|
| 20 | 4 | 426 | Nathaniel Walker |
E
|
| 01:58:21 | 00:21:08 | 00:01:08 | 01:03:30 | 00:00:23 | 00:10:26 | 00:10:53 | 00:10:50 | 00:32:09 |
|
| 21 | 5 | 158 | David Glossy |
G
|
| 01:58:40 | 00:18:25 | 00:00:49 | 01:02:30 | 00:00:40 | 00:11:50 | 00:12:21 | 00:12:03 | 00:36:14 |
|
| 22 | 6 | 148 | Keith Galea |
D
|
| 01:59:09 | 00:18:04 | 00:01:07 | 01:03:16 | 00:00:59 | 00:11:43 | 00:12:05 | 00:11:51 | 00:35:39 |
|
| 23 | 7 | 434 | Peter Wilby |
E
|
| 01:59:15 | 00:17:49 | 00:00:57 | 01:03:45 | 00:00:26 | 00:12:07 | 00:12:13 | 00:11:56 | 00:36:16 |
|
| 24 | 8 | 34 | Jamie Beecham |
F
|
| 01:59:17 | 00:18:12 | 00:00:48 | 01:01:54 | 00:00:48 | 00:12:25 | 00:12:28 | 00:12:39 | 00:37:32 |
|
| 25 | 9 | 18 | Andrew Auld |
H
|
| 01:59:26 | 00:18:59 | 00:00:46 | 01:04:28 | 00:00:40 | 00:11:21 | 00:11:43 | 00:11:26 | 00:34:30 |
|
| 26 | 10 | 275 | David Mcdougall |
G
|
| 01:59:34 | 00:18:22 | 00:01:02 | 01:02:43 | 00:00:33 | 00:12:07 | 00:12:20 | 00:12:24 | 00:36:51 |
|
| 27 | 11 | 449 | Mark Yeoman |
G
|
| 01:59:38 | 00:18:26 | 00:01:01 | 01:02:52 | 00:00:28 | 00:12:02 | 00:12:20 | 00:12:27 | 00:36:49 |
|
| 28 | 12 | 326 | Luke Partridge |
E
|
| 02:00:04 | 00:18:00 | 00:00:51 | 01:03:32 | 00:00:30 | 00:12:01 | 00:12:29 | 00:12:37 | 00:37:07 |
|
| 29 | 13 | 150 | Peter Galpin |
G
|
| 02:00:12 | 00:21:28 | 00:01:17 | 01:02:04 | 00:00:42 | 00:11:28 | 00:11:36 | 00:11:34 | 00:34:38 |
|
| 30 | 14 | 284 | Steve Mckeown |
H
|
| 02:00:28 | 00:20:24 | 00:01:15 | 01:03:04 | 00:00:30 | 00:11:45 | 00:11:48 | 00:11:40 | 00:35:13 |
|
| 31 | 15 | 453 | Phil Jenkins |
H
|
| 02:01:04 | 00:17:44 | 00:01:04 | 01:02:08 | 00:00:28 | 00:12:57 | 00:13:22 | 00:13:17 | 00:39:36 |
|
| 32 | 16 | 60 | Mark Brooks |
G
|
| 02:01:09 | 00:18:56 | 00:00:45 | 01:04:14 | 00:00:46 | 00:11:52 | 00:12:22 | 00:12:12 | 00:36:26 |
|
| 33 | 17 | 135 | Richard Evans |
H
|
| 02:01:11 | 00:17:48 | 00:00:52 | 01:04:31 | 00:00:48 | 00:12:17 | 00:12:30 | 00:12:22 | 00:37:09 |
|
| 34 | 18 | 369 | Keith Sanders |
E
|
| 02:02:08 | 00:21:24 | 00:01:16 | 01:02:10 | 00:00:33 | 00:12:14 | 00:12:20 | 00:12:09 | 00:36:43 |
|
| 35 | 19 | 320 | Charlie Palmer |
F
|
| 02:02:40 | 00:21:04 | 00:01:31 | 01:02:10 | 00:00:41 | 00:12:36 | 00:12:20 | 00:12:15 | 00:37:11 |
|
| 36 | 20 | 243 | Joshua Lawless |
C
|
| 02:02:45 | 00:16:57 | 00:00:50 | 01:04:34 | 00:00:54 | 00:12:44 | 00:14:12 | 00:12:32 | 00:39:28 |
|
| 37 | 21 | 372 | Clark Schofield |
F
|
| 02:02:46 | 00:19:41 | 00:00:53 | 01:04:04 | 00:00:25 | 00:12:25 | 00:12:54 | 00:12:22 | 00:37:41 |
|
| 38 | 22 | 459 | Robin Dowswell |
H
|
| 02:02:57 | 00:20:50 | 00:00:59 | 01:02:53 | 00:00:29 | 00:12:40 | 00:12:31 | 00:12:33 | 00:37:44 |
|
| 39 | 23 | 201 | Richard Hooker |
F
|
| 02:03:32 | 00:20:10 | 00:01:20 | 01:04:11 | 00:00:51 | 00:12:07 | 00:12:33 | 00:12:17 | 00:36:57 |
|
| 40 | 24 | 406 | Mark Sykes |
E
|
| 02:03:35 | 00:19:21 | 00:00:55 | 01:04:16 | 00:00:26 | 00:12:40 | 00:12:51 | 00:13:03 | 00:38:34 |
|
| 41 | 25 | 302 | Eimear Mullan |
E
|
| 02:04:03 | 00:21:32 | 00:00:55 | 01:05:51 | 00:00:31 | 00:11:26 | 00:11:52 | 00:11:53 | 00:35:11 |
|
| 42 | 26 | 325 | Kevin Partridge |
J
|
| 02:04:09 | 00:17:58 | 00:01:06 | 01:07:16 | 00:00:31 | 00:12:18 | 00:12:22 | 00:12:34 | 00:37:14 |
|
| 43 | 27 | 439 | Matt Winn-smith |
F
|
| 02:04:17 | 00:21:14 | 00:01:28 | 01:05:33 | 00:00:24 | 00:11:45 | 00:12:11 | 00:11:39 | 00:35:35 |
|
| 44 | 28 | 254 | Stephen Livermore |
E
|
| 02:04:38 | 00:19:14 | 00:01:14 | 01:06:31 | 00:00:46 | 00:11:54 | 00:12:33 | 00:12:22 | 00:36:49 |
|
| 45 | 29 | 157 | Neil Giles |
G
|
| 02:04:40 | 00:21:25 | 00:01:14 | 01:03:46 | 00:00:37 | 00:12:15 | 00:12:49 | 00:12:31 | 00:37:35 |
|
| 46 | 30 | 75 | Giles Carter |
F
|
| 02:05:11 | 00:19:45 | 00:00:56 | 01:04:25 | 00:00:42 | 00:12:41 | 00:13:46 | 00:12:54 | 00:39:21 |
|
| 47 | 31 | 79 | Lee Charles |
G
|
| 02:05:32 | 00:21:16 | 00:01:13 | 01:02:08 | 00:00:45 | 00:13:15 | 00:13:32 | 00:13:21 | 00:40:08 |
|
| 48 | 32 | 48 | Mark Boxall |
F
|
| 02:05:37 | 00:21:10 | 00:00:48 | 01:05:43 | 00:00:38 | 00:12:28 | 00:12:31 | 00:12:16 | 00:37:15 |
|
| 49 | 33 | 233 | William Kirk-wilson |
G
|
| 02:05:48 | 00:20:33 | 00:00:57 | 01:06:01 | 00:00:38 | 00:12:21 | 00:12:36 | 00:12:37 | 00:37:34 |
|
| 50 | 34 | 401 | Stefan Stone |
F
|
| 02:06:16 | 00:21:18 | 00:01:09 | 01:06:48 | 00:00:41 | 00:11:52 | 00:12:25 | 00:12:00 | 00:36:17 |
|
| 51 | 35 | 260 | Mark Loveday |
E
|
| 02:06:59 | 00:21:20 | 00:01:18 | 01:06:53 | 00:00:41 | 00:11:53 | 00:12:33 | 00:12:19 | 00:36:45 |
|
| 52 | 36 | 463 | Club Sportivo Mk |
T
|
| 02:07:20 | 00:18:54 | 00:00:55 | 01:09:22 | 00:00:42 | 00:12:04 | 00:12:45 | 00:12:34 | 00:37:23 |
|
| 53 | 37 | 184 | James Hartwright |
F
|
| 02:07:49 | 00:19:46 | 00:00:56 | 01:07:01 | 00:00:51 | 00:12:49 | 00:13:19 | 00:13:03 | 00:39:11 |
|
| 54 | 38 | 183 | Andrew Harrison |
F
|
| 02:08:24 | 00:22:17 | 00:00:48 | 01:04:14 | 00:00:43 | 00:13:09 | 00:13:21 | 00:13:49 | 00:40:19 |
|
| 55 | 39 | 22 | Chris Bailey |
F
|
| 02:08:24 | 00:22:31 | 00:00:49 | 01:06:02 | 00:00:43 | 00:12:25 | 00:13:00 | 00:12:52 | 00:38:17 |
|
| 56 | 40 | 409 | David Thompson |
H
|
| 02:08:47 | 00:23:48 | 00:01:56 | 01:04:44 | 00:00:39 | 00:12:20 | 00:12:40 | 00:12:38 | 00:37:38 |
|
| 57 | 41 | 281 | Paul Mcinulty |
F
|
| 02:08:51 | 00:18:23 | 00:01:14 | 01:07:23 | 00:00:44 | 00:13:27 | 00:13:46 | 00:13:53 | 00:41:06 |
|
| 58 | 42 | 324 | Gavin Parsons |
F
|
| 02:08:55 | 00:20:17 | 00:01:27 | 01:09:46 | 00:00:47 | 00:12:05 | 00:12:23 | 00:12:07 | 00:36:35 |
|
| 59 | 43 | 290 | Chris Mellor |
J
|
| 02:09:29 | 00:22:23 | 00:01:23 | 01:07:22 | 00:00:57 | 00:12:10 | 00:12:28 | 00:12:44 | 00:37:22 |
|
| 60 | 44 | 168 | Yvette Grice |
E
|
| 02:09:39 | 00:18:22 | 00:00:54 | 01:12:09 | 00:00:50 | 00:12:29 | 00:12:34 | 00:12:19 | 00:37:22 |
|
| 61 | 45 | 343 | Jonathan Pike |
F
|
| 02:09:48 | 00:22:55 | 00:01:11 | 01:06:56 | 00:00:40 | 00:12:35 | 00:12:40 | 00:12:46 | 00:38:01 |
|
| 62 | 46 | 305 | Craig Naidoo |
E
|
| 02:09:55 | 00:22:52 | 00:01:38 | 01:06:35 | 00:00:42 | 00:12:45 | 00:12:42 | 00:12:39 | 00:38:06 |
|
| 63 | 47 | 248 | Allan Leighton |
I
|
| 02:10:13 | 00:19:36 | 00:01:11 | 01:04:08 | 00:00:44 | 00:14:04 | 00:15:02 | 00:15:26 | 00:44:32 |
|
| 64 | 48 | 285 | Justin Mckie |
F
|
| 02:10:19 | 00:22:56 | 00:01:39 | 01:04:38 | 00:00:48 | 00:13:05 | 00:13:41 | 00:13:29 | 00:40:15 |
|
| 65 | 49 | 365 | Mustafa Salih |
H
|
| 02:10:21 | 00:20:46 | 00:01:27 | 01:08:27 | 00:00:50 | 00:12:50 | 00:13:09 | 00:12:50 | 00:38:49 |
|
| 66 | 50 | 142 | Steffan Ford |
F
|
| 02:10:30 | 00:20:25 | 00:01:13 | 01:07:31 | 00:00:57 | 00:13:08 | 00:13:32 | 00:13:41 | 00:40:21 |
|
| 67 | 51 | 30 | Christopher Baxter |
H
|
| 02:10:40 | 00:22:21 | 00:01:07 | 01:07:20 | 00:00:47 | 00:12:49 | 00:13:08 | 00:13:05 | 00:39:02 |
|
| 68 | 52 | 378 | Tom Sexton |
E
|
| 02:10:59 | 00:18:59 | 00:01:44 | 01:06:15 | 00:00:43 | 00:14:02 | 00:14:44 | 00:14:29 | 00:43:15 |
|
| 69 | 53 | 339 | Gary Peters |
H
|
| 02:11:09 | 00:19:36 | 00:01:18 | 01:07:55 | 00:00:42 | 00:13:24 | 00:13:54 | 00:14:18 | 00:41:36 |
|
| 70 | 54 | 179 | Mark Hannay |
E
|
| 02:11:12 | 00:20:36 | 00:01:50 | 01:07:05 | 00:01:27 | 00:12:43 | 00:13:42 | 00:13:47 | 00:40:12 |
|
| 71 | 55 | 234 | Henry Knott |
D
|
| 02:11:19 | 00:22:17 | 00:01:40 | 01:06:12 | 00:01:07 | 00:13:03 | 00:13:34 | 00:13:23 | 00:40:00 |
|
| 72 | 56 | 329 | Alec Patterson |
F
|
| 02:11:42 | 00:19:42 | 00:01:18 | 01:09:36 | 00:00:38 | 00:13:17 | 00:13:48 | 00:13:19 | 00:40:24 |
|
| 73 | 57 | 35 | Stephen Bell |
F
|
| 02:12:00 | 00:22:23 | 00:01:17 | 01:06:59 | 00:00:51 | 00:13:59 | 00:13:40 | 00:12:49 | 00:40:28 |
|
| 74 | 58 | 261 | Tim Lucas |
D
|
| 02:12:06 | 00:22:19 | 00:01:07 | 01:09:35 | 00:00:52 | 00:12:46 | 00:12:43 | 00:12:43 | 00:38:12 |
|
| 75 | 59 | 80 | Kevin Chesham |
K
|
| 02:12:08 | 00:20:52 | 00:01:40 | 01:09:02 | 00:01:04 | 00:13:19 | 00:13:19 | 00:12:50 | 00:39:28 |
|
| 76 | 60 | 74 | Joanna Carritt |
F
|
| 02:12:16 | 00:21:27 | 00:01:15 | 01:09:34 | 00:00:41 | 00:12:56 | 00:13:13 | 00:13:07 | 00:39:16 |
|
| 77 | 61 | 400 | Michael Stockton |
G
|
| 02:12:44 | 00:22:26 | 00:00:59 | 01:09:28 | 00:00:28 | 00:12:53 | 00:13:08 | 00:13:20 | 00:39:21 |
|
| 78 | 62 | 251 | Richard Lewey |
I
|
| 02:12:52 | 00:23:31 | 00:01:43 | 01:06:51 | 00:01:06 | 00:13:17 | 00:13:19 | 00:13:02 | 00:39:38 |
|
| 79 | 63 | 3 | Iain Adams |
G
|
| 02:12:58 | 00:25:07 | 00:01:13 | 01:08:07 | 00:00:59 | 00:12:25 | 00:12:39 | 00:12:25 | 00:37:29 |
|
| 80 | 64 | 173 | Simon Hall |
H
|
| 02:13:04 | 00:24:27 | 00:01:25 | 01:08:25 | 00:00:50 | 00:12:17 | 00:12:48 | 00:12:51 | 00:37:56 |
|
| 81 | 65 | 286 | Gavin Mclaughlin |
H
|
| 02:13:13 | 00:19:08 | 00:01:27 | 01:11:52 | 00:00:41 | 00:13:10 | 00:13:42 | 00:13:10 | 00:40:02 |
|
| 82 | 66 | 76 | James Cartwright |
F
|
| 02:13:20 | 00:23:01 | 00:02:33 | 01:07:18 | 00:00:59 | 00:12:55 | 00:13:25 | 00:13:07 | 00:39:27 |
|
| 83 | 67 | 143 | Ian Forrest |
G
|
| 02:13:25 | 00:24:30 | 00:01:15 | 01:08:56 | 00:00:48 | 00:12:06 | 00:12:52 | 00:12:56 | 00:37:54 |
|
| 84 | 68 | 223 | Marc Jones |
D
|
| 02:13:26 | 00:23:16 | 00:01:32 | 01:07:05 | 00:00:49 | 00:13:25 | 00:13:40 | 00:13:37 | 00:40:42 |
|
| 85 | 69 | 172 | Antony Hall |
H
|
| 02:13:27 | 00:20:24 | 00:01:11 | 01:07:18 | 00:00:53 | 00:14:05 | 00:14:44 | 00:14:48 | 00:43:37 |
|
| 86 | 70 | 200 | Trevor Hook |
J
|
| 02:13:50 | 00:26:01 | 00:01:15 | 01:05:05 | 00:00:42 | 00:13:40 | 00:13:38 | 00:13:27 | 00:40:45 |
|
| 87 | 71 | 456 | Stephen Hones |
E
|
| 02:14:02 | 00:21:53 | 00:01:07 | 01:12:59 | 00:00:33 | 00:12:42 | 00:12:50 | 00:11:56 | 00:37:28 |
|
| 88 | 72 | 199 | Robert Hoodless |
I
|
| 02:14:11 | 00:23:38 | 00:01:25 | 01:08:11 | 00:00:40 | 00:13:04 | 00:13:44 | 00:13:28 | 00:40:16 |
|
| 89 | 73 | 422 | Robin Underwood |
G
|
| 02:14:26 | 00:20:53 | 00:01:29 | 01:08:21 | 00:00:29 | 00:14:21 | 00:14:38 | 00:14:11 | 00:43:10 |
|
| 90 | 74 | 119 | Stephen Dransfield |
E
|
| 02:14:30 | 00:25:16 | 00:01:10 | 01:09:09 | 00:00:34 | 00:12:20 | 00:13:17 | 00:12:42 | 00:38:19 |
|
| 91 | 75 | 211 | Mark Hyde |
J
|
| 02:14:37 | 00:20:35 | 00:01:22 | 01:05:24 | 00:00:55 | 00:15:07 | 00:15:41 | 00:15:31 | 00:46:19 |
|
| 92 | 76 | 82 | Alan Clark |
H
|
| 02:15:26 | 00:22:10 | 00:01:20 | 01:10:05 | 00:00:46 | 00:13:32 | 00:13:55 | 00:13:36 | 00:41:03 |
|
| 93 | 77 | 383 | Simon Shepherd |
F
|
| 02:15:27 | 00:22:34 | 00:00:59 | 01:07:46 | 00:00:38 | 00:13:52 | 00:14:31 | 00:15:06 | 00:43:29 |
|
| 94 | 78 | 132 | Esther Evans |
G
|
| 02:15:29 | 00:22:54 | 00:00:55 | 01:11:34 | 00:00:57 | 00:12:41 | 00:13:11 | 00:13:15 | 00:39:07 |
|
| 95 | 79 | 408 | Richard Thomas |
F
|
| 02:15:29 | 00:22:45 | 00:01:24 | 01:10:01 | 00:01:04 | 00:12:51 | 00:13:26 | 00:13:55 | 00:40:12 |
|
| 96 | 80 | 348 | Jonathan Price |
G
|
| 02:15:33 | 00:22:50 | 00:01:48 | 01:07:59 | 00:01:07 | 00:13:24 | 00:14:02 | 00:14:19 | 00:41:45 |
|
| 97 | 81 | 217 | Thomas Jackson |
J
|
| 02:15:39 | 00:25:54 | 00:01:53 | 01:09:20 | 00:00:46 | 00:12:15 | 00:12:41 | 00:12:47 | 00:37:43 |
|
| 98 | 82 | 411 | Kai Timmermann |
E
|
| 02:15:47 | 00:19:52 | 00:01:10 | 01:09:50 | 00:00:33 | 00:13:58 | 00:15:07 | 00:15:14 | 00:44:19 |
|
| 99 | 83 | 226 | Mike Jubb |
G
|
| 02:15:54 | 00:26:23 | 00:01:36 | 01:04:53 | 00:00:31 | 00:14:32 | 00:14:02 | 00:13:55 | 00:42:29 |
|
| 100 | 84 | 39 | Graeme Blair |
H
|
| 02:16:05 | 00:22:46 | 00:00:50 | 01:10:21 | 00:01:08 | 00:13:30 | 00:13:37 | 00:13:50 | 00:40:57 |
Rate this information
| Not rated |
| No feedback available for this area |
WITH resultSet AS (SELECT Results.ResultId FROM Results WITH (NOLOCK) WHERE Results.RaceId=599)
, spt9368 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=9368 And Splits.Duration Is Not NULL), spt9369 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=9369 And Splits.Duration Is Not NULL), spt9370 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=9370 And Splits.Duration Is Not NULL), spt9371 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=9371 And Splits.Duration Is Not NULL), spt9372 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=9372 And Splits.Duration Is Not NULL), spt10436 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=10436 And Splits.Duration Is Not NULL), spt10437 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=10437 And Splits.Duration Is Not NULL), spt10438 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=10438 And Splits.Duration Is Not NULL), spt9373 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=9373 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, spt9368.Duration AS [Splt_9368]
, spt9369.Duration AS [Splt_9369]
, spt9370.Duration AS [Splt_9370]
, spt9371.Duration AS [Splt_9371]
, spt9372.Duration AS [Splt_9372]
, spt10436.Duration AS [Splt_10436]
, spt10437.Duration AS [Splt_10437]
, spt10438.Duration AS [Splt_10438]
, spt9373.Duration AS [Splt_9373]
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 spt9368 WITH (NOLOCK) ON spt9368.ResultId=Results.ResultId
LEFT OUTER JOIN spt9369 WITH (NOLOCK) ON spt9369.ResultId=Results.ResultId
LEFT OUTER JOIN spt9370 WITH (NOLOCK) ON spt9370.ResultId=Results.ResultId
LEFT OUTER JOIN spt9371 WITH (NOLOCK) ON spt9371.ResultId=Results.ResultId
LEFT OUTER JOIN spt9372 WITH (NOLOCK) ON spt9372.ResultId=Results.ResultId
LEFT OUTER JOIN spt10436 WITH (NOLOCK) ON spt10436.ResultId=Results.ResultId
LEFT OUTER JOIN spt10437 WITH (NOLOCK) ON spt10437.ResultId=Results.ResultId
LEFT OUTER JOIN spt10438 WITH (NOLOCK) ON spt10438.ResultId=Results.ResultId
LEFT OUTER JOIN spt9373 WITH (NOLOCK) ON spt9373.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
|