17.10
26.8
21‐22.9
24.10
24.10
9.10
19.10
3.10
23.10
4.9
16.10
17.10
24.10
24.10
24.10
21.10
23.10
23‐24.10
9.9
17.10
16.10
23.10
23.10
22.10
21.10
10.10
9.10
10.10
27.9
3.10
9.10
18.9
2.10
17.10
2.10
18.9
16.10
10.10
14.10
30.9
30.9
16.10
16.10
16.10
3.10
17.10
14.10
9.10
3.10
10.10
17.10
17.10
16.10
16.10
3.10
26.9
13.10
7.10
14.10
9.10
28.8
6.10
9.10
13.10
9.10
9.10
9.10
12.10
9.10
19.9
12.10
10.10
10.10
9.10
10.10
3.10
10.10
10.10
10.10
10.10
10.10
10.10
10.10
10.10
10.10
9.10
9.10
3.10
30.9
10.10
25.9
13.9
27.9
19.9
9.10
3.10
26.9
9.10
7.10
7.10
Tävlande: 62 (40+22)   Starter: 62 (40+22)


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


Final A

Final

1Andrzej Jaros
Andrzej Jaros 90, POL
47.41
90POL
47.41
SB
  
2Cezary Mirosław
Cezary Mirosław 97, POL
47.94
97POL
47.94
  
3Markus Einan
Markus Einan 97, NOR
48.18
97NOR
48.18
SB
  
4Luca Thompson
Luca Thompson 00, NOR
48.66
00NOR
48.66
SB
  
M 1500 m     


Final A

Final

1Thomas Roth
Thomas Roth 91, NOR
3:45.08
91NOR
3:45.08
SB
  
2Marius Øyre Vedvik
Marius Øyre Vedvik 92, NOR
3:45.77
92NOR
3:45.77
PB
  
3Emil DanielssonSWE
3:45.87
SB
  
4Jacob Boutera
Jacob Boutera 96, NOR
3:45.96
96NOR
3:45.96
  
5Per Svela
Per Svela 92, NOR
3:47.38
92NOR
3:47.38
PB
  
6Ferdinand Kvan Edman
Ferdinand Kvan Edman 93, NOR
3:47.43
93NOR
3:47.43
  
7Peter Glans
Peter Glans 93, DEN
3:47.55
93DEN
3:47.55
SB
  
8Even Brøndbo Dahl
Even Brøndbo Dahl 94, NOR
3:48.66
94NOR
3:48.66
  
9Didrik Hexeberg Warlo
Didrik Hexeberg Warlo 99, NOR
3:48.75
99NOR
3:48.75
PB
  
10Andreas Holst Lindgreen
Andreas Holst Lindgreen 98, DEN
3:49.02
98DEN
3:49.02
SB
  
11Erik Udø Pedersen
Erik Udø Pedersen 94, NOR
3:49.31
94NOR
3:49.31
SB
  
12Fredrik Sandvik
Fredrik Sandvik 98, NOR
3:50.55
98NOR
3:50.55
SB
  
13Mats Hauge
Mats Hauge 97, NOR
3:51.98
97NOR
3:51.98
  
14Abubakar AbdullahiSWE
3:52.47
  
15Johan WalldénSWE
4:03.64
  
Håkon Mushom
Håkon Mushom 93, NOR
DNF
93NOR
DNF
  
John FoitzikSWE
DNF
  
Final B
1Moa Abounnachat Bollerød
Moa Abounnachat Bollerød 01, NOR
3:51.95
01NOR
3:51.95
SB
  
2Thomas Myklebust Heggøy
Thomas Myklebust Heggøy 94, NOR
3:54.59
94NOR
3:54.59
SB
  
3Gustav Berlin
3:54.68
SWE
3:54.68
  
4Alexander HolmbladSWE
3:54.86
  
5Simon WallenlindSWE
3:55.46
SB
  
6Mikołaj Czeronek
Mikołaj Czeronek 00, POL
3:57.23
00POL
3:57.23
  
