Jesper Hellström

Född: 27 juli 1995

Ålder: 25 år 175 dagar

Förening:
 Hässelby SK
 

  •  2 SM‐guld
  •  3 ISM‐guld, 1 ISM‐silver, 1 ISM‐brons

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.*, alltat169448.multi, alltat169448.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 tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.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

Inga resultat 2021. Senaste resultatet är från 2020.

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.*, alltat169448.multi, alltat169448.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 tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.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 (2)
6.88i
PB  (15)FGPSätraFGP, Sätra11.2.20
6.89i
PB  FGPSätraFGP, Sätra11.2.20
Längd (5)
7.57i
PB  (2)ISMVäxjöISM, Växjö23.2.20
 
XX7.32X7.57
6.95
SB  KilKil14.6.20+1.3
 
6.95
+1.3
XXXXX
6.85
  Göteborg/UGöteborg/U4.7.20+1.0
 
6.57
+1.3
6.76
-1.5
X
+4.9
X
+1.5
6.85
+1.0
6.82
+1.5
7.21
SB  SMUppsalaSM, Uppsala15.8.20-0.6
 
7.21
-0.6
7.36
SB  SMUppsalaSM, Uppsala16.8.20-0.5
 
7.36
-0.5
X
-0.7
X
-1.5
X
-0.7
X
+0.8
X
+0.2
Tresteg (5)
16.36i
PB (52) (1)ISMVäxjöISM, Växjö22.2.20
 
16.36XXX15.69
16.37
SB  Göteborg/SGöteborg/S6.8.20+0.4
 
16.22
0.0
14.69
-0.1
X
0.0
16.37
+0.4
16.09
  SMUppsalaSM, Uppsala14.8.20+0.1
 
16.07
+0.4
X
+0.3
16.09
+0.1
X
+0.9
X
+1.3
X
0.0
16.55
SB  vFINTampere, FINvFIN, Tampere, FIN5.9.20-0.9
 
16.09
-0.1
X
+0.2
16.17
-0.2
X
-0.2
16.26
-0.6
16.55
-0.9
16.65
SB (28) ISTAFBerlin, GERISTAF, Berlin, GER13.9.20-0.7
 
X
+1.2
16.65
-0.7
16.53
+0.4
14.89
+0.2
16.60
+0.5
16.56
+0.2
Kula (1)
10.57
PB  KarlstadKarlstad19.9.20
Diskus (1)
28.24
SB  KarlstadKarlstad19.9.20
Slägga (1)
22.12
PB  KarlstadKarlstad19.9.20
Spjut (1)
44.29
PB  KarlstadKarlstad19.9.20
Castorama (1)
1.825
PB  KarlstadKarlstad19.9.20
10.57   44.29   28.24   22.12
4x100 m (1)
41.14
PB  Göteborg/SGöteborg/S6.8.20
 Hässelby SK
Jesper Hellström, Carl af Forselles
Grigorios Kyriakoudis, Olle Forslin

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.*, alltat169448.multi, alltat169448.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 tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.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

100 m (1)
10.98
PB  HuddingeHuddinge15.6.19-0.4
Längd (1)
7.39i
SB  (6)ISMNorrköpingISM, Norrköping17.2.19
Tresteg (8)
15.77i
SB  VäxjöVäxjö19.1.19
16.20i
PB (63) (1)v3NatNadderud, NORv3Nat, Nadderud, NOR10.2.19
 
15.5815.7915.9416.20
15.89i
  ISMNorrköpingISM, Norrköping16.2.19
16.34w
  Team ChMalmö/STeam Ch, Malmö/S26.6.19+3.2
 
15.94
+4.8
16.18
+2.3
16.34
+3.2
X
+3.0
16.30
=PB  VUSGöteborg/UVUS, Göteborg/U30.6.19+1.9
16.54w
  VUSGöteborg/UVUS, Göteborg/U30.6.19+2.6
 
X
+1.2
16.30
+1.9
X
+1.8
X
-0.4
16.54
+2.6
16.53
PB  Lag-EM Super LBydgoszcz, POLLag-EM Super L, Bydgoszcz, POL11.8.19-1.7
 
X
+1.6
15.45
-0.8
16.53
-1.7
X
+0.7
16.71
PB (56) (1)vFINStockholm/SvFIN, Stockholm/S24.8.19+0.5
 
16.62
+1.4
16.71
+0.5
14.91
+0.6
16.53
+1.1
15.80
  SMKarlstadSM, Karlstad30.8.19+1.4
 
15.80
+1.4
Spjut (1)
40.17
PB  Karlstad/MKarlstad/M18.10.19
4x100 m (1)
41.21
PB  Team ChMalmö/STeam Ch, Malmö/S26.6.19
 Hässelby SK
Jesper Hellström, Dennis Forsman
Grigorios Kyriakoudis, Carl af Forselles

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.*, alltat169448.multi, alltat169448.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 tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.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

