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
Tävlande: 128 (70+58)   Starter: 128 (70+58)


select distinct results19.*, 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, 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= 12916370 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 18 jan

Final A

Final
Inne 18 jan
1Matt Ludwig
Matt Ludwig 96, USA
5.71
96USA
5.71
PB
  
2Seito Yamamoto
Seito Yamamoto 92, JPN
5.71
92JPN
5.71
SB
  
3Andrew Irwin
Andrew Irwin 93, USA
5.61
93USA
5.61
  
4Devin King
Devin King 96, USA
5.51
96USA
5.51
SB
  
4Armand DuplantisSWE
5.51
SB
  
6Nate Richartz
Nate Richartz 94, USA
5.51
94USA
5.51
SB
  
7Sondre Guttormsen
Sondre Guttormsen 99, NOR
5.41
99NOR
5.41
  
Cole Walsh
Cole Walsh 95, USA
NH
95USA
NH
  
Shawnacy Barber
Shawnacy Barber 94, CAN
NH
94CAN
NH
  
Scott Houston
Scott Houston 90, USA
NH
90USA
NH
  
5.265.415.515.615.715.81
Ludwig-ooxooxxx
Yamamoto-xoooxoxxx
Irwin--ooxxx
King-ooxpxpx
Duplantis--o-xxx
Richartz-xxoxoxxx
Guttormsen-oxxpx
Walsh-xpxx
Barberxxx
Houstonxxx
Final B
18 jan
18 jan
1Austin Miller
Austin Miller 94, USA
5.51
94USA
5.51
SB
  
2Audie Wyatt
Audie Wyatt 96, USA
5.51
96USA
5.51
SB
  
3Victor Weirich
Victor Weirich 87, USA
5.41
87USA
5.41
SB
  
4Garrett Starkey
Garrett Starkey 93, USA
5.41
93USA
5.41
SB
  
5Tim Ehrhardt
Tim Ehrhardt 95, USA
5.41
95USA
5.41
SB
  
6Nick Meyer
Nick Meyer 95, USA
5.26
95USA
5.26
  
6Tray Oates
Tray Oates 95, USA
5.26
95USA
5.26
  
8Jake Albright
Jake Albright 93, USA
5.26
93USA
5.26
SB
  
9Scott Marshall
Scott Marshall 95, USA
5.06
95USA
5.06
SB
  
Final C
18 jan
18 jan
1Hunter Arnold
Hunter Arnold 94, USA
4.85
94USA
4.85
SB
  
2Jacob Flores
Jacob Flores , USA
4.85
USA
4.85
SB
  
3Tyler Knight
Tyler Knight 94, USA
4.85
94USA
4.85
SB
  
4Caleb Phillips
Caleb Phillips , USA
4.65
USA
4.65
  
Open M Stav     
Inne 19 jan

Final A

Final
Inne 19 jan
1August Kiles
August Kiles 95, USA
5.35
95USA
5.35
SB
  
2Carson Waters
Carson Waters 96, USA
5.20
96USA
5.20
  
3Michael Cyphers
Michael Cyphers 93, USA
5.20
93USA
5.20
SB
  
4Kota Suzuki
Kota Suzuki 95, JPN
5.20
95JPN
5.20
=PB
  
5Tomoki Yamamoto
Tomoki Yamamoto 92, JPN
5.20
92JPN
5.20
PB
  
5Hiroki Ogita
Hiroki Ogita 87, JPN
5.20
87JPN
5.20
SB
  
6Grant Sisserson
Grant Sisserson 95, USA
5.20
95USA
5.20
SB
  
7Tate Curran
Tate Curran 99, USA
5.20
99USA
5.20
SB
  
8Hiroaki Yonehara
Hiroaki Yonehara 93, JPN
5.05
93JPN
5.05
  
9Koh Kogiso
Koh Kogiso 97, JPN
5.05
97JPN
5.05
PB
  
10Alec Hsu Li-Ming
Alec Hsu Li-Ming 91, TPE
5.05
91TPE
5.05
SB
  
Final B
19 jan
19 jan
1Simen Guttormsen
Simen Guttormsen 01, NOR
5.15
01NOR
5.15
PB
  
2Michael Gonzalez
Michael Gonzalez 98, USA
5.05
98USA
5.05
PB
  
3Aleksandris Eglitis
Aleksandris Eglitis , USA
4.90
USA
4.90
PB
  
4Kevin Ward
Kevin Ward , USA
4.90
USA
4.90
PB
  
5Aj Hop
Aj Hop , USA
4.75
USA
4.75
PB
  
6Keith Rayburn
Keith Rayburn 92, MEX
4.75
92MEX
4.75
SB
  
7Kyle Brown
Kyle Brown , USA
4.75
USA
4.75
SB
  