7Mathias Flak
Mathias Flak 99, NOR
3:57.45
99NOR
3:57.45
PB
  
8Henrik Hanssen
Henrik Hanssen 97, NOR
3:57.46
97NOR
3:57.46
SB
  
9Abdullahi Dahir Rabi
Abdullahi Dahir Rabi 03, SOM
3:58.40
03SOM
3:58.40
PB
  
10Sebastian NilssonSWE
3:58.46
SB
  
11Christoffer Boll
Christoffer Boll 92, DEN
3:59.55
92DEN
3:59.55
  
12Ole Lyngbø
Ole Lyngbø 01, NOR
3:59.63
01NOR
3:59.63
SB
  
13Håkon Stavik
Håkon Stavik 00, NOR
3:59.96
00NOR
3:59.96
PB
  
17Julius Mäkinen
Julius Mäkinen 01, FIN
4:18.61
01FIN
4:18.61
SB
  
Vidar Dahle
Vidar Dahle 88, NOR
DNF
88NOR
DNF
  
Final C
1Axel Djurberg
4:00.83
SWE
4:00.83
  
M Stav     


Final A

Final

1Simen Guttormsen
Simen Guttormsen 01, NOR
5.00
01NOR
5.00
  
Eirik Greibrokk Dolve
Eirik Greibrokk Dolve 95, NOR
NH
95NOR
NH
  
M Kula     


Final A

Final

1Michał Rozporski
Michał Rozporski 88, POL
18.06
88POL
18.06
  
Kvinnor
K 400 m     


Final A

Final

1Nora Kollerød Wold
Nora Kollerød Wold 97, NOR
56.01
97NOR
56.01
SB
  
2Lovisa BivstedtSWE
57.04
PB
  
K 1500 m     


Final A

Final

1Mina Marie Anglero
Mina Marie Anglero 97, NOR
4:26.02
97NOR
4:26.02
  
2Elin Brink
4:27.25
SWE
4:27.25
PB
  
3Malin Edland
Malin Edland 99, NOR
4:29.17
99NOR
4:29.17
  
4Maria Sagnes Wågan
Maria Sagnes Wågan 92, NOR
4:29.32
92NOR
4:29.32
  
5Vilde Våge Henriksen
Vilde Våge Henriksen 00, NOR
4:30.49
00NOR
4:30.49
  
6Silje Fjørtoft
Silje Fjørtoft 87, NOR
4:30.51
87NOR
4:30.51
SB
  
7Christina Toogood
Christina Toogood 89, NOR
4:31.65
89NOR
4:31.65
  
8Ingrid Kristiansen
Ingrid Kristiansen 92, NOR
4:33.05
92NOR
4:33.05
SB
  
9Sara Busic
Sara Busic 02, NOR
4:33.98
02NOR
4:33.98
PB
  
10Ina Halle Haugen
Ina Halle Haugen 03, NOR
4:34.10
03NOR
4:34.10
  
11Maren Halle Haugen
Maren Halle Haugen 03, NOR
4:34.32
03NOR
4:34.32
PB
  
12Vienna Søyland Dahle
Vienna Søyland Dahle 92, NOR
4:35.82
92NOR
4:35.82
  
13Olivia WeslienSWE
4:36.64
  
14Christine Næss
Christine Næss 00, NOR
4:37.89
00NOR
4:37.89
  
15Sara Dädeby
4:38.26
SWE
4:38.26
  
16Anna Zielinkiewicz
Anna Zielinkiewicz 89, POL
4:38.31
89POL
4:38.31
SB
  
Tamara Tverdostup
Tamara Tverdostup 79, UKR
DNF
79UKR
DNF
  
Final B
2Ida Holm
4:43.35
SWE
4:43.35
SB
  
K Kula     


Final A

Final

1Frida ÅkerströmSWE
16.61
  
2Agnieszka Maluśkiewicz
Agnieszka Maluśkiewicz 89, POL
15.75
89POL
15.75