Arvid Mägi Theorin

Född: 21 mars 2001

Ålder: 19 år 303 dagar

Förening:
 Malmö AI
 15.11.2020–

Tidigare förening(ar):
IF Kville –14.11.2020

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.*, alltat259504.multi, alltat259504.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.alltat259504 inner join world.yearsweall ON alltat259504.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 alltat259504.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.*, alltat259504.multi, alltat259504.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.alltat259504 inner join world.yearsweall ON alltat259504.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 alltat259504.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 (6.0 kg) (4)
18.34i
PB  (16) Växjö/TiVäxjö/Ti1.2.20
 
X17.4117.6517.9317.9418.34
17.65i
  IJSMGöteborg/FHIJSM, Göteborg/FH1.3.20
 
16.7017.3517.1417.2717.65X
17.11
SB  (72) KungälvKungälv4.7.20
 
17.11XXXX16.05
NM
  Malmö/SMalmö/S19.7.20
 
XXXXXX
Kula (2)
16.53i
PB  (10) (7)ISMVäxjöISM, Växjö22.2.20
 
14.9915.5616.53X15.90X
14.92
SB  BottnarydBottnaryd27.6.20
 
14.82X14.92XXX
Diskus (1.75 kg) (1)
44.55i
PB  Växjö/TiVäxjö/Ti1.2.20
 
44.55XX42.60XX

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.*, alltat259504.multi, alltat259504.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.alltat259504 inner join world.yearsweall ON alltat259504.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 alltat259504.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) (8)
17.44i
PB  (37) IJSMVäxjöIJSM, Växjö24.2.19
18.01
PB  (65) Växjö/AVäxjö/A10.5.19
17.26
  Göteborg/SGöteborg/S8.6.19
16.64
  MalmöMalmö18.6.19
 
15.89XXXX16.64
17.42
  BottnarydBottnaryd29.6.19
17.65
  JEM19BoråsJEM19, Borås18.7.19
 
X17.65X
17.70
  JSMGöteborg/SJSM, Göteborg/S11.8.19
17.84
  V3NatKristiansand, NORV3Nat, Kristiansand, NOR17.8.19
 
16.95XX17.5617.8417.83
Kula (1)
15.57
PB  (65) (16)NorrköpingNorrköping2.6.19
Diskus (1.75 kg) (3)
48.37
PB  BottnarydBottnaryd29.6.19
48.98
PB  VUSGöteborg/UVUS, Göteborg/U30.6.19
50.24
PB  JSMGöteborg/SJSM, Göteborg/S10.8.19
Diskus (1)
41.26
SB  Göteborg/S-KGöteborg/S-K25.9.19
Vikt  (1)
15.03i
PB  (18)IJSMVäxjöIJSM, Växjö23.2.19
Slägga (6.0 kg) (1)
45.20
PB  Göteborg/S-KGöteborg/S-K4.5.19
Slägga (1)
41.61
PB  Göteborg/S-KGöteborg/S-K25.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.*, alltat259504.multi, alltat259504.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.alltat259504 inner join world.yearsweall ON alltat259504.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 alltat259504.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) (16)
17.47i
PB  Göteborg/FHGöteborg/FH2.12.17
17.28i
  Göteborg/FHGöteborg/FH17.12.17
16.86i
  Göteborg/FHGöteborg/FH13.1.18
17.84i
PB  VäxjöVäxjö20.1.18
18.57i
PB  (9) (9) Växjö/TiVäxjö/Ti3.2.18
 
16.74X17.4418.57X17.51
18.01i
  IUSMUppsalaIUSM, Uppsala25.2.18
 
16.54XXX16.9118.01
17.35
PB  BålstaBålsta12.5.18
16.43
  Göteborg/SGöteborg/S3.6.18
17.93
PB  Göteborg/SGöteborg/S9.6.18
17.93
=PB  HalmstadHalmstad17.6.18
16.73
  VUSGöteborg/UVUS, Göteborg/U1.7.18
17.56
  UEMGyőr, HUNUEM, Győr, HUN5.7.18
 
X17.5617.05
18.01
PB  UEMGyőr, HUNUEM, Győr, HUN6.7.18
 
