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: 92 (43+49)   Starter: 117 (50+67)


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

Final A

Final
Inne
1Cornelius Strickland
Cornelius Strickland 93, USA
6.86
93USA
6.86
SB
  
M 300 m     
Inne

Final A

Final
Inne
1Rondell Sorrillo
Rondell Sorrillo 86, TTO
34.02
86TTO
34.02
SB
  
M 1000 m     
Inne

Final A

Final
Inne
1Tre Kinnaird
Tre Kinnaird 95, USA
2:23.84
95USA
2:23.84
PB
  
2Rorey Hunter
Rorey Hunter 93, AUS
2:25.39
93AUS
2:25.39
PB
  
3Scott Arsenault
Scott Arsenault 95, USA
2:25.92
95USA
2:25.92
PB
  
4Owen Skeete
Owen Skeete 93, USA
2:26.52
93USA
2:26.52
PB
  
M 1 mile     
Inne

Final A

Final
Inne
1John Darmody
John Darmody , USA
4:08.70
USA
4:08.70
PB
  
M 3000 m     
Inne

Final A

Final
Inne
1Jeremy Coughler
Jeremy Coughler 95, CAN
8:18.39
95CAN
8:18.39
PB
  
2David Timlin
David Timlin 94, USA
8:19.42
94USA
8:19.42
PB
  
M 5000 m     
Inne

Final A

Final
Inne
1Brian Shrader
Brian Shrader 91, USA
13:40.94
91USA
13:40.94
PB
  
1Joshua Mirth
Joshua Mirth , USA
14:17.84
USA
14:17.84
PB
  
2Craig Lutz
Craig Lutz 92, USA
13:47.09
92USA
13:47.09
PB
  
3Edwin Kibichiy
Edwin Kibichiy 92, KEN
13:53.18
92KEN
13:53.18
PB
  
4Caleb Hoover
Caleb Hoover 92, USA
13:58.03
92USA
13:58.03
PB
  
5Weston Strum
Weston Strum 92, USA
14:02.09
92USA
14:02.09
PB
  
6Alejandro Arroyo
Alejandro Arroyo 91, MEX
14:05.87
91MEX
14:05.87
PB
  
7Andrew Mclain
Andrew Mclain , USA
14:13.98
USA
14:13.98
PB
  
8Erik Peterson
Erik Peterson 94, USA
14:18.67
94USA
14:18.67
SB
  
M 60 m häck     
Inne

Final A

Final
Inne
1Greggmar Swift
Greggmar Swift 91, BAR
7.62
91BAR
7.62
PB
  
2Keith Hayes
Keith Hayes 90, USA
7.80
90USA
7.80
SB
  
3Adarius Washington
Adarius Washington 92, USA
7.85
92USA
7.85
PB
  
4Nick Anderson
Nick Anderson 95, USA
7.90
95USA
7.90
PB
  
5Ingvar Moseley
Ingvar Moseley 91, CAN
8.15
91CAN
8.15
  
6Daley Carter
Daley Carter 94, BAR
8.16
94BAR
8.16
PB
  
Heat 1
1Keith Hayes
Keith Hayes 90, USA
7.90
90USA
7.90
SB
  
Heat 2
1Greggmar Swift
Greggmar Swift 91, BAR
7.70
91BAR
7.70
SB
  
Heat 3
1Nick Anderson
Nick Anderson 95, USA
7.95
95USA
7.95
PB
  
2Ingvar Moseley
Ingvar Moseley 91, CAN
8.12
91CAN
8.12
SB
  
Heat 4
1Adarius Washington
Adarius Washington 92, USA
7.99
92USA
7.99
SB
  
2Marcus Neely
Marcus Neely 94, USA
8.15
94USA
8.15
PB
  
M Stav     
Inne

Final A

Final
Inne
1Scott Houston
Scott Houston 90, USA
5.25
90USA
5.25
SB
  
2Drew Volz
Drew Volz 92, USA
5.25
92USA
5.25
=PB
  
3Josh Dangel
Josh Dangel 91, USA
5.10
91USA
5.10
SB
  
Colt Robinson
Colt Robinson 93, USA
NH
93USA
NH
  
M Längd     
Inne

Final A

Final
Inne
1Cal Lane
Cal Lane 90, USA
8.04
90USA
8.04
PB
  
Sam Spallinger
Sam Spallinger 90, USA
NM
90USA
NM
  
M Tresteg     
Inne

Final A

Final
Inne
1Michael Nwankwo
Michael Nwankwo 93, USA
15.24
93USA
15.24
SB
  
M Kula     
Inne

