William Lanndalen

Född: 18 juni 2001

Ålder: 19 år 218 dagar

Förening:
 Ullevi FK
 14.1.2020–

Tidigare förening(ar):
IF Kville 15.11.2017–13.1.2020
IK Ymer –14.11.2017

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

Kula (1)
11.41
PB  BoråsBorås23.6.20
 
XX11.41XXX
Diskus (1)
32.61
SB  BoråsBorås16.6.20
 
32.2132.5532.6131.28
Vikt (11.34 kg) ()
15.37i
SB  Göteborg/FHGöteborg/FH11.1.20
Vikt  (2)
16.23i
PB  (12)ISMVäxjöISM, Växjö23.2.20
 
16.2315.79XXX16.03
14.95i
  IJSMGöteborg/FHIJSM, Göteborg/FH29.2.20
 
14.47X14.9514.52X14.94
Slägga (6.0 kg) (6)
NM
  VäxjöVäxjö31.1.20
 
XXXXXX
62.10
PB  BoråsBorås17.6.20
 
61.3462.10XX58.99X
NM
  BoråsBorås23.6.20
 
XXXXXX
58.54
  Göteborg/S-KGöteborg/S-K27.6.20
59.02
  BålstaBålsta18.7.20
 
XXXX59.02X
59.75
  JSMNorrköpingJSM, Norrköping21.8.20
 
56.3355.5459.7559.51X59.08
Slägga (2)
53.71
PB  BoråsBorås17.6.20
 
X49.21X53.71X51.52
48.92
  BoråsBorås23.6.20
 
X48.92X
Spjut (7)
55.04
PB  Göteborg/S-KGöteborg/S-K14.6.20
 
51.7555.0451.9148.40X52.17
55.33
PB  BoråsBorås30.6.20
 
55.3352.19XX50.84X
58.55
PB  BålstaBålsta18.7.20
 
58.5552.17XX51.1658.55
52.70
  VarbergVarberg23.7.20
 
48.9452.7049.4449.70
56.55
  BoråsBorås28.7.20
 
49.2451.7556.55
56.32
  SöderhamnSöderhamn8.8.20
 
56.3255.5054.36X52.48X
61.01
PB  JSMNorrköpingJSM, Norrköping23.8.20
 
55.4756.3450.5356.4561.0158.00

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

Kula (6.0 kg) (1)
12.82i
PB  Göteborg/S-KGöteborg/S-K3.3.19
Kula (1)
11.31
PB  RydaRyda21.9.19
Diskus (1)
33.94
SB  BoråsBorås5.10.19
Vikt  (2)
15.16i
PB  (17)Göteborg/FHGöteborg/FH13.1.19
14.61i
  IJSMVäxjöIJSM, Växjö23.2.19
Slägga (6.0 kg) (6)
55.16
PB  Göteborg/S-KGöteborg/S-K2.3.19
60.39
PB  Göteborg/SGöteborg/S9.6.19
59.07
  VUSGöteborg/UVUS, Göteborg/U29.6.19
58.78
  BottnarydBottnaryd30.6.19
55.26
  JSMGöteborg/SJSM, Göteborg/S9.8.19
58.68
  VarbergVarberg18.8.19
Slägga (2)
50.74
PB  NorrköpingNorrköping2.6.19
51.67
PB  (24)BoråsBorås5.10.19
Spjut (3)
47.19
SB  Göteborg/S-KGöteborg/S-K3.3.19
49.63
PB  VUSGöteborg/UVUS, Göteborg/U28.6.19
49.98
PB  BoråsBorås5.10.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.*, alltat292894.multi, alltat292894.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.alltat292894 inner join world.yearsweall ON alltat292894.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 alltat292894.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

Kula (5.0 kg) (3)
11.52i
SB  Göteborg/FHGöteborg/FH13.1.18
13.78i
PB  BoråsBorås1.3.18
13.38
PB  KungsbackaKungsbacka25.8.18
Kula (1)
10.60
PB  Göteborg/S-KGöteborg/S-K11.9.18
Diskus (1.5 kg) (3)
43.93i
PB  Växjö/TiVäxjö/Ti3.2.18
 
42.58XX41.5243.0943.93
43.80
SB  ÖSPHelsingborgÖSP, Helsingborg8.7.18
42.40
  USMHuddingeUSM, Huddinge3.8.18
 
39.8035.4542.40XXX
Diskus (1)
31.13
SB  Göteborg/S-KGöteborg/S-K11.10.18
Vikt (11.34 kg) (2)
18.89i
PB  Göteborg/FHGöteborg/FH13.1.18
18.13i
  IUSMUppsalaIUSM, Uppsala24.2.18
 
