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
Tävlande: 100 (51+49)   Starter: 111 (57+54)


select distinct results19.*, 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, 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= 12931273 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 100 m     

Vind: +0.7

Final A

Final

Vind: +0.7
1Henrik Larsson
10.57
IF Göta Karlstad
10.57
SB
  
2Erik Hagberg
10.63
Upsala IF
10.63
SB
  
3Desmond RogoAIK
10.80
SB
  
4Albin Boestad
11.31
IFK Lidingö
11.31
PB
  
M 200 m     

Vind: 0.0

Final A

Final

Vind: 0.0
1Henrik Larsson
21.58
IF Göta Karlstad
21.58
  
2Dennis Otieno
21.72
Hammarby IF
21.72
SB
  
3Isak Andersson
21.86
Upsala IF
21.86
SB
  
4Mikael Lundkvist
22.97
Huddinge AIS
22.97
PB
  
5David Århammar
23.70
IFK Lidingö
23.70
PB
  
M 400 m     


Final A

Final

1Emmanuel Dawlson
49.23
Hammarby IF
49.23
PB
  
2Andreas Movin
49.38
IFK Lidingö
49.38
SB
  
3Albert Nygren
50.13
Upsala IF
50.13
SB
  
5Lukas Sällström
51.59
IFK Umeå
51.59
PB
  
M 800 m     


Final A

Final

1Robin Rohlén
1:50.66
IFK Umeå
1:50.66
SB
  
2Björn Seifert
1:50.95
Upsala IF
1:50.95
PB
  
Viktor Frisk
1:56.77
Huddinge AIS
1:56.77
SB
  
M 1500 m     


Final A

Final

2Björn Seifert
4:09.45
Upsala IF
4:09.45
SB
  
5Rasmus Tidestad
4:29.84
IF Göta Karlstad
4:29.84
SB
  
M 5000 m     


Final A

Final

1Jonas Leandersson
14:57.12
IF Göta Karlstad
14:57.12
PB
  
2Martin Nilsson
15:05.30
IFK Umeå
15:05.30
PB
  
3John Kingstedt
15:27.81
Huddinge AIS
15:27.81
SB
  
5Jonatan Alvaeus
16:07.18
Upsala IF
16:07.18
SB
  
6Mikkel Knif
16:10.20
Hammarby IF
16:10.20
SB
  
M 3000 m hinder     


Final A

Final

1Olof Silvander
9:31.32
IFK Lidingö
9:31.32
PB
  
2Simon Hector
9:44.27
Huddinge AIS
9:44.27
PB
  
5Frezghi Tesfamariam
11:30.19
IF Göta Karlstad
11:30.19
SB
  
6Johan Lindberg
13:08.88
Upsala IF
13:08.88
SB
  
M 110 m häck     

Vind: -2.1

Final A

Final

Vind: -2.1
5Jesper Rilegård
18.44
IFK Lidingö
18.44
PB
  
David Adrian
15.83 nwi
Huddinge AIS
15.83 nwi
  
M 400 m häck     


Final A

Final

1Isak Andersson
52.63
Upsala IF
52.63
  
2Ludvig HillenfjärdHuddinge AIS
52.99
SB
  
4Ludwig Sjödin
57.22
IFK Umeå
57.22
PB
  
5Gabriel GunnarssonIF Göta Karlstad
57.76
PB
  
M Höjd     


Final A

Final

1Oskar Lundqvist
2.06
Upsala IF
2.06
  
2Arvid Ryberg
2.03
IF Göta Karlstad
2.03
  
3Hampus Carlens
2.00
IFK Lidingö
2.00
SB
  
6Vilmer Vännman
1.75
IFK Umeå
1.75
PB
  
M Stav     


Final A

Final

5Dennis Elms JanssonHuddinge AIS
3.80
PB
  
M Längd     


Final A

Final

1Andreas OtterlingIFK Lidingö
7.77
0.0 SB
  
2David Svensson
7.21
Hammarby IF
7.21
0.0 PB
  
6Vilmer Vännman
6.07
IFK Umeå
6.07
+0.8 PB
  
M Tresteg     


Final A

Final

1Erik Ehrlin
15.49
Hammarby IF
15.49
+1.0
  
2Antonis Dinopoulos
15.18
Upsala IF
15.18
0.0 SB
  
3Albin Boestad
14.81w
IFK Lidingö
14.81w
+2.5
  
4Markus Asplund
13.26
IF Göta Karlstad
13.26
0.0 SB
  
M Kula     


Final A

Final

2Tim Wunger
Tim Wunger 94, Upsala IF
14.35
Upsala IF
14.35
SB
  
William Ullberg
14.93
IFK Umeå
14.93
SB
  
Oscar Vestlund
14.14
IF Göta Karlstad
14.14
SB
  
M Diskus     


Final A

Final

1Ulf Ankarling
48.13
IF Göta Karlstad
48.13
SB
  
6Jakob ThorvaldssonIFK Lidingö
31.99
PB
  
Matt Brown
Matt Brown 80, Hammarby
47.93
Hammarby IF
47.93
SB
  
Victor Wisén
45.52
Upsala IF
45.52
PB
  
M Slägga     


Final A

Final

1Oscar Vestlund
69.79
IF Göta Karlstad
69.79
SB
  
3Jonas Hansson-BergénNyköpings BIS
48.46
SB
  
5Daniel Ragnvaldsson
45.36
IFK Umeå
45.36
SB
  