Final A

Final
Inne
1Matt Babicz
Matt Babicz 92, USA
19.22
92USA
19.22
SB
  
2Brad Szypka
Brad Szypka 93, USA
19.09
93USA
19.09
SB
  
3Tavis Bailey
Tavis Bailey 92, USA
18.36
92USA
18.36
SB
  
4Chuk Enekwechi
Chuk Enekwechi 93, NGR
18.28
93NGR
18.28
SB
  
5Matt Hoty
Matt Hoty 91, USA
18.18
91USA
18.18
SB
  
6Nik Huffman
Nik Huffman 94, USA
17.84
94USA
17.84
PB
  
7Luke Lewis
Luke Lewis 95, USA
16.84
95USA
16.84
PB
  
M Vikt     
Inne

Final A

Final
Inne
1Chuk Enekwechi
Chuk Enekwechi 93, NGR
23.01
93NGR
23.01
SB
  
2Cameron Brown
Cameron Brown 94, USA
21.52
94USA
21.52
PB
  
3Tavis Bailey
Tavis Bailey 92, USA
20.51
92USA
20.51
PB
  
4Timothy Morse
Timothy Morse 85, USA
20.18
85USA
20.18
  
5Chris Fields
Chris Fields 91, USA
19.80
91USA
19.80
SB
  
6Andrew Miller
Andrew Miller , USA
19.21
USA
19.21
PB
  
Kvinnor
K 60 m     
Inne

Final A

Final
Inne
1Katie Wise
Katie Wise 93, USA
7.40
93USA
7.40
SB
  
2Javianne Oliver
Javianne Oliver 94, USA
7.44
94USA
7.44
=PB
  
3Dominique Booker
Dominique Booker 92, USA
7.46
92USA
7.46
SB
  
4Kenya Woodall
Kenya Woodall 94, USA
7.52
94USA
7.52
PB
  
5Devynne Charlton
Devynne Charlton 95, BAH
7.52
95BAH
7.52
=PB
  
6Latoya Williams
Latoya Williams , USA
7.58
USA
7.58
=PB
  
7Savannah Carson
Savannah Carson 95, USA
7.59
95USA
7.59
PB
  
8Twyla Winfrey
Twyla Winfrey 93, USA
7.61
93USA
7.61
SB
  
Heat 1
1Katie Wise
Katie Wise 93, USA
7.51
93USA
7.51
SB
  
2Latoya Williams
Latoya Williams , USA
7.58
USA
7.58
PB
  
3Shawntanay Johnson
Shawntanay Johnson 92, USA
7.66
92USA
7.66
SB
  
Heat 2
1Dominique Booker
Dominique Booker 92, USA
7.52
92USA
7.52
SB
  
Heat 3
1Javianne Oliver
Javianne Oliver 94, USA
7.44
94USA
7.44
PB
  
Heat 4
1Devynne Charlton
Devynne Charlton 95, BAH
7.56
95BAH
7.56
SB
  
2Kenya Woodall
Kenya Woodall 94, USA
7.60
94USA
7.60
PB
  
3Carmiesha Cox
Carmiesha Cox 95, BAH
7.67
95BAH
7.67
SB
  
Heat 5
1Savannah Carson
Savannah Carson 95, USA
7.61
95USA
7.61
PB
  
2Twyla Winfrey
Twyla Winfrey 93, USA
7.62
93USA
7.62
SB
  
K 300 m     
Inne

Final A

Final
Inne
1Dezerea Bryant
Dezerea Bryant 93, USA
36.70
93USA
36.70
PB
  
2Kendra Harrison
Kendra Harrison 92, USA
37.84
92USA
37.84
PB
  
3Felicia Brown
Felicia Brown 93, USA
38.07
93USA
38.07
PB
  
4Carmiesha Cox
Carmiesha Cox 95, BAH
38.60
95BAH
38.60
PB
  
5Kenya Woodall
Kenya Woodall 94, USA
38.60
94USA
38.60
PB
  
Final B
1Jasmine Mitchell
Jasmine Mitchell 95, USA
38.46
95USA
38.46
PB
  
2Morganne Phillips
Morganne Phillips 92, USA
38.60
92USA
38.60
SB
  
Final C
1Alisha Adair
Alisha Adair , USA
38.83
USA
38.83
PB
  
Final D
1Kenyattia Hackworth
Kenyattia Hackworth 93, USA
38.98
93USA
38.98
PB
  
Final E
1Sha'Keela Saunders
Sha'Keela Saunders 93, USA
39.24
93USA
39.24
SB
  
K 500 m     
Inne

