Johanna Duplantis

Född: 24 september 2002

Ålder: 18 år 123 dagar

Förening:
 Upsala IF
 25.5.2018–

Tidigare förening(ar):
IK Stål –24.5.2018

Inom parentes efter årsbästa: topp-100-placeringen på världsbästalistan.
Grön parentes: topp-100-placering på världsbästalistan i 19-årsklassen.
Orange parentes: topp-100-placering på världsbästalistan i 17-årsklassen.

2021

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2021-1 ELSE 2021 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2021 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (2)
3.75i
PB  Belton, TXBelton, TX1.1.21
3.80i
PB  (29) Baton Rouge, LABaton Rouge, LA9.1.21
 
3.50
O
3.65
O
3.80
XO
3.95
XXX
    

2020

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2020-1 ELSE 2020 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2020 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (8)
3.35i
SB  Baton Rouge, LABaton Rouge, LA11.1.20
3.40i
SB  Reno, NVReno, NV17.1.20
3.35i
  Baton Rouge, LABaton Rouge, LA25.1.20
3.66i
PB  (20)Baton Rouge, LABaton Rouge, LA22.2.20
3.20
SB  Lafayette, LALafayette, LA5.3.20
3.57
SB  TäbyTäby18.7.20
 
3.30
XO
3.44
O
3.57
XO
3.68
XXX
    
3.71
PB  NorrköpingNorrköping1.8.20
 
3.35
O
3.48
O
3.60
XO
3.71
XO
3.82
XXX
   
3.78
PB  Göteborg/SGöteborg/S6.8.20
 
3.48
O
3.58
XO
3.68
O
3.78
XO
3.88
XXX
   

2019

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2019-1 ELSE 2019 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2019 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (6)
3.65i
PB  (57) (21)Reno, NVReno, NV19.1.19
3.65i
=PB  Baton Rouge, LABaton Rouge, LA16.2.19
3.58
=PB  TexasRAustin, TXTexasR, Austin, TX30.3.19
3.65
PB  (22)Baton Rouge, LABaton Rouge, LA4.5.19
3.24
  USMGöteborg/SUSM, Göteborg/S11.8.19
3.13
  TeamCh-jUppsalaTeamCh-j, Uppsala18.8.19
 
3.13
O
3.33
XXX
      

2018

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2018-1 ELSE 2018 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2018 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (3)
3.58
PB  (24)Hammond, LAHammond, LA12.4.18
3.47
  Moulins, FRAMoulins, FRA23.6.18
3.53
  USMEnskedeUSM, Enskede4.8.18
 
3.24
XO
3.33
O
3.38
O
3.43
O
3.48
O
3.53
XXO
3.60
X
 
Tresteg (1)
10.17 nwi
  Lafayette, LALafayette, LA2.3.18

2016

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2016-1 ELSE 2016 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2016 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (1)
2.63
PB  Göteborg/UGöteborg/U2.7.16

2015

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2015-1 ELSE 2015 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2015 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (1)
2.99i
PB  Reno, NVReno, NV17.1.15

2014

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2014-1 ELSE 2014 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2014 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (1)
Provisorisk bana:
2.82
  Quintana, TXQuintana, TX14.6.14

2013

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2013-1 ELSE 2013 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2013 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (2)
2.50
PB  GävleGävle21.7.13
Provisorisk bana:
2.65
  Santa Rosa Beach, FLSanta Rosa Beach, FL26.10.13

2012

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2012-1 ELSE 2012 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2012 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (1)
2.03i
SB  Reno, NVReno, NV21.1.12

2011

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat243726.multi, alltwat243726.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2011-1 ELSE 2011 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat243726 inner join world.yearwsweall ON alltwat243726.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat243726.IID=coursew.IID WHERE yearwsweall.Year = 2011 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (1)
2.13i
PB  Reno, NVReno, NV29.1.11

Längst till höger topp-50-placering i den svenska genom-tiderna-statistiken

Stav
Ute
3.78
Göteborg/S6.8.2050
Inne
3.80
Baton Rouge, LA9.1.21
Stav
3.80i
2
HS
Baton Rouge, LA9.1.21
3.78
3
Club ChGöteborg/S6.8.20
3.75i
=3
HS
B
Belton, TX1.1.21
3.71
2
B
Norrköping1.8.20
3.66i
3
HS
Baton Rouge, LA22.2.20
3.65i
2
C
Reno, NV19.1.19
3.65i
1
HS
Baton Rouge, LA16.2.19
3.65
1
HS
Baton Rouge, LA4.5.19
3.58
1
Hammond, LA12.4.18
3.58
14
HS
B
TexasRAustin, TX30.3.19
Visa/dölj alla resultat
3.57
3
B
Täby18.7.20
3.53
1
16
USMEnskede4.8.18
3.47
14
Moulins, FRA23.6.18
3.40i
12
HS
Reno, NV17.1.20
3.35i
3
HS
Baton Rouge, LA11.1.20
3.35i
5
HS
Baton Rouge, LA25.1.20
3.24
4
17
USMGöteborg/S11.8.19
3.20
1
HS
Lafayette, LA5.3.20
3.13
6
17
TeamCh-jUppsala18.8.19
2.99i
5
Reno, NV17.1.15
2.63
3
14
Göteborg/U2.7.16
2.50
1
13
Gävle21.7.13
2.13i
2
15
B
Reno, NV29.1.11
2.03i
1
Reno, NV21.1.12
10-bästasnitt: 3.681

Total results in database: 27
By event:
Stav:26
Tresteg:1
Stav
Ute Visa/dölj alla resultat
2013
2.50
 1-13
Gävle
21.7
 
2016
2.63
 3-14
Göteborg/U
2.7
 
2018
3.58
 1
Hammond, LA
12.4
 
3.53
1 -16
Enskede
4.8
 
3.47
14
Moulins, FRA
23.6
 
2019
3.65
 1-HS
Baton Rouge, LA
4.5
 
3.58
14cB-HS
Austin, TX
30.3
 
3.24
4 -17
Göteborg/S
11.8
 
3.13
6-17
Uppsala
18.8
 
2020
3.78
3
Göteborg/S
6.8
 
3.71
2cB
Norrköping
1.8
 
3.57
3cB
Täby
18.7
 
3.20
1-HS
Lafayette, LA
5.3
 
Inne Visa/dölj alla resultat
2011
2.13
 2rB-15
Reno, NV
29.1
 
2012
2.03
 1
Reno, NV
21.1
 
2015
2.99
 5h-18
Reno, NV
17.1
 
2019
3.65
 2cC
Reno, NV
19.1
 
3.65
1-HS
Baton Rouge, LA
16.2
 
2020
3.66
 3-HS
Baton Rouge, LA
22.2
 
3.40
12-HS
Reno, NV
17.1
 
3.35
3-HS
Baton Rouge, LA
11.1
 
3.35
5-HS
Baton Rouge, LA
25.1
 
2021
3.80
2-HS
Baton Rouge, LA
9.1
 
3.75
3=cB-HS
Belton, TX
1.1
 

Junior-ungdom
Ute
Stav
USM 2018 1
16
3.53
USM 2019 4
17
3.24