8.8
26.11
20.11
27.11
27.11
27.11
27.11
24.10
17.10
4.9
21.11
10.10
26.9
17.8
25.8
26.8
6.9
19.8
8.9
9.10
31.8
23.8
4.9
20.11
21.11
13.11
10.10
16.10
21.11
19.9
20‐21.11
18.9
21.11
24.8
19.8
16.10
4.9
13.11
6.11
12‐14.11
6.11
3.10
2.10
8.10
12.9
19.8
28.8
30.10
19.9
12.9
7.11
7.11
24.10
16.10
19.9
7.11
19.9
10.10
18.9
16.10
5‐7.11
6.11
7.11
2.10
24.10
30.10
22.10
11.9
19.9
3.10
16.10
17.10
30.10
3.10
26.9
10.10
21.8
9.10
9.10
5.8
17.10
13.9
31.10
11.9
2.10
16.10
2.10
16.10
23.10
28.8
22.10
22.10
18.8
22.10
17.10
26.8
21‐22.9
24.10
24.10
9.10


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

1Amanuel GergisSWE
28:55
  
2Peter Glans
Peter Glans 93, DEN
29:06
93DEN
29:06
  
3David NilssonSWE
29:12
  
4Ole Hesselbjerg
Ole Hesselbjerg 90, DEN
29:22
90DEN
29:22
  
5Ørjan Grønnevig
Ørjan Grønnevig 91, NOR
29:24
91NOR
29:24
  
6Thijs Nijhuis
Thijs Nijhuis 92, DEN
29:25
92DEN
29:25
  
7Hlynur Andrésson
Hlynur Andrésson 93, ISL
29:26
93ISL
29:26
  
8Daniel LundgrenSWE
29:26
  
9Jaakko Piesanen
Jaakko Piesanen 93, FIN
29:27
93FIN
29:27
  
10Jonas Gertsen
Jonas Gertsen 98, DEN
29:28
98DEN
29:28
  
11Mikkel Dahl-Jessen
Mikkel Dahl-Jessen 94, DEN
29:34
94DEN
29:34
  
12Erik Udø Pedersen
Erik Udø Pedersen 94, NOR
29:42
94NOR
29:42
  
13Eivind Øygård
Eivind Øygård 92, NOR
29:46
92NOR
29:46
  
14Oscar ClaessonSWE
29:47
  
15Gabriel SteffensenSWE
29:52
  
16Trond Einar Moen Pedersli
Trond Einar Moen Pedersli 94, NOR
30:01
94NOR
30:01
  
17Miika Tenhunen
Miika Tenhunen 96, FIN
30:11
96FIN
30:11
  
18Jens Søndergaard Jensen
Jens Søndergaard Jensen 86, DEN
30:23
86DEN
30:23
  
19Jesper Faurschou
Jesper Faurschou 83, DEN
30:35
83DEN
30:35
  
20Jarkko Järvenpää
Jarkko Järvenpää 86, FIN
30:41
86FIN
30:41
  
21Andreas Schonberg Lommer
Andreas Schonberg Lommer 91, DEN
31:04
91DEN
31:04
  
22Hannu Granberg
Hannu Granberg 90, FIN
31:09
90FIN
31:09
  
23Gudni Páll Pálsson
Gudni Páll Pálsson 87, ISL
32:27
87ISL
32:27
  
24Thórólfur Ingi Thórsson
Thórólfur Ingi Thórsson 76, ISL
32:37
76ISL
32:37
  
25Sæmundur Ólafsson
Sæmundur Ólafsson 95, ISL
33:23
95ISL
33:23
  
26Vignir Már Lýdsson
Vignir Már Lýdsson 89, ISL
34:27
89ISL
34:27
  
27Vilhjálmur Thór Svansson
Vilhjálmur Thór Svansson 86, ISL
35:18
86ISL
35:18
  
P19 6 km terräng     


Final A

Final

1Håkon Stavik
Håkon Stavik 00, NOR
19:57
00NOR
19:57
  
2Omar IsmailSWE
19:59
  
3Emil Millán de la OlivaSWE
20:02
  
4Leevi Keronen
Leevi Keronen 00, FIN
20:10
00FIN
20:10
  
5Mika Kotiranta
Mika Kotiranta 00, FIN
20:18
00FIN
20:18
  
6Markus Kirk Kjeldsen
Markus Kirk Kjeldsen 01, DEN
20:24
01DEN
20:24
  
7Jonatan Andersen Vedvik
Jonatan Andersen Vedvik 00, NOR
20:28
00NOR
20:28
  
8Magnus Nyman Hall
Magnus Nyman Hall 99, DEN
20:30
99DEN
20:30
  
9Simon Nebijo Steinshamn
Simon Nebijo Steinshamn 99, NOR
20:31
99NOR
20:31
  
10Anton Østdal
Anton Østdal 01, DEN
20:31
01DEN
20:31
  
11Alexander Siedler Nielsen
Alexander Siedler Nielsen 99, DEN
20:47
99DEN
20:47
  