Final A

Final
Inne
1Alethia Marrero
Alethia Marrero 95, PUR
1:11.08
95PUR
1:11.08
PB
  
2Felicia Majors
Felicia Majors 95, USA
1:13.19
95USA
1:13.19
SB
  
3Aarin Jones
Aarin Jones 94, USA
1:13.22
94USA
1:13.22
PB
  
K 3000 m     
Inne

Final A

Final
Inne
1Emily Oren
Emily Oren 93, USA
9:28.11
93USA
9:28.11
PB
  
2Brittany Neeley
Brittany Neeley 94, USA
9:41.39
94USA
9:41.39
PB
  
K 5000 m     
Inne

Final A

Final
Inne
1Courtney Frerichs
Courtney Frerichs 93, USA
15:48.12
93USA
15:48.12
PB
  
2Marisa Howard
Marisa Howard 92, USA
16:07.90
92USA
16:07.90
PB
  
3Mara Olson
Mara Olson 93, USA
16:10.47
93USA
16:10.47
PB
  
4Kristina Galat
Kristina Galat 94, USA
16:38.20
94USA
16:38.20
PB
  
5Calli Thackery
Calli Thackery 93, GBR
16:44.44
93GBR
16:44.44
PB
  
K 60 m häck     
Inne

Final A

Final
Inne
1Leah Nugent
Leah Nugent 92, USA
8.29
92USA
8.29
SB
  
2Devynne Charlton
Devynne Charlton 95, BAH
8.33
95BAH
8.33
PB NU20R
  
3Jacklyn Howell
Jacklyn Howell 96, USA
8.42
96USA
8.42
PB
  
Heat 2
1Leah Nugent
Leah Nugent 92, USA
8.36
92USA
8.36
SB
  
2Jacklyn Howell
Jacklyn Howell 96, USA
8.45
96USA
8.45
=PB
  
Heat 3
1Devynne Charlton
Devynne Charlton 95, BAH
8.39
95BAH
8.39
SB
  
K Höjd     
Inne

Final A

Final
Inne
1Erika Hurd
Erika Hurd 94, USA
1.86
94USA
1.86
PB
  
K Stav     
Inne

Final A

Final
Inne
1Sophie Gutermuth
Sophie Gutermuth 92, USA
4.22
92USA
4.22
PB
  
2Sarah Rasnick
Sarah Rasnick 92, USA
3.95
92USA
3.95
SB
  
3Jessica Harter
Jessica Harter 94, USA
3.80
94USA
3.80
PB
  
Kimyanna Rudolph
Kimyanna Rudolph 94, USA
NH
94USA
NH
  
Jax Williams
Jax Williams 94, USA
NH
94USA
NH
  
Alexandra Whitford
Alexandra Whitford , USA
NH
USA
NH
  
K Längd     
Inne

Final A

Final
Inne
1Sha'Keela Saunders
Sha'Keela Saunders 93, USA
6.35
93USA
6.35
PB
  
K Kula     
Inne

Final A

Final
Inne
1Cassie Wertman
Cassie Wertman 93, USA
16.39
93USA
16.39
SB
  
2Dani Bunch
Dani Bunch 91, USA
16.23
91USA
16.23
SB
  
3Becky Famurewa
Becky Famurewa 94, USA
15.70
94USA
15.70
PB
  
4Madison Jacobs
Madison Jacobs 95, USA
14.89
95USA
14.89
SB
  
5Adriana Brown
Adriana Brown 96, USA
14.64
96USA
14.64
PB
  
6Katelyn Rutz
Katelyn Rutz 93, USA
14.32
93USA
14.32
PB
  
7Elizabeth Iversen
Elizabeth Iversen 94, USA
14.23
94USA
14.23
PB
  
8M.J. Doan
M.J. Doan 91, USA
14.20
91USA
14.20
SB
  
K Vikt     
Inne

Final A

Final
Inne
1Felisha Johnson
Felisha Johnson 89, USA
23.19
89USA
23.19
SB
  
2Becky Famurewa
Becky Famurewa 94, USA
20.52
94USA
20.52
PB
  
3Dani Bunch
Dani Bunch 91, USA
20.39
91USA
20.39
SB
  
4Dolly Nyemah
Dolly Nyemah 93, USA
19.79
93USA
19.79
PB
  
5Nakel McClinton
Nakel McClinton 94, USA
17.92
94USA
17.92
SB
  
6Katelyn Rutz
Katelyn Rutz 93, USA
17.59
93USA
17.59
PB
  
7Frida ÅkerströmSWE
17.30
PB