Friidrottsstatistik

Senaste resultaten

8.8	Norrtälje Norrtälje Stadslopp
26.11	Öllsjö Kasttävling
20.11	Falkenberg Falkenbergs Höstmil
27.11	Vällingby Uttagning Terräng-EM
27.11	Varberg Julbockspelen
27.11	Linköping Folkungaspelen
27.11	Örebro Triumfglass-spelen
24.10	Valö Castorama
17.10	Valö Castorama
4.9	Hässleholm Hässleholmsloppet
21.11	Växjö Klubbmästerskap
10.10	Valö Kasttävling
26.9	Valö Kasttävling
17.8	Jönköping Blodomloppet
25.8	Västerås Blodomloppet
26.8	Karlstad Blodomloppet
6.9	Timrå Blodomloppet
19.8	Borlänge Blodomloppet
8.9	Växjö Blodomloppet
9.10	Malmö Blodomloppet
31.8	Halmstad Blodomloppet
23.8	Östersund Blodomloppet
4.9	Mjölby Mjölby Stadslopp
20.11	Örebro Vinterspelen
21.11	Öllsjö Resultattävling
13.11	Värnamo Vintermaraton
10.10	Stockholm Stockholm Minimarathon
16.10	Stockholm Tjurruset
21.11	Bollnäs Lagtävling 12-17 år
19.9	Stockholm STHLM Trail Run
20‐21.11	Göteborg/FH Göteborgs Adventsspel
18.9	Örebro Bergslagsleden Ultra
21.11	Huddinge Första chansen
24.8	Simrishamn Kretsmästerskap
19.8	Stockholm STHLM 10
16.10	Stockholm Kalvruset
4.9	Göteborg Fredsloppet
13.11	Uppsala Kasttävling
6.11	Västerås/Ap Halloweenkastet
12‐14.11	Västerås IVSM
6.11	Stockholm Höstrusket
3.10	Enskede Hammarbys ungdoms-castorama 2
2.10	Enskede Hammarbys ungdoms-castorama 1
8.10	Stockholm ASICS Stockholm High Five
12.9	Uddevalla Lilla Bohusspelen
19.8	Stockholm STHLM Junior Run
28.8	Stockholm ASICS Premiärmilen
30.10	Värnamo WärnamoMilen
19.9	Sölvesborg Ryssberget Trail
12.9	Norrköping Castorama
7.11	Falun Resultattävling
7.11	Falun IVDM Dalarna
24.10	Falun IVDM Dalarna
16.10	Sävedalen Sävedalsloppet
19.9	Olofström Kasttävling
7.11	Tullinge Långa Tullinge-Tumbaloppet
19.9	Olofström Castorama
10.10	Valö Castorama
18.9	Finspång OMT Finspångs Stadslopp
16.10	Vretstorp DM-UDM-VDM Terräng
5‐7.11	Sävedalen Sävedalen Inomhus
6.11	Sollentuna Rekordjakten
7.11	Tullinge NM-JNM Terräng
2.10	Umeå DM-UDM-VDM Terräng 4 km
24.10	Huddinge Castorama
30.10	Umeå KM Terräng
22.10	Höganäs SM-löpet
11.9	Nora VSM Halvmaraton
19.9	Hallsberg Tarstaborgsrundan
3.10	Örebro Hostruset 5 km väg
16.10	Varberg Varberg Halvmarathon
17.10	Ystad DM-JDM-VDM 10 km väg
30.10	Helsingborg GGP 1 timme
3.10	Valö Castorama
26.9	Valö Castorama
10.10	Falun Resultattävling
21.8	Vintrosa Vintrosaloppet
9.10	Göteborg VSM Maraton
9.10	Göteborg Göteborg Marathon
5.8	Katrineholm Höjdtävling
17.10	Falun Resultattävling
13.9	Uppsala Hopptävling
31.10	Falun Resultattävling
11.9	Vänersborg Skräcklanmaran
2.10	Bromma Tolvanloppet
16.10	Södertälje Täljemilen
2.10	Uddevalla USK-loppet
16.10	Danderyd Stavtävling
23.10	Sätra KM inomhus
28.8	Skövde Hagenloppet
22.10	Bottnaryd Kastfemkamp
22.10	Bottnaryd Kasttävling
18.8	Vaxholm Strömmingsloppet
22.10	Bottnaryd Castorama
17.10	Sandviken Kasttävling
26.8	Mjölby Mjölbyfemman
21‐22.9	Sollentuna DM-JDM-UDM-VDM Terräng
24.10	Oskarshamn Havslättsmarodören
24.10	Henån Kultävling
9.10	Nacka Hellasloppet