17.4117.02X17.61X18.01
17.05
  USMHuddingeUSM, Huddinge5.8.18
18.09
PB  Ljungby/LTLjungby/LT17.8.18
18.62
PB  (33) (29) vFINTampere, FINvFIN, Tampere, FIN1.9.18
 
18.00X18.1518.6217.2717.93
Kula (6.0 kg) (1)
14.82i
PB  VäxjöVäxjö20.1.18
Kula (1)
14.39
SB  Göteborg/SGöteborg/S5.9.18
Diskus (1.5 kg) (3)
38.30i
PB  Växjö/TiVäxjö/Ti3.2.18
 
XX38.30XXX
49.94
PB  BålstaBålsta12.5.18
42.48
  USMHuddingeUSM, Huddinge3.8.18
 
XX37.35X42.48X
Diskus (1)
42.26
PB  Göteborg/S-KGöteborg/S-K11.9.18
Vikt (11.34 kg) (2)
15.22i
PB  Göteborg/FHGöteborg/FH13.1.18
17.46i
PB  IUSMUppsalaIUSM, Uppsala24.2.18
 
XX17.46X16.99X
Slägga (1)
36.12
PB  Göteborg/S-KGöteborg/S-K11.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.*, alltat259504.multi, alltat259504.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.alltat259504 inner join world.yearsweall ON alltat259504.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 alltat259504.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

100 m (2)
11.51w
  Göteborg/UGöteborg/U1.7.17+2.3
11.72
PB  USMFalunUSM, Falun11.8.17+1.0
200 m (1)
23.46
PB  Göteborg/UGöteborg/U2.7.17+1.6
Stav (1)
3.35i
SB  Göteborg/FHGöteborg/FH5.2.17
Kula (5.0 kg) (7)
16.25i
PB  Göteborg/FHGöteborg/FH3.12.16
16.60
PB  USMUppsalaUSM, Uppsala4.3.17
 
15.33X16.60XXX
17.24
PB  KungälvKungälv25.6.17
16.88
  VUSGöteborg/UVUS, Göteborg/U1.7.17
16.29
  EYOFGyőr, HUNEYOF, Győr, HUN27.7.17
15.48
  USMFalunUSM, Falun13.8.17
 
XX15.0015.4814.7413.46
16.29
  vFINStockholm/SvFIN, Stockholm/S3.9.17
 
16.1716.29XXXX
Kula (1)
14.42
PB  JönköpingJönköping25.5.17
Diskus (1.5 kg) (1)
48.78
PB  USMFalunUSM, Falun12.8.17
 
45.26X43.68XX48.78
Vikt (11.34 kg) (1)
14.60
PB  USMUppsalaUSM, Uppsala5.3.17
 
X14.4514.60XXX

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

80 m (1)
9.79
PB  Göteborg/SGöteborg/S11.6.16+0.6
300 m (2)
38.41
PB  Göteborg/SGöteborg/S12.6.16
39.14
  USMVellingeUSM, Vellinge6.8.16
Stav (3)
3.52i
PB  Göteborg/FHGöteborg/FH27.2.16
3.52i
=PB  IUSMUddevallaIUSM, Uddevalla5.3.16
 
3.45
O
3.52
O
3.57
XXX
     
3.40
SB  Göteborg/SGöteborg/S11.6.16
Kula (4.0 kg) (4)
13.17i
PB  Göteborg/FHGöteborg/FH20.12.15
13.17i
=PB  IUSMUddevallaIUSM, Uddevalla5.3.16
 
13.1712.1113.0312.7912.95X
13.52
PB  USMVellingeUSM, Vellinge7.8.16
 
12.18X13.52XXX
16.37
PB  LinköpingLinköping4.9.16
Diskus (1.0 kg) (1)
51.61
PB  USMVellingeUSM, Vellinge6.8.16
 
51.61
Slägga (1)
25.01
PB  LinköpingLinköping14.5.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.*, alltat259504.multi, alltat259504.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.alltat259504 inner join world.yearsweall ON alltat259504.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 alltat259504.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

80 m (2)
10.17
PB  VarbergVarberg8.8.15+1.3
10.10w
  VarbergVarberg8.8.15+2.2
