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
5.8
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
24.10
24.10
9.10
Arena: Sätrahallen
Tävlande: 60 (27+33)   Starter: 60 (27+33)


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

Final A

Final
Inne
1Stellan Back
4.32
Turebergs FK
4.32
SB
  
1Theodor Duvert
3.42
Turebergs FK
3.42
SB
  
1Oskar Törnvall
2.82
Hammarby IF
2.82
PB
  
1Pål Haugen Lillefosse
Pål Haugen Lillefosse 01, NOR
5.50
01NOR
5.50
PB =NU20R
  
2Urho Kujanpää
Urho Kujanpää 97, FIN
5.42
97FIN
5.42
  
3Tommi Holttinen
Tommi Holttinen 97, FIN
5.42
97FIN
5.42
SB
  
4Huang Bokai 
Huang Bokai  96, CHN
5.32
96CHN
5.32
  
5Zhang Yifan 
Zhang Yifan  96, CHN
5.22
96CHN
5.22
SB
  
6Carl Sténson
5.12
Hellas FK
5.12
  
7Eetu Turakainen
Eetu Turakainen 98, FIN
5.12
98FIN
5.12
SB
  
5.025.125.225.325.425.505.60
Back
Duvert
Törnvall
Lillefosse-xo-ooxoxxx
Kujanpää--o-xoxxx
Holttinen-xo-xoxoxxx
Huang Bokai---xoxxx
Zhang Yifanxooxoxxx
Sténsonxooxxx
Turakainenoxxoxxx
Final B
1Fredrik Weiseth
Fredrik Weiseth 94, NOR
5.12
94NOR
5.12
PB
  
2Simon Thor
5.02
IFK Märsta
5.02
PB
  
3Carl af Forselles
4.92
Hässelby SK
4.92
PB
  
4Jami Siira
Jami Siira 01, FIN
4.82
01FIN
4.82
PB
  
5Fredrik SamuelssonHässelby SK
4.82
SB
  
6Tom Johansson
Tom Johansson 99, KFUM Örebro
4.72
KFUM Örebro
4.72
  
7Emil Carlsson
Emil Carlsson 02, IFK Växjö
4.72
IFK Växjö
4.72
PB
  
8Yoann Rouzières
4.52
Hässelby SK
4.52
SB
  
9Robin JacobssonUllevi FK
4.52
  
4.424.524.624.724.824.925.025.125.22
Weiseth----o-oxox
Thor--o-xxooxoxxx
af Forselles--xo-xoxxoxxx
Siira-oxooxxoxxx
Samuelssonxo-oxxoxxoxxx
Johansson--oxoxxx
Carlssonoooxxoxxx
Rouzières-oxxx
Jacobsson-xo-xxx
Final C
1Juho Alasaari
Juho Alasaari 03, FIN
4.72
03FIN
4.72
PB
  
2Carl-Einar Söderström EskonniemiHellas FK
4.42
  
3Samuel ErikssonRånäs 4H
4.22
PB
  
4Tobias Solberg
4.02
Hässelby SK
4.02
SB
  
5Edvin Hagberg
4.02
Turebergs FK
4.02
SB
  
6Jonathan HowserTäby IS
3.92
  
7Otto Hiivola
Otto Hiivola 04, FIN
3.92
04FIN
3.92
PB
  
8Per Drageryd
Per Drageryd 91, KFUM Örebro
3.82
KFUM Örebro
3.82
SB
  
3.823.924.024.124.224.324.424.524.624.724.82
Alasaari--o-oooooxxoxxx
Söderström Eskonniemi----xxoxoxoxxx
Eriksson-xoooxoxxx
Solberg--oxxx
Hagbergo-xxo-xxx
Howserooxxx
Hiivolaxoxoxxx
Dragerydo-xxx
Kvinnor
K Stav     
Inne

Final A

Final
Inne
1Angelica BengtssonHässelby SK
4.60
SB
  
2Michaela Meijer
4.42
Örgryte IS
4.42
  