17.2616.5617.3317.6817.4318.13
Slägga (5.0 kg) (7)
54.00
SB  Växjö/AVäxjö/A3.2.18
 
XXXX54.00X
63.32
PB  (91) BålstaBålsta12.5.18
59.74
  Göteborg/SGöteborg/S3.6.18
61.35
  Växjö/AVäxjö/A25.6.18
61.12
  VUSGöteborg/UVUS, Göteborg/U30.6.18
60.29
  Karlstad/MKarlstad/M21.7.18
61.59
  USMHuddingeUSM, Huddinge5.8.18
Slägga (1)
45.14
PB  Göteborg/S-KGöteborg/S-K11.10.18
Spjut (700 g) (3)
52.70i
PB  Växjö/TiVäxjö/Ti3.2.18
 
52.7042.1744.6446.76XX
52.00
SB  USMHuddingeUSM, Huddinge4.8.18
 
48.2048.2648.4449.5550.0252.00
55.45
PB  KungsbackaKungsbacka25.8.18
Spjut (1)
47.94
PB  LerumLerum19.8.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.*, alltat292894.multi, alltat292894.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.alltat292894 inner join world.yearsweall ON alltat292894.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 alltat292894.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

Kula (5.0 kg) (4)
12.10i
PB  UppsalaUppsala17.12.16
12.91i
PB  BoråsBorås28.1.17
12.91
PB  HelsingborgHelsingborg8.7.17
12.10
  USMFalunUSM, Falun13.8.17
 
X11.41X11.9112.1011.91
Diskus (1.5 kg) (1)
44.06
PB  USMFalunUSM, Falun12.8.17
 
43.82XX44.06XX
Diskus (1)
34.76
PB  BoråsBorås24.9.17
Slägga (5.0 kg) (2)
58.49
PB  Göteborg/UGöteborg/U1.7.17
57.38
  USMFalunUSM, Falun11.8.17
 
XX56.4257.3457.38X
Slägga (1)
35.26
SB  BoråsBorås24.9.17
Spjut (700 g) (2)
49.60
PB  USMFalunUSM, Falun13.8.17
 
45.5047.7847.6549.6046.4147.71
55.02
PB  KungsbackaKungsbacka26.8.17
Spjut (1)
47.89
PB  Göteborg/SGöteborg/S3.6.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.*, alltat292894.multi, alltat292894.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.alltat292894 inner join world.yearsweall ON alltat292894.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 alltat292894.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

Kula (4.0 kg) (4)
12.08i
PB  Göteborg/FHGöteborg/FH20.12.15
11.26i
  IUSMUddevallaIUSM, Uddevalla5.3.16
 
11.26X11.00
12.81
PB  GöteborgGöteborg21.7.16
12.43
  USMVellingeUSM, Vellinge7.8.16
 
12.1412.2612.4312.2012.31
Diskus (1.0 kg) (2)
41.37
PB  USMVellingeUSM, Vellinge6.8.16
 
41.37
46.15
PB  VarbergVarberg13.8.16
Vikt (9.08 kg) (1)
17.58i
PB  IUSMUddevallaIUSM, Uddevalla6.3.16
 
16.26X16.49X17.58X
Slägga (4.0 kg) (2)
57.74
PB  BoråsBorås24.7.16
51.83
  USMVellingeUSM, Vellinge5.8.16
 
45.16X51.83XXX
Slägga (1)
35.87
PB  JönköpingJönköping5.6.16
Spjut (600 g) (2)
52.40
PB  USMVellingeUSM, Vellinge7.8.16
 
49.1552.4047.6547.56X48.68
54.28
PB  GöteborgGöteborg18.8.16

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

Kula (4.0 kg) (2)
10.57i
PB  Göteborg/FHGöteborg/FH22.11.14
11.28
PB  HerrljungaHerrljunga13.9.15
Diskus (1.0 kg) (1)
33.84
PB  LidköpingLidköping5.9.15
Slägga (4.0 kg) (1)
41.72
PB  LidköpingLidköping6.9.15
Spjut (600 g) (1)
40.30
PB  LidköpingLidköping6.9.15

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

Kula
Ute
11.41
Borås23.6.20
Diskus
Ute
34.76
Borås24.9.17
Vikt
Inne
16.23
Växjö23.2.20
Slägga
Ute
53.71
Borås17.6.20
Spjut
Ute
61.01
Norrköping23.8.20