Längd (2)
7.08i
SB  (10)ISMGävleISM, Gävle18.2.18
7.39w
  FGPSollentunaFGP, Sollentuna28.6.18+2.7
 
7.39
+2.7
X
+1.3
XX
+2.6
X
Tresteg (4)
15.67i
SB  (1)VäxjöVäxjö20.1.18
15.59i
  ISMGävleISM, Gävle17.2.18
15.43
SB  (2)SollentunaSollentuna1.6.18+0.5
NM
  VUSGöteborg/UVUS, Göteborg/U1.7.18
Diskus (1)
31.73
PB  HässelbyHässelby31.7.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.*, alltat169448.multi, alltat169448.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 tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.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

60 m (1)
6.99i
PB  (23)Raka SpåretSätraRaka Spåret, Sätra4.2.17
100 m (2)
11.06
PB  SkaraSkara6.6.17+1.5
11.03
PB  SkaraSkara6.6.17+0.8
Längd (15)
7.52i
PB  (4)Raka SpåretSätraRaka Spåret, Sätra4.2.17
7.48i
  v3NatTampere, FINv3Nat, Tampere, FIN11.2.17
 
7.407.48X7.36XX
7.29i
  IJSMGöteborg/FHIJSM, Göteborg/FH18.2.17
 
7.017.087.297.157.19
7.17i
  ISMVäxjöISM, Växjö26.2.17
 
6.747.017.17XXX
7.29
SB  Torremolinos, ESPTorremolinos, ESP19.4.17+2.0
7.30
SB  København, DENKøbenhavn, DEN20.6.170.0
7.51
PB  (5)FGPSollentunaFGP, Sollentuna29.6.17+1.6
 
7.51
+1.6
XXXXX
7.50
  VUSGöteborg/UVUS, Göteborg/U1.7.17+0.8
7.47
  BoråsBorås7.7.17+0.8
7.61w
  JEM22Bydgoszcz, POLJEM22, Bydgoszcz, POL13.7.17+2.3
 
X
+0.7
7.61
+2.3
X
+0.6
7.49
  JEM22Bydgoszcz, POLJEM22, Bydgoszcz, POL14.7.17+0.6
 
7.49
+0.6
7.41
+1.8
X
+0.7
6.35
  JSMGävleJSM, Gävle12.8.17+2.0
7.03w
  JSMGävleJSM, Gävle12.8.17+3.1
 
6.35
+2.0
7.03
+3.1
7.05
  JSMGävleJSM, Gävle13.8.17+0.3
 
6.71
-0.8
X
-0.1
X
+0.3
7.05
+0.3
X
-0.1
X
-0.3
7.05
  SMHelsingborgSM, Helsingborg25.8.17+1.9
7.11w
  SMHelsingborgSM, Helsingborg25.8.17+2.1
 
X
+4.5
7.05
+1.9
7.11
+2.1
6.94
  SMHelsingborgSM, Helsingborg26.8.17-1.4
 
X
-2.2
6.94
-1.4
X
-1.7
X
-2.0
Tresteg (7)
15.92i
PB  (1)VäxjöVäxjö21.1.17
15.25i
  IJSMGöteborg/FHIJSM, Göteborg/FH19.2.17
 
X14.7715.1614.9315.25
15.32i
  ISMVäxjöISM, Växjö25.2.17
 
15.0214.8315.1214.9814.9815.32
14.85
SB  SollentunaSollentuna9.6.17+0.6
DNS
  JEM22Bydgoszcz, POLJEM22, Bydgoszcz, POL15.7.17
15.47
PB  (5)JSMGävleJSM, Gävle11.8.17+0.8
 
14.82
+3.4
14.10
+3.6
15.00
+1.6
14.84
+1.7
15.16
+1.9
15.47
+0.8
14.61
  SMHelsingborgSM, Helsingborg27.8.17+0.6
 
14.61
+0.6
X
+2.3
X
+4.2

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.*, alltat169448.multi, alltat169448.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 tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.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

60 m (1)
7.06i
PB  SätraSätra6.2.16
100 m (1)
11.43
PB  Göteborg/UGöteborg/U2.7.16-0.2
Längd (10)
7.30i
PB  IJSMVäxjöIJSM, Växjö20.2.16
 
6.964.846.947.037.30X
6.98i
  ISMMalmö/AISM, Malmö/A28.2.16
 
6.986.83
6.98
SB  BauhausStockholm/SBauhaus, Stockholm/S16.6.16-0.6
 
6.98
-0.6
6.92
-0.3
X
-0.4
X
+0.1
X
-0.6
X
-0.2
7.46w
  NorrköpingNorrköping13.7.16+2.5
 
7.09
+1.4
7.46
+2.5

+7.3
2.00X
+3.1
7.07
  JSMHässleholmJSM, Hässleholm5.8.16+0.1
 