6Alexander LindefalkHammarby IF
37.09
PB
  
M Spjut     


Final A

Final

2Axel Lönegren
60.45
Upsala IF
60.45
SB
  
Kvinnor
K 100 m     

Vind: 0.0

Final A

Final

Vind: 0.0
1Hanna Adriansson NordbergIFK Lidingö
12.00
SB
  
3Alexandra RosengrenHuddinge AIS
12.54
PB
  
4Caroline KihlblomTäby IS
12.57
SB
  
6Astrid Eggesjö
13.06
Västerås FK
13.06
SB
  
K 200 m     

Vind: -0.4

Final A

Final

Vind: -0.4
1Hanna Adriansson NordbergIFK Lidingö
24.83
SB
  
2Ebba Svantesson
25.28
Upsala IF
25.28
SB
  
4Sarah Karlsson
25.88
Huddinge AIS
25.88
SB
  
K 400 m     


Final A

Final

2Sofia HultgrenTäby IS
58.09
SB
  
3Freja Nygren
58.49
Gefle IF
58.49
PB
  
4Linda Frödin GladIFK Lidingö
59.52
SB
  
K 800 m     


Final A

Final

2Hanna Bergström
2:13.37
Huddinge AIS
2:13.37
PB
  
4Linn Kalderén
2:17.25
Turebergs FK
2:17.25
PB
  
Rebecka Öberg
2:13.03
IFK Lidingö
2:13.03
PB
  
K 1500 m     


Final A

Final

3Greta Graziani
4:43.54
Täby IS
4:43.54
SB
  
4Maja Björnsson
4:55.10
Upsala IF
4:55.10
PB
  
K 5000 m     


Final A

Final

1Charlotte Schönbeck
17:33.15
IFK Lidingö
17:33.15
SB
  
2Camilla Elofsson
17:37.82
Huddinge AIS
17:37.82
PB
  
K 3000 m hinder     


Final A

Final

1Emilia Lillemo
10:26.74
Täby IS
10:26.74
SB
  
2Mika Söderström
11:08.26
IFK Lidingö
11:08.26
PB
  
3Moa Rothman
Moa Rothman 96, Västerås
11:14.34
Västerås FK
11:14.34
SB
  
4Ebba Fock
Ebba Fock 02, Upsala IF
14:02.42
Upsala IF
14:02.42
PB
  
5Tone Albrektsson
16:22.52
Huddinge AIS
16:22.52
PB
  
K 100 m häck     

Vind: -1.1

Final A

Final

Vind: -1.1
4Lisa Fröberg
15.58
IFK Lidingö
15.58
PB
  
K 400 m häck     


Final A

Final

1Lovisa Linde
1:00.84
Täby IS
1:00.84
SB
  
2Tyra Landin
Tyra Landin 02, Västerås
1:03.33
Västerås FK
1:03.33
PB
  
3Lisa Fröberg
1:03.60
IFK Lidingö
1:03.60
PB
  
4Ida Ekroth
Ida Ekroth 96, Upsala IF
1:05.12
Upsala IF
1:05.12
SB
  
5Vendela Ström
1:06.87
Gefle IF
1:06.87
PB
  
6Elwira Ripsweden
1:13.80
Huddinge AIS
1:13.80
SB
  
K Höjd     


Final A

Final

1Lovisa Östervall
1.73
Upsala IF
1.73
SB
  
2Linda Skantze
1.70
IFK Lidingö
1.70
SB
  
3Elvira Jonsson
1.67
Västerås FK
1.67
PB
  
K Stav     


Final A

Final

2Johanna Hellman
3.48
IFK Lidingö
3.48
PB
  
5Denise ErikssonGefle IF
2.60
SB
  
5Louise Kvarforth
2.60
Västerås FK
2.60
SB
  
K Längd     


Final A

Final

1Malin Marmbrandt
6.27
Västerås FK
6.27
+0.5 SB
  
Malin Olsson
5.88w
IFK Lidingö
5.88w
w
  
K Tresteg     


Final A

Final

1Malin Marmbrandt
12.97
Västerås FK
12.97
+0.4 SB
  
3Maja Björk
11.08
Huddinge AIS
11.08
+1.7 PB
  
4Veronika NordinGefle IF
10.96
+1.0 PB
  
5Emelie Eklund
10.95
Täby IS
10.95
+0.6 SB
  
6Madeleine ErikssonIFK Lidingö
10.79
+1.8 PB
  
K Kula     


Final A

Final

2Emma Stenlöf
Emma Stenlöf 96, Västerås
13.50
Västerås FK
13.50
SB
  
3Sofia Linde
12.79
Täby IS
12.79
SB
  
5Therese Jernbeck
11.74
IFK Lidingö
11.74
SB
  
K Diskus     


Final A

Final

1Vanessa Kamga
53.04
Upsala IF
53.04
  
5Lovisa Linde
29.53
Täby IS
29.53
SB
  
6Malin Eriksson
29.29
Huddinge AIS
29.29
SB
  
K Slägga     


Final A

Final

1Kajsa Wennberg
56.55
Upsala IF
56.55
  
2Jennifer Andersson
54.90
Västerås FK
54.90
PB
  
4Freja LiljedahlGefle IF
45.69
SB
  
5Josefin Krieg
39.32
Huddinge AIS
39.32
SB
  
K Spjut     


Final A

Final

5Therese Jernbeck
35.98
IFK Lidingö
35.98
SB
  
6Linnéa Frobe
32.64
Täby IS
32.64
PB