Junior-ungdom
Kula (4.0 kg)
Ute
12.81
Göteborg21.7.16
Inne
12.08
Göteborg/FH20.12.15
Kula (5.0 kg)
Ute
13.38
Kungsbacka25.8.18
Inne
13.78
Borås1.3.18
Kula (6.0 kg)
Inne
12.82
Göteborg/S-K3.3.19
Diskus (1.0 kg)
Ute
46.15
Varberg13.8.16
Diskus (1.5 kg)
Ute
44.06
Falun12.8.17
Inne
43.93
Växjö/Ti3.2.18
Vikt (11.34 kg)
Inne
18.89
Göteborg/FH13.1.18
Vikt (9.08 kg)
Inne
17.58
Uddevalla6.3.16
Slägga (4.0 kg)
Ute
57.74
Borås24.7.16
Slägga (5.0 kg)
Ute
63.32
Bålsta12.5.18
Slägga (6.0 kg)
Ute
62.10
Borås17.6.20
Spjut (600 g)
Ute
54.28
Göteborg18.8.16
Spjut (700 g)
Ute
55.45
Kungsbacka25.8.18
Spjut
61.01
1
19
JSMNorrköping23.8.20
58.55
1
19
Bålsta18.7.20
56.55
1
19
Borås28.7.20
56.32
3
22
Söderhamn8.8.20
55.33
1
19
Borås30.6.20
55.04
3
Göteborg/S-K14.6.20
52.70
1
19
Varberg23.7.20
49.98
com
Borås5.10.19
49.63
7
19
VUSGöteborg/U28.6.19
47.94
1
Lerum19.8.18
Visa/dölj alla resultat
47.89
6
Göteborg/S3.6.17
47.19
1
19
Göteborg/S-K3.3.19
10-bästasnitt: 54.305

Slägga (6.0 kg)
62.10
1
19
Borås17.6.20
60.39
1
19
Göteborg/S9.6.19
59.75
5
19
JSMNorrköping21.8.20
59.07
3
19
VUSGöteborg/U29.6.19
59.02
6
19
Bålsta18.7.20
58.78
3
19
Bottnaryd30.6.19
58.68
1
19
Varberg18.8.19
58.54
1
19
Göteborg/S-K27.6.20
55.26
6
19
JSMGöteborg/S9.8.19
55.16
3
19
Göteborg/S-K2.3.19
10-bästasnitt: 58.675

Total results in database: 87
By event:
Kula (4.0 kg):6
Kula (5.0 kg):7
Kula (6.0 kg):1
Kula:3
Diskus (1.0 kg):3
Diskus (1.5 kg):4
Diskus:4
Vikt (11.34 kg):3
Vikt (9.08 kg):1
Vikt :4
Slägga (4.0 kg):3
Slägga (5.0 kg):9
Slägga (6.0 kg):12
Slägga:7
Spjut (600 g):3
Spjut (700 g):5
Spjut:12
Kula
Ute Visa/dölj alla resultat
2018
10.60
 2
Göteborg/S-K
11.9
 
2019
11.31
 Com
Ryda
21.9
 
2020
11.41
2
Borås
23.6
 
Diskus
Ute Visa/dölj alla resultat
2017
34.76
Com
Borås
24.9
 
2018
31.13
 Com
Göteborg/S-K
11.10
 
2019
33.94
 Com
Borås
5.10
 
2020
32.61
 1
Borås
16.6
 
Slägga
Ute Visa/dölj alla resultat
2016
35.87
 3
Jönköping
5.6
 
2017
35.26
 Com
Borås
24.9
 
2018
45.14
 Com
Göteborg/S-K
11.10
 
2019
51.67
 Com
Borås
5.10
 
50.74
Norrköping
2.6
 
2020
53.71
1
Borås
17.6
 
48.92
1
Borås
23.6
 
Spjut
Ute Visa/dölj alla resultat
2017
47.89
 6
Göteborg/S
3.6
 
2018
47.94
 1
Lerum
19.8
 
2019
49.98
 Com
Borås
5.10
 
49.63
7-19
Göteborg/U
28.6
 
47.19
1-19
Göteborg/S-K
3.3
 
2020
61.01
1-19
Norrköping
23.8
 
58.55
1-19
Bålsta
18.7
 
56.55
1-19
Borås
28.7
 
56.32
3-22
Söderhamn
8.8
 
55.33
1-19
Borås
30.6
 
55.04
3
Göteborg/S-K
14.6
 
52.70
1-19
Varberg
23.7
 
Vikt
Inne Visa/dölj alla resultat
2019
15.16
 1
Göteborg/FH
13.1
 
14.61
6-19
Växjö
23.2
 
2020
16.23
7
Växjö
23.2
 
14.95
3-19
Göteborg/FH
29.2
 