Resultat: Nordic Cross Country Championships, Reykjavik ISL 10.11.18 Terräng

select distinct results18.*, womenpbestsweden.BB AS PBwomen, womensbestsweden.BB AS SBwomen, CASE WHEN EventN IN (910, 193, 9998, 9999) THEN EventN+RealMetres/100 ELSE EventN END AS RealEventN, RealEventN AS RealEventN2, '' AS SM, countries.Countryfull, Events.Event AS eventry, results18.Ind AS Indiiy, results18.ID AS ID, results18.ID AS IDI, Events.TF AS type, results18.eventname AS en2, results18.Country AS RealCountry, IF(EndDate Is Null,'',CONCAT(DAYOFMONTH(results18.Date),' ')) AS Datti1, IF(EndDate Is Null,'',substring(Monthname(results18.Date),1,3)) AS Datti2, Round.Roundname, Events.Eventname, Pos.PosName, Sex.Sexi, CASE WHEN results18.AGO IN (12,15) THEN b.AGName ELSE a.AGName END AS AGName, CASE WHEN results18.AGO IN (12,15) THEN b.AGO ELSE a.AGO END AS agoo, `2010`.irrelagularities.Irrname, CASE WHEN results18.Sex = 1 THEN `2010`.menwl.BB ELSE `2010`.womenwl.BB END AS WL, CASE WHEN results18.Sex = 1 THEN `2010`.menwl.Standing ELSE `2010`.womenwl.Standing END AS Standingi, CASE WHEN results18.Date<=Club10end THEN Club10 WHEN results18.Date<=Club9end THEN Club9 WHEN results18.Date<=Club8end THEN Club8 WHEN results18.Date<=Club7end THEN Club7 WHEN results18.Date<=Club6end THEN Club6 WHEN results18.Date<=Club5end THEN Club5 WHEN results18.Date<=Club4end THEN Club4 WHEN results18.Date<=Club3end THEN Club3 WHEN results18.Date<=Club2end THEN Club2 ELSE sweclubsat.Club END AS RealClub, posswe.PosName AS posswe, combinedmen.eventno AS combM, combinedwomen.eventno AS combW FROM results18 LEFT JOIN `2010`.sweclubsat ON sweclubsat.ID=results18.ID AND CASE WHEN results18.Sex=1 and (results18.secondarypos not rlike ('K|F') or results18.secondarypos is null) THEN sweclubsat.gender='M' ELSE sweclubsat.gender='W' END LEFT JOIN (SELECT events.*, eventsext.Orderi AS RealEventN FROM events LEFT JOIN `2010`.eventsext ON events.Event=eventsext.Event) AS Events ON CAST(results18.EventN AS UNSIGNED) = Events.Orderi LEFT JOIN Sex ON results18.Sex = Sex.Sex LEFT JOIN Comp ON results18.CID = Comp.CID LEFT JOIN AG as a ON results18.AGO = a.AGO LEFT JOIN AG as b ON results18.Points = b.AgeGroup LEFT OUTER JOIN Pos ON results18.PosOrderg = Pos.Orderi LEFT OUTER JOIN Round ON results18.Round = Round.Ro LEFT JOIN `2010`.irrelagularities ON `2010`.irrelagularities.Irr = results18.Irr LEFT JOIN `2010`.menwl ON `2010`.menwl.iid = results18.iid LEFT JOIN `2010`.womenwl ON `2010`.womenwl.iid = results18.iid LEFT JOIN world.countries ON results18.Country=countries.Country LEFT JOIN results.posswe ON results18.PosOrderg = posswe.Orderi LEFT JOIN `2010`.combinedmen ON results18.IID=combinedmen.parentid AND results18.Sex=1 LEFT JOIN `2010`.combinedwomen ON results18.IID=combinedwomen.parentid AND results18.Sex=2 LEFT JOIN `2010`.womenpbestsweden ON results18.iid=womenpbestsweden.iid AND (results18.Sex=2 OR results18.secondarypos rlike ('K|F')) AND womenpbestsweden.Roundi IS NULL LEFT JOIN `2010`.womensbestsweden ON results18.iid=womensbestsweden.iid AND (results18.Sex=2 OR results18.secondarypos rlike ('K|F')) AND womensbestsweden.Roundi IS NULL WHERE results18.CID= 12913427 AND `2010`.womenwl.Roundi IS NULL AND `2010`.menwl.Roundi IS NULL ORDER BY Sex, CASE WHEN results18.AGO=15 THEN COALESCE(agoo,0)+100000 ELSE agoo END, combM, combW, RealEventN2, RealEventN, CASE WHEN results18.AGO=12 THEN 999999 ELSE results18.AGO END, results18.Round, Posorderg, CASE WHEN Remarks Is Not Null THEN CASE WHEN Pos1>0 THEN 2 ELSE 3 END ELSE CASE WHEN Pos1>0 THEN 0 ELSE 1 END END, CASE WHEN Pos1 IS NOT NULL THEN Pos1 ELSE 999999 END, SortResult, RealMetres DESC