X
7.07
  JSMHässleholmJSM, Hässleholm5.8.16+0.1
7.35
=PB  JSMHässleholmJSM, Hässleholm6.8.16+1.7
7.35
PB  JSMHässleholmJSM, Hässleholm6.8.16+1.7
 
7.22
+2.7
7.11
+1.0
7.11
+2.0
7.35
+1.7
7.11
  SMSollentunaSM, Sollentuna26.8.16+0.7
 
6.77
+1.7
7.11
+0.7
X
+1.7
7.38
PB  SMSollentunaSM, Sollentuna27.8.16-0.4
 
X
+1.8
X
+0.7
7.38
-0.4
X
+0.9
7.08
+7.1
7.24
+0.9
Tresteg (9)
14.73i
SB  Raka SpåretSätraRaka Spåret, Sätra6.2.16
15.18i
PB  IJSMVäxjöIJSM, Växjö21.2.16
 
14.9314.8715.1813.61
15.05i
  ISMMalmö/AISM, Malmö/A27.2.16
 
13.8914.7714.8915.0514.8414.88
15.03
SB  VUSGöteborg/UVUS, Göteborg/U3.7.16+1.2
15.32w
  VUSGöteborg/UVUS, Göteborg/U3.7.16+2.1
15.07
SB  NorrköpingNorrköping13.7.16+1.4
 
14.38
+0.5
X
+2.7
14.69
+1.9
14.74
+3.1
X
+1.6
15.07
+1.4
14.43
  JSMHässleholmJSM, Hässleholm7.8.16+0.8
14.83w
  JSMHässleholmJSM, Hässleholm7.8.16+2.3
14.83w
  JSMHässleholmJSM, Hässleholm7.8.16+2.3
 
14.43
+0.8
XX14.29
+0.6
14.75
+3.1
14.83
+2.3
14.72
  NordicCEspoo, FINNordicC, Espoo, FIN20.8.16-0.6
 
14.47
-1.0
X
-1.2
X
-2.3
X
-0.4
14.72
-0.6
14.59
-1.1
14.45
  SMSollentunaSM, Sollentuna28.8.16-0.4
 
XX
+2.2
14.45
-0.4

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.*, alltat169448.multi, alltat169448.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 tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.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

60 m (1)
7.22i
PB  SätraSätra31.1.15
Längd (3)
6.76i
PB  ISMSätraISM, Sätra22.2.15
 
X6.76X
7.07i
PB  NC-jGöteborg/FHNC-j, Göteborg/FH28.2.15
 
5.516.696.687.077.026.69
7.21
PB  JSMKalmarJSM, Kalmar22.8.15+1.1
 
X
+1.2
6.92
+0.9
X
+0.9
7.08
+1.1
7.21
+1.1
X
+1.5
Tresteg (6)
14.91i
PB  ISMSätraISM, Sätra21.2.15
 
13.6014.40X14.90X14.91
14.63i
  IJSMGöteborg/FHIJSM, Göteborg/FH1.3.15
 
14.35XX14.6314.51
14.59
SB  SundsvallSundsvall1.7.15+0.7
 
X
+3.6
X
+0.4
14.59
+0.7

+1.4
14.94
PB  VUSGöteborg/UVUS, Göteborg/U5.7.15+1.3
15.23
PB  SMSöderhamnSM, Söderhamn9.8.150.0
 
14.89
+1.1
X
+3.1
X
+1.1
14.67
+0.1
15.23X
+2.6
14.77
  JSMKalmarJSM, Kalmar23.8.15+1.4
14.94w
  JSMKalmarJSM, Kalmar23.8.15+2.1
 
14.44
+1.4
14.94
+2.1
X
+1.9
X
+1.3
14.77
+1.4
14.23
+2.1

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.*, alltat169448.multi, alltat169448.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 tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.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

60 m (1)
7.42i
PB  HuddingeHuddinge18.1.14
100 m (1)
11.70
PB  Göteborg/UGöteborg/U28.6.14-0.1
Längd (5)
6.13i
SB  IJSMSätraIJSM, Sätra16.2.14
 
6.133.76X
7.12
PB  (16)HuddingeHuddinge15.6.14+1.9
6.60
  BoråsBorås5.7.14+1.2
 
6.41
+1.2
6.60
+1.2
6.52
+3.5
6.52
+1.8
6.94
  SMUmeåSM, Umeå1.8.14+1.5
 
6.94
+1.5
X
+1.9
X
+1.8
6.82
  SMUmeåSM, Umeå2.8.14+1.5
 
6.82
+1.5
X6.31
-0.1
Tresteg (6)
14.42i
PB  IJSMSätraIJSM, Sätra15.2.14
 
13.5014.0714.0714.3014.42
14.53i
PB  (56) ISMGöteborg/FHISM, Göteborg/FH22.2.14
 