12Mustafe Muuse
Mustafe Muuse 01, FIN
20:54
01FIN
20:54
  
13Axel DjurbergSWE
21:13
  
14Tedros Gebretensai Haile
Tedros Gebretensai Haile 99, NOR
21:21
99NOR
21:21
  
15Julius Mäkinen
Julius Mäkinen 01, FIN
21:42
01FIN
21:42
  
16Dadi Arnarson
Dadi Arnarson 99, ISL
22:59
99ISL
22:59
  
17Dagbjartur Kristjánsson
Dagbjartur Kristjánsson 00, ISL
23:05
00ISL
23:05
  
18Andri Már Hannesson
Andri Már Hannesson 99, ISL
23:55
99ISL
23:55
  
Hlynur Ólason
Hlynur Ólason 01, ISL
DNF
01ISL
DNF
  
Alexander Tengblad Nikolaisen
Alexander Tengblad Nikolaisen 01, DEN
DNF
01DEN
DNF
  
Kvinnor
K 7.5 km terräng     


Final A

Final

1Anna Emilie Møller
Anna Emilie Møller 97, DEN
27:34
97DEN
27:34
  
2Lisa HavellSWE
27:41
  
3Sara ChristianssonSWE
27:44
  
4Maja Alm
Maja Alm 88, DEN
28:10
88DEN
28:10
  
5Sigrid Jervell VågNOR
28:22
  
6Silje Fjørtoft
Silje Fjørtoft 87, NOR
28:25
87NOR
28:25
  
7Sanna MustonenSWE
28:28
  
8Maria Sagnes Wågan
Maria Sagnes Wågan 92, NOR
25:38
92NOR
25:38
  
9Simone Glad
Simone Glad 90, DEN
28:47
90DEN
28:47
  
10Linn NilssonSWE
28:57
  
11Vienna Søyland Dahle
Vienna Søyland Dahle 92, NOR
29:06
92NOR
29:06
  
12Klaara Leponiemi
Klaara Leponiemi 98, FIN
30:00
98FIN
30:00
  
13Rebekka Fuglø
Rebekka Fuglø 93, DEN
30:09
93DEN
30:09
  
14Sara Schou Kristensen
Sara Schou Kristensen 97, DEN
30:21
97DEN
30:21
  
15Ilona Välimäki
Ilona Välimäki 92, FIN
31:01
92FIN
31:01
  
16Elín Edda Sigurðardóttir
Elín Edda Sigurðardóttir 89, ISL
31:09
89ISL
31:09
  
17Íris Anna Skúladóttir
Íris Anna Skúladóttir 89, ISL
31:21
89ISL
31:21
  
18Arndís Ýr Hafthorsdóttir
Arndís Ýr Hafthorsdóttir 88, ISL
31:50
88ISL
31:50
  
19Helga Gudný Elíasdóttir
Helga Gudný Elíasdóttir 94, ISL
32:22
94ISL
32:22
  
20Rannveig Oddsdóttir
Rannveig Oddsdóttir 73, ISL
32:40
73ISL
32:40
  
21Anna Berglind Pálmadóttir
Anna Berglind Pálmadóttir 79, ISL
34:25
79ISL
34:25
  
Annemari Kiekara
Annemari Kiekara 77, FIN
DNF
77FIN
DNF
  
Aníta Hinriksdóttir
Aníta Hinriksdóttir 96, ISL
DNF
96ISL
DNF
  
F19 4.5 km terräng     


Final A

Final

1Moona Korkealaakso
Moona Korkealaakso 02, FIN
16:53
02FIN
16:53
  
2Laura Valgreen Petersen
Laura Valgreen Petersen 00, DEN
16:56
00DEN
16:56
  
3Astrid Snäll
Astrid Snäll 99, FIN
16:56
99FIN
16:56
  
4Emma Kirkeberg Mørk
Emma Kirkeberg Mørk 02, NOR
17:13
02NOR
17:13
  
5Emilia LillemoSWE
17:26
  
6Kristine Mygind Sørensen
Kristine Mygind Sørensen 02, DEN
17:30
02DEN
17:30
  
7Christine Næss
Christine Næss 00, NOR
17:32
00NOR
17:32
  
8Sophie Søefeldt
Sophie Søefeldt 00, DEN
17:42
00DEN
17:42
  
9Anna Mark Helwigh
Anna Mark Helwigh 00, DEN
17:46
00DEN
17:46
  
10Vera SjöbergSWE
17:47
  
11Salla Laukkanen
Salla Laukkanen 00, FIN
17:54
00FIN
17:54
  
12Emilie Mo
Emilie Mo 01, NOR
17:59
01NOR
17:59
  
13Linnéa SennströmSWE
18:13
  
14Pinja Kotinurmi
Pinja Kotinurmi 02, FIN
18:24
02FIN
18:24
  
15Sara Mjöll Smáradóttir
Sara Mjöll Smáradóttir 00, ISL
20:02
00ISL
20:02
  
16Sólrún Soffía Arnardóttir
Sólrún Soffía Arnardóttir 01, ISL
20:50
01ISL
20:50