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 | 59 | Gill Brooks |
F
|
| | 00:30:49 | 00:01:35 | | | | | | |
|
| 2 | 0 | 25 | Veronica Banks |
F
|
| | 00:23:41 | 00:02:44 | | | | | | |
|
| 3 | 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 |
|
| 4 | 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 |
|
| 5 | 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 |
|
| 6 | 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 |
|
| 7 | 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 |
|
| 8 | 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 |
|
| 9 | 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 |
|
| 10 | 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 |
|
| 11 | 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 |
|
| 12 | 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 |
|
| 13 | 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 |
|
| 14 | 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 |
|
| 15 | 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 |
|
| 16 | 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 |
|
| 17 | 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 |
|
| 18 | 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 |
|
| 19 | 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 |
|
| 20 | 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 |
|
| 21 | 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 |
|
| 22 | 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 |
|
| 23 | 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 |
|
| 24 | 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 |
|
| 25 | 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 |
|
| 26 | 91 | 404 | Frederique Sumption |
F
|
| 02:16:55 | 00:22:58 | 00:01:03 | 01:12:06 | 00:00:27 | 00:12:58 | 00:13:35 | 00:13:45 | 00:40:18 |
|
| 27 | 95 | 405 | Philip Sutton |
F
|
| 02:17:24 | 00:23:06 | 00:01:52 | 01:08:07 | 00:00:49 | 00:14:15 | 00:14:41 | 00:14:31 | 00:43:27 |
|
| 28 | 98 | 53 | Adam Bradshaw |
F
|
| 02:17:51 | 00:21:50 | 00:01:32 | 01:07:49 | 00:01:27 | 00:14:37 | 00:15:35 | 00:14:59 | 00:45:11 |
|
| 29 | 105 | 356 | Stephen Riley |
F
|
| 02:18:42 | 00:22:59 | 00:01:56 | 01:09:54 | 00:00:29 | 00:14:23 | 00:14:55 | 00:14:03 | 00:43:21 |
|
| 30 | 106 | 338 | David Perry |
F
|
| 02:18:48 | 00:23:28 | 00:01:19 | 01:10:49 | 00:00:41 | 00:13:57 | 00:14:24 | 00:14:08 | 00:42:29 |
|
| 31 | 107 | 220 | Cameron Jensen |
F
|
| 02:18:50 | 00:24:29 | 00:01:21 | 01:08:06 | 00:00:52 | 00:14:50 | 00:14:37 | 00:14:31 | 00:43:58 |
|
| 32 | 108 | 110 | James Dear |
F
|
| 02:18:56 | 00:25:42 | 00:01:11 | 00:59:54 | 00:00:52 | 00:12:06 | 00:12:39 | 00:26:30 | 00:51:15 |
|
| 33 | 109 | 170 | Jonathan Grover |
F
|
| 02:18:58 | 00:20:42 | 00:01:49 | 01:10:37 | 00:00:57 | 00:14:47 | 00:14:52 | 00:15:11 | 00:44:50 |
|
| 34 | 119 | 96 | Katie Crowe |
F
|
| 02:20:14 | 00:22:14 | 00:01:01 | 01:12:25 | 00:00:53 | 00:14:11 | 00:14:44 | 00:14:43 | 00:43:38 |
|
| 35 | 127 | 237 | Bart Kuijten |
F
|
| 02:20:47 | 00:24:18 | 00:01:50 | 01:13:13 | 00:00:58 | 00:13:08 | 00:13:46 | 00:13:32 | 00:40:26 |
|
| 36 | 130 | 72 | Nick Carreras |
F
|
| 02:20:54 | 00:23:46 | 00:04:40 | 01:08:42 | 00:01:06 | 00:13:55 | 00:14:21 | 00:14:21 | 00:42:37 |
|
| 37 | 135 | 219 | CornT Jansen van vuuren |
F
|
| 02:21:20 | 00:25:12 | 00:01:42 | 01:12:26 | 00:01:01 | 00:13:02 | 00:13:50 | 00:14:05 | 00:40:57 |
|
| 38 | 139 | 279 | Julian Mcgowan |
F
|
| 02:21:41 | 00:29:01 | 00:01:45 | 01:11:32 | 00:01:09 | 00:13:02 | 00:12:45 | 00:12:26 | 00:38:13 |
|
| 39 | 145 | 203 | Suzanne Hopper |
F
|
| 02:21:53 | 00:22:56 | 00:01:04 | 01:15:10 | 00:00:39 | 00:13:44 | 00:14:09 | 00:14:08 | 00:42:01 |
|
| 40 | 148 | 122 | Chris Dunn |
F
|
| 02:21:59 | 00:26:28 | 00:01:26 | 01:10:47 | 00:01:01 | 00:13:29 | 00:14:20 | 00:14:26 | 00:42:15 |
|
| 41 | 149 | 73 | Chrlotte Carritt |
F
|
| 02:22:04 | 00:22:53 | 00:01:32 | 01:17:33 | 00:00:55 | 00:12:47 | 00:13:10 | 00:13:12 | 00:39:09 |
|
| 42 | 152 | 293 | Rob Michaelson-yeates |
F
|
| 02:22:11 | 00:23:47 | 00:02:02 | 01:13:39 | 00:01:09 | 00:13:20 | 00:14:01 | 00:14:11 | 00:41:32 |
|
| 43 | 155 | 342 | David Philipps |
F
|
| 02:22:25 | 00:25:02 | 00:02:06 | 01:08:38 | 00:01:27 | 00:15:07 | 00:15:14 | 00:14:47 | 00:45:08 |
|
| 44 | 172 | 97 | Robert Crump |
F
|
| 02:24:46 | 00:22:41 | 00:01:45 | 01:12:19 | 00:01:05 | 00:15:40 | 00:15:42 | 00:15:32 | 00:46:54 |
|
| 45 | 174 | 190 | Danny Heathwood |
F
|
| 02:24:58 | 00:28:52 | 00:01:57 | 01:11:44 | 00:00:51 | 00:14:09 | 00:13:35 | 00:13:48 | 00:41:32 |
|
| 46 | 178 | 297 | Dave Mitcham |
F
|
| 02:25:15 | 00:26:18 | 00:01:15 | 01:14:36 | 00:00:43 | 00:13:49 | 00:14:18 | 00:14:13 | 00:42:20 |
|
| 47 | 185 | 154 | Jon Geller |
F
|
| 02:25:48 | 00:25:30 | 00:01:14 | 01:14:55 | 00:00:45 | 00:14:35 | 00:14:30 | 00:14:17 | 00:43:22 |
|
| 48 | 193 | 194 | Mark Hoad |
F
|
| 02:26:32 | 00:25:41 | 00:01:31 | 01:15:24 | 00:01:35 | 00:13:34 | 00:14:17 | 00:14:26 | 00:42:17 |
|
| 49 | 199 | 360 | Sara Rogger |
F
|
| 02:27:14 | 00:24:24 | 00:01:12 | 01:15:48 | 00:00:56 | 00:14:46 | 00:15:19 | 00:14:46 | 00:44:51 |
|
| 50 | 200 | 123 | Mark Dury |
F
|
| 02:27:14 | 00:26:29 | 00:01:19 | 01:14:21 | 00:01:18 | 00:15:04 | 00:14:36 | 00:14:06 | 00:43:46 |
|
| 51 | 205 | 202 | Michelle Hopkins |
F
|
| 02:27:40 | 00:22:37 | 00:01:20 | 01:18:23 | 00:01:01 | 00:14:32 | 00:14:54 | 00:14:50 | 00:44:16 |
|
| 52 | 223 | 38 | Dan Betts |
F
|
| 02:29:27 | 00:23:55 | 00:00:52 | 01:14:20 | 00:00:45 | 00:16:03 | 00:16:58 | 00:16:32 | 00:49:33 |
|
| 53 | 227 | 189 | Andrew Heath |
F
|
| 02:29:36 | 00:24:48 | 00:01:31 | 01:15:19 | 00:01:04 | 00:14:41 | 00:17:01 | 00:15:09 | 00:46:51 |
|
| 54 | 231 | 153 | Paul Gassor |
F
|
| 02:30:10 | 00:27:16 | 00:02:21 | 01:15:26 | 00:01:29 | 00:14:02 | 00:14:41 | 00:14:51 | 00:43:34 |
|
| 55 | 233 | 390 | Antony Smith |
F
|
| 02:30:35 | 00:22:29 | 00:02:42 | 01:14:39 | 00:01:25 | 00:16:31 | 00:16:33 | 00:16:14 | 00:49:18 |
|
| 56 | 237 | 282 | Christy Mckee |
F
|
| 02:30:59 | 00:23:41 | 00:02:43 | 01:17:08 | 00:01:35 | 00:15:02 | 00:15:27 | 00:15:21 | 00:45:50 |
|
| 57 | 244 | 454 | Thomas Graham |
F
|
| 02:31:34 | 00:23:23 | 00:04:13 | 01:15:41 | 00:01:07 | 00:15:02 | 00:16:10 | 00:15:55 | 00:47:07 |
|
| 58 | 251 | 259 | Matthew Lonsdale |
F
|
| 02:32:22 | 00:25:54 | 00:02:33 | 01:14:31 | 00:01:18 | 00:15:32 | 00:16:20 | 00:16:12 | 00:48:04 |
|
| 59 | 252 | 210 | Gordon Hutton |
F
|
| 02:32:23 | 00:27:19 | 00:02:28 | 01:09:35 | 00:01:12 | 00:17:04 | 00:17:19 | 00:17:24 | 00:51:47 |
|
| 60 | 256 | 86 | Oliver Comyn |
F
|
| 02:32:49 | 00:25:49 | 00:01:29 | 01:12:18 | 00:01:14 | 00:16:21 | 00:17:47 | 00:17:47 | 00:51:55 |
|
| 61 | 257 | 376 | Holly jane Seear |
F
|
| 02:32:56 | 00:28:19 | 00:01:29 | 01:13:56 | 00:00:55 | 00:15:46 | 00:16:13 | 00:16:16 | 00:48:15 |
|
| 62 | 262 | 352 | Thomas Reddall |
F
|
| 02:33:42 | 00:33:02 | 00:04:01 | 01:13:04 | 00:01:08 | 00:13:57 | 00:14:28 | 00:13:59 | 00:42:24 |
|
| 63 | 269 | 118 | David Douglas |
F
|
| 02:34:33 | 00:29:31 | 00:01:37 | 01:14:04 | 00:01:29 | 00:15:22 | 00:16:01 | 00:16:26 | 00:47:49 |
|
| 64 | 274 | 361 | Chantelle Rothe |
F
|
| 02:34:55 | 00:29:01 | 00:01:24 | 01:13:08 | 00:01:02 | 00:16:19 | 00:17:09 | 00:16:50 | 00:50:18 |
|
| 65 | 279 | 246 | Andy Leatherbarrow |
F
|
| 02:35:50 | 00:28:48 | 00:02:08 | 01:16:15 | 00:01:23 | 00:15:36 | 00:15:27 | 00:16:08 | 00:47:11 |
|
| 66 | 286 | 435 | Ian Wild |
F
|
| 02:36:30 | 00:25:20 | 00:03:39 | 01:22:43 | 00:01:00 | 00:13:50 | 00:14:43 | 00:15:12 | 00:43:45 |
|
| 67 | 287 | 268 | Dan Mapp |
F
|
| 02:36:56 | 00:30:53 | 00:02:30 | 01:19:59 | 00:01:16 | 00:13:42 | 00:14:07 | 00:14:26 | 00:42:15 |
|
| 68 | 290 | 291 | Lars Menken |
F
|
| 02:37:33 | 00:24:05 | 00:03:19 | 01:17:07 | 00:01:40 | 00:16:33 | 00:17:18 | 00:17:30 | 00:51:21 |
|
| 69 | 291 | 45 | Steve Bonsell |
F
|
| 02:37:45 | 00:28:58 | 00:01:41 | 01:20:43 | 00:00:41 | 00:14:17 | 00:15:19 | 00:16:02 | 00:45:38 |
|
| 70 | 293 | 301 | Ian Morris |
F
|
| 02:38:08 | 00:28:49 | 00:02:14 | 01:20:00 | 00:00:55 | 00:14:47 | 00:15:43 | 00:15:38 | 00:46:08 |
|
| 71 | 297 | 100 | Verity Currie |
F
|
| 02:39:11 | 00:27:43 | 00:03:25 | 01:14:01 | 00:01:27 | 00:17:27 | 00:17:42 | 00:17:24 | 00:52:33 |
|
| 72 | 298 | 207 | Keturah Hughes |
F
|
| 02:39:48 | 00:20:45 | 00:04:42 | 01:23:10 | 00:01:14 | 00:16:02 | 00:16:51 | 00:17:01 | 00:49:54 |
|
| 73 | 305 | 318 | James Pace |
F
|
| 02:40:53 | 00:25:22 | 00:02:33 | 01:24:17 | 00:01:22 | 00:16:20 | 00:15:34 | 00:15:23 | 00:47:17 |
|
| 74 | 309 | 249 | Robert Lenton |
F
|
| 02:41:51 | 00:28:29 | 00:02:38 | 01:20:57 | 00:00:58 | 00:15:47 | 00:16:29 | 00:16:30 | 00:48:46 |
|
| 75 | 310 | 114 | Andrew Dodds |
F
|
| 02:41:55 | 00:31:15 | 00:03:40 | 01:16:50 | 00:01:16 | 00:15:47 | 00:16:00 | 00:17:04 | 00:48:51 |
|
| 76 | 319 | 460 | Janahan Tharma |
F
|
| 02:44:05 | 00:25:18 | 00:02:28 | 01:25:30 | 00:00:50 | 00:16:15 | 00:16:38 | 00:17:03 | 00:49:56 |
|
| 77 | 321 | 1 | Vicki Abberton |
F
|
| 02:44:14 | 00:26:22 | 00:01:27 | 01:22:16 | 00:01:01 | 00:17:23 | 00:18:03 | 00:17:40 | 00:53:06 |
|
| 78 | 324 | 437 | Lucy Williams |
F
|
| 02:44:44 | 00:33:28 | 00:01:31 | 01:22:08 | 00:00:58 | 00:15:08 | 00:15:37 | 00:15:51 | 00:46:36 |
|
| 79 | 326 | 149 | Laura Galpin |
F
|
| 02:45:16 | 00:26:35 | 00:01:24 | 01:19:42 | 00:01:07 | 00:18:02 | 00:19:03 | 00:19:21 | 00:56:26 |
|
| 80 | 327 | 185 | Lucy Hartwright |
F
|
| 02:45:28 | 00:27:45 | 00:01:27 | 01:23:38 | 00:00:59 | 00:16:59 | 00:17:15 | 00:17:24 | 00:51:38 |
|
| 81 | 344 | 77 | William Cartwright |
F
|
| 02:50:28 | 00:27:56 | 00:02:02 | 01:24:38 | 00:01:43 | 00:17:47 | 00:18:17 | 00:18:02 | 00:54:06 |
|
| 82 | 347 | 90 | Nigel Cooney |
F
|
| 02:51:22 | 00:32:52 | 00:02:16 | 01:21:38 | 00:02:01 | 00:16:49 | 00:17:48 | 00:17:57 | 00:52:34 |
|
| 83 | 350 | 424 | Jean-sebastien Vecten |
F
|
| 02:53:13 | 00:30:00 | 00:01:47 | 01:21:36 | 00:01:11 | 00:18:44 | 00:19:59 | 00:19:53 | 00:58:36 |
|
| 84 | 358 | 289 | Rebecca Meehan |
F
|
| 02:56:04 | 00:25:43 | 00:03:17 | 01:33:22 | 00:01:47 | 00:16:52 | 00:17:34 | 00:17:27 | 00:51:53 |
|
| 85 | 361 | 231 | Gemma Kilbey |
F
|
| 02:58:20 | 00:38:59 | 00:02:46 | 01:22:03 | 00:01:48 | 00:16:56 | 00:18:07 | 00:17:38 | 00:52:41 |
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 AND Results.Category = 'F')
, 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
|