27.11
23.11
28.11
27.11
27.11
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
21‐22.9
Arrangör: UNC-Wilmington
Tävlande: 46 (20+26)   Starter: 59 (22+37)


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= 12977449 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 100 m     

Vind: -1.7

Final A

Final

Vind: -1.7
1Jabari Johnson
Jabari Johnson , USA
10.74
USA
10.74
SB
  
2Deshawn Ballard
Deshawn Ballard 99, USA
10.78
99USA
10.78
SB
  
3Jordan Johnson
Jordan Johnson 85, USA
10.96
85USA
10.96
SB
  
4Goba Dan-Princewill
Goba Dan-Princewill , GBR
11.07
GBR
11.07
SB
  
M 200 m     

Vind: +0.8

Final A

Final

Vind: +0.8
1Deshawn Ballard
Deshawn Ballard 99, USA
21.42
99USA
21.42
SB
  
2Goba Dan-Princewill
Goba Dan-Princewill , GBR
22.49
GBR
22.49
  
M 400 m     


Final A

Final

1Cooper Wright
Cooper Wright , USA
49.16
USA
49.16
PB
  
2Cole Krehnbrink
Cole Krehnbrink , USA
49.62
USA
49.62
PB
  
M 800 m     


Final A

Final

1Josh Hairston
Josh Hairston , USA
1:55.69
USA
1:55.69
PB
  
M 1500 m     


Final A

Final

1Ryan Brown
Ryan Brown , USA
3:54.87
USA
3:54.87
PB
  
2Dwayne Lillie
Dwayne Lillie , USA
3:57.35
USA
3:57.35
PB
  
3Gable Dershem
Gable Dershem , USA
3:59.67
USA
3:59.67
PB
  
4Michael Flanagan
Michael Flanagan , USA
3:59.81
USA
3:59.81
PB
  
M 5000 m     


Final A

Final

1Isaac Benz
Isaac Benz , USA
14:32.27
USA
14:32.27
PB
  
M 110 m häck     

Vind: +0.1

Final A

Final

Vind: +0.1
1Casimir Tawiah
Casimir Tawiah 97, USA
14.41
97USA
14.41
  
2Joshua Parks
Joshua Parks , USA
14.93
USA
14.93
  
M 400 m häck     


Final A

Final

1Cameron Kee
Cameron Kee , USA
54.27
USA
54.27
SB
  
2Corinthians Payne
Corinthians Payne , USA
54.32
USA
54.32
PB
  
3Dylan Blankenship
Dylan Blankenship , USA
54.98
USA
54.98
SB
  
M Längd     


Final A

Final

1Jordan Johnson
Jordan Johnson 97, USA
7.35
97USA
7.35
+1.9 PB
  
Johnson7.35
+1.9
x
+2.5
7.02
+1.9
x
+1.9
6.88w
+2.3
M Tresteg     


Final A

Final

1Joshua Green
Joshua Green , USA
14.09w
USA
14.09w
+2.3
  
Green13.89w
+3.6
14.09w
+2.3
13.89
+0.6
x
+2.0
M Kula     


Final A

Final

1Nate Karl
Nate Karl , USA
15.25
USA
15.25
PB
  
Karl14.81x15.2514.59xx
Kvinnor
K 100 m     

Vind: +0.1

Final A

Final

Vind: +0.1
1LaBria King
LaBria King 98, USA
12.04
98USA
12.04
SB
  
2Samara Gibson
Samara Gibson 99, USA
12.26
99USA
12.26
SB
  
Final B
Vind: +1.6
Vind: +1.6
1Tia Jackson
Tia Jackson 02, GBR
12.28
02GBR
12.28
  
K 200 m     

Vind: +0.4

Final A

Final

Vind: +0.4
1Jessica Dixon
Jessica Dixon 99, USA
24.94
99USA
24.94
SB
  
K 400 m     


Final A

Final

1Jessica Dixon
Jessica Dixon 99, USA
56.37
99USA
56.37
SB
  
2Jelonnie Smith
Jelonnie Smith , USA
57.03
USA
57.03
SB
  
3Aliya Barrows
Aliya Barrows , USA
57.96
USA
57.96
SB
  
K 800 m     


Final A

Final

1Melanie White
Melanie White , USA
2:11.94
USA
2:11.94
PB
  
2Gabriela de Oliviera
Gabriela de Oliviera 00, BRA
2:14.64
00BRA
2:14.64
SB
  
K 5000 m     


Final A

Final

1Destiny Stanford
Destiny Stanford , USA
17:18.54
USA
17:18.54
PB
  
K 100 m häck     

Vind: -0.3

Final A

Final

