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: 35 (14+21)   Starter: 43 (14+29)


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

Final A

Final

Vind: +3.6
1Roshard Williams
Roshard Williams , USA
10.60w
USA
10.60w
  
M 200 m     

Vind: +3.1

Final A

Final

Vind: +3.1
1Kevin Bell
Kevin Bell 92, USA
21.39w
92USA
21.39w
  
2Darnell Gilbert
Darnell Gilbert 90, USA
21.40w
90USA
21.40w
  
M 400 m     


Final A

Final

1Pascal Orelus
Pascal Orelus 91, HAI
47.77
91HAI
47.77
  
M 110 m häck     

Vind: +1.3

Final A

Final

Vind: +1.3
1Isaac Williams
Isaac Williams 93, USA
14.04
93USA
14.04
PB
  
2Dailyn Moore
Dailyn Moore 89, USA
14.23
89USA
14.23
  
3Bryan Cain
Bryan Cain 93, USA
14.27
93USA
14.27
PB
  
4Landon Hargrove
Landon Hargrove 91, USA
14.37
91USA
14.37
PB
  
5Leon Bullock
Leon Bullock 91, USA
14.41
91USA
14.41
SB
  
M 400 m häck     


Final A

Final

1Eric Futch
Eric Futch 93, USA
51.77
93USA
51.77
SB
  
2Paul Barrett
Paul Barrett , USA
51.94
USA
51.94
PB
  
M Stav     


Final A

Final

1Sean Young
Sean Young 85, USA
5.50
85USA
5.50
PB
  
2Josh Dangel
Josh Dangel 91, USA
5.21
91USA
5.21
  
M Tresteg     


Final A

Final

1Shane Lewis
Shane Lewis 91, USA
15.32w
91USA
15.32w
+3.6
  
Kvinnor
K 100 m     

Vind: +3.1

Final A

Final

Vind: +3.1
1Dariel Jackson
Dariel Jackson 90, USA
11.55w
90USA
11.55w
  
2Aireonna Bailey
Aireonna Bailey 89, USA
11.57w
89USA
11.57w
  
3Monique Williams
Monique Williams 91, USA
11.73w
91USA
11.73w
  
4Shanay Portis
Shanay Portis 91, USA
11.74w
91USA
11.74w
  
5Melissa Teape
Melissa Teape 90, JAM
11.81w
90JAM
11.81w
  
6Shanice Smith
Shanice Smith 92, USA
11.99w
92USA
11.99w
  
7Kadeidra Jackson
Kadeidra Jackson 94, USA
12.01w
94USA
12.01w
  
K 200 m     

Vind: +5.5

Final A

Final

Vind: +5.5
1Aireonna Bailey
Aireonna Bailey 89, USA
23.23w
89USA
23.23w
  
2Ngozi Onwumere
Ngozi Onwumere 92, USA
23.54w
92USA
23.54w
  
3Dariel Jackson
Dariel Jackson 90, USA
23.58w
90USA
23.58w
  
4Rachael James
Rachael James 91, USA
23.85w
91USA
23.85w
  
5Kiersten Brewer
Kiersten Brewer 93, USA
23.92w
93USA
23.92w
  
6Anasztázia Nguyen
Anasztázia Nguyen 93, HUN
24.25w
93HUN
24.25w
  
Final B
Vind: +4.4
Vind: +4.4
1Shanay Portis
Shanay Portis 91, USA
23.97w
91USA
23.97w
  
2Melissa Teape
Melissa Teape 90, JAM
24.08w
90JAM
24.08w
  
3Christine Poole-Trice
Christine Poole-Trice 92, USA
24.11w
92USA
24.11w
  
4Kadeidra Jackson
Kadeidra Jackson 94, USA
24.25w
94USA
24.25w
  
K 400 m     


Final A

Final

1Rachael James
Rachael James 91, USA
54.08
91USA
54.08
SB
  
2Christine Poole-Trice
Christine Poole-Trice 92, USA
54.67
92USA
54.67
PB
  
K 100 m häck     

Vind: +1.2

Final A

Final

Vind: +1.2
1Sade-Mariah Greenidge
Sade-Mariah Greenidge 93, BAR
13.53
93BAR
13.53
SB
  
2Je'Rica Sanders
Je'Rica Sanders 93, USA
13.95
93USA
13.95
PB
  
3DanHeisha Harding
DanHeisha Harding 91, USA
14.07
91USA
14.07
  
4Ena Johnson
Ena Johnson 91, USA
14.13
91USA
14.13
SB
  
K Höjd     


Final A

Final

1Courtney Anderson
Courtney Anderson 90, USA
1.83
90USA
1.83
PB
  
2Erika Hurd
Erika Hurd 94, USA
1.78
94USA
1.78
PB
  
K Stav     


Final A

Final

1MacKenzie Fields
MacKenzie Fields 90, USA
4.10
90USA
4.10
  
K Längd     


Final A

Final

1Monique Williams
Monique Williams 91, USA
6.18
91USA
6.18
+0.3
  
K Kula     


Final A

Final

1Frida ÅkerströmSWE
14.65
SB
  
2Atasha Warren
Atasha Warren 90, USA
14.53
90USA
14.53
SB