300 m (1)
38.51
PB  LidköpingLidköping6.9.15
Stav (2)
3.00i
PB  Göteborg/FHGöteborg/FH22.11.14
3.56
PB  LidköpingLidköping6.9.15
Kula (4.0 kg) (2)
11.77i
PB  Göteborg/FHGöteborg/FH22.11.14
12.72
PB  LidköpingLidköping5.9.15
Diskus (1.0 kg) (1)
34.66
PB  HelsingborgHelsingborg11.7.15
Slägga (4.0 kg) (1)
23.61
PB  Göteborg/SGöteborg/S7.6.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.*, alltat259504.multi, alltat259504.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.alltat259504 inner join world.yearsweall ON alltat259504.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 alltat259504.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

Stav (1)
2.80
PB  UddevallaUddevalla13.9.14

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

80 m
Ute
9.79
Göteborg/S11.6.16+0.6
100 m
Ute
11.72
Falun11.8.17+1.0
200 m
Ute
23.46
Göteborg/U2.7.17+1.6
300 m
Ute
38.41
Göteborg/S12.6.16
Stav
Ute
3.56
Lidköping6.9.15
Inne
3.52
Göteborg/FH27.2.16
Kula
Ute
15.57
Norrköping2.6.19
Inne
16.53
Växjö22.2.20
Diskus
Ute
42.26
Göteborg/S-K11.9.18
Vikt
Inne
15.03
Växjö23.2.19
Slägga
Ute
41.61
Göteborg/S-K25.9.19

Junior-ungdom
Kula (4.0 kg)
Ute
16.37
Linköping4.9.16
Inne
13.17
Göteborg/FH20.12.15
Kula (5.0 kg)
Ute
18.62
Tampere, FIN1.9.18
Inne
18.57
Växjö/Ti3.2.18
Kula (6.0 kg)
Ute
18.01
Växjö/A10.5.19
Inne
18.34
Växjö/Ti1.2.20
Diskus (1.0 kg)
Ute
51.61
Vellinge6.8.16
Diskus (1.5 kg)
Ute
49.94
Bålsta12.5.18
Inne
38.30
Växjö/Ti3.2.18
Diskus (1.75 kg)
Ute
50.24
Göteborg/S10.8.19
Inne
44.55
Växjö/Ti1.2.20
Vikt (11.34 kg)
Ute
14.60
Uppsala5.3.17
Inne
17.46
Uppsala24.2.18
Slägga (4.0 kg)
Ute
23.61
Göteborg/S7.6.15
Slägga (6.0 kg)
Ute
45.20
Göteborg/S-K4.5.19

Kula (5.0 kg)
18.62
1
17
vFINTampere, FIN1.9.18
18.57i
1
17
Växjö/Ti3.2.18
18.09
1
17
Ljungby/LT17.8.18
18.01i
1
17
IUSMUppsala25.2.18
18.01
6
17
UEMGyőr, HUN6.7.18
17.93
1
17
Göteborg/S9.6.18
17.93
1
Halmstad17.6.18
17.84i
1
17
Växjö20.1.18
17.56
12
17
Q
UEMGyőr, HUN5.7.18
17.47i
1
17
Göteborg/FH2.12.17
Visa/dölj alla resultat
17.35
1
17
Bålsta12.5.18
17.28i
1
Göteborg/FH17.12.17
17.24
1
17
Kungälv25.6.17
17.05
2
17
USMHuddinge5.8.18
16.88
2
16
VUSGöteborg/U1.7.17
16.86i
1
17
Göteborg/FH13.1.18
16.73
1
17
VUSGöteborg/U1.7.18
16.60
1
16
NC-yUppsala4.3.17
16.43
1
17
Göteborg/S3.6.18
16.29
7
16
EYOFGyőr, HUN27.7.17
16.29
4
17
vFINStockholm/S3.9.17
16.25i
1
16
Göteborg/FH3.12.16
15.48
2
16
NC-yFalun13.8.17
10-bästasnitt: 18.003
Kula (6.0 kg)
18.34i
1
19
Växjö/Ti1.2.20
18.01
1
19
Växjö/A10.5.19
17.84
1
19
V3NatKristiansand, NOR17.8.19
17.70
1
19
JSMGöteborg/S11.8.19
17.65
21
19
Q
JEM19Borås18.7.19
17.65i
1
19
IJSMGöteborg/FH1.3.20
17.44i
1
19
IJSMVäxjö24.2.19
17.42
1
19
Bottnaryd29.6.19
17.26
1
19
Göteborg/S8.6.19
17.11
1
19
Kungälv4.7.20
Visa/dölj alla resultat
16.64
1
19
Malmö18.6.19
14.82i
1
19
Växjö20.1.18
10-bästasnitt: 17.642

