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: 112 (54+58)   Starter: 123 (59+64)


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

Vind: +2.3

Final A

Final

Vind: +2.3
2Markus Ögren
22.80w
Hammarby IF
22.80w
  
3Karl David Nie
23.34w
Hammarby IF
23.34w
  
6Kristian Efremov
22.53
Hammarby IF
22.53
SB
  
Final B
Vind: 0.0
Vind: 0.0
1William Frobe
22.66
Täby IS
22.66
PB
  
2Andreas Movin
23.01
IFK Lidingö
23.01
SB
  
2Carl-Einar Söderström EskonniemiHellas FK
23.17
PB
  
3Daniel Nordmark
23.69
Västerås FK
23.69
SB
  
3Arvid Friberg
24.13
Danderyds SK
24.13
PB
  
4Christopher SvenssonIFK Lidingö
23.92
SB
  
4Gustaf Backman
Gustaf Backman 99, Spårvägen
24.30
Spårvägens FK
24.30
PB
  
M 300 m     


Final A

Final

6Gustav Zetterlund
38.59
KFUM Örebro
38.59
PB
  
Final B
1Paul Förnestig
39.42
Hammarby IF
39.42
PB
  
5Gustav Gahne
41.93
Täby IS
41.93
PB
  
M 400 m     


Final A

Final

1Emil Thedéen
52.27
Bromma IF
52.27
PB
  
3Fredrik Kihlblom
52.88
Huddinge AIS
52.88
PB
  
5Filip Hedlund
53.47
Hellas FK
53.47
PB
  
Final B
1David SvenssonIFK Tumba
51.61
PB
  
3Anton Ledell
54.62
Huddinge AIS
54.62
PB
  
M 1500 m     


Final A

Final

1Anton Wåhlin
4:02.57
Malmö AI
4:02.57
SB
  
1Adam Lindström
4:03.27
Hässelby SK
4:03.27
SB
  
1Abdi Yusuf
Abdi Yusuf 96, Hammarby
4:03.28
Hammarby IF
4:03.28
PB
  
1Oscar Majling
4:16.81
Hässelby SK
4:16.81
SB
  
4John Kingstedt
3:57.12
Huddinge AIS
3:57.12
PB
  
5Gustav Berlin
3:58.32
IK Akele
3:58.32
PB
  
6Anton Danielson
3:58.63
Malmö AI
3:58.63
SB
  
9Bienvenue Musore
4:02.11
Tyresö FK
4:02.11
SB
  
Final B
1Jaouad Khamlichi
4:17.98
Tyresö FK
4:17.98
PB NR
  
1Daniel Alemu
Daniel Alemu 97, Trångsviken
4:20.53
Trångsvikens IF
4:20.53
PB
  
2Gustav Nordling
4:05.34
Spårvägens FK
4:05.34
PB
  
3Joel Norling
4:05.72
Tierps IF
4:05.72
PB
  
4Selman Özkan
4:08.65
Hammarby IF
4:08.65
PB
  
5August Mollén
August Mollén 99, GoIF Tjalve
4:10.84
GoIF Tjalve
4:10.84
PB
  
6Pontus Hagman
Pontus Hagman 97, Västerås
4:12.60
Västerås FK
4:12.60
PB
  
7Otto Kingstedt
4:13.53
Huddinge AIS
4:13.53
SB
  
8Stefan Stojanovic
4:14.33
Hässelby SK
4:14.33
PB
  
P19 200 m     

Vind: +1.7

Final A

Final

Vind: +1.7
1Filip La FleurYstads IF
22.21
PB
  
2Nicklas Holm
22.37
Hellas FK
22.37
PB
  
5Andreas GustafssonFalu IK
22.50
PB
  
6Joakim Karlsson
22.90
Finspångs AIK
22.90
PB
  
7Peter Holmberg
23.78
Vallentuna FK
23.78
PB
  
P19 110 m häck (99.1 cm)     

Vind: +1.9

Final A

Final

Vind: +1.9
2Andreas GustafssonFalu IK
14.45
SB
  
3Sebastian Ruthström
15.32
Spårvägens FK
15.32
PB
  
P17 1500 m     


Final A

Final

1Axel Alness-Borg
4:18.17
IFK Lidingö
4:18.17
PB
  
2Henry Jacobson
4:23.33
Tyresö FK
4:23.33
PB
  
