4‐5.12
5.12
2.12
31.10
4‐5.12
4.12
27.11
23.11
28.11
27.11
27.11
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
17.10
13.9
31.10
11.9
2.10
16.10
2.10
16.10
23.10
28.8
22.10
Tävlande: 46 (22+24)   Starter: 62 (30+32)


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

Final A

Final
28 maj
Vind: -0.3
1Karsten Warholm
Karsten Warholm 96, NOR
10.55
96NOR
10.55
  
2Salum Ageze Kashafali
Salum Ageze Kashafali 93, NOR
10.63
93NOR
10.63
SB
  
3Håkon Morken
Håkon Morken 93, NOR
10.70
93NOR
10.70
  
4Filip Bøe
Filip Bøe 00, NOR
10.91
00NOR
10.91
PB
  
5Henrik Overvåg
Henrik Overvåg 94, NOR
10.92
94NOR
10.92
  
5Jonas Tapani Halonen
Jonas Tapani Halonen 95, NOR
10.92
95NOR
10.92
  
7Nivethan Panchalingam
Nivethan Panchalingam 93, NOR
11.02
93NOR
11.02
  
7Lars Jøran Storhaug
Lars Jøran Storhaug 89, NOR
11.02
89NOR
11.02
  
Heat 1
28 maj Vind: +0.8
28 majVind: +0.8
1Karsten Warholm
Karsten Warholm 96, NOR
10.52
96NOR
10.52
PB
  
2Lars Jøran Storhaug
Lars Jøran Storhaug 89, NOR
10.91
89NOR
10.91
  
3Øystein Klareng
Øystein Klareng 96, NOR
10.94
96NOR
10.94
  
Heat 2
28 maj Vind: +1.0
28 majVind: +1.0
1Salum Ageze Kashafali
Salum Ageze Kashafali 93, NOR
10.67
93NOR
10.67
SB
  
2Henrik Overvåg
Henrik Overvåg 94, NOR
10.83
94NOR
10.83
PB
  
3Filip Bøe
Filip Bøe 00, NOR
10.92
00NOR
10.92
PB
  
4Jostein Joshua Fossøy
Jostein Joshua Fossøy 92, NOR
10.96
92NOR
10.96
  
Heat 3
28 maj Vind: +0.4
28 majVind: +0.4
1Håkon Morken
Håkon Morken 93, NOR
10.67
93NOR
10.67
PB
  
2Jonas Tapani Halonen
Jonas Tapani Halonen 95, NOR
10.91
95NOR
10.91
SB
  
3Nivethan Panchalingam
Nivethan Panchalingam 93, NOR
10.92
93NOR
10.92
  
M 400 m     
29 maj

Final A

Final
29 maj
1Josh-Kevin Ramirez Talm
Josh-Kevin Ramirez Talm 96, NOR
48.13
96NOR
48.13
SB
  
M 800 m     
28 maj

Final A

Final
28 maj
1Sverre Blom Breivik
Sverre Blom Breivik 96, NOR
1:51.88
96NOR
1:51.88
  
2Håvard Hildeskor
Håvard Hildeskor 92, NOR
1:54.13
92NOR
1:54.13
SB
  
3Didrik Hexeberg Warlo
Didrik Hexeberg Warlo 99, NOR
1:54.14
99NOR
1:54.14
PB
  
4Sondre Juven
Sondre Juven 99, NOR
1:54.30
99NOR
1:54.30
  
5Petter Myhr
Petter Myhr 00, NOR
1:56.14
00NOR
1:56.14
PB
  
M Höjd     
28 maj

Final A

Final
28 maj
1Kristoffer Nilsen
Kristoffer Nilsen 89, NOR
2.05
89NOR
2.05
SB
  
2Storm Koksvik
Storm Koksvik 98, NOR
2.00
98NOR
2.00
  
M Kula     
28 maj

Final A

Final
28 maj
1Michał Rozporski
Michał Rozporski 88, POL
19.67
88POL
19.67
PB
  
M Diskus     
28 maj

Final A

Final
28 maj
1Ola Stunes Isene
Ola Stunes Isene 95, NOR
58.70
95NOR
58.70
SB
  
M Spjut     
29 maj

Final A

Final
29 maj
1Håkon Løvenskiold Kveseth
Håkon Løvenskiold Kveseth 93, NOR
63.32
93NOR
63.32
  
P17 100 m     
28 maj
Vind: +1.6

Final A

Final
28 maj
Vind: +1.6
1Fredrik Øvereng
Fredrik Øvereng 99, NOR
11.07
99NOR
11.07
PB
  
Kvinnor
K 100 m     
28 maj
Vind: -0.4

Final A

Final
28 maj
Vind: -0.4
1Helene Rønningen
Helene Rønningen 98, NOR
11.66
98NOR
11.66
PB
  
2Agathe Holtan Wathne
Agathe Holtan Wathne 94, NOR
12.24
94NOR
12.24
  
