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: 21 (11+10)   Starter: 24 (13+11)


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= 12944453 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 800 m     


Final A

Final

8Sebastian PerssonYstads IF
2:11.84
PB
  
M Spjut     


Final A

Final

4Emil PerssonKA 2 IF
51.05
SB
  
P17 100 m     

Vind: +2.2

Final A

Final

Vind: +2.2
1Hampus Lilja
11.67w
Klippans FK
11.67w
  
2Mattias SjövallLomma FIK
11.70w
  
P15 300 m häck (76.2 cm)     


Final A

Final

1Bimo Soenarso
43.28
Ystads IF
43.28
PB
  
1Hugo DelvéusKA 2 IF
43.43
PB
  
P15 Slägga (4.0 kg)     


Final A

Final

1Casper BorgströmIFK Lund
35.57
PB
  
2Sebastian SmusinIF Kronan
33.94
PB
  
P15 Spjut (600 g)     


Final A

Final

2Casper BorgströmIFK Lund
37.80
PB
  
P14 80 m     

Vind: +5.7

Final A

Final

Vind: +5.7
1Bimo Soenarso
9.34w
Ystads IF
9.34w
  
2Caleb ConableIFK Lund
9.70w
  
P14 2000 m     


Final A

Final

2Kasper Friberg
Kasper Friberg 01, Björnstorp
6:49.74
Björnstorps IF
6:49.74
PB
  
P14 Kula (4.0 kg)     


Final A

Final

3Henrik PalmbladÅhus FIK
10.56
PB
  
Kvinnor
K Längd     


Final A

Final

1Jennika LarssonIFK Lund
5.17
0.0 SB
  
K Slägga (3.0 kg) extra     


Final A

Final

3Emma Johansson Melin
44.98
Göteborgs KIK
44.98
PB
  
F17 Slägga (3.0 kg)     


Final A

Final

3Nora Kindberg
39.02
Åhus FIK
39.02
PB
  
F15 Slägga (3.0 kg)     


Final A

Final

4Hanna Olofsson
37.41
PB
  
F15 Spjut (500 g)     


Final A

Final

1Moa Linder
35.50
IFK Lund
35.50
PB
  
F14 80 m     

Vind: +1.9

Final A

Final

Vind: +1.9
3Malin PerssonIFK Lund
10.84
PB
  
Heat 2
Vind: +3.0
Vind: +3.0
1Maja MaunsbachIFK Lund
10.59w
  
2Malin Persson
10.67w
IFK Lund
10.67w
  
F14 Slägga (3.0 kg)     


Final A

Final

1Fanny LundbergÅhus FIK
36.33
PB
  
F13 60 m     
Heat 3
Vind: +2.4
Vind: +2.4
1Elin Ekelund
Elin Ekelund 02, Eslövs AI
8.26w
Eslövs AI
8.26w
  
F13 Stav     


Final A

Final

1Celina JohannsenMalmö AI
2.40
PB