P17 110 m häck (91.4 cm, 8.9 m)     

Vind: +2.6

Final A

Final

Vind: +2.6
1Johan BengtssonTäby IS
15.07w
  
2Fredrik Kihlblom
15.08w
Huddinge AIS
15.08w
  
3Axel Abrahamsson
15.99w
Bromma IF
15.99w
  
6Edvin Hagberg
16.44w
Turebergs FK
16.44w
  
P17 Stav     


Final A

Final

1Gabriel Rosshagen
3.76
Hässelby SK
3.76
PB
  
P17 Kula (5.0 kg)     


Final A

Final

1Viktor Wahlén DiederichsenSpårvägens FK
11.32
PB
  
3Gustaf Backman
Gustaf Backman 99, Spårvägen
10.99
Spårvägens FK
10.99
PB
  
4Edvin Hagberg
10.79
Turebergs FK
10.79
PB
  
P17 Slägga (5.0 kg)     


Final A

Final

1Edvin Larsson
Edvin Larsson 98, Eskilstuna
62.92
Eskilstuna FI
62.92
PB
  
P17 Spjut (700 g)     


Final A

Final

5Viktor Wahlén DiederichsenSpårvägens FK
38.01
PB
  
P15 2000 m     


Final A

Final

3Martin Nerell
6:18.23
Turebergs FK
6:18.23
PB
  
4Filip Lindeberg
6:21.52
IFK Lidingö
6:21.52
PB
  
5Nils Jonsson
6:26.90
Danderyds SK
6:26.90
PB
  
7Anton Axelsson
6:30.63
Hässelby SK
6:30.63
PB
  
8Markus Asplund
6:31.91
Huddinge AIS
6:31.91
PB
  
Kvinnor
K 200 m     

Vind: +1.6

Final A

Final

Vind: +1.6
1Amanda Hansson
25.40
Hässelby SK
25.40
PB
  
1Frida Hjorth
26.15 nwi
Säters IF
26.15 nwi
  
2Ida Thunberg
25.93
IK Stål
25.93
PB
  
2Ella Sjöblom
26.73 nwi
Tyresö FK
26.73 nwi
  
3Matilda Sönnergaard
26.50
Spårvägens FK
26.50
PB
  
4Linda Frödin GladTurebergs FK
25.07
SB
  
4Ida Fritzdorf KåbergHammarby IF
26.66
SB
  
Final B
Vind: +3.0
Vind: +3.0
2Frida HogstrandTäby IS
25.40w
  
2Sofie Persson
26.50
Hässelby SK
26.50
PB
  
3Elin Eriksson
26.52w
Hässelby SK
26.52w
  
4Jenny Åkervall
27.14w
IFK Stocksund
27.14w
  
4Sanna Pettersson
Sanna Pettersson 99, Östersunds GIF
27.31
Östersunds GIF
27.31
PB
  
5Hanna Tegner
27.45w
Bromma IF
27.45w
  
Final C
Vind: +2.4
Vind: +2.4
2Celina Reichardt
26.34w
Spårvägens FK
26.34w
  
3Ebba Gällhagen
26.77w
Turebergs FK
26.77w
  
4Helena Kolte
27.07w
Täby IS
27.07w
  
5Johanna NorbergTäby IS
27.13w
  
K 300 m     


Final A

Final

2Linda Eriksson
41.89
Huddinge AIS
41.89
SB
  
3Kajsa Eriksson
42.13
Huddinge AIS
42.13
PB
  
6Linda Nyblom
44.20
Turebergs FK
44.20
PB
  
Final B
2Elin Antonsson
43.54
PB
  
4Linn Arnlund
44.07
IF Vingarna
44.07
PB
  
Final C
2Lea Andersen
43.70
Täby IS
43.70
PB
  
K 1500 m     


Final A

Final

2Amanda Trense
4:58.69
Täby IS
4:58.69
SB
  
K 100 m häck (76.2 cm, 8.5 m)     

Vind: +0.1

Final A

Final

Vind: +0.1
3Linnéa Frobe
14.39
Täby IS
14.39
PB
  
F19 200 m     

Vind: +0.7

Final A

Final

Vind: +0.7
2Lisa Olsson
25.71
Hellas FK
25.71
PB
  
3Sofia Hultgren
25.93
Ludvika FFI
25.93
PB
  
