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
6.10
10.10
9.10
9.10
9.10
7.10
7.10
30.9
9.10
9.10
2.10
2.10
26.9
26.9
5.10
2.10
2.10
3.10
2.10
26.9
29.9
27.9
22.9
20.9
Tävlande: 76 (29+47)   Starter: 79 (29+50)


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

Final A

Final
Inne
6Simon Ekström
7.28
Hovslätts IK
7.28
SB
  
Final B
1Markus SparrmanIK Ymer
7.10
SB
  
1David JohanssonÅhus FIK
7.31
PB
  
2Felix Francois
7.15
Örgryte IS
7.15
PB
  
2Mahyar NoghaniUllevi FK
7.31
PB
  
3Anton Levin
Anton Levin 92, Helsingborg
7.36
IFK Helsingborg
7.36
PB
  
4Daniel Norgren
7.22
Örgryte IS
7.22
SB
  
6Fredrik Nyhlén
7.40
Mölndals AIK
7.40
PB
  
Heat 1
2David KallebäckVarbergs GIF
7.08
PB
  
4Christian Hedman
7.26
IFK Växjö
7.26
SB
  
Heat 2
1Fredrik OttossonAlvesta FI
7.10
SB
  
Heat 3
3Patrik Holmberg
7.32
Huddinge AIS
7.32
PB
  
M 400 m     
Inne

Final A

Final
Inne
1Viktor Ekelund
50.40
Malmö AI
50.40
PB
  
M 1500 m     
Inne

Final A

Final
Inne
9Jonas Lumsdén
4:35.00
Ullevi FK
4:35.00
PB
  
Final B
1Sebastian Stöckemann
4:33.7m
IFK Växjö
4:33.7m
PB
  
Final C
2Tim Willemen
4:18.38
Örgryte IS
4:18.38
PB
  
M Stav     
Inne

Final A

Final
Inne
1Erik LarssonVisby IF Gute
4.42
SB
  
P19 60 m     
Inne
Inne
Heat 4
4Robin ÅkessonMalmö AI
7.38
SB
  
P17 60 m     
Inne

Final A

Final
Inne
3Lucas Andersson
7.27
Sävedalens AIK
7.27
=PB
  
Heat 1
2Robin Nordkvist
7.18
Huddinge AIS
7.18
PB
  
3Hannes Carlsson
7.39
FI Kalmarsund
7.39
PB
  
P16 60 m     
Inne

Final A

Final
Inne
1Fredrick Ekholm
7.30
Huddinge AIS
7.30
PB
  
2Viktor Elvung-NilssonFIF Gnistan
7.36
PB
  
3André Ilve
7.42
IK Pallas
7.42
SB
  
Heat 3
2Victor Ivarsson
7.43
IFK Växjö
7.43
PB
  
3Ulrik SköldkvistIFK Lidingö
7.46
PB
  
P15 Höjd     
Inne

Final A

Final
Inne
1Karl Persson
1.81
Wärnamo SK
1.81
PB
  
4Patrick Malmquist
1.72
IFK Helsingborg
1.72
PB
  
P15 Tresteg     
Inne

Final A

Final
Inne
5Kim Wiik Olsson
11.10
Treby IF
11.10
PB
  
Kvinnor
K 60 m     
Inne

Final A

Final
Inne
1Rebecca NilssonUllevi FK
7.77
PB
  
1Elise Malmberg
Elise Malmberg 95, Hässleholm
7.89
Hässleholms AIS
7.89
PB
  
2Linnea SandellIF Kronan
7.99
PB
  
2Wilma Kroon
8.00
Malmö AI
8.00
PB
  
4Sarah Blicher HembergIFK Halmstad
8.08
PB
  
5Emelie Orosz
8.14
Ljungby FIK
8.14
PB
  
5Anna SamuelssonÅhus FIK
8.16
PB
  
6Hanna Hultemark
8.14
IFK Växjö
8.14
PB
  
Final B
1Ebba Lund
8.16
PB
  
3Matilda Ekberg
8.19
Heleneholms IF
8.19
SB
  
4Sofia Wiberg
Sofia Wiberg 95, IFK Växjö
8.21
IFK Växjö
8.21
  
Heat 3
3Anette PerssonIF Kville
7.98
PB
  