X14.2314.15X14.1214.53
14.64
PB  (7)Göteborg/UGöteborg/U29.6.14+0.4
14.81w
  Göteborg/UGöteborg/U29.6.14+2.1
14.17
  SMUmeåSM, Umeå3.8.14-0.6
 
X
+2.0
X
+0.8
14.17
-0.6
14.05
+0.5
14.11
+0.1
13.95
-1.1
14.69 nwi
  JSMGävleJSM, Gävle8.8.14
 
14.22
+3.3
14.41
+3.6
14.36
+2.1
13.37
+4.1
X
+5.3
14.69
+3.3

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.*, alltat169448.multi, alltat169448.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 tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.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

60 m (1)
7.49i
PB  HuddingeHuddinge19.1.13
Längd (2)
6.49i
PB  SätraSätra26.1.13
5.88i
  IJSMUddevallaIJSM, Uddevalla24.2.13
Tresteg (1)
14.02i
PB  IJSMUddevallaIJSM, Uddevalla23.2.13

2012

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.*, alltat169448.multi, alltat169448.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 2012-1 ELSE 2012 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.IID=course.IID WHERE yearsweall.Year = 2012 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)
12.33
PB  USMHuddingeUSM, Huddinge16.9.12-3.1
300 m (1)
39.38
PB  USMHuddingeUSM, Huddinge15.9.12
1000 m (1)
3:12.51
PB  USMHuddingeUSM, Huddinge16.9.12
110 m häck (91.4 cm, 8.9 m) (2)
16.49
PB  HuddingeHuddinge15.9.12-1.3
16.49
=PB  USMHuddingeUSM, Huddinge15.9.12
Höjd (1)
1.61
PB  USMHuddingeUSM, Huddinge16.9.12
Stav (2)
3.32
PB  HuddingeHuddinge15.9.12
3.32
=PB  USMHuddingeUSM, Huddinge15.9.12
Längd (4)
6.00i
PB  IUSMBollnäsIUSM, Bollnäs26.2.12
6.44
PB  Göteborg/UGöteborg/U9.7.12+1.5
6.18
  USMSollentunaUSM, Sollentuna10.8.12+0.5
6.70w
  USMSollentunaUSM, Sollentuna10.8.12+3.0
6.18
  USMHuddingeUSM, Huddinge16.9.12+0.7
Tresteg (3)
13.17i
PB  IUSMBollnäsIUSM, Bollnäs25.2.12
14.15
PB  (18)Göteborg/UGöteborg/U8.7.12+0.5
13.78
  USMSollentunaUSM, Sollentuna12.8.12+0.5
Kula (5.0 kg) (1)
10.60
PB  USMHuddingeUSM, Huddinge16.9.12
Diskus (1.5 kg) (1)
24.66
PB  USMHuddingeUSM, Huddinge15.9.12
Spjut (700 g) (2)
40.37
PB  HuddingeHuddinge15.9.12
40.37
=PB  USMHuddingeUSM, Huddinge15.9.12
Tiokamp (P17, 300m) (1)
5.301
PB  USMHuddingeUSM, Huddinge16.9.12
            
            

2011

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.*, alltat169448.multi, alltat169448.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 2011-1 ELSE 2011 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.IID=course.IID WHERE yearsweall.Year = 2011 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 (91.4 cm, 8.9 m) (1)
9.63i
PB  IUSMHuddingeIUSM, Huddinge19.2.11
Längd (1)
5.33i
PB  IUSMHuddingeIUSM, Huddinge19.2.11
Tresteg (3)
12.17i
PB  SätraSätra5.2.11
12.14i
  IUSMHuddingeIUSM, Huddinge20.2.11
11.91
PB  HuddingeHuddinge10.6.11+1.1

2010

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.*, alltat169448.multi, alltat169448.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 2010-1 ELSE 2010 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat169448 inner join world.yearsweall ON alltat169448.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 alltat169448.IID=course.IID WHERE yearsweall.Year = 2010 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

110 m häck (91.4 cm, 8.9 m) (2)
17.50w
  GävleGävle19.9.10+2.2
17.50w
  GävleGävle19.9.10+2.2
Längd (2)
5.09i
PB  NorrköpingNorrköping28.2.10
5.43
PB  USMKilUSM, Kil13.8.10-0.1
Tresteg (3)
11.49i
PB  NorrköpingNorrköping27.2.10
11.90
PB  Göteborg/UGöteborg/U3.7.10+0.6
11.88
  USMKilUSM, Kil15.8.100.0

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