Total results in database: 84
By event:
80 m:3
100 m:2
200 m:1
300 m:3
Stav:7
Kula (4.0 kg):6
Kula (5.0 kg):23
Kula (6.0 kg):13
Kula:5
Diskus (1.0 kg):2
Diskus (1.5 kg):4
Diskus (1.75 kg):4
Diskus:2
Vikt (11.34 kg):3
Vikt :1
Slägga (4.0 kg):1
Slägga (6.0 kg):1
Slägga:3
80 m
Ute Visa/dölj alla resultat
2015
10.17
 2h2-15
Varberg
8.8
 +1.3
10.10w
 5
Varberg
8.8
 +2.2
2016
9.79
2h1-15
Göteborg/S
11.6
 +0.6
100 m
Ute Visa/dölj alla resultat
2017
11.72
6h1-16
Falun
11.8
 +1.0
11.51w
 4h5-16
Göteborg/U
1.7
 +2.3
200 m
Ute Visa/dölj alla resultat
2017
23.46
2D-16
Göteborg/U
2.7
 +1.6
300 m
Ute Visa/dölj alla resultat
2015
38.51
 2h3-14
Lidköping
6.9
 
2016
38.41
1-15
Göteborg/S
12.6
 
39.14
3h2-15
Vellinge
6.8
 
Stav
Ute Visa/dölj alla resultat
2014
2.80
 2-13
Uddevalla
13.9
 
2015
3.56
3-14
Lidköping
6.9
 
2016
3.40
 1-15
Göteborg/S
11.6
 
Inne Visa/dölj alla resultat
2015
3.00
 1-14
Göteborg/FH
22.11
 
2016
3.52
6
Göteborg/FH
27.2
 
3.52
2-15
Uddevalla
5.3
 
2017
3.35
 4-17
Göteborg/FH
5.2
 
Kula
Ute Visa/dölj alla resultat
2017
14.42
 1
Jönköping
25.5
 
2018
14.39
 Com
Göteborg/S
5.9
 
2019
15.57
1
Norrköping
2.6
 
2020
14.92
 5
Bottnaryd
27.6
 
Inne Visa/dölj alla resultat
2020
16.53
6
Växjö
22.2
 
Diskus
Ute Visa/dölj alla resultat
2018
42.26
Com
Göteborg/S-K
11.9
 
2019
41.26
 Com
Göteborg/S-K
25.9
 
Slägga
Ute Visa/dölj alla resultat
2016
25.01
 5
Linköping
14.5
 
2018
36.12
 Com
Göteborg/S-K
11.9
 
2019
41.61
Com
Göteborg/S-K
25.9
 
Vikt
Inne Visa/dölj alla resultat
2019
15.03
5-19
Växjö
23.2
 

Junior-ungdom
Kula (4.0 kg)
Ute Visa/dölj alla resultat
2015
12.72
 2-14
Lidköping
5.9
 
2016
16.37
1-15
Linköping
4.9
 
13.52
6-15
Vellinge
7.8
 
Inne Visa/dölj alla resultat
2015
11.77
 1-14
Göteborg/FH
22.11
 
2016
13.17
1-15
Göteborg/FH
20.12
 
13.17
4-15
Uddevalla
5.3
 
Kula (5.0 kg)
Ute Visa/dölj alla resultat
2017
17.24
 1-17
Kungälv
25.6
 
16.88
2-16
Göteborg/U
1.7
 
16.60
1-16
Uppsala
4.3
 
16.29
7-16
Győr, HUN
27.7
 
16.29
4-17
Stockholm/S
3.9
 
15.48
2-16
Falun
13.8
 
