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: 81 (45+36)   Starter: 108 (59+49)


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= 12918188 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 60 m     
Inne

Final A

Final
Inne
1Micah Larkins
Micah Larkins 94, USA
6.66
94USA
6.66
SB
  
2Akanni Hislop
Akanni Hislop 98, TTO
6.66
98TTO
6.66
PB
  
3Hakim Ruffin
Hakim Ruffin 00, USA
6.67
00USA
6.67
PB
  
4Kie'ave Harry
Kie'ave Harry , USA
6.72
USA
6.72
PB
  
5Diamantae Griffin
Diamantae Griffin 99, USA
6.80
99USA
6.80
PB
  
6KaDarius Berry
KaDarius Berry , USA
6.80
USA
6.80
=PB
  
7Edward Clarke
Edward Clarke 95, JAM
6.92
95JAM
6.92
  
Heat 1
1Micah Larkins
Micah Larkins 94, USA
6.70
94USA
6.70
SB
  
1Jebarri Cumberbatch
Jebarri Cumberbatch 98, BAR
6.94
98BAR
6.94
=SB
  
2Kie'ave Harry
Kie'ave Harry , USA
6.74
USA
6.74
SB
  
3Diamantae Griffin
Diamantae Griffin 99, USA
6.87
99USA
6.87
  
4Xavier Mulugata
Xavier Mulugata 97, TTO
6.87
97TTO
6.87
PB
  
5Javin Arrington
Javin Arrington , USA
6.92
USA
6.92
  
6Cliff Resias
Cliff Resias 96, BAH
6.94
96BAH
6.94
  
7Aaron Worrell
Aaron Worrell 95, BAR
7.04
95BAR
7.04
  
Heat 2
1Hakim Ruffin
Hakim Ruffin 00, USA
6.76
00USA
6.76
  
1Daveon Rodgers
Daveon Rodgers 98, USA
7.00
98USA
7.00
PB
  
2Jaron Flournoy
Jaron Flournoy 96, USA
6.77
96USA
6.77
  
3Jebarri Cumberbatch
Jebarri Cumberbatch 98, BAR
6.88
98BAR
6.88
PB
  
3Ayrton Nubret
Ayrton Nubret 94, FRA
7.02
94FRA
7.02
PB
  
4Treydarius Carr
Treydarius Carr 99, USA
6.89
99USA
6.89
  
5Dylan Peebles
Dylan Peebles 98, USA
6.91
98USA
6.91
  
Heat 3
1Akanni Hislop
Akanni Hislop 98, TTO
6.69
98TTO
6.69
PB
  
2KaDarius Berry
KaDarius Berry , USA
6.80
USA
6.80
PB
  
3Edward Clarke
Edward Clarke 95, JAM
6.81
95JAM
6.81
SB
  
4Devin Dixon
Devin Dixon , USA
6.92
USA
6.92
PB
  
5Matthew Clarke
Matthew Clarke 00, BAR
6.94
00BAR
6.94
=PB
  
Heat 4
1Micah Larkins
Micah Larkins 94, USA
6.79
94USA
6.79
  
Heat 5
1Diamantae Griffin
Diamantae Griffin 99, USA
6.89
99USA
6.89
  
2Devin Dixon
Devin Dixon , USA
6.98
USA
6.98
  
M 200 m     
Inne
Inne
Final C
3Ayrton Nubret
Ayrton Nubret 94, FRA
22.88
94FRA
22.88
SB
  
M 800 m     
Inne

Final A

Final
Inne
1Andre Colebrook
Andre Colebrook 94, BAH
1:55.14
94BAH
1:55.14
SB
  
M 3000 m     
Inne

Final A

Final
Inne
1Joey Croft
Joey Croft 00, GBR
8:43.93
00GBR
8:43.93
PB
  
M 60 m häck     
Inne

Final A

Final
Inne
1Arthur Price
Arthur Price , USA
7.89
USA
7.89
  
2Al-Tariq Dunson
Al-Tariq Dunson 00, USA
8.14
00USA
8.14
PB
  
3Justin Taylor
Justin Taylor , USA
8.31
USA
8.31
SB
  
4RC Walbrook
RC Walbrook , USA
8.34
USA
8.34
PB
  
M Höjd     
Inne

Final A

Final
Inne
1Corvell Todd
Corvell Todd 00, USA
2.10
00USA
2.10
=PB
  
2Tre'Anterius Brooks
Tre'Anterius Brooks , USA
2.00
USA
2.00
=PB
  
1.952.002.052.102.14
Todd-oxoxxoxxx
Brooksxooxxx
M Stav     
Inne

Final A

Final
Inne
1Armand DuplantisSWE
5.68
  
