27.11
23.11
28.11
27.11
27.11
8.8
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
Arena: Campus Friidrottsarena   Arrangör: IFK Umeå
Tävlande: 7 (5+2)   Starter: 7 (5+2)


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= 12971504 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 Castorama     


Final A

Final

1Lukas Hamrin
2.933
Timrå AIF
2.933
  
2Albin Silén
2.267
Strands IF
2.267
PB
  
3Oskar Antonsson
Oskar Antonsson 98, Trångsviken
2.233
Trångsvikens IF
2.233
  
4Albert OttanderEstuna IF
2.171
PB
  
5Rasmus Hellberg
2.159
IFK Umeå
2.159
PB
  
Hamrin13.3758.3245.5143.84
Silén10.6237.8336.9341.56
Antonsson11.0339.3143.2329.03
Ottander10.8657.2831.7425.76
Hellberg10.5535.0730.1847.48
M Kula castorama    


Final A

Final

Lukas Hamrin
13.37
Timrå AIF
13.37
  
Oskar Antonsson
Oskar Antonsson 98, Trångsviken
11.03
Trångsvikens IF
11.03
  
Albert OttanderEstuna IF
10.86
PB
  
Albin Silén
10.62
Strands IF
10.62
PB
  
Rasmus Hellberg
10.55
IFK Umeå
10.55
PB
  
Hamrin12.6012.4813.37x
Antonsson10.5310.7410.7111.03
Ottander10.7710.86x
Silén10.469.8410.6210.44
Hellberg9.3310.559.679.54
M Spjut castorama    


Final A

Final

Lukas Hamrin
58.32
Timrå AIF
58.32
  
Albert OttanderEstuna IF
57.28
  
Oskar Antonsson
Oskar Antonsson 98, Trångsviken
39.31
Trångsvikens IF
39.31
  
Albin Silén
37.83
Strands IF
37.83
PB
  
Rasmus Hellberg
35.07
IFK Umeå
35.07
  
M Diskus castorama    


Final A

Final

Lukas Hamrin
45.51
Timrå AIF
45.51
  
Oskar Antonsson
Oskar Antonsson 98, Trångsviken
43.23
Trångsvikens IF
43.23
  
Albin Silén
36.93
Strands IF
36.93
PB
  
Albert OttanderEstuna IF
31.74
SB
  
Rasmus Hellberg
30.18
IFK Umeå
30.18
PB
  
M Slägga castorama    


Final A

Final

Rasmus Hellberg
47.48
IFK Umeå
47.48
PB
  
Lukas Hamrin
43.84
Timrå AIF
43.84
PB
  
Albin Silén
41.56
Strands IF
41.56
PB
  
Oskar Antonsson
Oskar Antonsson 98, Trångsviken
29.03
Trångsvikens IF
29.03
  
Albert OttanderEstuna IF
25.76
PB
  
Kvinnor
K Castorama     


Final A

Final

1Amanda Nordin
Amanda Nordin 97, Skellefteå AIK
2.013
Skellefteå AIK
2.013
  
2Lovisa Rutfors
923
IFK Umeå
923
PB
  
Nordin11.4026.9343.18NM
Rutfors6.7613.3011.9013.74
K Kula castorama    


Final A

Final

Amanda Nordin
Amanda Nordin 97, Skellefteå AIK
11.40
Skellefteå AIK
11.40
PB
  
Lovisa Rutfors
6.76
IFK Umeå
6.76
PB
  
Nordin10.2911.4010.10x
Rutfors6.626.59x6.76
K Spjut castorama    


Final A

Final

Amanda Nordin
Amanda Nordin 97, Skellefteå AIK
26.93
Skellefteå AIK
26.93
SB
  
Lovisa Rutfors
13.30
IFK Umeå
13.30
PB
  
K Diskus castorama    


Final A

Final

Amanda Nordin
Amanda Nordin 97, Skellefteå AIK
43.18
Skellefteå AIK
43.18
  
Lovisa Rutfors
11.90
IFK Umeå
11.90
PB
  
K Slägga castorama    


Final A

Final

Lovisa Rutfors
13.74
IFK Umeå
13.74
PB
  
Amanda Nordin
Amanda Nordin 97, Skellefteå AIK
NM
Skellefteå AIK
NM