Män
M 9 km terräng Final A Final
1	Amanuel Gergis Amanuel Gergis 96, SWE 28:55	96	SWE	28:55	=
2	Peter Glans Peter Glans 93, DEN 29:06	93	DEN	29:06	=
3	David Nilsson David Nilsson 87, SWE 29:12	87	SWE	29:12	=
4	Ole Hesselbjerg Ole Hesselbjerg 90, DEN 29:22	90	DEN	29:22	=
5	Ørjan Grønnevig Ørjan Grønnevig 91, NOR 29:24	91	NOR	29:24	=
6	Thijs Nijhuis Thijs Nijhuis 92, DEN 29:25	92	DEN	29:25	=
7	Hlynur Andrésson Hlynur Andrésson 93, ISL 29:26	93	ISL	29:26	=
8	Daniel Lundgren Daniel Lundgren 85, SWE 29:26	85	SWE	29:26	=
9	Jaakko Piesanen Jaakko Piesanen 93, FIN 29:27	93	FIN	29:27	=
10	Jonas Gertsen Jonas Gertsen 98, DEN 29:28	98	DEN	29:28	=
11	Mikkel Dahl-Jessen Mikkel Dahl-Jessen 94, DEN 29:34	94	DEN	29:34	=
12	Erik Udø Pedersen Erik Udø Pedersen 94, NOR 29:42	94	NOR	29:42	=
13	Eivind Øygård Eivind Øygård 92, NOR 29:46	92	NOR	29:46	=
14	Oscar Claesson Oscar Claesson 95, SWE 29:47	95	SWE	29:47	=
15	Gabriel Steffensen Gabriel Steffensen 96, SWE 29:52	96	SWE	29:52	=
16	Trond Einar Moen Pedersli Trond Einar Moen Pedersli 94, NOR 30:01	94	NOR	30:01	=
17	Miika Tenhunen Miika Tenhunen 96, FIN 30:11	96	FIN	30:11	=
18	Jens Søndergaard Jensen Jens Søndergaard Jensen 86, DEN 30:23	86	DEN	30:23	=
19	Jesper Faurschou Jesper Faurschou 83, DEN 30:35	83	DEN	30:35	=
20	Jarkko Järvenpää Jarkko Järvenpää 86, FIN 30:41	86	FIN	30:41	=
21	Andreas Schonberg Lommer Andreas Schonberg Lommer 91, DEN 31:04	91	DEN	31:04	=
22	Hannu Granberg Hannu Granberg 90, FIN 31:09	90	FIN	31:09	=
23	Gudni Páll Pálsson Gudni Páll Pálsson 87, ISL 32:27	87	ISL	32:27	=
24	Thórólfur Ingi Thórsson Thórólfur Ingi Thórsson 76, ISL 32:37	76	ISL	32:37	=
25	Sæmundur Ólafsson Sæmundur Ólafsson 95, ISL 33:23	95	ISL	33:23	=
26	Vignir Már Lýdsson Vignir Már Lýdsson 89, ISL 34:27	89	ISL	34:27	=
27	Vilhjálmur Thór Svansson Vilhjálmur Thór Svansson 86, ISL 35:18	86	ISL	35:18	=
P19 6 km terräng Final A Final
1	Håkon Stavik Håkon Stavik 00, NOR 19:57	00	NOR	19:57	=
2	Omar Ismail Omar Ismail 00, SWE 19:59	00	SWE	19:59	=
3	Emil Millán de la Oliva Emil Millán de la Oliva 01, SWE 20:02	01	SWE	20:02	=
4	Leevi Keronen Leevi Keronen 00, FIN 20:10	00	FIN	20:10	=
5	Mika Kotiranta Mika Kotiranta 00, FIN 20:18	00	FIN	20:18	=
6	Markus Kirk Kjeldsen Markus Kirk Kjeldsen 01, DEN 20:24	01	DEN	20:24	=
7	Jonatan Andersen Vedvik Jonatan Andersen Vedvik 00, NOR 20:28	00	NOR	20:28	=
8	Magnus Nyman Hall Magnus Nyman Hall 99, DEN 20:30	99	DEN	20:30	=
9	Simon Nebijo Steinshamn Simon Nebijo Steinshamn 99, NOR 20:31	99	NOR	20:31	=
10	Anton Østdal Anton Østdal 01, DEN 20:31	01	DEN	20:31	=
11	Alexander Siedler Nielsen Alexander Siedler Nielsen 99, DEN 20:47	99	DEN	20:47	=
12	Mustafe Muuse Mustafe Muuse 01, FIN 20:54	01	FIN	20:54	=
13	Axel Djurberg Axel Djurberg 99, SWE 21:13	99	SWE	21:13	=
14	Tedros Gebretensai Haile Tedros Gebretensai Haile 99, NOR 21:21	99	NOR	21:21	=
15	Julius Mäkinen Julius Mäkinen 01, FIN 21:42	01	FIN	21:42	=
16	Dadi Arnarson Dadi Arnarson 99, ISL 22:59	99	ISL	22:59	=
17	Dagbjartur Kristjánsson Dagbjartur Kristjánsson 00, ISL 23:05	00	ISL	23:05	=
18	Andri Már Hannesson Andri Már Hannesson 99, ISL 23:55	99	ISL	23:55	=
	Hlynur Ólason Hlynur Ólason 01, ISL DNF	01	ISL	DNF	=
	Alexander Tengblad Nikolaisen Alexander Tengblad Nikolaisen 01, DEN DNF	01	DEN	DNF	=
