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: 59 (41+18)   Starter: 73 (50+23)


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

Vind: +2.5

Final A

Final

Vind: +2.5
1Keitavious Walter
Keitavious Walter 96, USA
10.35w
96USA
10.35w
  
1Keitavious Walter
Keitavious Walter 96, USA
10.36w
96USA
10.36w
  
2Kirk Merritt
Kirk Merritt , USA
10.53w
USA
10.53w
  
3Quinten Brown
Quinten Brown , USA
10.60w
USA
10.60w
  
4Logan Hart
Logan Hart , USA
10.65w
USA
10.65w
  
5Sethan Hollier
Sethan Hollier , USA
10.65w
USA
10.65w
  
6Dontrelle Allen
Dontrelle Allen , USA
10.73w
USA
10.73w
  
7Josh Lister
Josh Lister , USA
10.77w
USA
10.77w
  
8Jerome Bazile
Jerome Bazile , USA
10.79w
USA
10.79w
  
5A M 200 m     

Vind: +0.5

Final A

Final

Vind: +0.5
1Corrieon Mosby
Corrieon Mosby , USA
21.35
USA
21.35
PB
  
2Kirk Merritt
Kirk Merritt , USA
21.52
USA
21.52
PB
  
3Sethan Hollier
Sethan Hollier , USA
21.54
USA
21.54
PB
  
4Logan Hart
Logan Hart , USA
21.86
USA
21.86
PB
  
5A M 400 m     


Final A

Final

1Corrieon Mosby
Corrieon Mosby , USA
48.01
USA
48.01
PB
  
2Jandon Briscoe
Jandon Briscoe 99, USA
48.62
99USA
48.62
PB
  
5A M 110 m häck (99.1 cm)     

Vind: +1.5

Final A

Final

Vind: +1.5
1Brandon Singleton
Brandon Singleton 96, USA
13.81
96USA
13.81
PB
  
2Kristian Fulton
Kristian Fulton , USA
14.17
USA
14.17
PB
  
3Juwon Johnson
Juwon Johnson , USA
14.40
USA
14.40
PB
  
4Kam Cummings
Kam Cummings , USA
14.46
USA
14.46
PB
  
5A M 300 m häck (83.8 cm)     


Final A

Final

1Brandon Singleton
Brandon Singleton , USA
37.53
USA
37.53
PB
  
5A M Höjd     


Final A

Final

1James Willingham
James Willingham , USA
2.03
USA
2.03
  
5A M Stav     


Final A

Final

1Armand DuplantisSWE
5.10
  
5A M Längd     


Final A

Final

1Jace Attuso
Jace Attuso 98, USA
7.25
98USA
7.25
+0.9 PB
  
2Kristian Fulton
Kristian Fulton , USA
7.23
USA
7.23
+0.9 PB
  
4A M 100 m     

Vind: +3.8

Final A

Final

Vind: +3.8
1Donte' Jackson
Donte' Jackson 95, USA
10.30w
95USA
10.30w
  
2Edward Davis
Edward Davis 97, USA
10.42w
97USA
10.42w
  
3Raymond Calais Jr.
Raymond Calais Jr. , USA
10.57w
USA
10.57w
  
4Kevon Marsh
Kevon Marsh , USA
10.68w
USA
10.68w
  
5Dorsavion Williams
Dorsavion Williams , USA
10.73w
USA
10.73w
  
4A M 200 m     

Vind: +0.6

Final A

Final

Vind: +0.6
1Donte' Jackson
Donte' Jackson 95, USA
21.26
95USA
21.26
PB
  
2Jaylen Jones
Jaylen Jones , USA
21.86
USA
21.86
PB
  
4A M 400 m     


Final A

Final

1Tahrike Jones
Tahrike Jones , USA
47.97
USA
47.97
PB
  
2Andre Johnson
Andre Johnson , USA
48.54
USA
48.54
PB
  
3Deonte Wright
Deonte Wright , USA
48.82
USA
48.82
PB
  
4A M 110 m häck (99.1 cm)     

Vind: +1.1

Final A

Final

Vind: +1.1
1Christian Boyd
Christian Boyd 95, USA
14.16
95USA
14.16
PB
  
4A M 300 m häck (83.8 cm)     


Final A

Final

1Christian Boyd
Christian Boyd 95, USA
37.54
95USA
37.54
PB
  
4A M Höjd     


Final A

Final

1Chris Edwards
Chris Edwards 99, USA
2.13
99USA
2.13
=PB
  
4A M Längd     


Final A

Final