2018
18.62
1-17
Tampere, FIN
1.9
 
18.09
1-17
Ljungby/LT
17.8
 
18.01
6-17
Győr, HUN
6.7
 
17.93
1-17
Göteborg/S
9.6
 
17.93
1
Halmstad
17.6
 
17.56
12q-17
Győr, HUN
5.7
 
17.35
1-17
Bålsta
12.5
 
17.05
2-17
Huddinge
5.8
 
16.73
1-17
Göteborg/U
1.7
 
16.43
1-17
Göteborg/S
3.6
 
Inne Visa/dölj alla resultat
2017
16.25
 1-16
Göteborg/FH
3.12
 
2018
18.57
1-17
Växjö/Ti
3.2
 
18.01
1-17
Uppsala
25.2
 
17.84
1-17
Växjö
20.1
 
17.47
1-17
Göteborg/FH
2.12
 
17.28
1
Göteborg/FH
17.12
 
16.86
1-17
Göteborg/FH
13.1
 
Kula (6.0 kg)
Ute Visa/dölj alla resultat
2019
18.01
1-19
Växjö/A
10.5
 
17.84
1-19
Kristiansand, NOR
17.8
 
17.70
1 -19
Göteborg/S
11.8
 
17.65
21q-19
Borås
18.7
 
17.42
1-19
Bottnaryd
29.6
 
17.26
1-19
Göteborg/S
8.6
 
16.64
1-19
Malmö
18.6
 
2020
17.11
 1-19
Kungälv
4.7
 
Inne Visa/dölj alla resultat
2018
14.82
 1-19
Växjö
20.1
 
2019
17.44
 1-19
Växjö
24.2
 
2020
18.34
1-19
Växjö/Ti
1.2
 
17.65
1-19
Göteborg/FH
1.3
 
Diskus (1.0 kg)
Ute Visa/dölj alla resultat
2015
34.66
 6-15
Helsingborg
11.7
 
2016
51.61
1-15
Vellinge
6.8
 
Diskus (1.5 kg)
Ute Visa/dölj alla resultat
2017
48.78
 1-16
Falun
12.8
 
2018
49.94
1-17
Bålsta
12.5
 
42.48
6 -17
Huddinge
3.8
 
Inne Visa/dölj alla resultat
2018
38.30
10-17
Växjö/Ti
3.2
 
Diskus (1.75 kg)
Ute Visa/dölj alla resultat
2019
50.24
4 -19
Göteborg/S
10.8
 
48.98
2-19
Göteborg/U
30.6
 
48.37
4-19
Bottnaryd
29.6
 
Inne Visa/dölj alla resultat
2020
44.55
4-19
Växjö/Ti
1.2
 
Slägga (4.0 kg)
Ute Visa/dölj alla resultat
2015
23.61
3-14
Göteborg/S
7.6
 
Slägga (6.0 kg)
Ute Visa/dölj alla resultat
2019
45.20
2-19
Göteborg/S-K
4.5
 
Vikt (11.34 kg)
Ute Visa/dölj alla resultat
2017
14.60
5-16
Uppsala
5.3
 
Inne Visa/dölj alla resultat
2018
17.46
4-17
Uppsala
24.2
 
15.22
2
Göteborg/FH
13.1
 
Inne
Kula
ISM 2020 6
16.53

Junior-ungdom
Ute
Kula (5.0 kg)
USM 2018 2
17
17.05
Kula (6.0 kg)
JSM 2019 1
19
17.70
Diskus (1.5 kg)
USM 2018 6
17
42.48
Diskus (1.75 kg)
JSM 2019 4
19
50.24
Inne
Kula (5.0 kg)
IUSM 2018 1
17
18.01
Kula (6.0 kg)
IJSM 2019 1
19
17.44
IJSM 2020 1
19
17.65
Vikt (11.34 kg)
IUSM 2018 4
17
17.46
Vikt
IJSM 2019 5
19
15.03

Junior-ungdom
Ute
Kula (5.0 kg)
EYOF 2017 7
16
16.29
UEM 2018 6
17
18.01
12
17
Q
17.56
Kula (6.0 kg)
JEM19 2019 21
21
19
Q
17.65