2Devin King
Devin King 96, USA
5.53
96USA
5.53
  
3Antonio Ruiz
Antonio Ruiz 96, MEX
5.38
96MEX
5.38
  
4Branson Ellis
Branson Ellis 00, USA
5.23
00USA
5.23
  
5Riccardo Klotz
Riccardo Klotz 99, AUT
5.23
99AUT
5.23
PB
  
6Cameron Reed
Cameron Reed , USA
4.93
USA
4.93
PB
  
6Carter Scott
Carter Scott , USA
4.93
USA
4.93
  
4.784.935.085.235.385.535.685.92
Duplantis-----xooxxx
King----ooxxx
Ruiz---xxoxoxxx
Ellis---oxxx
Klotz-ooxxoxxx
Reedoxxoxxx
Scott-xxoxxx
M Längd     
Inne

Final A

Final
Inne
1Damar Forbes
Damar Forbes 90, JAM
7.94
90JAM
7.94
SB
  
2Rodney Ruffin
Rodney Ruffin 97, USA
7.51
97USA
7.51
  
3Jace Attuso
Jace Attuso 98, USA
7.07
98USA
7.07
  
4Kaleb Clark
Kaleb Clark , USA
6.97
USA
6.97
PB
  
5Michael Strong
Michael Strong , USA
6.97
USA
6.97
  
6Tre'Anterius Brooks
Tre'Anterius Brooks , USA
6.96
USA
6.96
  
8Aaron Worrell
Aaron Worrell 95, BAR
6.81
95BAR
6.81
  
Forbes7.877.807.90x7.757.94
Ruffinx7.427.39x7.51x
Attuso6.357.076.966.936.92x
Clark6.566.976.656.706.936.79
Strong6.656.866.926.746.856.97
Brooksx6.72x6.69x6.96
Worrellx6.63x6.775.536.81
M Tresteg     
Inne

Final A

Final
Inne
1Da'Quan Bellard
Da'Quan Bellard 95, USA
15.63
95USA
15.63
PB
  
2Christian Miller
Christian Miller 98, USA
15.04
98USA
15.04
  
3Jacorious Jeter
Jacorious Jeter 96, USA
14.55
96USA
14.55
PB
  
Bellardx15.63xxxx
Miller13.6115.04x14.8215.04x
Jeter13.78x14.2914.3114.55x
M Kula     
Inne

Final A

Final
Inne
1Stevon Crooks
Stevon Crooks , JAM
17.18
JAM
17.18
SB
  
2Marco Arevalo
Marco Arevalo , USA
16.04
USA
16.04
PB
  
Crooksx16.90x16.97x17.18
Arevalo15.3015.4616.0415.66x15.60
M Vikt     
Inne

Final A

Final
Inne
1Jake Norris
Jake Norris 99, GBR
21.82
99GBR
21.82
PB
  
Norris19.8320.1319.5921.8221.05x
Kvinnor
K 60 m     
Inne

Final A

Final
Inne
1Aleia Hobbs
Aleia Hobbs 96, USA
7.13
96USA
7.13
SB
  
2Kortnei Johnson
Kortnei Johnson 97, USA
7.14
97USA
7.14
PB
  
3Sha'Carri Richardson
Sha'Carri Richardson 00, USA
7.21
00USA
7.21
  
4Ariyonna Augustine
Ariyonna Augustine 00, USA
7.44
00USA
7.44
  
5Rachel Misher
Rachel Misher 97, USA
7.45
97USA
7.45
  
6Cassondra Hall
Cassondra Hall 97, USA
7.51
97USA
7.51
  
7Zakiya Denoon
Zakiya Denoon 95, TTO
7.61
95TTO
7.61
  
Heat 1
1Sha'Carri Richardson
Sha'Carri Richardson 00, USA
7.37
00USA
7.37
  
2Tonea Marshall
Tonea Marshall 98, USA
7.42
98USA
7.42
PB
  
3Cassondra Hall
Cassondra Hall 97, USA
7.46
97USA
7.46
=SB
  
Heat 2
1Kortnei Johnson
Kortnei Johnson 97, USA
7.17
97USA
7.17
=PB
  
2Zakiya Denoon
Zakiya Denoon 95, TTO
7.54
95TTO
7.54
  
3Kerry-Ann Scott
Kerry-Ann Scott 97, JAM
7.72
97JAM
7.72
  
4Taylor Mumford
Taylor Mumford , USA
7.78
USA
7.78
PB
  
Heat 3
1Aleia Hobbs
Aleia Hobbs 96, USA
7.14
96USA
7.14
SB
  
2Rachel Misher
Rachel Misher 97, USA
7.45
97USA
7.45
  