K 200 m     
Inne
Inne
Final B
1Anja Persson-HellbergHeleneholms IF
26.73
PB
  
3Frida McCabeIFK Lund
26.06
SB
  
Final C
2Charlotte Lanfelt
27.24
Huddinge AIS
27.24
PB
  
K 400 m     
Inne

Final A

Final
Inne
4Emma Lagerqvist
1:03.19
IFK Växjö
1:03.19
SB
  
K 1500 m     
Inne

Final A

Final
Inne
6Johanna Hylén
5:19.1m
Malmö AI
5:19.1m
SB
  
K Höjd     
Inne

Final A

Final
Inne
1Linnea KillanderMalmö AI
1.50
SB
  
1Emilia Bengtsson
1.65
IFK Helsingborg
1.65
PB
  
K Stav     
Inne

Final A

Final
Inne
6Hedvig Samuelsson
3.62
FI Kalmarsund
3.62
SB
  
K Tresteg     
Inne

Final A

Final
Inne
7Mathilda OlssonFK Athlet
11.39
PB
  
8Nathalie Nagy
11.36
Mölndals AIK
11.36
SB
  
F19 60 m     
Inne

Final A

Final
Inne
1Marica Merkel JohanssonKa 2 IF
7.90
SB
  
3Therese BorgqvistKA 2 IF
7.95
PB
  
Heat 1
3Mathilda OlssonFK Athlet
8.11
SB
  
Heat 2
1Frida Rosén-HagertHovslätts IK
8.13
SB
  
2Marie HagströmIK Ymer
8.14
PB
  
3Frida McCabeIFK Lund
8.14
SB
  
5Therese Jernbeck
8.27
IFK Lidingö
8.27
PB
  
Heat 3
3Estelle Montler
Estelle Montler 91, Göteborgs KIK
8.20
Göteborgs KIK
8.20
PB
  
Heat 4
2Rebecca Arnesson
8.17
IFK Växjö
8.17
=PB
  
F19 Höjd     
Inne

Final A

Final
Inne
9Karin Bengtsson
1.55
Mölndals AIK
1.55
SB
  
F17 60 m     
Inne

Final A

Final
Inne
2Daniella Busk
7.84
Malmö AI
7.84
SB
  
5Ellen Hjerpe Darrell
8.23
Göteborgs KIK
8.23
PB
  
Heat 1
4Frida Åhsberg
8.29
Villstad GIF
8.29
PB
  
F17 200 m     
Inne

Final A

Final
Inne
1Erika HåkanssonIK Finish
27.07
PB
  
F17 Höjd     
Inne

Final A

Final
Inne
1Lina MarcussenIK Lerum FI
1.55
SB
  
3Maria Tell
1.66
Högby IF
1.66
SB
  
6Natalie WestmanVarbergs GIF
1.55
SB
  
F17 Tresteg     
Inne

Final A

Final
Inne
1Khaddi Sagnia
12.69
Ullevi FK
12.69
  
F16 60 m     
Inne
Inne
Heat 1
3Elin Larsson
Elin Larsson 94, Falkenberg
8.20
Falkenbergs IK
8.20
  
Heat 4
3Elina Gunnarsson
8.19
Hovslätts IK
8.19
PB
  
F15 60 m     
Inne
Inne
Heat 7
2Alice Petersson
8.18
FI Kalmarsund
8.18
PB
  
F15 Höjd     
Inne

Final A

Final
Inne
1Hanna Ringdahl
1.70
Eslövs AI
1.70
PB
  
2Emma Schack
1.70
Åhus FIK
1.70
PB
  
9Margareta CelsingIFK Lidingö
1.50
SB
  
F15 Tresteg     
Inne

Final A

Final
Inne
1Josefin Enoksson
11.30
Klippans FK
11.30
PB
  
4Ronja Olsson
10.83
Ullevi FK
10.83
PB
  
F15 Kula (3.0 kg)     
Inne

Final A

Final
Inne
2Ronja Olsson
11.93
Ullevi FK
11.93
PB
  
F12 Höjd     
Inne

Final A

Final
Inne
1Sofia Lindwall
Sofia Lindwall 98, Göteborgs KIK
1.50
Göteborgs KIK
1.50
PB