Kvinnor
K 7.5 km terräng Final A Final
1	Anna Emilie Møller Anna Emilie Møller 97, DEN 27:34	97	DEN	27:34	=
2	Lisa Havell Lisa Havell 88, SWE 27:41	88	SWE	27:41	=
3	Sara Christiansson Sara Christiansson 97, SWE 27:44	97	SWE	27:44	=
4	Maja Alm Maja Alm 88, DEN 28:10	88	DEN	28:10	=
5	Sigrid Jervell Våg Sigrid Jervell Våg 92, NOR 28:22	92	NOR	28:22	=
6	Silje Fjørtoft Silje Fjørtoft 87, NOR 28:25	87	NOR	28:25	=
7	Sanna Mustonen Sanna Mustonen 91, SWE 28:28	91	SWE	28:28	=
8	Maria Sagnes Wågan Maria Sagnes Wågan 92, NOR 25:38	92	NOR	25:38	=
9	Simone Glad Simone Glad 90, DEN 28:47	90	DEN	28:47	=
10	Linn Nilsson Linn Nilsson 90, SWE 28:57	90	SWE	28:57	=
11	Vienna Søyland Dahle Vienna Søyland Dahle 92, NOR 29:06	92	NOR	29:06	=
12	Klaara Leponiemi Klaara Leponiemi 98, FIN 30:00	98	FIN	30:00	=
13	Rebekka Fuglø Rebekka Fuglø 93, DEN 30:09	93	DEN	30:09	=
14	Sara Schou Kristensen Sara Schou Kristensen 97, DEN 30:21	97	DEN	30:21	=
15	Ilona Välimäki Ilona Välimäki 92, FIN 31:01	92	FIN	31:01	=
16	Elín Edda Sigurðardóttir Elín Edda Sigurðardóttir 89, ISL 31:09	89	ISL	31:09	=
17	Íris Anna Skúladóttir Íris Anna Skúladóttir 89, ISL 31:21	89	ISL	31:21	=
18	Arndís Ýr Hafthorsdóttir Arndís Ýr Hafthorsdóttir 88, ISL 31:50	88	ISL	31:50	=
19	Helga Gudný Elíasdóttir Helga Gudný Elíasdóttir 94, ISL 32:22	94	ISL	32:22	=
20	Rannveig Oddsdóttir Rannveig Oddsdóttir 73, ISL 32:40	73	ISL	32:40	=
21	Anna Berglind Pálmadóttir Anna Berglind Pálmadóttir 79, ISL 34:25	79	ISL	34:25	=
	Annemari Kiekara Annemari Kiekara 77, FIN DNF	77	FIN	DNF	=
	Aníta Hinriksdóttir Aníta Hinriksdóttir 96, ISL DNF	96	ISL	DNF	=