Final C
19 jan
19 jan
1Alejandro Avila
Alejandro Avila , USA
4.75
USA
4.75
PB
  
2Matt Hunt
Matt Hunt , USA
4.60
USA
4.60
PB
  
2Zayn Largent
Zayn Largent , USA
4.60
USA
4.60
=PB
  
4Norman Napolitano
Norman Napolitano , USA
4.60
USA
4.60
PB
  
5Mason Pierce
Mason Pierce , USA
4.60
USA
4.60
PB
  
Final D
19 jan
19 jan
1Thomas Slakey
Thomas Slakey , USA
4.60
USA
4.60
PB
  
2Nathaniel Carranza
Nathaniel Carranza , USA
4.60
USA
4.60
PB
  
HS M Stav     
Inne
Inne
Final B
19 jan
19 jan
1Max Manson
Max Manson 00, USA
4.97
00USA
4.97
  
2Nicholas Russell
Nicholas Russell , USA
4.97
USA
4.97
PB
  
2Jacob Rice
Jacob Rice 01, USA
4.97
01USA
4.97
PB
  
4Park Seung 
Park Seung  00, KOR
4.97
00KOR
4.97
PB
  
5Dalton Shepler
Dalton Shepler 01, USA
4.82
01USA
4.82
  
5Keaton Daniel
Keaton Daniel 01, USA
4.82
01USA
4.82
PB
  
7Grant Levesque
Grant Levesque 00, USA
4.82
00USA
4.82
  
8Bowman Starr
Bowman Starr 01, USA
4.67
01USA
4.67
  
Final B
19 jan
19 jan
1Scott Toney
Scott Toney 02, USA
4.87
02USA
4.87
PB
  
2Dillon McCarthy
Dillon McCarthy 02, USA
4.87
02USA
4.87
PB
  
3Timothy Ellis
Timothy Ellis , USA
4.77
USA
4.77
PB
  
4Zachary Klobutcher
Zachary Klobutcher , USA
4.72
USA
4.72
PB
  
Coll M Stav     
Inne
Inne
Final B
19 jan
19 jan
1Zach Bradford
Zach Bradford 99, USA
5.50
99USA
5.50
PB
  
2Kyle Rogers
Kyle Rogers 99, USA
5.50
99USA
5.50
PB
  
3Hussain Asim Al-Hizam
Hussain Asim Al-Hizam 98, KSA
5.30
98KSA
5.30
SB
  
4Paulo Benavides
Paulo Benavides 97, USA
5.30
97USA
5.30
SB
  
5Cole Wigal
Cole Wigal , USA
5.20
USA
5.20
  
6Matthew Keim
Matthew Keim , USA
5.05
USA
5.05
PB
  
7Tyler Fraker
Tyler Fraker , USA
4.90
USA
4.90
SB
  
8Justin Petz
Justin Petz , USA
4.90
USA
4.90
=PB
  
9Seth Wilmoth
Seth Wilmoth , USA
4.70
USA
4.70
PB
  
10Adam Alexander
Adam Alexander , USA
4.70
USA
4.70
SB
  
Kvinnor
K Stav     
Inne 18 jan

Final A

Final
Inne 18 jan
1Ekateríni Stefanídi
Ekateríni Stefanídi 90, GRE
4.74
90GRE
4.74
SB
  
2Katie Nageotte
Katie Nageotte 91, USA
4.74
91USA
4.74
SB
  
3Lexi Jacobus
Lexi Jacobus 96, USA
4.66
96USA
4.66
=PB
  
4Morgann LeLeux
Morgann LeLeux 92, USA
4.56
92USA
4.56
SB
  
4Alysha Newman
Alysha Newman 94, CAN
4.56
94CAN
4.56
SB
  
6Annie Johnigan
Annie Johnigan 95, USA
4.56
95USA
4.56
=PB
  
7Kristen Leland
Kristen Leland 92, USA
4.46
92USA
4.46
=SB
  
8Lucy Bryan
Lucy Bryan 95, GBR
4.36
95GBR
4.36
SB
  
9Xu Huiqin 
Xu Huiqin  93, CHN
4.21
93CHN
4.21
  
10Emily Grove
Emily Grove 93, USA
4.21
93USA
4.21
  
4.214.364.464.564.664.744.86
Stefanídi---ooxoxxx
Nageotte--oxxooxoxxx
Jacobusoooxoxoxxx
LeLeux-oxooxxx
Newman-xoooxxx
Johniganoooxxoxxx
Leland--oxxx
Bryan
Xu Huiqin
Grove
Final B
18 jan
18 jan
1Tori Hoggard
Tori Hoggard 96, USA
4.46
96USA
4.46
SB
  
2Kortney Ross
Kortney Ross 92, USA
4.46
92USA
4.46
SB
  