1Damien Bernard
Damien Bernard , USA
7.35
USA
7.35
+1.3 PB
  
2Jerome Wynn
Jerome Wynn , USA
7.32
USA
7.32
+1.3 PB
  
4A M Tresteg     


Final A

Final

1Christian Miller
Christian Miller 98, USA
15.46w
98USA
15.46w
+2.5
  
3A M 100 m     

Vind: +2.1

Final A

Final

Vind: +2.1
1Hakim Ruffin
Hakim Ruffin 00, USA
10.60w
00USA
10.60w
  
2Xavious Eason
Xavious Eason , USA
10.69w
USA
10.69w
  
3Joseph Dickerson
Joseph Dickerson , USA
10.70w
USA
10.70w
  
4Alvontre Perro
Alvontre Perro , USA
10.73w
USA
10.73w
  
5Semaj Lewis
Semaj Lewis , USA
10.79w
USA
10.79w
  
6Devin White
Devin White , USA
10.84w
USA
10.84w
  
7Ryan Reed
Ryan Reed , USA
10.89w
USA
10.89w
  
3A M 200 m     

Vind: +2.0

Final A

Final

Vind: +2.0
1Kelvin Brooks
Kelvin Brooks , USA
21.49
USA
21.49
PB
  
2Hakim Ruffin
Hakim Ruffin 00, USA
21.60
00USA
21.60
PB
  
3A M 400 m     


Final A

Final

1Trevions Rouchon
Trevions Rouchon , USA
48.51
USA
48.51
PB
  
Kvinnor
HS K Spjut     


Final A

Final

1Peyton Montgomery
Peyton Montgomery 97, USA
49.50
97USA
49.50
=PB
  
5A K 100 m     

Vind: +2.0

Final A

Final

Vind: +2.0
1Janie O'Connor
Janie O'Connor 98, USA
11.52
98USA
11.52
PB
  
2Hannah Jackson
Hannah Jackson 97, USA
11.76
97USA
11.76
PB
  
3Jessica Harris
Jessica Harris 96, USA
11.92
96USA
11.92
=PB
  
4Kyah Loyd
Kyah Loyd 99, USA
12.22
99USA
12.22
PB
  
5A K 200 m     

Vind: +0.6

Final A

Final

Vind: +0.6
1Hannah Jackson
Hannah Jackson 97, USA
23.73
97USA
23.73
PB
  
2Janie O'Connor
Janie O'Connor 98, USA
23.78
98USA
23.78
PB
  
5A K 400 m     


Final A

Final

1Janie O'Connor
Janie O'Connor 98, USA
54.86
98USA
54.86
PB
  
2Chelsey Jones
Chelsey Jones 97, USA
55.11
97USA
55.11
PB
  
3Ariane Williams
Ariane Williams 97, USA
55.81
97USA
55.81
PB
  
4DeKayta Alex
DeKayta Alex , USA
56.19
USA
56.19
PB
  
5A K 800 m     


Final A

Final

1Chelsey Jones
Chelsey Jones 97, USA
2:12.84
97USA
2:12.84
PB
  
5A K Spjut     


Final A

Final

1Peyton Montgomery
Peyton Montgomery 97, USA
49.50
97USA
49.50
PB
  
4A K 100 m     

Vind: +0.7

Final A

Final

Vind: +0.7
1Aldrianna Dupree
Aldrianna Dupree 00, USA
11.91
00USA
11.91
PB
  
2Rikianne Patterson
Rikianne Patterson 99, USA
12.07
99USA
12.07
PB
  
3Claudesha Watson
Claudesha Watson , USA
12.21
USA
12.21
PB
  
4Imani Mulmore
Imani Mulmore , USA
12.22
USA
12.22
PB
  
5Taylor Mumford
Taylor Mumford , USA
12.27
USA
12.27
PB
  
4A K Stav     


Final A

Final

1Kimberly Rushford
Kimberly Rushford , USA
3.81
USA
3.81
PB
  
3A K 100 m     

Vind: +2.0

Final A

Final

Vind: +2.0
1Naishaylyn Brown
Naishaylyn Brown , USA
12.04
USA
12.04
PB
  
2Taylor Shaw
Taylor Shaw 99, USA
12.22
99USA
12.22
PB
  
3A K 400 m     


Final A

Final

1Ry-anne Riley
Ry-anne Riley , USA
56.86
USA
56.86
PB
  
3A K Spjut     


Final A

Final

1Alexis Rigmaiden
Alexis Rigmaiden , USA
47.42
USA
47.42