60 m
Inne
6.88
Sätra11.2.20
100 m
Ute
10.98
Huddinge15.6.19-0.4
300 m
Ute
39.38
Huddinge15.9.12
1000 m
Ute
3:12.51
Huddinge16.9.12
Höjd
Ute
1.61
Huddinge16.9.12
Stav
Ute
3.32
Huddinge15.9.12
Längd
Ute
7.51
Sollentuna29.6.17+1.6
Inne
7.57
Växjö23.2.2022
Tresteg
Ute
16.71
Stockholm/S24.8.19+0.55
Inne
16.36
Växjö22.2.208
Kula
Ute
10.57
Karlstad19.9.20
Diskus
Ute
31.73
Hässelby31.7.18
Slägga
Ute
22.12
Karlstad19.9.20
Spjut
Ute
44.29
Karlstad19.9.20
Castorama
Ute
1.825
Karlstad19.9.20

Junior-ungdom
60 m häck (91.4 cm, 8.9 m)
Inne
9.63
Huddinge19.2.11
110 m häck (91.4 cm, 8.9 m)
Ute
16.49
Huddinge15.9.12-1.3
Kula (5.0 kg)
Ute
10.60
Huddinge16.9.12
Diskus (1.5 kg)
Ute
24.66
Huddinge15.9.12
Spjut (700 g)
Ute
40.37
Huddinge15.9.12
Tiokamp (P17, 300m)
Ute
5.301
Huddinge16.9.12
Längd
7.57i
2
ISMVäxjö23.2.20
7.52i
1
Raka SpåretSätra4.2.17
7.51
5
Folksam GPSollentuna29.6.17+1.6
7.50
5
VUSGöteborg/U1.7.17+0.8
7.49
9
22
JEM22Bydgoszcz, POL14.7.17+0.6
7.48i
3
v3NatTampere, FIN11.2.17
7.47
1
Club ChBorås7.7.17+0.8
7.39i
5
ISMNorrköping17.2.19
7.38
5
SMSollentuna27.8.16-0.4
7.36
5
SMUppsala16.8.20-0.5
Visa/dölj alla resultat
7.35
5
22
JSMHässleholm6.8.16+1.7
7.35
5
22
JSMHässleholm6.8.16+1.7
7.30i
5
22
IJSMVäxjö20.2.16
7.30
9
København, DEN20.6.170.0
7.29i
1
22
IJSMGöteborg/FH18.2.17
7.29
1
Torremolinos, ESP19.4.17+2.0
7.21
4
22
JSMKalmar22.8.15+1.1
7.21
5
Q
SMUppsala15.8.20-0.6
7.17i
4
ISMVäxjö26.2.17
7.12
1
19
Huddinge15.6.14+1.9
7.11
7
Q
SMSollentuna26.8.16+0.7
7.08i
7
ISMGävle18.2.18
7.07i
4
ISMGöteborg/FH28.2.15
7.07
3
22
Q
JSMHässleholm5.8.16+0.1
7.07
3
22
JSMHässleholm5.8.16+0.1
7.05
4
22
JSMGävle13.8.17+0.3
7.05
+
Q
SMHelsingborg25.8.17+1.9
6.98i
9
ISMMalmö/A28.2.16
6.98
3
BauhausStockholm/S16.6.16-0.6
6.95
2
Kil14.6.20+1.3
6.94
12
Q
SMUmeå1.8.14+1.5
6.94
7
SMHelsingborg26.8.17-1.4
6.85
5
B
Göteborg/U4.7.20+1.0
6.82
11
SMUmeå2.8.14+1.5
6.76i
12
ISMSätra22.2.15
6.60
4
teamNCBorås5.7.14+1.2
6.49i
2
Sätra26.1.13
6.44
7
17
Göteborg/U9.7.12+1.5
6.35
+
22
Q
JSMGävle12.8.17+2.0
6.18
+
17
USMSollentuna10.8.12+0.5
6.18
multi
17
USMHuddinge16.9.12+0.7
6.13i
12
19
IJSMSätra16.2.14
6.00i
11
17
IUSMBollnäs26.2.12
5.88i
16
19
IJSMUddevalla24.2.13
5.43
20
15
Q
NC-yKil13.8.10-0.1
5.33i
19
16
NC-yHuddinge19.2.11
5.09i
21
15
Q
Norrköping28.2.10
10-bästasnitt: 7.467
Tresteg
16.71
1
vFINStockholm/S24.8.19+0.5
16.65
3
ISTAFBerlin, GER13.9.20-0.7
16.55
2
vFINTampere, FIN5.9.20-0.9
16.53
4
Lag-EM Super LBydgoszcz, POL11.8.19-1.7
16.37
1
Club ChGöteborg/S6.8.20+0.4
16.36i
1
ISMVäxjö22.2.20
16.30
+
VUSGöteborg/U30.6.19+1.9
16.20i
1
v3NatBærum, NOR10.2.19
16.09
1
SMUppsala14.8.20+0.1
15.92i
2
Växjö21.1.17
Visa/dölj alla resultat
15.89i
1
ISMNorrköping16.2.19
15.80
1
SMKarlstad30.8.19+1.4
15.77i
1
Växjö19.1.19
15.67i
1
Växjö20.1.18
15.59i
1
ISMGävle17.2.18
15.47
1
22
JSMGävle11.8.17+0.8
15.43
1
Sollentuna1.6.18+0.5
15.32i
3
ISMVäxjö25.2.17
15.25i
1
22
IJSMGöteborg/FH19.2.17
15.23
5
SMSöderhamn9.8.150.0
15.18i
1
22
IJSMVäxjö21.2.16
15.07
2
teamNCNorrköping13.7.16+1.4
15.05i
5
ISMMalmö/A27.2.16
15.03
+
VUSGöteborg/U3.7.16+1.2
14.94
5
VUSGöteborg/U5.7.15+1.3
14.91i
5
ISMSätra21.2.15
14.85
1
Sollentuna9.6.17+0.6
14.77
+
22
JSMKalmar23.8.15+1.4
14.73i
1
Raka SpåretSätra6.2.16
14.72
4
22
NordicCEspoo, FIN20.8.16-0.6
14.64
+
19
Göteborg/U29.6.14+0.4
14.63i
1
22
IJSMGöteborg/FH1.3.15
14.61
9
SMHelsingborg27.8.17+0.6
14.59
3
teamNCSundsvall1.7.15+0.7
14.53i
6
ISMGöteborg/FH22.2.14
14.45
11
SMSollentuna28.8.16-0.4
14.43
+
22
JSMHässleholm7.8.16+0.8
14.42i
1
19
IJSMSätra15.2.14
14.17
7
SMUmeå3.8.14-0.6
14.15
2
17
Göteborg/U8.7.12+0.5
14.02i
2
19
IJSMUddevalla23.2.13
13.78
3
17
USMSollentuna12.8.12+0.5
13.17i
5
17
IUSMBollnäs25.2.12
12.17i
4
17
Sätra5.2.11
12.14i
8
16
NC-yHuddinge20.2.11
11.91
2
16
Huddinge10.6.11+1.1
11.90
6
15
Göteborg/U3.7.10+0.6
11.88
9
15
NC-yKil15.8.100.0
11.49i
10
15
Norrköping27.2.10
10-bästasnitt: 16.368