4Matilda From
Matilda From 96, Västerås
26.52
Västerås FK
26.52
PB
  
5Victoria Stöckel
Victoria Stöckel 97, Nedre Soppero
26.77
Nedre Soppero IK
26.77
PB
  
F19 1500 m     


Final A

Final

1Ida Tryggveson
4:52.28
F Bålsta IK
4:52.28
PB
  
3Ebba Simensen
Ebba Simensen 97, Brännans FF
5:01.67
Brännans FF
5:01.67
PB
  
5Nicole Sörensen
5:15.08
Falu IK
5:15.08
SB
  
F19 100 m häck     

Vind: +0.7

Final A

Final

Vind: +0.7
3Victoria Stöckel
Victoria Stöckel 97, Nedre Soppero
16.92
Nedre Soppero IK
16.92
PB
  
4Emilia Stenström
16.95
Huddinge AIS
16.95
PB
  
F17 200 m     

Vind: +0.7

Final A

Final

Vind: +0.7
6Lovisa Johansson SjödinUllevi FK
27.39
PB
  
F17 400 m     


Final A

Final

1Anna Engelin
Anna Engelin 98, Östersunds GIF
57.96
Östersunds GIF
57.96
SB
  
2Carolina SöderbomÄrla IF
59.19
PB
  
4Lovisa Glavare KarlssonTäby IS
1:01.30
PB
  
5Hanna Aabakken
1:01.83
Västerås FK
1:01.83
SB
  
7Ewelina Fabiszewska
1:05.44
Huddinge AIS
1:05.44
PB
  
F17 100 m häck (76.2 cm, 8.5 m)     

Vind: +0.1

Final A

Final

Vind: +0.1
7Maria SödergrenTäby IS
15.00
SB
  
Heat 1
Vind: -1.6
Vind: -1.6
3Helena Kolte
15.39
Täby IS
15.39
SB
  
4Matilda Sönnergaard
16.03
Spårvägens FK
16.03
PB
  
6Celina Reichardt
17.54
Spårvägens FK
17.54
PB
  
Heat 3
Vind: +1.7
Vind: +1.7
1Mathilda ErikssonIFK Tumba
14.62
SB
  
4Marina Janhunen
15.21
Hammarby IF
15.21
PB
  
6Mathilda Jerpdal
16.56
Vallentuna FK
16.56
PB
  
F17 Kula (3.0 kg)     


Final A

Final

4Louise Svensson
13.37
Eskilstuna FI
13.37
PB
  
7Tilde All
11.35
Täby IS
11.35
PB
  
F15 2000 m     


Final A

Final

1Smilla Szalkai
Smilla Szalkai 01, Spårvägen
6:46.74
Spårvägens FK
6:46.74
PB
  
1Ella Georgsson
7:27.56
Högbo GIF
7:27.56
PB
  
1Maja Sund
Maja Sund 01, Tureberg
7:36.25
Turebergs FK
7:36.25
PB
  
1Maria Persson
7:37.70
Bollnäs FIK
7:37.70
SB
  
4Linn Tapani
7:03.91
Sågmyra SK
7:03.91
PB
  
7Kajsa Sten
Kajsa Sten 01, Oxelösund
7:09.35
SLK Oxelösund
7:09.35
PB
  
8Carolina Larson
7:13.54
Danderyds SK
7:13.54
SB
  
9Frida Nöu
Frida Nöu 01, Tureberg
7:23.31
Turebergs FK
7:23.31
PB
  
F15 80 m häck (76.2 cm, 8 m)     

Vind: +3.2

Final A

Final

Vind: +3.2
3Nina Jacobsson
12.15w
Sundsvalls FI
12.15w
  
4My Lindberg
12.30w
Hammarby IF
12.30w
  
7Linnea Ånger
Linnea Ånger 00, Söderhamn
12.58w
Söderhamns IF
12.58w
  
Heat 1
Vind: +1.9
Vind: +1.9
2My Lindberg
12.49
Hammarby IF
12.49
PB
  
Heat 3
Vind: +2.6
Vind: +2.6
3Izabella RipswedenIFK Tumba
12.74w
  
F15 Spjut (500 g)     


Final A

Final

2Lina Hagberg
36.10
Turebergs FK
36.10
PB
  
3Nina Jacobsson
33.20
Sundsvalls FI
33.20
PB