Junior-ungdom
Kula (4.0 kg)
Ute Visa/dölj alla resultat
2015
11.28
 1-15
Herrljunga
13.9
 
2016
12.81
2-15
Göteborg
21.7
 
12.43
8-15
Vellinge
7.8
 
Inne Visa/dölj alla resultat
2015
10.57
 2-14
Göteborg/FH
22.11
 
2016
12.08
2-15
Göteborg/FH
20.12
 
11.26
12-15
Uddevalla
5.3
 
Kula (5.0 kg)
Ute Visa/dölj alla resultat
2017
12.91
 4-17
Helsingborg
8.7
 
12.10
6-16
Falun
13.8
 
2018
13.38
2-17
Kungsbacka
25.8
 
Inne Visa/dölj alla resultat
2017
12.91
 1-17
Borås
28.1
 
12.10
1-17
Uppsala
17.12
 
2018
13.78
1-17
Borås
1.3
 
11.52
5-17
Göteborg/FH
13.1
 
Kula (6.0 kg)
Inne Visa/dölj alla resultat
2019
12.82
4-19
Göteborg/S-K
3.3
 
Diskus (1.0 kg)
Ute Visa/dölj alla resultat
2015
33.84
 4-14
Lidköping
5.9
 
2016
46.15
1-15
Varberg
13.8
 
41.37
8-15
Vellinge
6.8
 
Diskus (1.5 kg)
Ute Visa/dölj alla resultat
2017
44.06
4-16
Falun
12.8
 
2018
43.80
 2-17
Helsingborg
8.7
 
42.40
7 -17
Huddinge
3.8
 
Inne Visa/dölj alla resultat
2018
43.93
6-17
Växjö/Ti
3.2
 
Slägga (4.0 kg)
Ute Visa/dölj alla resultat
2015
41.72
 1-14
Lidköping
6.9
 
2016
57.74
1-15
Borås
24.7
 
51.83
1-15
Vellinge
5.8
 
Slägga (5.0 kg)
Ute Visa/dölj alla resultat
2017
58.49
 5-17
Göteborg/U
1.7
 
57.38
1-16
Falun
11.8
 
2018
63.32
1-17
Bålsta
12.5
 
61.59
2-17
Huddinge
5.8
 
61.35
2-17
Växjö/A
25.6
 
61.12
4-17
Göteborg/U
30.6
 
60.29
1-17
Karlstad/M
21.7
 
59.74
1-17
Göteborg/S
3.6
 
54.00
3-17
Växjö/A
3.2
 
Slägga (6.0 kg)
Ute Visa/dölj alla resultat
2019
60.39
 1-19
Göteborg/S
9.6
 
59.07
3-19
Göteborg/U
29.6
 
58.78
3-19
Bottnaryd
30.6
 
58.68
1-19
Varberg
18.8
 
55.26
6 -19
Göteborg/S
9.8
 
55.16
3-19
Göteborg/S-K
2.3
 
2020
62.10
1-19
Borås
17.6
 
59.75
5-19
Norrköping
21.8
 
59.02
6-19
Bålsta
18.7
 
58.54
1-19
Göteborg/S-K
27.6
 
Spjut (600 g)
Ute Visa/dölj alla resultat
2015
40.30
 3-14
Lidköping
6.9
 
2016
54.28
1-15
Göteborg
18.8
 
52.40
1-15
Vellinge
7.8
 
Spjut (700 g)
Ute Visa/dölj alla resultat
2017
55.02
 1-17
Kungsbacka
26.8
 
49.60
1-16
Falun
13.8
 
2018
55.45
1-17
Kungsbacka
25.8
 
52.00
2 -17
Huddinge
4.8
 
Vikt (9.08 kg)
Inne Visa/dölj alla resultat
2016
17.58
1-15
Uddevalla
6.3
 
Vikt (11.34 kg)
Inne Visa/dölj alla resultat
2018
18.89
1
Göteborg/FH
13.1
 
18.13
3-17
Uppsala
24.2
 
2020
15.37
 --17
Göteborg/FH
11.1
 
Inne
Vikt
ISM 2020 7
16.23

Junior-ungdom
Ute
Diskus (1.5 kg)
USM 2018 7
17
42.40
Slägga (5.0 kg)
USM 2018 2
17
61.59
Slägga (6.0 kg)
JSM 2019 6
19
55.26
JSM 2020 5
19
59.75
Spjut (700 g)
USM 2018 2
17
52.00
Spjut
JSM 2020 1
19
61.01
Inne
Vikt (11.34 kg)
IUSM 2018 3
17
18.13
Vikt
IJSM 2019 6
19
14.61
IJSM 2020 3
19
14.95