Jonas Asplund

Född: 14 februari 1973

Ålder: 47 år 335 dagar

Förening:
 IFK Märsta
 

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 sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat21868.multi, alltat21868.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.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`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2021-1 ELSE 2021 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb.alltat21868 inner join world.yearsweall ON alltat21868.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat21868.IID=course.IID WHERE yearsweall.Year = 2021 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

Stav (1)
4.75i
SB (81) GöteborgGöteborg9.1.21
 
4.35
XO
4.50
O
4.63
XO
4.75
O
4.94
XS
   

2020

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

60 m (3)
7.72i
PB  IVSMMalmö/AIVSM, Malmö/A29.2.20
7.66i
PB  IVSMMalmö/AIVSM, Malmö/A29.2.20
7.56i
PB  IVSMMalmö/AIVSM, Malmö/A29.2.20
100 m (1)
12.01w
  UppsalaUppsala21.8.20+3.4
Stav (18)
4.70i
SB  NorrköpingNorrköping6.1.20
 
4.50
O
4.60
O
4.70
O
     
4.53i
  SätraSätra18.1.20
4.78i
SB  VästeråsVästerås19.1.20
4.72i
  SollentunaSollentuna22.1.20
 
4.57
O
       
4.83i
SB  SätraSätra25.1.20
 
4.53
O
4.63
O
4.73
O
4.83
XXO
4.93
XXX
   
4.50i
  UppsalaUppsala26.1.20
4.90i
SB  (10)Göteborg/FHGöteborg/FH1.2.20
4.85i
  UppsalaUppsala8.2.20
4.62i
  ISMVäxjöISM, Växjö23.2.20
 
4.62
O
4.77
XXX
      
4.50i
  IVSMMalmö/AIVSM, Malmö/A1.3.20
 
4.50
O
4.70
XXX
      
4.70i
  SollentunaSollentuna4.3.20
 
4.40
XO
4.55
O
4.70
O
     
4.24
SB  SollentunaSollentuna12.7.20
 
4.04
O
4.14
XO
4.24
O
     
4.87
SB  TäbyTäby18.7.20
 
4.55
O
4.66
O
4.77
O
4.87
XXO
4.95
XXX
   
NH
  NorrköpingNorrköping1.8.20
 
4.64
XXX
       
4.70
  SollentunaSollentuna7.8.20
 
4.50
O
4.70
XO
4.90
XXX
     
4.79
  SMUppsalaSM, Uppsala16.8.20
 
4.41
O
4.55
O
4.69
O
4.79
O
4.89
XXX
   
4.74
  UppsalaUppsala21.8.20
 
X       
4.61
  NorrköpingNorrköping5.9.20
 
4.51
O
4.61
O
4.71
XXX
     

2019

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

60 m häck (99.1 cm) (1)
9.21i
PB  VVMToruń, POLVVM, Toruń, POL28.3.19
Höjd (1)
1.72i
PB  VVMToruń, POLVVM, Toruń, POL28.3.19
 
1.60
O
1.63
O
1.66
O
1.69
XO
1.72
O
1.75
XR
  
Stav (7)
4.70i
SB  (15)UppsalaUppsala5.1.19
4.45i
  ISMNorrköpingISM, Norrköping17.2.19
4.35i
  VVMToruń, POLVVM, Toruń, POL27.3.19
 
4.05
O
4.20
O
4.35
O
4.80
XXX
    
4.72
SB  HuddingeHuddinge14.6.19
4.60
  Stockholm/SStockholm/S31.7.19
4.86
SB  (10)SollentunaSollentuna4.8.19
4.75
  SMKarlstadSM, Karlstad1.9.19
 
4.48
O
4.62
XXO
4.75
XO
4.85
XXX
    
Längd (1)
5.88i
SB  VVMToruń, POLVVM, Toruń, POL28.3.19
 
5.665.775.88
Kula (1)
8.99i
PB  VVMToruń, POLVVM, Toruń, POL28.3.19
 
8.998.23X
Tiokamp ()
4.068
PB  (17)Caorle, ITACaorle, ITA6.9.19
            
            

2018

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

Stav (3)
4.61
SB  Stockholm/SStockholm/S18.7.18
4.66
SB  (21)Málaga, ESPMálaga, ESP11.9.18
4.66
=SB  VVMMálaga, ESPVVM, Málaga, ESP11.9.18

2017

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

Stav (3)
4.50i
SB  UppsalaUppsala19.11.16
4.60i
SB  (23)BoråsBorås5.2.17
4.10
SB  Aarhus, DENAarhus, DEN31.7.17

2016

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

100 m (1)
11.66w
  SöderhamnSöderhamn22.7.16+2.2
200 m (1)
23.84
PB  SöderhamnSöderhamn23.7.16+1.7
Stav (3)
4.82i
SB  (12)SätraSätra12.2.16
4.71
SB  (16)SöderhamnSöderhamn22.7.16
4.63
  SMSollentunaSM, Sollentuna26.8.16
 
4.42
O
4.63
XO
4.77
XXX
     

2015

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

100 m (1)
11.70
PB  UddevallaUddevalla24.7.15+1.6
Stav (2)
4.77i
SB  ISMSätraISM, Sätra22.2.15
 
4.49
O
4.63
O
4.77
XO
4.86
XXX
    
4.73
SB  (17)SätraSätra30.8.15
Längd (1)
6.20i
PB  Toruń, POLToruń, POL26.3.15

2014

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

100 m (1)
11.93
PB  UppsalaUppsala5.7.14+1.1
Stav (2)
4.72
SB  (24)SollentunaSollentuna8.6.14
4.33
  SMUmeåSM, Umeå2.8.14
 
4.33
O
4.54
XXX
      
Tresteg (1)
11.14
PB  HuddingeHuddinge27.7.140.0

2013

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

Stav (1)
4.71
SB  (21)BålstaBålsta25.8.13

1998

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

Stav (2)
5.20i
=PB  LidingöLidingö3.2.98
5.21
PB  Stockholm/SStockholm/S16.7.98

1997

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

Stav (2)
5.20i
PB  SolnaSolna23.1.97
5.20
PB  VästeråsVästerås9.8.97

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

60 m
Inne
7.56
Malmö/A29.2.20
100 m
Ute
11.70
Uddevalla24.7.15+1.6
200 m
Ute
23.84
Söderhamn23.7.16+1.7
Höjd
Inne
1.72
Toruń, POL28.3.19
Stav
Ute
5.21
Stockholm/S16.7.9835
Inne
5.20
Solna23.1.9730
Längd
Inne
6.20
Toruń, POL26.3.15
Tresteg
Ute
11.14
Huddinge27.7.140.0
Kula
Inne
8.99
Toruń, POL28.3.19
Tiokamp
Ute
4.068
Caorle, ITA6.9.19

Veteran
60 m häck (99.1 cm)
Inne
9.21
Toruń, POL28.3.19
Stav
5.21
1
Stockholm/S16.7.98
5.20i
-
Solna23.1.97
5.20
-
Västerås9.8.97
5.20i
-
Lidingö3.2.98
4.90i
2
Göteborg/FH1.2.20
4.87
5
Täby18.7.20
4.86
1
Sollentuna4.8.19
4.85i
1
Uppsala8.2.20
4.83i
=5
B
Sätra25.1.20
4.82i
3
Sätra12.2.16
Visa/dölj alla resultat
4.79
6
SMUppsala16.8.20
4.78i
1
Västerås19.1.20
4.77i
7
ISMSätra22.2.15
4.75
9
SMKarlstad1.9.19
4.75i
3
Göteborg9.1.21
4.74
1
45
Uppsala21.8.20
4.73
3
Sätra30.8.15
4.72
2
Sollentuna8.6.14
4.72
-
Huddinge14.6.19
4.72i
1
Sollentuna22.1.20
4.71
3
Bålsta25.8.13
4.71
1
Söderhamn22.7.16
4.70i
5
Uppsala5.1.19
4.70i
2
Norrköping6.1.20
4.70i
1
Sollentuna4.3.20
4.70
1
Sollentuna7.8.20
4.66
1
Málaga, ESP11.9.18
4.66
1
45
VVMMálaga, ESP11.9.18
4.63
6
SMSollentuna26.8.16
4.62i
=8
ISMVäxjö23.2.20
4.61
5
Stockholm/S18.7.18
4.61
2
Norrköping5.9.20
4.60i
1
Borås5.2.17
4.60
4
Stockholm/S31.7.19
4.53i
3
Sätra18.1.20
4.50i
2
Uppsala19.11.16
4.50i
1
Uppsala26.1.20
4.50i
1
45
VSMMalmö/A1.3.20
4.45i
12
ISMNorrköping17.2.19
4.35i
1
45
VVMToruń, POL27.3.19
4.33
15
SMUmeå2.8.14
4.24
1
Sollentuna12.7.20
4.10
2
Aarhus, DEN31.7.17
10-bästasnitt: 4.994

Total results in database: 60
By event:
60 m:3
100 m:4
200 m:1
60 m häck (99.1 cm):1
Höjd:1
Stav:44
Längd:2
Tresteg:1
Kula:1
Tiokamp:1
1000 m stafett:1
60 m
Inne Visa/dölj alla resultat
2020
7.56
2-45
Malmö/A
29.2
 
7.66
2h1-45
Malmö/A
29.2
 
7.72
1h2-45
Malmö/A
29.2
 
100 m
Ute Visa/dölj alla resultat
2014
11.93
 4h3
Uppsala
5.7
 +1.1
2015
11.70
240 h2
Uddevalla
24.7
 +1.6
2016
11.66w
 240
Söderhamn
22.7
 +2.2
2020
12.01w
 1-45
Uppsala
21.8
 +3.4
200 m
Ute Visa/dölj alla resultat
2016
23.84
240
Söderhamn
23.7
 +1.7
Höjd
Inne Visa/dölj alla resultat
2019
1.72
P-45
Toruń, POL
28.3
 
Stav
Ute Visa/dölj alla resultat
1997
5.20
 
Västerås
9.8
 
1998
5.21
1
Stockholm/S
16.7
 
2013
4.71
 3
Bålsta
25.8
 
2014
4.72
 2
Sollentuna
8.6
 
4.33
15
Umeå
2.8
 
2015
4.73
 3
Sätra
30.8
 
2016
4.71
 140
Söderhamn
22.7
 
4.63
6
Sollentuna
26.8
 
2017
4.10
 240
Aarhus, DEN
31.7
 
2018
4.66
145
Málaga, ESP
11.9
 
2018
4.66
 1-45
Málaga, ESP
11.9
 
4.61
5
Stockholm/S
18.7
 
2019
4.86
 145
Sollentuna
4.8
 
4.75
9
Karlstad
1.9
 
4.72
Huddinge
14.6
 
4.60
4
Stockholm/S
31.7
 
2020
4.87
 5
Täby
18.7
 
4.79
6
Uppsala
16.8
 
4.74
1-45
Uppsala
21.8
 
4.70
1
Sollentuna
7.8
 
4.61
2
Norrköping
5.9
 
4.24
1
Sollentuna
12.7
 
Inne Visa/dölj alla resultat
1997
5.20
Solna
23.1
 
1998
5.20
 
Lidingö
3.2
 
2015
4.77
 7
Sätra
22.2
 
2016
4.82
 3
Sätra
12.2
 
2017
4.60
 140
Borås
5.2
 
4.50
2
Uppsala
19.11
 
2019
4.70
 5
Uppsala
5.1
 
4.45
12
Norrköping
17.2
 
4.35
1-45
Toruń, POL
27.3
 
2020
4.90
 2
Göteborg/FH
1.2
 
4.85
1
Uppsala
8.2
 
4.83
5=cB
Sätra
25.1
 
4.78
1
Västerås
19.1
 
4.72
1
Sollentuna
22.1
 
4.70
2
Norrköping
6.1
 
4.70
1
Sollentuna
4.3
 
4.62
8=
Växjö
23.2
 
4.53
3
Sätra
18.1
 
4.50
1
Uppsala
26.1
 
4.50
1-45
Malmö/A
1.3
 
2021
4.75
 3
Göteborg
9.1
 
Längd
Inne Visa/dölj alla resultat
2015
6.20
P-40
Toruń, POL
26.3
 
2019
5.88
 P-45
Toruń, POL
28.3
 
Tresteg
Ute Visa/dölj alla resultat
2014
11.14
240
Huddinge
27.7
 0.0
Kula
Inne Visa/dölj alla resultat
2019
8.99
P-45
Toruń, POL
28.3
 
Tiokamp
Ute Visa/dölj alla resultat
2019
4.068
-45
Caorle, ITA
6.9
 

Veteran
60 m häck (99.1 cm)
Inne Visa/dölj alla resultat
2019
9.21
P-45
Toruń, POL
28.3
 
Ute
Stav
SM 2014 15
4.33
SM 2016 6
4.63
SM 2019 9
4.75
SM 2020 7
4.79
Inne
Stav
ISM 2015 7
4.77
ISM 2019 12
4.45
ISM 2020 8=
4.62