Total results in database: 149
By event:
60 m:7
100 m:6
300 m:1
1000 m:1
60 m häck (91.4 cm, 8.9 m):1
110 m häck (91.4 cm, 8.9 m):4
Höjd:1
Stav:2
Längd:53
Tresteg:59
Kula (5.0 kg):1
Kula:1
Diskus (1.5 kg):1
Diskus:2
Slägga:1
Spjut (700 g):2
Spjut:2
Tiokamp (P17, 300m):1
Castorama:1
4x100 m:2
60 m
Inne Visa/dölj alla resultat
2013
7.49
 5h1
Huddinge
19.1
 
2014
7.42
 4rB
Huddinge
18.1
 
2015
7.22
 4h3
Sätra
31.1
 
2016
7.06
 1h1
Sätra
6.2
 
2017
6.99
 2h4
Sätra
4.2
 
2020
6.88
2p1
Sätra
11.2
 
6.89
5h2
Sätra
11.2
 
100 m
Ute Visa/dölj alla resultat
2012
12.33
 M-17
Huddinge
16.9
-3.1
2014
11.70
 5h5-19
Göteborg/U
28.6
-0.1
2016
11.43
 5h5
Göteborg/U
2.7
-0.2
2017
11.03
 1rH
Skara
6.6
 +0.8
11.06
1h14
Skara
6.6
 +1.5
2019
10.98
1h1
Huddinge
15.6
-0.4
300 m
Ute Visa/dölj alla resultat
2012
39.38
D-17
Huddinge
15.9
 
1000 m
Ute Visa/dölj alla resultat
2012
3:12.51
M-17
Huddinge
16.9
 
Höjd
Ute Visa/dölj alla resultat
2012
1.61
M-17
Huddinge
16.9
 
Stav
Ute Visa/dölj alla resultat
2012
3.32
D-17
Huddinge
15.9
 
3.32
d
Huddinge
15.9
 
Längd
Ute Visa/dölj alla resultat
2010
5.43
 20q-15
Kil
13.8
-0.1
2012
6.44
 7-17
Göteborg/U
9.7
 +1.5
6.18
--17
Sollentuna
10.8
 +0.5
6.18
M-17
Huddinge
16.9
 +0.7
6.70w
 4-17
Sollentuna
10.8
 +3.0
2014
7.12
 1-19
Huddinge
15.6
 +1.9
6.94
12q
Umeå
1.8
 +1.5
6.82
11
Umeå
2.8
 +1.5
6.60
4
Borås
5.7
 +1.2
2015
7.21
 4-22
Kalmar
22.8
 +1.1
2016
7.38
 5
Sollentuna
27.8
-0.4
7.35
5-22
Hässleholm
6.8
 +1.7
7.35
5-22
Hässleholm
6.8
 +1.7
7.11
7q
Sollentuna
26.8
 +0.7
