Lytchett Manor Striders
SELECT minResult, FirstName, surname, raceName, raceDate, gender FROM (SELECT r.*, eventKey AS eK, resultKey FROM (SELECT MIN(`result`) AS minResult, `personKey` as pK, NonLMS FROM `results` NATURAL JOIN `events` NATURAL JOIN `eventParents` WHERE `distanceKey` = 'MAR' and `excludePerformance` = 0 GROUP BY `personKey` ) AS r LEFT JOIN `results` ON resultKey WHERE r.pK = results.personKey AND r.minResult = results.result) AS r2 LEFT JOIN `people` ON personKey=pK LEFT JOIN `events` ON eventKey=eK WHERE 1=1 AND NonLMS IS NULL ORDER BY minResult

Fastest LMS Performances

# Time Runner Race Date
102:42:00Steve CannonNorth Dorset Marathon06/05/12
202:47:40Scott ParfittManchester Marathon19/04/15
302:49:17Mark WilsonLondon Marathon16/04/00
402:49:48Lee DempsterManchester Marathon19/04/15
502:52:28Craig OBrienNew Forest Marathon09/09/01
602:53:58Sean EdwardsNorth Dorset Marathon30/04/17
702:54:29John CakebreadLondon Marathon17/04/05
802:54:32Nigel RogersonLondon Marathon21/04/13
902:56:01Nick Gavin Dublin Marathon25/10/10
1002:56:18Pete RabjohnsLondon Marathon18/04/04
1103:02:39Kevin HaynesLondon Marathon17/04/05
1203:03:31Russ ConwayLondon Marathon18/04/04
1303:06:49Gary TrowBournemouth Marathon05/10/14
1403:06:51Ian ChurchwardLondon Marathon22/04/07
1503:07:38Robbie BurnsLondon Marathon13/04/03
1603:08:57George BoothLondon Marathon18/04/99
1703:10:41Steve NethercottLondon Marathon26/04/09
1803:11:13Nigel HelmLondon Marathon26/04/15
1903:11:55Tom AndrewsAthens Marathon12/11/17
2003:12:10Kirsten KnowlesLondon Marathon18/04/99
2103:14:04Tony PeachLondon Marathon17/04/11
2203:19:05Carly ReadingsParis Marathon12/04/15
2303:22:23John DermodyLondon Marathon22/04/01
2403:23:07Alex ThompsonLittledown Marathon03/07/16
2503:23:20Jim WalshLondon Marathon16/04/00
2603:24:03Brian SandersonLondon Marathon23/04/06
2703:24:36Stephen LittlecottTaunton Marathon06/04/03
2803:26:34Jemma MurrayAbingdon Marathon23/10/16
2903:26:49David WhiddonShakespeare Marathon29/04/07
3003:27:20Mark DornanLondon Marathon13/04/03
3103:28:25Judith VlaarkampLondon Marathon22/04/12
3203:28:58Gary CoxEdinburgh Marathon25/05/08
3303:30:02David DentLondon Marathon23/04/06
3403:30:07Gary Williams-LucasLondon Marathon22/04/01
3503:31:04Hamish MurrayLondon Marathon13/04/08
3603:32:08Lee PullenBournemouth Marathon08/10/17
3703:32:50David RiglerLondon Marathon22/04/12
3803:34:52Gareth JohnsonBournemouth Marathon05/10/14
3903:35:16Tom HicksLondon Marathon24/04/16
4003:35:25Paula WrightNorth Dorset Marathon30/04/17
4103:36:50Matt BrookerLondon Marathon18/04/99
4203:37:36David SargentBournemouth Marathon02/10/16
4303:37:43Martin SmithNorth Dorset Marathon30/04/17
4403:38:13Matt BosanquetDorchester Marathon28/05/17
4503:39:00Carolyn SalzanoLondon Marathon16/04/00
4603:40:09Kaye NippardLondon Marathon24/04/16
4703:41:00Richard PhilpBrighton Marathon15/04/12
4803:41:08Tim WelfordBournemouth Marathon04/10/15
4903:41:48David SawyerNeolithic Marathon01/05/16
5003:41:59Kirsten LeonardLondon Marathon18/04/04
5103:42:05Barry TellingBerlin Marathon24/09/06
5203:42:21Mark StaceyBrighton Marathon12/04/15
5303:42:39Gary IrishLondon Marathon25/04/10
5403:42:53Steve CooperLondon Marathon26/04/09
5503:44:15Trevor FinnisSouthampton Marathon23/04/17
5603:45:25Chris KeevilLondon Marathon18/04/99
5703:45:45Olga Rodriguez BromidgeManchester Marathon19/04/15
5803:47:48Martin GreensladeLondon Marathon17/04/11
5903:48:31Sue JonesBrighton Marathon16/04/16
6003:48:39Russell FalettoBournemouth Marathon05/10/14
6103:48:40Helen RichardsLondon Marathon24/04/16
6203:50:00Tracey HarveyTaunton Marathon12/04/15
6303:50:00Heather NethercottBournemouth Marathon05/10/14
6403:50:11Tony WeaverIsle of Wight Marathon09/10/17
6503:50:40Kate ConwayLondon Marathon23/04/06
6603:50:49Simon MooreBournemouth Marathon08/10/17
6703:51:09Karl WhitfieldNorth Dorset Marathon05/05/13
6803:51:47Judith ScarfeAbingdon Marathon22/10/17
6903:52:26Russ MarandeNew Forest Marathon27/09/09
7003:53:25Jenny Walker-LeachBrighton Marathon12/04/15
7103:54:00Dave SmithRock n Roll Liverpool Marathon28/05/17
7203:54:10Robin DickensLondon Marathon16/04/00
7303:54:43Sue TuckerLondon Marathon22/04/01
7403:54:53Rob CooperParis Marathon06/04/08
7503:54:59Laura WilkinsonLondon Marathon17/04/05
7603:55:12Elaine HiggsLondon Marathon17/04/11
7703:56:00Ian TownsendLondon Marathon16/04/00
7803:56:09Pete McMahonLake Garda Marathon10/10/10
7903:56:19David RustellNorth Dorset Marathon01/05/16
8003:57:02Mick Falcous-GillSnowdonia Marathon31/10/99
8103:57:10Meineck DanLondon Marathon23/04/17
8203:57:12Bruce GhinnLondon Marathon21/04/13
8303:57:46Sue NobleLondon Marathon17/04/05
8403:57:48Dani PreedyLondon Marathon18/04/99
8503:57:58Elizabeth Johnston TrowBournemouth Marathon06/10/13
8603:59:15Donna PearceLondon Marathon26/04/09
8703:59:32Dan MeineckBrighton Marathon16/04/16
8803:59:35John MorrisAthens Marathon12/11/17
8904:01:41Hayley DornanLondon Marathon13/04/03
9004:02:00Christopher BillinghurstBournemouth Marathon04/10/15
9104:03:25Phil BrookerLondon Marathon18/04/99
9204:03:26Dougie ScarfeLondon Marathon26/04/15
9304:06:50Michael NairnTaunton Marathon12/04/15
9404:07:14Julie SpratleyNorth Dorset Marathon06/05/12
9504:07:53Kate RabjohnsBrighton Marathon16/04/16
9604:08:24Mike CutlerLondon Marathon17/04/05
9704:08:41Alison HoultonParis Marathon15/04/12
9804:09:54Kirsty WestonAthens Marathon12/11/17
9904:10:58Jill Falcous-GillLondon Marathon18/04/99
10004:11:35Chris LovellLondon Marathon13/04/08
10104:14:19Steve ColeDorchester Marathon28/05/17
10204:15:19Kate MillarSnowdonia Marathon31/10/99
10304:16:14Penny EttlingLondon Marathon13/04/08
10404:16:56David HatchLondon Marathon18/04/99
10504:19:04Julie SpencerLondon Marathon22/04/01
10604:19:41Spencer CheungEdinburgh Marathon31/05/09
10704:20:00Gary JordanLondon Marathon14/04/02
10804:20:29Heather BrainLondon Marathon16/04/00
10904:22:33Phillipa RolleAbingdon Marathon22/10/17
11004:23:13Nicola PhilpBrighton Marathon15/04/12
11104:23:46Scott MordewDorchester Marathon28/05/17
11204:24:23Elizabeth BakerLondon Marathon17/04/05
11304:24:25Marli MorlandBrighton Marathon09/04/17
11404:26:44Sheena HudsonLondon Marathon14/04/02
11504:27:35Rob BrownLondon Marathon26/04/09
11604:28:30Kevin SheldrakeLondon Marathon17/04/05
11704:29:37Bill OakleyParis Marathon06/04/08
11804:31:20Aaron WebbLondon Marathon25/04/10
11904:32:00Rachel BelfordLondon Marathon16/04/00
12004:33:04Liz HullLondon Marathon18/04/04
12104:34:23Wendy RichmondLondon Marathon14/04/02
12204:36:45Helen YeomanLondon Marathon13/04/08
12304:37:01Clare WelfordBournemouth Marathon06/10/13
12404:37:08Carla HamptonBrighton Marathon16/04/16
12504:37:50Sarah JaquesLondon Marathon17/04/05
12604:39:21Tia DykeSouth Downs Marathon01/07/07
12704:39:40Linda NixonLondon Marathon18/04/99
12804:40:47Andrea YoungLondon Marathon26/04/09
12904:41:32Sarah ClarkAthens Marathon12/11/17
13004:42:32Clyde McPhersonBournemouth Marathon08/10/17
13104:42:52Kate HughesNorth Dorset Marathon03/05/15
13204:46:05Julie BlinkhornLondon Marathon16/04/00
13304:46:46Nathan BotleyLondon Marathon21/04/13
13404:48:23Steve VincentBournemouth Marathon04/10/15
13504:49:00Hayley VincentBournemouth Marathon05/10/14
13604:50:44Michaela ParkerLondon Marathon18/04/04
13704:51:51Nicola TwissellLondon Marathon21/04/13
13804:52:15Tamsin MilesBournemouth Marathon08/10/17
13904:52:22Julie JoblingLondon Marathon18/04/99
14004:54:14Bex JohnsonLarmer Tree Marathon15/03/15
14104:54:29Rob DruryLondon Marathon22/04/01
14204:59:00Cheryl GhinnNorth Dorset Marathon05/05/13
14305:04:24Mark JonesNew Forest Marathon09/09/01
14405:05:00Kenneth OxfordLondon Marathon16/04/00
14505:06:06Caroline BryantLondon Marathon17/04/05
14605:09:31Caroline DoddEdinburgh Marathon23/05/10
14705:11:21Tanya FarrarBournemouth Marathon06/10/13
14805:15:00Andy HarrisLondon Marathon16/04/00
14905:17:10Adam JafferBournemouth Marathon02/10/16
15005:20:19Louise HatchLondon Marathon23/04/06
15105:24:30Roger CooperPurbeck Marathon17/09/17
15205:25:51Amanda SmartNew Forest Marathon16/09/07
15305:30:13Weaver TonyLarmer Tree Marathon12/03/17
15405:42:37Lesley WhiteBournemouth Marathon06/10/13
15505:44:53Peter CollinsMarathon du Medoc 13/09/14
15605:44:54Colin ShearingMarathon du Medoc 13/09/14
15705:46:20Catherine ShelleyBeachy Head Off-Road Marathon28/10/12
15805:52:22Fred WatsonLondon Marathon22/04/07
15905:53:23Jonathan WattsDorset Invader Marathon17/07/16
16005:55:13Linda TreaysLondon Marathon23/04/06
16105:57:53Stephen MartinGiants Head Marathon25/06/16
16206:04:20Lisa BissetBerlin Marathon24/09/17
16306:40:52Beverley TreweekLondon Marathon21/04/13