F19 4.5 km terräng Final A Final
1	Moona Korkealaakso Moona Korkealaakso 02, FIN 16:53	02	FIN	16:53	=
2	Laura Valgreen Petersen Laura Valgreen Petersen 00, DEN 16:56	00	DEN	16:56	=
3	Astrid Snäll Astrid Snäll 99, FIN 16:56	99	FIN	16:56	=
4	Emma Kirkeberg Mørk Emma Kirkeberg Mørk 02, NOR 17:13	02	NOR	17:13	=
5	Emilia Lillemo Emilia Lillemo 00, SWE 17:26	00	SWE	17:26	=
6	Kristine Mygind Sørensen Kristine Mygind Sørensen 02, DEN 17:30	02	DEN	17:30	=
7	Christine Næss Christine Næss 00, NOR 17:32	00	NOR	17:32	=
8	Sophie Søefeldt Sophie Søefeldt 00, DEN 17:42	00	DEN	17:42	=
9	Anna Mark Helwigh Anna Mark Helwigh 00, DEN 17:46	00	DEN	17:46	=
10	Vera Sjöberg Vera Sjöberg 01, SWE 17:47	01	SWE	17:47	=
11	Salla Laukkanen Salla Laukkanen 00, FIN 17:54	00	FIN	17:54	=
12	Emilie Mo Emilie Mo 01, NOR 17:59	01	NOR	17:59	=
13	Linnéa Sennström Linnéa Sennström 00, SWE 18:13	00	SWE	18:13	=
14	Pinja Kotinurmi Pinja Kotinurmi 02, FIN 18:24	02	FIN	18:24	=
15	Sara Mjöll Smáradóttir Sara Mjöll Smáradóttir 00, ISL 20:02	00	ISL	20:02	=
16	Sólrún Soffía Arnardóttir Sólrún Soffía Arnardóttir 01, ISL 20:50	01	ISL	20:50	=