3Bonnie Draxler
Bonnie Draxler 95, USA
4.36
95USA
4.36
PB
  
4Lakan Taylor
Lakan Taylor 95, USA
4.21
95USA
4.21
SB
  
5Jill Marois
Jill Marois 94, USA
4.01
94USA
4.01
  
Alex Pevtsova
Alex Pevtsova 93, USA
NH
93USA
NH
  
Jax Williams
Jax Williams 94, USA
NH
94USA
NH
  
Kristen Brown
Kristen Brown 92, USA
NH
92USA
NH
  
Anjuli Knäsche
Anjuli Knäsche 93, GER
NH
93GER
NH
  
Open K Stav     
Inne 19 jan

Final A

Final
Inne 19 jan
1Megan Zimlich
Megan Zimlich 93, USA
4.30
93USA
4.30
PB
  
2Ariel Lieghio
Ariel Lieghio 92, USA
4.20
92USA
4.20
SB
  
3Natalie Uy
Natalie Uy 94, USA
4.20
94USA
4.20
PB
  
4Zaida Uresty
Zaida Uresty 98, MEX
3.85
98MEX
3.85
PB
  
5Alisandra Negrete
Alisandra Negrete 92, MEX
3.85
92MEX
3.85
SB
  
6Becky Szabo
Becky Szabo 95, USA
3.85
95USA
3.85
SB
  
7Erika Fiedler
Erika Fiedler 91, CAN
3.85
91CAN
3.85
SB
  
8Olimpia Villalobos
Olimpia Villalobos , MEX
3.65
MEX
3.65
PB
  
9Karlee Fowler
Karlee Fowler 96, USA
3.65
96USA
3.65
SB
  
10Bryn Williamson
Bryn Williamson , USA
3.65
USA
3.65
SB
  
10Yeoryia Stefanídi
Yeoryia Stefanídi 95, GRE
3.65
95GRE
3.65
SB
  
Karin Fisher
Karin Fisher 88, USA
NH
88USA
NH
  
Final B
19 jan
19 jan
1Annjolina Wessels
Annjolina Wessels , USA
3.75
USA
3.75
PB
  
1Rachel Schmoekel
Rachel Schmoekel , USA
3.75
USA
3.75
=PB
  
HS K Stav     
Inne
Inne
1Brynn King
Brynn King 00, USA
3.91
00USA
3.91
PB
  
Final C
19 jan
19 jan
1Chloe Cunliffe
Chloe Cunliffe 00, USA
4.26
00USA
4.26
PB
  
1Maya Maloney
Maya Maloney 01, USA
3.75
01USA
3.75
PB
  
2Lindsay Absher
Lindsay Absher 00, USA
4.01
00USA
4.01
PB
  
2Johanna DuplantisSWE
3.65
PB
  
3Riley Floerke
Riley Floerke 00, USA
3.86
00USA
3.86
  
4Gracie Jauch
Gracie Jauch 01, USA
3.86
01USA
3.86
  
5Laurel Wong
Laurel Wong , USA
3.70
USA
3.70
SB
  
6Elizabeth Funk
Elizabeth Funk 00, USA
3.70
00USA
3.70
PB
  
7Julia Fixsen
Julia Fixsen 00, USA
3.70
00USA
3.70
SB
  
9Taylor Starkey
Taylor Starkey , USA
3.70
USA
3.70
PB
  
Coll K Stav     
Inne 19 jan

Final A

Final
Inne 19 jan
1Andrea Willis
Andrea Willis 98, USA
4.35
98USA
4.35
PB
  
2Desiree Freier
Desiree Freier 96, USA
4.10
96USA
4.10
  
3Abby Helminiak
Abby Helminiak , USA
4.10
USA
4.10
SB
  
4Alysia Allen
Alysia Allen , USA
3.95
USA
3.95
SB
  
5Alexis Romero
Alexis Romero 96, USA
3.95
96USA
3.95
  
6Morgan Hartsell
Morgan Hartsell 96, USA
3.95
96USA
3.95
SB
  
7Khristen Bryant
Khristen Bryant 98, USA
3.75
98USA
3.75
  
7Rylee Robinson
Rylee Robinson 97, USA
3.75
97USA
3.75
  
9Kaitlin Heri
Kaitlin Heri , USA
3.75
USA
3.75
PB
  
10Eboni Hall
Eboni Hall , USA
3.75
USA
3.75
  
11Dana Bowers
Dana Bowers , USA
3.75
USA
3.75
PB
  
11Marissa Berry
Marissa Berry 97, USA
3.75
97USA
3.75
SB
  
13Taylor Alexander
Taylor Alexander , USA
3.75
USA
3.75
SB
  
Final B
19 jan
19 jan
1Amy Stelly
Amy Stelly 97, USA
3.70
97USA
3.70