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: 93 (53+40)   Starter: 124 (75+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= 12916801 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 1 feb

Final A

Final
Inne 1 feb
1Roman Turner
Roman Turner , USA
6.74
USA
6.74
  
2Charles Jackson
Charles Jackson 88, USA
6.79
88USA
6.79
  
3Cliff Resias
Cliff Resias 96, BAH
6.86
96BAH
6.86
SB
  
4Diamantae Griffin
Diamantae Griffin 99, USA
6.86
99USA
6.86
PB
  
5Artis McCoy
Artis McCoy , USA
6.91
USA
6.91
  
6Terrell Jolla
Terrell Jolla , USA
6.93
USA
6.93
  
7Devin Dixon
Devin Dixon , USA
6.93
USA
6.93
=PB
  
8Kemar Cumberbatch
Kemar Cumberbatch 96, BAR
6.94
96BAR
6.94
  
Heat 1
1 feb
1 feb
1Cliff Resias
Cliff Resias 96, BAH
6.93
96BAH
6.93
  
1Kavacion Webster
Kavacion Webster 00, USA
7.00
00USA
7.00
  
2Devin Dixon
Devin Dixon , USA
6.93
USA
6.93
PB
  
3Khance Meyers
Khance Meyers 99, USA
6.96
99USA
6.96
  
4Jaysen Robinson
Jaysen Robinson 98, USA
6.97
98USA
6.97
=PB
  
5Jhavonte Perry
Jhavonte Perry , USA
6.99
USA
6.99
PB
  
6Rodney Ruffin
Rodney Ruffin 97, USA
6.99
97USA
6.99
PB
  
Heat 2
1 feb
1 feb
1Artis McCoy
Artis McCoy , USA
6.86
USA
6.86
PB
  
1Artis McCoy
Artis McCoy , USA
6.94
USA
6.94
  
2Diamantae Griffin
Diamantae Griffin 99, USA
6.88
99USA
6.88
PB
  
3Terrell Jolla
Terrell Jolla , USA
6.89
USA
6.89
  
4Jebarri Cumberbatch
Jebarri Cumberbatch 98, BAR
6.95
98BAR
6.95
  
5Terrance Laird
Terrance Laird 98, USA
6.98
98USA
6.98
  
6Gared Brown
Gared Brown , USA
6.99
USA
6.99
PB
  
Heat 3
1 feb
1 feb
1Charles Jackson
Charles Jackson 88, USA
6.82
88USA
6.82
  
2Roman Turner
Roman Turner , USA
6.84
USA
6.84
  
3Kemar Cumberbatch
Kemar Cumberbatch 96, BAR
6.93
96BAR
6.93
  
5Aaron Worrell
Aaron Worrell 95, BAR
7.07
95BAR
7.07
  
Heat 5
1 feb
1 feb
1Jaysen Robinson
Jaysen Robinson 98, USA
6.98
98USA
6.98
  
2Eran Siboni
Eran Siboni 97, ISR
7.07
97ISR
7.07
PB
  
Heat 6
1 feb
1 feb
1Jebarri Cumberbatch
Jebarri Cumberbatch 98, BAR
6.99
98BAR
6.99
  
2Babakarr Randall
Babakarr Randall 99, USA
7.00
99USA
7.00
PB
  
Heat 7
1 feb
1 feb
1Devin Dixon
Devin Dixon , USA
6.97
USA
6.97
  
M 400 m     
Inne 1 feb

Final A

Final
Inne 1 feb
1Donovan Storr
Donovan Storr 98, BAH
49.07
98BAH
49.07
  
M 800 m     
Inne
Inne
Final C
1 feb
1 feb
4Franz Beyer
Franz Beyer 96, GER
2:12.01
96GER
2:12.01
PB
  
5Chandler Mixon
Chandler Mixon , USA
2:12.58
USA
2:12.58
PB
  
M 1 mile     
Inne 1 feb

Final A

Final
Inne 1 feb
Hannes Burger
Hannes Burger 99, GER
DNF
99GER
DNF
  
M 60 m häck     
Inne 1 feb

Final A

Final
Inne 1 feb
1Al-Tariq Dunson
Al-Tariq Dunson 00, USA
8.22
00USA
8.22
PB
  
2Mykele Sanders
Mykele Sanders 97, USA
8.45
97USA
8.45
  
3Lucas-Arno Voigt
Lucas-Arno Voigt 98, GER
8.47
98GER
8.47
PB
  
6Franz Beyer
Franz Beyer 96, GER
8.87
96GER
8.87
  
7Chandler Mixon
Chandler Mixon , USA
9.07
USA
9.07
  
Heat 1
1 feb
1 feb
1Justin Taylor
Justin Taylor , USA
8.35
USA
8.35
=SB
  
2Mykele Sanders
Mykele Sanders 97, USA
8.39
97USA
8.39
  
3Blake Grace
Blake Grace , USA
8.42
USA
8.42
PB
  
4Lucas-Arno Voigt
Lucas-Arno Voigt 98, GER
8.50
98GER
8.50
PB
  
5Chandler Mixon
Chandler Mixon , USA
8.73
USA
8.73
  
6Franz Beyer
Franz Beyer 96, GER
8.76
96GER
8.76
SB
  
Heat 2
1 feb
1 feb
1Levaughn Battick
Levaughn Battick , JAM
8.21
JAM
8.21
  
2Al-Tariq Dunson
Al-Tariq Dunson 00, USA
8.24
00USA
8.24
PB
  
M Höjd     
Inne 1 feb

Final A

Final
Inne 1 feb
1Corvell Todd
Corvell Todd 00, USA
2.10
00USA
2.10
=PB
  
3Aaron Worrell
Aaron Worrell 95, BAR
1.90
95BAR
1.90
  
1.901.952.052.102.15
Todd-ooxoxxx
Worrellxoxxx
M Stav     
Inne 1 feb

Final A

Final
Inne 1 feb
1Armand DuplantisSWE
5.87
SB
  
2Devin King
Devin King 96, USA
5.52
96USA
5.52
SB
  
3Kyle Baudoin
Kyle Baudoin 97, USA
5.07
97USA
5.07
  
4Riccardo Klotz
Riccardo Klotz 99, AUT
4.92
99AUT
4.92
PB
  
5Cameron Reed
Cameron Reed , USA
4.77
USA
4.77
  
6Brendan Ford
Brendan Ford , USA
4.62
USA
4.62
PB
  
7Matthew Standridge
Matthew Standridge , USA
4.62
USA
4.62
SB
  
4.624.774.925.075.225.375.525.675.875.92
Duplantis------oxxoxoxxx
King-----oxxoxxx
Baudoin--xoxoxxx
Klotz--oxxx
Reedxoxoxxx
Fordxoxxx
Standridgexxoxxx
M Längd     
Inne 1 feb

Final A

Final
Inne 1 feb
1Rodney Ruffin
Rodney Ruffin 97, USA
7.50
97USA
7.50
  
2Kenan Jones
Kenan Jones , USA
7.34
USA
7.34
PB
  
3Sam Healy
Sam Healy 96, IRL
7.29
96IRL
7.29
SB
  
4Colm Bourke
Colm Bourke 94, IRL
7.15
94IRL
7.15
  
5Jaysen Robinson
Jaysen Robinson 98, USA
7.11
98USA
7.11
  
6Jace Attuso
Jace Attuso 98, USA
7.08
98USA
7.08
SB
  
7Markeit Steverson
Markeit Steverson , USA
6.96
USA
6.96
  
Ruffin7.457.507.32x7.14
Jones7.027.10x7.057.337.34
Healy6.887.06x7.167.29x
Bourkexx7.157.026.976.95
Robinson6.836.88x7.116.776.75
Attuso7.08x6.90x6.98x
Steversonxx6.92x6.96x
M Tresteg     
Inne 1 feb

Final A

Final
Inne 1 feb
1Ceaser Stephens
Ceaser Stephens , USA
15.48
USA
15.48
SB
  
2Quindarrius Thompson
Quindarrius Thompson , USA
15.13
USA
15.13
SB
  
3Da'Quan Bellard
Da'Quan Bellard 95, USA
14.97
95USA
14.97
SB
  
4John Joseph
John Joseph 00, USA
14.80
00USA
14.80
PB
  
5Lebrun Nelson
Lebrun Nelson 95, USA
14.70
95USA
14.70
SB
  
Stephens15.4815.3715.23x13.73x
Thompson14.90x14.76x15.13x
Bellardx14.97x14.57x14.92
Josephxx14.80xxx
Nelson14.70x14.3714.5514.6814.70
M Kula     
Inne 1 feb

Final A

Final
Inne 1 feb
1Stevon Crooks
Stevon Crooks , JAM
16.75
JAM
16.75
SB
  
2Shaquillle Singuineau
Shaquillle Singuineau , TTO
16.60
TTO
16.60
PB
  
Crooksx15.2916.3216.75xx
Singuineau15.7416.0816.4216.2916.60x
M Vikt     
Inne 1 feb

Final A

Final
Inne 1 feb
1Dominique Williams
Dominique Williams 97, USA
18.84
97USA
18.84
PB
  
Williamsx18.4318.8418.7618.8218.69
M Sjukamp     
Inne 31 jan - 1 feb

Final A

Final
Inne 31 jan - 1 feb
1Graham Collins
Graham Collins 00, USA
5.122
00USA
5.122
PB
  
2Tanner Parks
Tanner Parks , USA
4.700
USA
4.700
SB
  
3Connor Wilbur
Connor Wilbur , USA
4.574
USA
4.574
SB
  
Collins7.136.7210.711.898.554.502:56.83
Parks7.526.5811.681.778.754.303:08.27
Wilbur7.406.3111.251.8910.064.202:55.87
Kvinnor
K 60 m     
Inne 1 feb

Final A

Final
Inne 1 feb
1Zakiya Denoon
Zakiya Denoon 95, TTO
7.49
95TTO
7.49
  
2Aldrianna Dupree
Aldrianna Dupree 00, USA
7.52
00USA
7.52
  
3Maya Harewood
Maya Harewood 98, USA
7.72
98USA
7.72
  
4Marjorie Thompson
Marjorie Thompson 96, USA
7.75
96USA
7.75
  
5Ona Giles
Ona Giles , USA
7.79
USA
7.79
  
Heat 1
1 feb
1 feb
1Kimone Hinds
Kimone Hinds 97, JAM
7.58
97JAM
7.58
SB
  
2Ona Giles
Ona Giles , USA
7.78
USA
7.78
PB
  
Heat 2
1 feb
1 feb
1Zakiya Denoon
Zakiya Denoon 95, TTO
7.60
95TTO
7.60
  
2Maya Harewood
Maya Harewood 98, USA
7.62
98USA
7.62
SB
  
Heat 3
1 feb
1 feb
1Aldrianna Dupree
Aldrianna Dupree 00, USA
7.54
00USA
7.54
  
2Marjorie Thompson
Marjorie Thompson 96, USA
7.76
96USA
7.76
  
K 200 m     
Inne
Inne
Final C
1 feb
1 feb
2Fiebe Tengrootenhuysen
Fiebe Tengrootenhuysen 00, BEL
26.12
00BEL
26.12
  
K 400 m     
Inne 1 feb

Final A

Final
Inne 1 feb
1Terralicia Mercadel
Terralicia Mercadel , USA
56.55
USA
56.55
SB
  
2Kimona Smikle
Kimona Smikle , JAM
56.63
JAM
56.63
SB
  
Final B
1 feb
1 feb
1Kalei Matthews
Kalei Matthews , USA
56.91
USA
56.91
PB
  
K 800 m     
Inne
Inne
1Jessica Fox
Jessica Fox 94, GBR
2:29.78
94GBR
2:29.78
PB
  
K 1 mile     
Inne 1 feb

Final A

Final
Inne 1 feb
4Jessica Fox
Jessica Fox 94, GBR
5:27.38
94GBR
5:27.38
  
K 60 m häck     
Inne 1 feb

Final A

Final
Inne 1 feb
1Brandi Hughes
Brandi Hughes 97, USA
8.40
97USA
8.40
=SB
  
2Trishauna Hemmings
Trishauna Hemmings 97, JAM
8.76
97JAM
8.76
PB
  
3Juliette Smith
Juliette Smith , USA
8.83
USA
8.83
  
Heat 1
1 feb
1 feb
1Brandi Hughes
Brandi Hughes 97, USA
8.50
97USA
8.50
  
2Juliette Smith
Juliette Smith , USA
8.78
USA
8.78
PB
  
Heat 2
1 feb
1 feb
1Trishauna Hemmings
Trishauna Hemmings 97, JAM
8.78
97JAM
8.78
PB
  
Heat 3
1 feb
1 feb
1Kourtni Russell
Kourtni Russell 97, USA
8.74
97USA
8.74
PB
  
K Höjd     
Inne 1 feb

Final A

Final
Inne 1 feb
1Abigail O'Donoghue
Abigail O'Donoghue 99, USA
1.80
99USA
1.80
=SB
  
2Kaitlyn Walker
Kaitlyn Walker 97, USA
1.72
97USA
1.72
  
3Frankie Griffin
Frankie Griffin , USA
1.72
USA
1.72
  
1.621.671.721.761.801.83
O'Donoghue-ooooxxx
Walker-xooxxx
Griffinooxoxxx
K Stav     
Inne 1 feb

Final A

Final
Inne 1 feb
1Rebekah Markel
Rebekah Markel , USA
4.32
USA
4.32
PB
  
2Nastja Modic
Nastja Modic 99, SLO
3.92
99SLO
3.92
SB
  
3Alex Potts
Alex Potts 00, USA
3.92
00USA
3.92
SB
  
4Reagann LeLeux
Reagann LeLeux 99, USA
3.77
99USA
3.77
  
5Rose Brutkiewicz
Rose Brutkiewicz , USA
3.62
USA
3.62
  
5Amy Stelly
Amy Stelly 97, USA
3.62
97USA
3.62
  
7Kimberly Rushford
Kimberly Rushford , USA
3.62
USA
3.62
  
3.423.623.773.924.024.164.274.32
Markel---xxooxoxxoo
Modic-oooxxx
Potts-oxxoxxoxxx
LeLeux-oxoxxx
Brutkiewiczooxxx
Stellyooxxx
Rushfordoxoxxx
K Längd     
Inne 1 feb

Final A

Final
Inne 1 feb
1Jasmyn Steels
Jasmyn Steels 97, USA
6.28
97USA
6.28
PB
  
2Mercy Uyoyo Abire
Mercy Uyoyo Abire 97, NGR
6.05
97NGR
6.05
  
3Jasmine Scott-Kilgo
Jasmine Scott-Kilgo 00, CAN
5.61
00CAN
5.61
PB
  
Steels6.266.126.286.17
Abire5.955.696.055.805.905.77
Scott-Kilgo5.555.575.485.425.405.61
K Tresteg     
Inne 1 feb

Final A

Final
Inne 1 feb
1Kyndal McKnight
Kyndal McKnight 98, USA
12.26
98USA
12.26
  
2Lauren Clarke
Lauren Clarke , USA
12.24
USA
12.24
PB
  
McKnightx11.9412.15x11.8012.26
Clarke11.4911.9212.0311.4111.8212.24
K Kula     
Inne 1 feb

Final A

Final
Inne 1 feb
1Ashley Davis
Ashley Davis 85, USA
15.18
85USA
15.18
SB
  
2Danielle Lorenz
Danielle Lorenz , USA
14.78
USA
14.78
PB
  
3Kristian Jackson
Kristian Jackson , USA
13.75
USA
13.75
SB
  
5Alivia Busch
Alivia Busch 99, USA
13.04
99USA
13.04
PB
  
Davis15.18x15.1214.95x15.04
Lorenz13.6314.78x14.4514.30x
Jackson11.7312.33xx13.7513.55
Busch13.04x12.5612.1412.43x
K Vikt     
Inne 1 feb

Final A

Final
Inne 1 feb
1Brianna Sam
Brianna Sam , USA
18.35
USA
18.35
PB
  
Sam17.2816.31xx17.5518.35
K Femkamp     
Inne 1 feb

Final A

Final
Inne 1 feb
1Emilie Berge
Emilie Berge 97, NOR
3.970
97NOR
3.970
PB
  
2Pärl Eelma
Pärl Eelma 98, EST
3.730
98EST
3.730
SB
  
3Hanna-Mai Vaikla
Hanna-Mai Vaikla 97, EST
3.502
97EST
3.502
SB
  
4Sammi Jo Brashears
Sammi Jo Brashears , USA
3.351
USA
3.351
PB
  
5Pauline Helm
Pauline Helm 99, NOR
3.349
99NOR
3.349
SB
  
Berge8.941.7311.855.712:26.02
Eelma8.881.6710.485.452:27.11
Vaikla9.431.5512.315.542:37.02
Brashears9.361.5210.554.992:25.71
Helm9.281.528.685.372:25.77