Heat 1
28 maj Vind: 0.0
28 majVind: 0.0
1Helene Rønningen
Helene Rønningen 98, NOR
11.67
98NOR
11.67
PB
  
Heat 2
28 maj Vind: +1.0
28 majVind: +1.0
1Agathe Holtan Wathne
Agathe Holtan Wathne 94, NOR
12.24
94NOR
12.24
  
K 200 m     
29 maj
Vind: -0.7

Final A

Final
29 maj
Vind: -0.7
1Ingvild Meinseth
Ingvild Meinseth 99, NOR
24.95
99NOR
24.95
SB
  
K 400 m     
29 maj

Final A

Final
29 maj
1Yngvild Elvemo
Yngvild Elvemo 90, NOR
55.01
90NOR
55.01
SB
  
2Karoline Daland
Karoline Daland 99, NOR
55.93
99NOR
55.93
SB
  
3Martine Eikemo Borge
Martine Eikemo Borge 90, NOR
56.74
90NOR
56.74
SB
  
K 800 m     
28 maj

Final A

Final
28 maj
1Anniken Rostad Johansen
Anniken Rostad Johansen 88, NOR
2:12.73
88NOR
2:12.73
PB
  
2Stine Wangberg
Stine Wangberg 99, NOR
2:13.05
99NOR
2:13.05
PB
  
3Sigrid Jervell Våg
Sigrid Jervell Våg 92, NOR
2:14.14
92NOR
2:14.14
PB
  
4Emilie Olsen Solveig
Emilie Olsen Solveig 91, NOR
2:14.81
91NOR
2:14.81
PB
  
K 3000 m     
29 maj

Final A

Final
29 maj
1Sigrid Jervell Våg
Sigrid Jervell Våg 92, NOR
9:45.20
92NOR
9:45.20
PB
  
2Tessa Den Heijer
Tessa Den Heijer 96, NED
9:53.49
96NED
9:53.49
SB
  
3Anniken Rostad Johansen
Anniken Rostad Johansen 88, NOR
10:01.73
88NOR
10:01.73
PB
  
4Lene Sandem
Lene Sandem 88, NOR
10:15.77
88NOR
10:15.77
  
K Höjd     
29 maj

Final A

Final
29 maj
1Elin Dale
Elin Dale 96, NOR
1.70
96NOR
1.70
PB
  
K Längd     
29 maj

Final A

Final
29 maj
1Chiamaka Okparaebo
Chiamaka Okparaebo 92, NOR
5.65w
92NOR
5.65w
+2.7
  
2Ingvild Meinseth
Ingvild Meinseth 99, NOR
5.58
99NOR
5.58
+0.4 SB
  
K Spjut     
29 maj

Final A

Final
29 maj
1Lena Marie Hansen
Lena Marie Hansen 93, NOR
48.67
93NOR
48.67
SB
  
2Marte Aaltvedt
Marte Aaltvedt 89, NOR
45.50
89NOR
45.50
SB
  
3Emilie Ingerø
Emilie Ingerø 95, NOR
43.87
95NOR
43.87
  
F19 100 m     
28 maj
Vind: -0.7

Final A

Final
28 maj
Vind: -0.7
1Vilde Humstad Aasmo
Vilde Humstad Aasmo 98, NOR
12.14
98NOR
12.14
  
Heat 1
28 maj Vind: +1.1
28 majVind: +1.1
1Vilde Humstad Aasmo
Vilde Humstad Aasmo 98, NOR
12.09
98NOR
12.09
PB
  
F19 Diskus     
28 maj

Final A

Final
28 maj
1Berit Stunes Isene
Berit Stunes Isene 98, NOR
43.67
98NOR
43.67
  
F19 Spjut     
29 maj

Final A

Final
29 maj
1Carolin NäslundSWE
45.05
  
2Linnea Greiff
Linnea Greiff 98, NOR
43.30
98NOR
43.30
  
F17 100 m     
28 maj
Vind: +0.1

Final A

Final
28 maj
Vind: +0.1
1Tonje Fjellet Kristiansen
Tonje Fjellet Kristiansen 99, NOR
12.29
99NOR
12.29
  
Heat 1
28 maj Vind: +1.0
28 majVind: +1.0
1Tonje Fjellet Kristiansen
Tonje Fjellet Kristiansen 99, NOR
12.23
99NOR
12.23
SB
  
F17 200 m     
29 maj
Vind: +2.4

Final A

Final
29 maj
Vind: +2.4
1Tonje Fjellet Kristiansen
Tonje Fjellet Kristiansen 99, NOR
24.94w
99NOR
24.94w
  
F17 Spjut (500 g)     
29 maj

Final A

Final
29 maj
1Arianne Duarte Morais
Arianne Duarte Morais 99, NOR
50.41
99NOR
50.41
  
F16 800 m     
28 maj

Final A

Final
28 maj
1Sanne Njaastad
Sanne Njaastad 00, NOR
2:16.02
00NOR
2:16.02
PB