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: 45 (20+25)   Starter: 49 (22+27)


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

Men
Men 200m     

Wind: +1.1

Final A

Final

Wind: +1.1
5Victor Ivarsson
22.95
IFK Växjö
22.95
PB
  
Heat 1
Wind: +3.1
Wind: +3.1
2Victor Ivarsson
22.45w
IFK Växjö
22.45w
  
Heat 2
Wind: +5.0
Wind: +5.0
2Jakob LindbomKA 2 IF
22.05w
  
4Jonas SvenssonIFK Lund
23.80w
  
Men 300m     


Final A

Final

4Gustaf Borg
Gustaf Borg 98, Nyköping
40.05
Nyköpings BIS
40.05
SB
  
6Samuel Persgården
41.16
Kongahälla AIK
41.16
PB
  
Men 110m Hurdles     

Wind: +3.9

Final A

Final

Wind: +3.9
1Hampus Widlund
Hampus Widlund 93, IFK Växjö
14.38w
IFK Växjö
14.38w
  
2Sebastian HolmbergIFK Lund
16.87w
  
U20 M High Jump     


Final A

Final

4Markus Saarela
Markus Saarela 94, Trollhättan FIK
1.81
Trollhättan FIK
1.81
SB
  
U20 M Javelin Throw     


Final A

Final

6Hannes Kvist Wirdmo
42.47
IFK Växjö
42.47
SB
  
U18 M 200m     
Heat 1
Wind: +3.5
Wind: +3.5
4Eric Mårtensson
23.71w
IFK Trelleborg
23.71w
  
Heat 2
Wind: +3.4
Wind: +3.4
2Isaq Ali Abdirahman
23.34w
Öresund FK
23.34w
  
Heat 3
Wind: +3.6
Wind: +3.6
2Filip La Fleur
23.66w
Ystads IF
23.66w
  
3Andreas VidovicIFK Lund
23.96w
  
U18 M 110m Hurdles (91.4cm, 8.90m)     

Wind: +4.4

Final A

Final

Wind: +4.4
1Sebastian Gyllensten
15.39w
IFK Växjö
15.39w
  
U18 M Long Jump     


Final A

Final

8Joakim Bäckman
5.85w
Varbergs GIF
5.85w
+3.0
  
U16 M 100m Hurdles (84cm, 8.25m)     

Wind: +3.3

Final A

Final

Wind: +3.3
1Max Hrelja
Max Hrelja 98, Linköpings GIF
13.07w
Linköpings GIF
13.07w
  
Heat 1
Wind: +2.0
Wind: +2.0
1Max Hrelja
Max Hrelja 98, Linköpings GIF
13.11
Linköpings GIF
13.11
PB
  
Heat 2
Wind: +1.0
Wind: +1.0
3Viktor BondessonMalmö AI
14.25
PB
  
Heat 3
Wind: +2.5
Wind: +2.5
4Gustav Eriksson
14.81w
IF Kville
14.81w
  
U16 M Triple Jump     


Final A

Final

1Simon MartinssonLomma FIK
11.89w
+2.5
  
U16 M Discus Throw (1kg)     


Final A

Final

5Simon LarssonIK Ymer
44.48
PB
  
Women
Women 200m     

Wind: +2.4

Final A

Final

Wind: +2.4
1Greta Deltin
26.36w
Hammarby IF
26.36w
  
1Sarah Nordin
Sarah Nordin 97, Trollhättan FIK
27.66
Trollhättan FIK
27.66
PB
  
2Louise Ekman
25.85
Gefle IF
25.85
PB
  
Heat 1
Wind: +4.3
Wind: +4.3
6Johanna Aalto
26.87w
IF Kville
26.87w
  
7Hanna Malm
Hanna Malm 94, Helsingborg
27.03w
IFK Helsingborg
27.03w
  
Heat 2
Wind: +3.5
Wind: +3.5
1Lisa Skagersten
25.14w
Varbergs GIF
25.14w
  
Women 300m     


Final A

Final

3Emilia Jönsson
44.18
IFK Helsingborg
44.18
PB
  
Women 800m     


Final A

Final

3Tora Gimre
2:30.89
Malmö AI
2:30.89
PB
  
Women 100m Hurdles     

Wind: +0.7

Final A

Final

Wind: +0.7
2Fanny LindströmMalmö AI
14.68
PB
  
Women Triple Jump     


Final A

Final

6Tea Svensson
10.64w
IFK Lund
10.64w
+2.3
  
7Agnes Fredriksen
10.13w
Hovslätts IK
10.13w
+2.4
  
Women Javelin Throw     


Final A

Final

2Linnea Sieker
Linnea Sieker 95, Falkenberg
41.16
Falkenbergs IK
41.16
PB
  
U20 W 100m Hurdles     

Wind: +2.4

Final A

Final

Wind: +2.4
5Agnes Johansson
Agnes Johansson 95, Trollhättan FIK
15.80w
Trollhättan FIK
15.80w
  
U18 W 200m     
Heat 2
Wind: +3.0
Wind: +3.0
2Hanna Andersson
27.19w
IFK Trelleborg
27.19w
  
3Sarah Nordin
Sarah Nordin 97, Trollhättan FIK
27.35w
Trollhättan FIK
27.35w
  
5Madeleine SöderlundIK Lerum FI
27.64w
  
U18 W 100m Hurdles (76.2cm)     

Wind: +3.1

Final A

Final

Wind: +3.1
1Sara Cannmo
Sara Cannmo 96, Hovslätt
14.53w
Hovslätts IK
14.53w
  
4Sandra Östby
15.86w
IFK Tumba
15.86w
  
6Karin YtterbergIK Ymer
15.93w
  
7Nikolina Nordkvist
16.02w
IFK Helsingborg
16.02w
  
8Anna Larsson
16.32w
Varbergs GIF
16.32w
  
Heat 2
Wind: +1.2
Wind: +1.2
2Karin YtterbergIK Ymer
16.00
PB
  
U18 W High Jump     


Final A

Final

2Svea Hagrydh
Svea Hagrydh 97, Trollhättan FIK
1.64
Trollhättan FIK
1.64
PB
  
U18 W Discus Throw     


Final A

Final

3Frida Grindheim
30.48
IFK Helsingborg
30.48
PB
  
4Sandra Kemdal
Sandra Kemdal 97, Västerås
29.53
Västerås FK
29.53
PB
  
U16 W 80 Meter Hurdles (76.2 cm - 8m)     
Heat 3
Wind: +2.1
Wind: +2.1
4Amanda Seger
12.63w
Gefle IF
12.63w
  
U16 W Discus Throw (0.6kg)     


Final A

Final

1Amanda Holmberg
Amanda Holmberg 98, Lidköpings IS
48.18
Lidköpings IS
48.18
PB