27.11
23.11
28.11
27.11
27.11
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
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
Tävlande: 41 (20+21)   Starter: 42 (20+22)


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

Vind: +1.5

Final A

Final

Vind: +1.5
4Nasser Sebabi
10.97
Falu IK
10.97
SB
  
6Jonas HilmerssonUllevi FK
11.13
SB
  
M 400 m     


Final A

Final

1David Kallebäck
48.53
Varbergs GIF
48.53
PB
  
3Niklas LibergIFK Lund
49.34
PB
  
Final B
1Hjalmar Hallberg
50.33
Vittsjö GIK
50.33
SB
  
5Alexander Persson
51.19
Hammarby IF
51.19
SB
  
M Längd     


Final A

Final

1Per Jonsson
6.87
Bollnäs FIK
6.87
+1.9 PB
  
3Johan Damgren
Johan Damgren 86, IK Hakarpspojkarna
6.23
IK Hakarpspojkarna
6.23
+1.4 SB
  
P19 100 m     

Vind: +2.0

Final A

Final

Vind: +2.0
1Jesper Lang
11.05
Malmö AI
11.05
PB
  
3Juan Carlos da SilvasIF Kville
11.11
PB
  
P19 Längd     


Final A

Final

1Robin Weetom
6.06
Ullevi FK
6.06
+0.2 PB
  
3Dastid SelmaniIFK Lund
6.84
+1.6 PB
  
7Erik Jonsson
Erik Jonsson 91, Falkenberg
6.34w
Falkenbergs IK
6.34w
+2.5
  
P17 100 m     

Vind: +1.6

Final A

Final

Vind: +1.6
1Oscar Olausson
Oscar Olausson 93, Kristianstad
11.23
KFUM Kristianstad
11.23
PB
  
3André Ilve
11.54
IK Pallas
11.54
PB
  
P17 Diskus (1.5 kg)     


Final A

Final

6Rasmus Gunnervald
Rasmus Gunnervald 93, Svenljunga IK
39.33
Svenljunga IK
39.33
SB
  
P17 Spjut (700 g)     


Final A

Final

8Rasmus ElfgaardHabo FIF-04
40.03
PB
  
P15 100 m     

Vind: +0.2

Final A

Final

Vind: +0.2
3Christopher Swenning
11.81
Eslövs AI
11.81
=PB
  
P15 Spjut (600 g)     


Final A

Final

5Henrik Oscarsson Liebel
44.76
KFUM Kristianstad
44.76
PB
  
P14 Längd     


Final A

Final

3Tobias Jonsson
5.76w
IK Orient
5.76w
+2.6
  
Kvinnor
K 100 m     

Vind: +1.9

Final A

Final

Vind: +1.9
4Anette Persson
12.65
IF Kville
12.65
PB
  
6Josefin JohanssonEds SK
12.79
SB
  
K 400 m     


Final A

Final

2Betty StrandbergGefle IF
56.07
PB
  
Final B
1Sandra CarlssonIK Ymer
59.42
PB
  
Final C
3Josefin Ellmarker
1:05.67
IK Orient
1:05.67
PB
  
K 1500 m     


Final A

Final

2Sofia Enander
5:23.32
IK Orient
5:23.32
SB
  
K Längd     


Final A

Final

5Sofia Rahdevi
5.33w
Mölndals AIK
5.33w
+2.6
  
K Diskus     


Final A

Final

1Sandra JohanssonUllevi FK
25.04
SB
  
F19 100 m     

Vind: +2.0

Final A

Final

Vind: +2.0
1Emma Fredriksson
12.24
Hammarby IF
12.24
SB
  
4Josefin SahlströmMalmö AI
12.98
PB
  
F19 Längd     


Final A

Final

5Anna OlssonIFK Lund
5.00
+1.9 PB
  
F17 100 m     

Vind: +1.6

Final A

Final

Vind: +1.6
2Matilda HellqvistIK Orient
12.36
PB
  
5Ulrika Nyhlén
12.67
Mölndals AIK
12.67
SB
  
F17 Längd     


Final A

Final

1Matilda HellqvistIK Orient
5.73w
+3.3
  
3Erika EskilssonMalmö AI
5.55w
+3.3
  
F15 100 m     

Vind: +1.2

Final A

Final

Vind: +1.2
3Michelle Tyborn
12.81
Alingsås IF
12.81
PB
  
5Emilia ErikssonIFK Lund
13.03
SB
  
6Agnes Johansson
Agnes Johansson 95, Trollhättan FIK
13.28
Trollhättan FIK
13.28
PB
  
8Matilda Friberg
13.43
PB
  
F15 800 m     


Final A

Final

1Sarah Lahti
2:16.22
Klippans FK
2:16.22
PB
  
3Ida Ignell
Ida Ignell 95, Villstad
2:27.00
Villstad GIF
2:27.00
SB
  
F14 Höjd     


Final A

Final

2Annika Jönsson
1.55
IFK Helsingborg
1.55
PB