Vind: -0.3
1Kaya-Rae Dunbar
Kaya-Rae Dunbar 02, USA
14.03
02USA
14.03
PB
  
2Kayla Clark
Kayla Clark , USA
14.79
USA
14.79
PB
  
3Nuria Menendez
Nuria Menendez 02, ESP
15.42
02ESP
15.42
PB
  
K 400 m häck     


Final A

Final

1Jessica Wright
Jessica Wright 00, USA
1:01.46
00USA
1:01.46
PB
  
K Höjd     


Final A

Final

2Linn Hertz SaebböSWE
1.60
SB
  
1.551.601.65
Hertz Saebböxoxoxx
K Stav     


Final A

Final

1Madison George
Madison George , USA
3.81
USA
3.81
SB
  
2Celia Agee
Celia Agee 01, USA
3.66
01USA
3.66
SB
  
3.363.513.663.813.96
Georgexoxoxxooxxx
Ageeoooxxx
K Längd     


Final A

Final

1Ja'Tae Joyner
Ja'Tae Joyner , USA
5.74w
USA
5.74w
+2.2
  
2Taylor Smith
Taylor Smith , USA
5.66
USA
5.66
+1.9 PB
  
7Nuria Menendez
Nuria Menendez 02, ESP
5.34
02ESP
5.34
+1.8 SB
  
8Linn Hertz SaebböSWE
5.32
+1.4 SB
  
Joyner4.85
+0.7
5.28w
+2.4
5.55
+1.9
5.37w
+2.2
5.47
+1.5
5.74w
+2.2
Smith5.25
+1.1
5.66
+1.9
5.47
+1.8
5.62w
+2.3
5.63w
+2.6
5.59w
+3.0
Menendez5.10
+1.5
5.34
+1.8
5.24
+1.6
5.22w
+2.1
5.27w
+2.4
3.99w
+2.5
Hertz Saebböx
+1.5
5.24
+1.9
3.56
+1.5
5.32
+1.4
x
+1.9
x
+2.5
K Tresteg     


Final A

Final

1Linn Hertz SaebböSWE
11.73w
+2.4
  
Hertz Saebbö11.45
+0.4
11.71
+1.3
11.19
+1.7
x
+1.4
11.73w
+2.4
K Kula     


Final A

Final

1Lauryn Carlton
Lauryn Carlton 00, USA
12.82
00USA
12.82
  
2Kristine Strazdite
Kristine Strazdite 99, LAT
12.38
99LAT
12.38
SB
  
3Minyarn Smalls
Minyarn Smalls , USA
12.04
USA
12.04
PB
  
7Nuria Menendez
Nuria Menendez 02, ESP
10.83
02ESP
10.83
PB
  
Carlton12.2512.76xx12.7912.82
Strazdite11.63x12.22x12.3812.34
Smalls12.0410.9511.5710.5710.8411.29
Menendez10.8310.4110.219.6710.1910.31
K Diskus     


Final A

Final

1Kristine Strazdite
Kristine Strazdite 99, LAT
44.66
99LAT
44.66
SB
  
2Kathleen Collins
Kathleen Collins 00, USA
44.18
00USA
44.18
  
3Lauryn Carlton
Lauryn Carlton 00, USA
42.77
00USA
42.77
  
4Madison McCoy
Madison McCoy , USA
40.46
USA
40.46
SB
  
Strazdite42.2941.6341.77x44.6643.03
Collins44.18x42.79xxx
Carltonxxx42.77xx
McCoyx30.7338.3340.46xx
K Slägga     


Final A

Final

1Laura Igaune
Laura Igaune 88, LAT
70.64
88LAT
70.64
SB
  
2Charlotte Bradsher
Charlotte Bradsher , USA
53.76
USA
53.76
PB
  
3Madison McCoy
Madison McCoy , USA
49.21
USA
49.21
PB
  
4Lauryn Carlton
Lauryn Carlton 00, USA
48.65
00USA
48.65
PB
  
5Diana Effiom
Diana Effiom , USA
48.14
USA
48.14
PB
  
8Kristine Strazdite
Kristine Strazdite 99, LAT
45.24
99LAT
45.24
PB
  
Igaune70.6469.6068.2869.7268.83x
Bradsher52.2351.7253.7651.6652.5851.42
McCoyx46.56x48.3149.2144.83
Carlton46.83x43.7148.65x46.51
Effiomxx48.1444.95x45.57
Strazdite42.23x42.9945.2444.7444.61
K Spjut     


Final A

Final

1Nuria Menendez
Nuria Menendez 02, ESP
35.79
02ESP
35.79
PB
  
Menendez35.7934.9535.2334.7234.6534.42