3Xu Huiqin 
Xu Huiqin  93, CHN
4.42
93CHN
4.42
PB
  
4Minna Nikkanen
Minna Nikkanen 88, FIN
4.32
88FIN
4.32
SB
  
5Saga Andersson
Saga Andersson 00, FIN
4.22
00FIN
4.22
  
6Hanna Jansson
4.02
Ullevi FK
4.02
  
7Malin Dahlström
3.92
Örgryte IS
3.92
SB
  
8Aino Siitonen
Aino Siitonen 94, FIN
3.82
94FIN
3.82
  
Mallaury Sautereau
Mallaury Sautereau 96, FRA
NH
96FRA
NH
  
Fanny BerglundÖrgryte IS
NH
  
3.823.924.024.124.224.324.424.524.604.71
Bengtsson------o-xxoxxx
Meijer------o-xxx
Xu Huiqin----oxooxxx
Nikkanen---oxxoxxx
Andersson--oooxxx
Jansson-ooxxx
Dahlström-oxxx
Siitonenxoxxx
Sautereau--xxx
Berglundxxx
Final B
1Alva Sundin
3.92
Täby IS
3.92
PB
  
2Filippa Miller
3.92
Hovslätts IK
3.92
PB
  
3Anna Gordon
Anna Gordon 97, GBR
3.82
97GBR
3.82
  
4Essi Melender
Essi Melender 02, FIN
3.72
02FIN
3.72
PB
  
4Silja Andersson
Silja Andersson 03, FIN
3.72
03FIN
3.72
  
6Kiia Jullenmaa
Kiia Jullenmaa 01, FIN
3.72
01FIN
3.72
PB
  
6Pinja Koivumäki
Pinja Koivumäki 98, FIN
3.72
98FIN
3.72
PB
  
8Sandra AlveroHabo FIF-04
3.62
SB
  
9Tilda Kapell
3.52
Hammarby IF
3.52
SB
  
10Sophie Ohlsson
Sophie Ohlsson 99, IFK Växjö
3.52
IFK Växjö
3.52
SB
  
3.423.523.623.723.823.924.02
Sundin---ooxoxxx
Miller--oxooxxx
Gordon---oxxoxxx
Melenderooxxooxxx
Anderssonxooxooxxx
Jullenmaaoooxoxxx
Koivumäkioooxoxxx
Alvero--o-xxx
Kapellooxxx
Ohlssonoxoxxx
Final C
1Emma Rovasalo
Emma Rovasalo 03, FIN
3.72
03FIN
3.72
PB
  
2Greta ErlandssonRånäs 4H
3.62
  
3Molly Elliott
Molly Elliott 02, GBR
3.52
02GBR
3.52
PB
  
4Ebba Blomstrand
Ebba Blomstrand 00, KFUM Örebro
3.42
KFUM Örebro
3.42
SB
  
5Alvah Lind
3.42
Tyresö FK
3.42
  
6Olivia Härkönen
Olivia Härkönen 02, FIN
3.42
02FIN
3.42
PB
  
7Hilma Hindsberg
3.32
Kvarnsvedens GoIF
3.32
  
8Sara WinbergTäby IS
3.12
  
9Johanna Hellman
3.02
IFK Lidingö
3.02
SB
  
10Tilda FischerHabo FIF-04
3.02
SB
  
Madeleine EngströmHuddinge AIS
NH
  
2.923.023.123.223.323.423.523.623.723.82
Rovasalo----oooxooxxx
Erlandsson----xooxoxoxxx
Elliott---o-xooxxx
Blomstrand--oxoooxxx
Lind---oxxoxxoxxx
Härkönen-oxoxoxxoxxoxxx
Hindsberg--ooxoxxx
Winberg--xxo-xxx
Hellman-o-xxx
Fischerxooxxx
Engström-xxx
Final F
1Linnéa LindefalkHammarby IF
2.42
PB
  
4Tyra Hedberg
2.22
Hammarby IF
2.22
PB