7.07
3-22
Hässleholm
5.8
 +0.1
7.07
3q-22
Hässleholm
5.8
 +0.1
6.98
3
Stockholm/S
16.6
-0.6
7.46w
 1
Norrköping
13.7
 +2.5
2017
7.51
5
Sollentuna
29.6
 +1.6
7.50
5
Göteborg/U
1.7
 +0.8
7.49
9-22
Bydgoszcz, POL
14.7
 +0.6
7.47
1
Borås
7.7
 +0.8
7.30
9
København, DEN
20.6
 0.0
7.29
1
Torremolinos, ESP
19.4
 +2.0
7.05
4-22
Gävle
13.8
 +0.3
7.05
-q
Helsingborg
25.8
 +1.9
6.94
7
Helsingborg
26.8
-1.4
6.35
-q-22
Gävle
12.8
 +2.0
7.61w
 9q-22
Bydgoszcz, POL
13.7
 +2.3
7.11w
 8q
Helsingborg
25.8
 +2.1
7.03w
 4q-22
Gävle
12.8
 +3.1
2018
7.39w
 7
Sollentuna
28.6
 +2.7
2020
7.36
 5
Uppsala
16.8
-0.5
7.21
5q
Uppsala
15.8
-0.6
6.95
2
Kil
14.6
 +1.3
6.85
5cB
Göteborg/U
4.7
 +1.0
Inne Visa/dölj alla resultat
2010
5.09
 21q-15
Norrköping
28.2
 
2011
5.33
 19-16
Huddinge
19.2
 
2012
6.00
 11-17
Bollnäs
26.2
 
2013
6.49
 2
Sätra
26.1
 
5.88
16-19
Uddevalla
24.2
 
2014
6.13
 12-19
Sätra
16.2
 
2015
7.07
 4 -2
Göteborg/FH
28.2
 
6.76
12
Sätra
22.2
 
2016
7.30
 5-22
Växjö
20.2
 
6.98
9
Malmö/A
28.2
 
2017
7.52
 1
Sätra
4.2
 
7.48
3
Tampere, FIN
11.2
 
7.29
1-22
Göteborg/FH
18.2
 
7.17
4
Växjö
26.2
 
2018
7.08
 7
Gävle
18.2
 
2019
7.39
 5
Norrköping
17.2
 
2020
7.57
2
Växjö
23.2
 
Tresteg
Ute Visa/dölj alla resultat
2010
11.90
 6-15
Göteborg/U
3.7
 +0.6
11.88
9-15
Kil
15.8
 0.0
2011
11.91
 2-16
Huddinge
10.6
 +1.1
2012
14.15
 2-17
Göteborg/U
8.7
 +0.5
13.78
3-17
Sollentuna
12.8
 +0.5
2014
14.64
 +-19
Göteborg/U
29.6
 +0.4
14.17
7
Umeå
3.8
-0.6
14.81w
 1-19
Göteborg/U
29.6
 +2.1
2015
15.23
 5
Söderhamn
9.8
 0.0
14.94
5
Göteborg/U
5.7
 +1.3
14.77
--22
Kalmar
23.8
 +1.4
14.59
3
Sundsvall
1.7
 +0.7
14.94w
 1-22
Kalmar
23.8
 +2.1
2016
15.07
 2
Norrköping
13.7
 +1.4
15.03
-
Göteborg/U
3.7
 +1.2
14.72
4-22
Espoo, FIN
20.8
-0.6
14.45
11
Sollentuna
28.8
-0.4
14.43
--22
Hässleholm
7.8
 +0.8
15.32w
 1
Göteborg/U
3.7
 +2.1
14.83w
 2-22
Hässleholm
7.8
 +2.3
14.83w
 2-22
Hässleholm
7.8
 +2.3
2017
15.47
 1-22
Gävle
11.8
 +0.8
14.85
1
Sollentuna
9.6
 +0.6
14.61
9
Helsingborg
27.8
 +0.6
2018
15.43
 1
Sollentuna
1.6
 +0.5
2019
16.71
1
Stockholm/S
24.8
 +0.5
16.53
4
Bydgoszcz, POL
11.8
-1.7
16.30
-
Göteborg/U
30.6
 +1.9
15.80
1
Karlstad
30.8
 +1.4
16.54w
 1
Göteborg/U
30.6
 +2.6
16.34w
 1
Malmö/S
26.6
 +3.2
2020
16.65
 3
Berlin, GER
13.9
-0.7
16.55
2
Tampere, FIN
5.9
-0.9
16.37
1
Göteborg/S
6.8
 +0.4
16.09
1
Uppsala
14.8
 +0.1
Inne Visa/dölj alla resultat
2010
11.49
 10-15
Norrköping
27.2
 
2011
12.17
 4-17
Sätra
5.2
 
12.14
8-16
Huddinge
20.2
 
2012
13.17
 5-17
Bollnäs
25.2
 
