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
Arena: Malmö Stadions kastplan   Arrangör: Heleneholms IF
Tävlande: 27 (9+18)   Starter: 42 (13+29)


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


Final A

Final

1Ryan McCulloughMalmö AI
63.62
SB
  
P19 Slägga (6.0 kg)     


Final A

Final

1Hampus Wallin
63.58
Hovslätts IK
63.58
  
P17 Diskus (1.5 kg)     


Final A

Final

1Hugo Kajsjö
37.58
IK Lerum FI
37.58
  
P15 Kula (4.0 kg)     


Final A

Final

1Casper Griphage
12.01
IFK Trelleborg
12.01
  
Griphage11.7611.4012.0111.6711.8011.71
P15 Diskus (1.0 kg)     


Final A

Final

1Casper Griphage
44.69
IFK Trelleborg
44.69
  
2Jakob Romberg
Jakob Romberg 05, Hässleholm
41.88
Hässleholms AIS
41.88
PB
  
P15 Slägga (4.0 kg)     


Final A

Final

1Jakob Romberg
Jakob Romberg 05, Hässleholm
40.86
Hässleholms AIS
40.86
PB
  
P13 Kula (3.0 kg)     


Final A

Final

1Eric Hansson
12.05
Malmö AI
12.05
  
Hanssonxx10.8412.0511.3411.59
P13 Diskus (0.6 kg)     


Final A

Final

1Eric Hansson
38.99
Malmö AI
38.99
PB
  
M45 Kula     


Final A

Final

1Stefan HanssonMalmö AI
7.95
PB
  
Hansson7.417.447.337.737.957.24
M60 Kula (5.0 kg)     


Final A

Final

1Dan Lindahl
12.02
IFK Lund
12.02
PB
  
Lindahl10.9111.7612.02
M60 Diskus (1.0 kg)     


Final A

Final

1Dan Lindahl
36.04
IFK Lund
36.04
  
M65 Diskus (1.0 kg)     


Final A

Final

1Mikael SörenssonIFK Lund
31.13
  
Kvinnor
K Kula     


Final A

Final

1Victoria QuainooMalmö AI
13.20
PB
  
2Karolina WamslerIFK Lund
10.97
PB
  
3Annika HanssonMalmö AI
8.60
PB
  
Quainoo13.20xx12.7012.64x
Wamsler10.4510.439.4710.5310.9710.04
Hansson8.448.128.608.07x8.08
K Diskus     


Final A

Final

1Emilia Wamsler
41.40
Heleneholms IF
41.40
  
2Karolina WamslerIFK Lund
34.57
  
3Thea Löfman
34.57
Malmö AI
34.57
  
4Tilde Grönwall
30.85
Öresund FK
30.85
  
5Ella Eklund
30.76
Öresund FK
30.76
  
6Saga Redestam
Saga Redestam 04, Helsingborg
27.37
IFK Helsingborg
27.37
PB
  
7Alicia Byström
24.41
Hässleholms AIS
24.41
  
K Slägga     


Final A

Final

1Jennifer Quick
51.01
Malmö AI
51.01
  
2Victoria QuainooMalmö AI
49.30
SB
  
3Hanna GrönwallMalmö AI
46.77
SB
  
4Alicia Byström
35.95
Hässleholms AIS
35.95
  
5Annika Hansson
22.90
Malmö AI
22.90
PB
  
F17 Kula (3.0 kg)     


Final A

Final

1Thea Löfman
13.37
Malmö AI
13.37
  
2Mira Johansson
10.92
Malmö AI
10.92
PB
  
3Alba Hansson
9.59
Malmö AI
9.59
  
Löfman12.93x13.3712.88xx
Johansson10.7510.8410.929.98x9.16
Hanssonx9.599.44x8.999.29
F17 Slägga (3.0 kg)     


Final A

Final

1Tilde Grönwall
46.94
Öresund FK
46.94
  
2Elin Rydqvist
46.11
IFK Halmstad
46.11
PB
  
3Matilda Karlsson
38.41
IFK Helsingborg
38.41
  
4Saga Redestam
Saga Redestam 04, Helsingborg
36.80
IFK Helsingborg
36.80
PB
  
F15 Diskus (0.75 kg)     


Final A

Final

1Hanna KamradIFK Lund
33.15
  
2Alba Hansson
32.11
Malmö AI
32.11
PB
  
3Mira Johansson
25.43
Malmö AI
25.43
  
F15 Slägga (3.0 kg)     


Final A

Final

1Hanna KamradIFK Lund
32.90
SB
  
2Alba Hansson
27.28
Malmö AI
27.28
  
F13 Kula (2.0 kg)     


Final A

Final

1Isabella EnggrenMalmö AI
11.10
  
Enggren10.7211.1010.2610.3410.859.99
K55 Slägga (3.0 kg)     


Final A

Final

1Ann-Christin LindIFK Lund
37.24
SB