3Ariyonna Augustine
Ariyonna Augustine 00, USA
7.52
00USA
7.52
  
K 400 m     
Inne
Inne
Final E
Lilli Richter
Lilli Richter 98, GER
DNF
98GER
DNF
  
K 800 m     
Inne

Final A

Final
Inne
1Hollie Parker
Hollie Parker 96, GBR
2:13.63
96GBR
2:13.63
SB
  
K 1 mile     
Inne

Final A

Final
Inne
10Andrea Pérez
Andrea Pérez 97, ESP
5:48.64
97ESP
5:48.64
  
K 3000 m     
Inne

Final A

Final
Inne
1Stefanie Slekis
Stefanie Slekis 88, USA
10:05.10
88USA
10:05.10
SB
  
K 60 m häck     
Inne

Final A

Final
Inne
1Tonea Marshall
Tonea Marshall 98, USA
8.15
98USA
8.15
  
2Milan Young
Milan Young 99, USA
8.23
99USA
8.23
  
3Brittley Humphrey
Brittley Humphrey 98, USA
8.26
98USA
8.26
=SB
  
4Kyah Loyd
Kyah Loyd 99, USA
8.48
99USA
8.48
  
5Trishauna Hemmings
Trishauna Hemmings 97, JAM
8.69
97JAM
8.69
PB
  
Heat 1
1Brittley Humphrey
Brittley Humphrey 98, USA
8.27
98USA
8.27
  
2Milan Young
Milan Young 99, USA
8.31
99USA
8.31
  
Heat 2
1Tonea Marshall
Tonea Marshall 98, USA
8.13
98USA
8.13
  
2Kyah Loyd
Kyah Loyd 99, USA
8.47
99USA
8.47
PB
  
5Pauline Helm
Pauline Helm 99, NOR
9.38
99NOR
9.38
  
K Höjd     
Inne

Final A

Final
Inne
1Abigail Kwarteng
Abigail Kwarteng 97, GHA
1.78
97GHA
1.78
SB
  
2Abigail O'Donoghue
Abigail O'Donoghue 99, USA
1.74
99USA
1.74
  
3Kaitlyn Walker
Kaitlyn Walker 97, USA
1.74
97USA
1.74
  
Pauline Helm
Pauline Helm 99, NOR
NH
99NOR
NH
  
1.541.691.741.781.82
Kwarteng-oxooxxx
O'Donoghue-ooxxx
Walker-xxooxxx
Helmxxx
K Stav     
Inne

Final A

Final
Inne
1Madison Pecot
Madison Pecot 95, USA
4.27
95USA
4.27
PB
  
2AnnMarie Broussard
AnnMarie Broussard 99, USA
3.97
99USA
3.97
PB
  
3Amy Stelly
Amy Stelly 97, USA
3.67
97USA
3.67
  
3.523.673.823.974.124.274.36
Pecot---xxooxxoxxx
Broussard-xxoooxxx
Stellyxxoxxoxxx
K Längd     
Inne

Final A

Final
Inne
1Kenyattia Hackworth
Kenyattia Hackworth 93, USA
6.44
93USA
6.44
SB
  
2Mercy Uyoyo Abire
Mercy Uyoyo Abire 97, NGR
6.11
97NGR
6.11
  
3Kiara Williams
Kiara Williams 96, USA
6.09
96USA
6.09
SB
  
4Brittany Jones
Brittany Jones , USA
5.65
USA
5.65
  
Hackworthx6.34x6.306.416.44
Abire6.115.635.895.986.015.78
Williams5.445.935.97xx6.09
Jones5.645.65x5.595.13
K Tresteg     
Inne

Final A

Final
Inne
1Lynnika Pitts
Lynnika Pitts 92, USA
13.63
92USA
13.63
PB
  
2Kyndal McKnight
Kyndal McKnight 98, USA
12.77
98USA
12.77
PB
  
Pitts13.6311.9813.2913.56
McKnightx12.6612.6112.7312.7712.68
K Kula     
Inne

Final A

Final
Inne
1Ashley Davis
Ashley Davis 85, USA
15.56
85USA
15.56
SB
  
2Alexia Stein
Alexia Stein , USA
14.93
USA
14.93
PB
  
3Kristian Jackson
Kristian Jackson , USA
14.12
USA
14.12
PB
  
4Cori Runnels
Cori Runnels , USA
13.51
USA
13.51
SB
  
5Destiney Myers
Destiney Myers 96, USA
13.44
96USA
13.44
SB
  
Davis15.3014.83x15.1315.5615.41
Stein13.97xx14.3414.93x
Jackson12.6714.12x13.1014.12x
Runnels11.4012.26x12.4612.6313.51
Myers12.3312.4313.2013.4413.1112.64