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
Tävlande: 90 (45+45)   Starter: 90 (45+45)


select distinct results21.*, 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, 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= 12974918 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 Stav     
Inne 2 jan

Final A

Final
Inne 2 jan
1Tyler Carrel
Tyler Carrel , USA
5.15
USA
5.15
PB
  
2Nick Meyer
Nick Meyer 95, USA
5.12
95USA
5.12
SB
  
3Chad Horstmann
Chad Horstmann , USA
5.00
USA
5.00
SB
  
4Kristian Kneffler
Kristian Kneffler , USA
4.85
USA
4.85
PB
  
4Carter Scott
Carter Scott , USA
4.85
USA
4.85
SB
  
6Zach Davis
Zach Davis 01, USA
4.85
01USA
4.85
SB
  
7Austin Hicks
Austin Hicks , USA
4.70
USA
4.70
PB
  
8Alex Hindman
Alex Hindman 98, USA
4.70
98USA
4.70
SB
  
9Kameron Aime
Kameron Aime 01, USA
4.55
01USA
4.55
SB
  
10Nolan Blachowski
Nolan Blachowski , USA
4.55
USA
4.55
PB
  
11Brandon Brookfield
Brandon Brookfield , USA
4.55
USA
4.55
SB
  
Final B
2 jan
2 jan
1Rick Undesser
Rick Undesser , USA
4.85
USA
4.85
PB
  
2Denim Rogers
Denim Rogers 98, USA
4.70
98USA
4.70
PB
  
3Dylan German
Dylan German , USA
4.55
USA
4.55
SB
  
4Andrew Nageotte
Andrew Nageotte , USA
4.55
USA
4.55
PB
  
Final C
2 jan
2 jan
1Alex Cargo
Alex Cargo , USA
4.50
USA
4.50
PB
  
2Rylan Rogers
Rylan Rogers , USA
4.50
USA
4.50
PB
  
Elite M Stav     
Inne 2 jan

Final A

Final
Inne 2 jan
1Jacob Wooten
Jacob Wooten 97, USA
5.75
97USA
5.75
SB
  
2Nate Richartz
Nate Richartz 94, USA
5.75
94USA
5.75
PB
  
3Tray Oates
Tray Oates 95, USA
5.60
95USA
5.60
SB
  
4Branson Ellis
Branson Ellis 00, USA
5.50
00USA
5.50
SB
  
4Reese Watson
Reese Watson 93, USA
5.50
93USA
5.50
SB
  
6Matt Ludwig
Matt Ludwig 96, USA
5.40
96USA
5.40
SB
  
Final B
2 jan
2 jan
1Carson Waters
Carson Waters 96, USA
5.60
96USA
5.60
SB
  
2Scott Houston
Scott Houston 90, USA
5.50
90USA
5.50
  
3Austin Miller
Austin Miller 94, USA
5.40
94USA
5.40
  
4Michael Carr
Michael Carr 96, USA
5.15
96USA
5.15
  
5Alex Jacobs
Alex Jacobs , USA
5.15
USA
5.15
SB
  
6Nathan Hiett
Nathan Hiett 94, USA
5.00
94USA
5.00
SB
  
7Sean Young
Sean Young 85, USA
5.00
85USA
5.00
SB
  
8Grant Sisserson
Grant Sisserson 95, USA
5.00
95USA
5.00
SB
  
HS M Stav     
Inne 2 jan

Final A

Final
Inne 2 jan
1Clayton Simms
Clayton Simms 02, USA
5.20
02USA
5.20
  
2Carson Lenser
Carson Lenser 03, USA
4.85
03USA
4.85
  
3Beau Domingue
Beau Domingue , USA
4.70
USA
4.70
SB
  
4Jack Mann
Jack Mann , USA
4.70
USA
4.70
  
5Caleb Murdock
Caleb Murdock , USA
4.70
USA
4.70
SB
  
6Clark Hobbs
Clark Hobbs , USA
4.70
USA
4.70
PB
  
7James Rhoads
James Rhoads 03, USA
4.70
03USA
4.70
PB
  
Final B
1 jan
1 jan
1Brady Koolen
Brady Koolen , USA
4.82
USA
4.82
PB
  
2Brady Shadrick
Brady Shadrick , USA
4.67
USA
4.67
PB
  
3Ford Mayberry
Ford Mayberry , USA
4.67
USA
4.67
PB
  
4Wyatt Stewart
Wyatt Stewart , USA
4.67
USA
4.67
SB
  
5Jack De Francesco
Jack De Francesco , USA
4.67
USA
4.67
PB
  
Final C
2 jan
2 jan
1Hunter Cook
Hunter Cook , USA
4.67
USA
4.67
PB
  
Final D
2 jan
2 jan
1Grady Ward
Grady Ward , USA
4.80
USA
4.80
PB
  
Kvinnor
K Stav     
Inne 2 jan

Final A

