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
Arena: Edsbergs Sportfält   Arrangör: Turebergs FK
Tävlande: 12 (6+6)   Starter: 12 (6+6)


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

1Karl Ludvik
2.954
Turebergs FK
2.954
  
2Stellan Back
2.797
Turebergs FK
2.797
PB
  
3Jesper Ahlin
2.703
Turebergs FK
2.703
PB
  
4Teo Paganus
2.416
Turebergs FK
2.416
PB
  
5Fabian Mix
Fabian Mix 05, Tureberg
2.407
Turebergs FK
2.407
PB
  
6Esbjörn Eriksson
1.082
Turebergs FK
1.082
PB
  
Ludvik13.4350.5042.1556.85
Back13.4062.3041.5436.64
Ahlin15.8546.3941.1534.89
Paganus11.6942.0143.3734.47
Mix12.5642.5933.6242.08
Eriksson8.5132.2919.7214.22
M Kula castorama    


Final A

Final

Jesper Ahlin
15.85
Turebergs FK
15.85
PB
  
Karl Ludvik
13.43
Turebergs FK
13.43
PB
  
Stellan Back
13.40
Turebergs FK
13.40
SB
  
Fabian Mix
Fabian Mix 05, Tureberg
12.56
Turebergs FK
12.56
PB
  
Teo Paganus
11.69
Turebergs FK
11.69
PB
  
Esbjörn ErikssonTurebergs FK
8.51
PB
  
Ahlin14.29x15.0515.85
Ludvik13.4312.2612.86x
Back13.2912.7813.4012.64
Mix12.5612.35x12.44
Paganus11.48x11.5911.69
Eriksson8.478.51xx
M Spjut castorama    


Final A

Final

Stellan Back
62.30
Turebergs FK
62.30
  
Karl Ludvik
50.50
Turebergs FK
50.50
  
Jesper Ahlin
46.39
Turebergs FK
46.39
SB
  
Fabian Mix
Fabian Mix 05, Tureberg
42.59
Turebergs FK
42.59
PB
  
Teo Paganus
42.01
Turebergs FK
42.01
PB
  
Esbjörn Eriksson
32.29
Turebergs FK
32.29
PB
  
M Diskus castorama    


Final A

Final

Teo Paganus
43.37
Turebergs FK
43.37
PB
  
Karl Ludvik
42.15
Turebergs FK
42.15
  
Stellan Back
41.54
Turebergs FK
41.54
  
Jesper Ahlin
41.15
Turebergs FK
41.15
PB
  
Fabian Mix
Fabian Mix 05, Tureberg
33.62
Turebergs FK
33.62
PB
  
Esbjörn Eriksson
19.72
Turebergs FK
19.72
PB
  
M Slägga castorama    


Final A

Final

Karl Ludvik
56.85
Turebergs FK
56.85
  
Fabian Mix
Fabian Mix 05, Tureberg
42.08
Turebergs FK
42.08
PB
  
Stellan Back
36.64
Turebergs FK
36.64
SB
  
Jesper Ahlin
34.89
Turebergs FK
34.89
SB
  
Teo Paganus
34.47
Turebergs FK
34.47
PB
  
Esbjörn Eriksson
14.22
Turebergs FK
14.22
PB
  
Kvinnor
K Castorama     


Final A

Final

1Fanny Öhrn SelahnTurebergs FK
2.764
SB
  
2Vilma Damberg
2.471
Turebergs FK
2.471
PB
  
3Sofia Jäger StenbergTurebergs FK
2.311
PB
  
4Elin Runemar
2.303
Turebergs FK
2.303
PB
  
5Molly Skugge
2.148
Turebergs FK
2.148
PB
  
6Annelie SchöldströmTurebergs FK
1.534
SB
  
Öhrn Selahn11.1729.5540.7039.60
Damberg9.1229.6128.2945.13
Jäger Stenberg10.3426.4728.5233.05
Runemar10.1225.2125.7538.63
Skugge8.5621.7420.1948.98
Schöldström7.8013.1818.5129.54
K Kula castorama    


Final A

Final

Fanny Öhrn SelahnTurebergs FK
11.17
SB
  
Sofia Jäger StenbergTurebergs FK
10.34
  
Elin Runemar
10.12
Turebergs FK
10.12
PB
  
Vilma Damberg
9.12
Turebergs FK
9.12
PB
  
Molly Skugge
8.56
Turebergs FK
8.56
  
Annelie SchöldströmTurebergs FK
7.80
SB
  
Öhrn Selahn10.8311.1211.1710.89
Jäger Stenberg10.34xx9.96
Runemar9.499.7810.1210.08
Damberg8.478.578.209.12
Skugge8.207.848.568.36
Schöldström7.677.587.807.65
K Spjut castorama    


Final A

Final

Vilma Damberg
29.61
Turebergs FK
29.61
  
Fanny Öhrn SelahnTurebergs FK
29.55
SB
  
Sofia Jäger StenbergTurebergs FK
26.47
  
Elin Runemar
25.21
Turebergs FK
25.21
PB
  
Molly Skugge
21.74
Turebergs FK
21.74
PB
  
Annelie SchöldströmTurebergs FK
13.18
PB
  
K Diskus castorama    


Final A

Final

Fanny Öhrn SelahnTurebergs FK
40.70
  
Sofia Jäger StenbergTurebergs FK
28.52
  
Vilma Damberg
28.29
Turebergs FK
28.29
PB
  
Elin Runemar
25.75
Turebergs FK
25.75
PB
  
Molly Skugge
20.19
Turebergs FK
20.19
PB
  
Annelie SchöldströmTurebergs FK
18.51
  
K Slägga castorama    


Final A

Final

Molly Skugge
48.98
Turebergs FK
48.98
  
Vilma Damberg
45.13
Turebergs FK
45.13
  
Fanny Öhrn SelahnTurebergs FK
39.60
SB
  
Elin Runemar
38.63
Turebergs FK
38.63
PB
  
Sofia Jäger StenbergTurebergs FK
33.05
PB
  
Annelie SchöldströmTurebergs FK
29.54
SB