2013
14.02
 2-19
Uddevalla
23.2
 
2014
14.53
 6
Göteborg/FH
22.2
 
14.42
1-19
Sätra
15.2
 
2015
14.91
 5
Sätra
21.2
 
14.63
1 -22
Göteborg/FH
1.3
 
2016
15.18
 1-22
Växjö
21.2
 
15.05
5
Malmö/A
27.2
 
14.73
1
Sätra
6.2
 
2017
15.92
 2
Växjö
21.1
 
15.32
3
Växjö
25.2
 
15.25
1-22
Göteborg/FH
19.2
 
2018
15.67
 1
Växjö
20.1
 
15.59
1
Gävle
17.2
 
2019
16.20
 1
Bærum, NOR
10.2
 
15.89
1
Norrköping
16.2
 
15.77
1
Växjö
19.1
 
2020
16.36
1
Växjö
22.2
 
Kula
Ute Visa/dölj alla resultat
2020
10.57
Com
Karlstad
19.9
 
Diskus
Ute Visa/dölj alla resultat
2018
31.73
4
Hässelby
31.7
 
2020
28.24
 Com
Karlstad
19.9
 
Slägga
Ute Visa/dölj alla resultat
2020
22.12
Com
Karlstad
19.9
 
Spjut
Ute Visa/dölj alla resultat
2019
40.17
 Com
Karlstad/M
18.10
 
2020
44.29
Com
Karlstad
19.9
 
Castorama
Ute Visa/dölj alla resultat
2020
1.825
9
Karlstad
19.9
 

Junior-ungdom
60 m häck (91.4 cm, 8.9 m)
Inne Visa/dölj alla resultat
2011
9.63
6h2-16
Huddinge
19.2
 
110 m häck (91.4 cm, 8.9 m)
Ute Visa/dölj alla resultat
2010
17.50w
 3r2-17
Gävle
19.9
 +2.2
2010
17.50w
 3rB
Gävle
19.9
 +2.2
2012
16.49
D-17
Huddinge
15.9
 
2012
16.49
d
Huddinge
15.9
-1.3
Kula (5.0 kg)
Ute Visa/dölj alla resultat
2012
10.60
M-17
Huddinge
16.9
 
Diskus (1.5 kg)
Ute Visa/dölj alla resultat
2012
24.66
D-17
Huddinge
15.9
 
Spjut (700 g)
Ute Visa/dölj alla resultat
2012
40.37
d
Huddinge
15.9
 
40.37
D-17
Huddinge
15.9
 
Tiokamp (P17, 300m)
Ute Visa/dölj alla resultat
2012
5.301
9-17
Huddinge
16.9
 
Ute
Längd
SM 2014 11
6.82
12
Q
6.94
SM 2016 5
7.38
7
Q
7.11
SM 2017 7
6.94
8
Q
7.11w
SM 2020 5
7.36
5
Q
7.21
Tresteg
SM 2014 7
14.17
SM 2015 5
15.23
SM 2016 11
14.45
SM 2017 9
14.61
SM 2019 1
15.80
SM 2020 1
16.09
Inne
Längd
ISM 2015 12
6.76
ISM 2016 9
6.98
ISM 2017 4
7.17
ISM 2018 7
7.08
ISM 2019 5
7.39
ISM 2020 2
7.57
Tresteg
ISM 2014 6
14.53
ISM 2015 5
14.91
ISM 2016 5
15.05
ISM 2017 3
15.32
ISM 2018 1
15.59
ISM 2019 1
15.89
ISM 2020 1
16.36

Junior-ungdom
Ute
Längd
USM 2012 4
17
6.70w
JSM 2015 4
22
7.21
JSM 2016 5
22
7.35
5
22
7.35
3
22
7.07
3
22
Q
7.07
JSM 2017 4
22
7.05
4
22
Q
7.03w
Tresteg
USM 2012 3
17
13.78
JSM 2014 3
19
14.69
JSM 2015 1
22
14.94w
JSM 2016 2
22
14.83w
2
22
14.83w
JSM 2017 1
22
15.47
Tiokamp (P17, 300m)
USM 2012 9
17
5.301
Inne
Längd
IUSM 2012 11
17
6.00
IJSM 2013 16
19
5.88
IJSM 2014 12
19
6.13
IUSM 2015 4
7.07
IJSM 2016 5
22
7.30
IJSM 2017 1
22
7.29
Tresteg
IUSM 2012 5
17
13.17
IJSM 2013 2
19
14.02
IJSM 2014 1
19
14.42
IJSM 2015 1
22
14.63
IJSM 2016 1
22
15.18
IJSM 2017 1
22
15.25

Lag-EM och Europacupen
Tresteg
Super L 2019 4
16.53

Junior-ungdom
Längd
JEM22 2017 9
22
7.49
9
22
Q
7.61w
Tresteg
JEM22 2017
-
22
Q
DNS