Final
Inne 2 jan
1Savanah Amato
Savanah Amato , USA
4.13
USA
4.13
SB
  
1Casie Cullinane
Casie Cullinane , USA
3.60
USA
3.60
PB
  
2Karlee Fowler
Karlee Fowler 96, USA
4.00
96USA
4.00
=PB
  
3Taylor Starkey
Taylor Starkey , USA
3.85
USA
3.85
  
4Cat Patton
Cat Patton , USA
3.85
USA
3.85
PB
  
5Calie Spencer
Calie Spencer 96, USA
3.85
96USA
3.85
SB
  
6Nicole Berske
Nicole Berske , USA
3.70
USA
3.70
PB
  
6Riley Caudill
Riley Caudill , USA
3.70
USA
3.70
SB
  
8Riley Floerke
Riley Floerke 00, USA
3.70
00USA
3.70
SB
  
9Mackenzie West
Mackenzie West 97, USA
3.55
97USA
3.55
SB
  
10Whitney Bice
Whitney Bice 94, USA
3.55
94USA
3.55
SB
  
11Kaydin Pursley
Kaydin Pursley , USA
3.55
USA
3.55
PB
  
Elite K Stav     
Inne 2 jan

Final A

Final
Inne 2 jan
1Anicka Newell
Anicka Newell 93, CAN
4.70
93CAN
4.70
PB
  
2Alysha Newman
Alysha Newman 94, CAN
4.65
94CAN
4.65
SB
  
3Kortney Ross
Kortney Ross 92, USA
4.50
92USA
4.50
SB
  
4Megan Zimlich
Megan Zimlich 93, USA
4.15
93USA
4.15
  
HS K Stav     
Inne 2 jan

Final A

Final
Inne 2 jan
1Emery Prentice
Emery Prentice , USA
4.00
USA
4.00
  
2Olivia Lueking
Olivia Lueking 03, USA
3.85
03USA
3.85
  
3Rachel Homoly
Rachel Homoly 05, USA
3.85
05USA
3.85
  
4Heather Abadie
Heather Abadie 03, CAN
3.85
03CAN
3.85
  
4Emily Fitzsimmons
Emily Fitzsimmons , USA
3.85
USA
3.85
SB
  
4Payton Phillips
Payton Phillips 03, USA
3.85
03USA
3.85
SB
  
4Sky Schuller
Sky Schuller 05, USA
3.85
05USA
3.85
PB
  
8Mimi McHugh
Mimi McHugh , USA
3.70
USA
3.70
  
1Lilly Nichols
Lilly Nichols 06, POL
3.96
06POL
3.96
PB
  
3.143.303.453.603.753.813.964.11
Prentice
Lueking
Homoly
Abadie
Fitzsimmons
Phillips
Schuller
McHugh
Nicholsoooxoxoxoxoxxx
Final B
1 jan
1 jan
1Kashlee Dickinson
Kashlee Dickinson , USA
3.91
USA
3.91
PB
  
2Molly Haywood
Molly Haywood , USA
3.91
USA
3.91
PB
  
3Johanna DuplantisSWE
3.75
PB
  
3Kylie Clark
Kylie Clark , USA
3.75
USA
3.75
PB
  
5Hadley Jetmore
Hadley Jetmore 02, USA
3.75
02USA
3.75
SB
  
6Katie Schlather
Katie Schlather 03, USA
3.75
03USA
3.75
SB
  
6Joy Sherwood
Joy Sherwood , USA
3.75
USA
3.75
SB
  
8Kila Davis
Kila Davis , USA
3.75
USA
3.75
PB
  
9Rachael Allen
Rachael Allen , USA
3.75
USA
3.75
SB
  
10Lily Fleetwood
Lily Fleetwood , USA
3.60
USA
3.60
SB
  
11Alyssa Quinones-Mixon
Alyssa Quinones-Mixon 04, USA
3.60
04USA
3.60
SB
  
12Brynn Rychlik
Brynn Rychlik , USA
3.60
USA
3.60
  
Final C
1 jan
1 jan
1Lillianna Ifft
Lillianna Ifft 03, USA
3.75
03USA
3.75
PB
  
2Claire Bybee
Claire Bybee , USA
3.60
USA
3.60
SB
  
Final D
2 jan
2 jan
1Katie Wright
Katie Wright , USA
3.60
USA
3.60
PB
  
Final E
1 jan
1 jan
1Anna Willis
Anna Willis , USA
3.60
USA
3.60
  
2Kade Joslin
Kade Joslin , USA
3.60
USA
3.60
PB
  
3Nikolette Schmidt
Nikolette Schmidt , USA
3.60
USA
3.60
PB
  
3Lauren Schmitt
Lauren Schmitt , USA
3.60
USA
3.60
PB
  
F15 Stav     
Inne 1 jan

Final A

Final
Inne 1 jan
1Addison Kleinke
Addison Kleinke , USA
3.45
USA
3.45
PB