Friidrottsstatistik

Senaste resultaten

8.8	Norrtälje Norrtälje Stadslopp
26.11	Öllsjö Kasttävling
20.11	Falkenberg Falkenbergs Höstmil
27.11	Vällingby Uttagning Terräng-EM
27.11	Varberg Julbockspelen
27.11	Linköping Folkungaspelen
27.11	Örebro Triumfglass-spelen
24.10	Valö Castorama
17.10	Valö Castorama
4.9	Hässleholm Hässleholmsloppet
21.11	Växjö Klubbmästerskap
10.10	Valö Kasttävling
26.9	Valö Kasttävling
17.8	Jönköping Blodomloppet
25.8	Västerås Blodomloppet
26.8	Karlstad Blodomloppet
6.9	Timrå Blodomloppet
19.8	Borlänge Blodomloppet
8.9	Växjö Blodomloppet
9.10	Malmö Blodomloppet
31.8	Halmstad Blodomloppet
23.8	Östersund Blodomloppet
4.9	Mjölby Mjölby Stadslopp
20.11	Örebro Vinterspelen
21.11	Öllsjö Resultattävling
13.11	Värnamo Vintermaraton
10.10	Stockholm Stockholm Minimarathon
16.10	Stockholm Tjurruset
21.11	Bollnäs Lagtävling 12-17 år
19.9	Stockholm STHLM Trail Run
20‐21.11	Göteborg/FH Göteborgs Adventsspel
18.9	Örebro Bergslagsleden Ultra
21.11	Huddinge Första chansen
24.8	Simrishamn Kretsmästerskap
19.8	Stockholm STHLM 10
16.10	Stockholm Kalvruset
4.9	Göteborg Fredsloppet
13.11	Uppsala Kasttävling
6.11	Västerås/Ap Halloweenkastet
12‐14.11	Västerås IVSM
6.11	Stockholm Höstrusket
3.10	Enskede Hammarbys ungdoms-castorama 2
2.10	Enskede Hammarbys ungdoms-castorama 1
8.10	Stockholm ASICS Stockholm High Five
12.9	Uddevalla Lilla Bohusspelen
19.8	Stockholm STHLM Junior Run
28.8	Stockholm ASICS Premiärmilen
30.10	Värnamo WärnamoMilen
19.9	Sölvesborg Ryssberget Trail
12.9	Norrköping Castorama
7.11	Falun Resultattävling
7.11	Falun IVDM Dalarna
24.10	Falun IVDM Dalarna
16.10	Sävedalen Sävedalsloppet
19.9	Olofström Kasttävling
7.11	Tullinge Långa Tullinge-Tumbaloppet
19.9	Olofström Castorama
10.10	Valö Castorama
18.9	Finspång OMT Finspångs Stadslopp
16.10	Vretstorp DM-UDM-VDM Terräng
5‐7.11	Sävedalen Sävedalen Inomhus
6.11	Sollentuna Rekordjakten
7.11	Tullinge NM-JNM Terräng
2.10	Umeå DM-UDM-VDM Terräng 4 km
24.10	Huddinge Castorama
30.10	Umeå KM Terräng
22.10	Höganäs SM-löpet
11.9	Nora VSM Halvmaraton
19.9	Hallsberg Tarstaborgsrundan
3.10	Örebro Hostruset 5 km väg
16.10	Varberg Varberg Halvmarathon
17.10	Ystad DM-JDM-VDM 10 km väg
30.10	Helsingborg GGP 1 timme
3.10	Valö Castorama
26.9	Valö Castorama
10.10	Falun Resultattävling
21.8	Vintrosa Vintrosaloppet
9.10	Göteborg VSM Maraton
9.10	Göteborg Göteborg Marathon
5.8	Katrineholm Höjdtävling
17.10	Falun Resultattävling
13.9	Uppsala Hopptävling
31.10	Falun Resultattävling
11.9	Vänersborg Skräcklanmaran
2.10	Bromma Tolvanloppet
16.10	Södertälje Täljemilen
2.10	Uddevalla USK-loppet
16.10	Danderyd Stavtävling
23.10	Sätra KM inomhus
28.8	Skövde Hagenloppet
22.10	Bottnaryd Kastfemkamp
22.10	Bottnaryd Kasttävling
18.8	Vaxholm Strömmingsloppet
22.10	Bottnaryd Castorama
17.10	Sandviken Kasttävling
26.8	Mjölby Mjölbyfemman
21‐22.9	Sollentuna DM-JDM-UDM-VDM Terräng
24.10	Oskarshamn Havslättsmarodören
24.10	Henån Kultävling
9.10	Nacka Hellasloppet

Resultat: , Helsingborg 8.7.17

Tävlande: 65 (27+38) Starter: 77 (33+44)

select distinct results17.*, womenpbestsweden.BB AS PBwomen, womensbestsweden.BB AS SBwomen, CASE WHEN EventN IN (910, 193, 9998, 9999) THEN EventN+RealMetres/100 ELSE EventN END AS RealEventN, RealEventN AS RealEventN2, '' AS SM, countries.Countryfull, Events.Event AS eventry, results17.Ind AS Indiiy, results17.ID AS ID, results17.ID AS IDI, Events.TF AS type, results17.eventname AS en2, results17.Country AS RealCountry, IF(EndDate Is Null,'',CONCAT(DAYOFMONTH(results17.Date),' ')) AS Datti1, IF(EndDate Is Null,'',substring(Monthname(results17.Date),1,3)) AS Datti2, Round.Roundname, Events.Eventname, Pos.PosName, Sex.Sexi, CASE WHEN results17.AGO IN (12,15) THEN b.AGName ELSE a.AGName END AS AGName, CASE WHEN results17.AGO IN (12,15) THEN b.AGO ELSE a.AGO END AS agoo, `2010`.irrelagularities.Irrname, CASE WHEN results17.Sex = 1 THEN `2010`.menwl.BB ELSE `2010`.womenwl.BB END AS WL, CASE WHEN results17.Sex = 1 THEN `2010`.menwl.Standing ELSE `2010`.womenwl.Standing END AS Standingi, CASE WHEN results17.Date<=Club10end THEN Club10 WHEN results17.Date<=Club9end THEN Club9 WHEN results17.Date<=Club8end THEN Club8 WHEN results17.Date<=Club7end THEN Club7 WHEN results17.Date<=Club6end THEN Club6 WHEN results17.Date<=Club5end THEN Club5 WHEN results17.Date<=Club4end THEN Club4 WHEN results17.Date<=Club3end THEN Club3 WHEN results17.Date<=Club2end THEN Club2 ELSE sweclubsat.Club END AS RealClub, posswe.PosName AS posswe, combinedmen.eventno AS combM, combinedwomen.eventno AS combW FROM results17 LEFT JOIN `2010`.sweclubsat ON sweclubsat.ID=results17.ID AND CASE WHEN results17.Sex=1 and (results17.secondarypos not rlike ('K|F') or results17.secondarypos is null) THEN sweclubsat.gender='M' ELSE sweclubsat.gender='W' END LEFT JOIN (SELECT events.*, eventsext.Orderi AS RealEventN FROM events LEFT JOIN `2010`.eventsext ON events.Event=eventsext.Event) AS Events ON CAST(results17.EventN AS UNSIGNED) = Events.Orderi LEFT JOIN Sex ON results17.Sex = Sex.Sex LEFT JOIN Comp ON results17.CID = Comp.CID LEFT JOIN AG as a ON results17.AGO = a.AGO LEFT JOIN AG as b ON results17.Points = b.AgeGroup LEFT OUTER JOIN Pos ON results17.PosOrderg = Pos.Orderi LEFT OUTER JOIN Round ON results17.Round = Round.Ro LEFT JOIN `2010`.irrelagularities ON `2010`.irrelagularities.Irr = results17.Irr LEFT JOIN `2010`.menwl ON `2010`.menwl.iid = results17.iid LEFT JOIN `2010`.womenwl ON `2010`.womenwl.iid = results17.iid LEFT JOIN world.countries ON results17.Country=countries.Country LEFT JOIN results.posswe ON results17.PosOrderg = posswe.Orderi LEFT JOIN `2010`.combinedmen ON results17.IID=combinedmen.parentid AND results17.Sex=1 LEFT JOIN `2010`.combinedwomen ON results17.IID=combinedwomen.parentid AND results17.Sex=2 LEFT JOIN `2010`.womenpbestsweden ON results17.iid=womenpbestsweden.iid AND (results17.Sex=2 OR results17.secondarypos rlike ('K|F')) AND womenpbestsweden.Roundi IS NULL LEFT JOIN `2010`.womensbestsweden ON results17.iid=womensbestsweden.iid AND (results17.Sex=2 OR results17.secondarypos rlike ('K|F')) AND womensbestsweden.Roundi IS NULL WHERE results17.CID= 12945777 AND `2010`.womenwl.Roundi IS NULL AND `2010`.menwl.Roundi IS NULL ORDER BY Sex, CASE WHEN results17.AGO=15 THEN COALESCE(agoo,0)+100000 ELSE agoo END, combM, combW, RealEventN2, RealEventN, CASE WHEN results17.AGO=12 THEN 999999 ELSE results17.AGO END, results17.Round, Posorderg, CASE WHEN Remarks Is Not Null THEN CASE WHEN Pos1>0 THEN 2 ELSE 3 END ELSE CASE WHEN Pos1>0 THEN 0 ELSE 1 END END, CASE WHEN Pos1 IS NOT NULL THEN Pos1 ELSE 999999 END, SortResult, RealMetres DESC

Män
M 200 m Vind: +4.4 Final A Final			Vind: +4.4
4	Charles Mårelid Charles Mårelid 99, Örgryte 22.49w	99	Örgryte IS	22.49w
6	Johan Brasch Johan Brasch 98, Wärnamo 22.71w	98	Wärnamo SK	22.71w
7	Filip La Fleur Filip La Fleur 97, IFK Växjö 22.87w	97	IFK Växjö	22.87w
8	Johan Carlson Johan Carlson 99, Trollhättan FIK 23.11w	99	Trollhättan FIK	23.11w
Heat 2 Vind: +1.1			Vind: +1.1
2	Filip La Fleur Filip La Fleur 97, IFK Växjö 23.03	97	IFK Växjö	23.03	=SB
M 300 m Final A Final
1	Vilmer Elovsson Vilmer Elovsson 02, Mölndal 36.27	02	Mölndals AIK	36.27	=PB
3	Erik Ljungberg Bergelin Erik Ljungberg Bergelin 02, Höör 38.01	02	Höörs IS	38.01	=PB
6	Isac Engman Isac Engman 02, Malmö 39.16	02	Malmö AI	39.16	=PB
M 1500 m Final A Final
1	Omar Nuur Omar Nuur 01, IFK Växjö 4:01.94	01	IFK Växjö	4:01.94	=PB
2	Ken Slättengren Ken Slättengren 95, Högby 4:03.61	95	Högby IF	4:03.61	=SB
6	Isak Bjeregaard Isak Bjeregaard 81, Björnstorp 4:08.65	81	Björnstorps IF	4:08.65	=PB
Final B
2	Carl Jälknäs Carl Jälknäs 00, Trollhättan FIK 4:21.18	00	Trollhättan FIK	4:21.18	=PB
3	David Cannmo David Cannmo 01, Trollhättan FIK 4:24.00	01	Trollhättan FIK	4:24.00	=PB
M Tresteg Final A Final
	Lukas Medina Sørensen Lukas Medina Sørensen 03, DEN 11.86	03	DEN	11.86	+0.0 =PB
P19 110 m häck (99.1 cm) Vind: +0.3 Final A Final			Vind: +0.3
5	Simon Martinsson Simon Martinsson 99, Lomma 16.30	99	Lomma FIK	16.30	=PB
6	Viktor Kjellsson Viktor Kjellsson 98, IFK Växjö 16.31	98	IFK Växjö	16.31	=PB
P17 200 m Vind: +3.5 Final A Final			Vind: +3.5
5	Johan Claeson Johan Claeson 01, Tranås 23.19w	01	Tranås AIF	23.19w
6	Filip Engström Filip Engström 01, AIK 23.80w	01	AIK	23.80w
Heat 1 Vind: +1.1			Vind: +1.1
3	Filip Engström Filip Engström 01, AIK 23.92	01	AIK	23.92	=PB
Heat 2 Vind: +0.5			Vind: +0.5
4	Johan Claeson Johan Claeson 01, Tranås 23.30	01	Tranås AIF	23.30	=PB
P17 110 m häck (91.4 cm, 8.9 m) Vind: +1.6 Final A Final			Vind: +1.6
4	Victor Gustafsson Victor Gustafsson 01, Linköpings GIF 15.06	01	Linköpings GIF	15.06	=PB
5	Philip Ryding Philip Ryding 01, Kville 15.86	01	IF Kville	15.86	=PB
6	Max Rosquist-Larsson Max Rosquist-Larsson 01, Malmö 16.01	01	Malmö AI	16.01	=PB
P17 Längd Final A Final
3	Max Rosquist-Larsson Max Rosquist-Larsson 01, Malmö 6.26w	01	Malmö AI	6.26w	+2.5
7	Philip Ryding Philip Ryding 01, Kville 5.93	01	IF Kville	5.93	+1.1 =PB
9	Isak Hejdenberg Isak Hejdenberg 01, Örgryte 5.84	01	Örgryte IS	5.84	+0.7 =PB
P17 Kula (5.0 kg) Final A Final
4	William Lanndalen William Lanndalen 01, Ymer 12.91	01	IK Ymer	12.91	=PB
8	Caleb Conable Caleb Conable 01, Malmö 10.35	01	Malmö AI	10.35	=PB
P17 Spjut (700 g) Final A Final
8	Tom Berensson Tom Berensson 01, Kville 39.90	01	IF Kville	39.90	=PB
P15 80 m häck (83.8 cm) Vind: +1.9 Final A Final			Vind: +1.9
1	Vilmer Elovsson Vilmer Elovsson 02, Mölndal 11.01	02	Mölndals AIK	11.01	=PB
4	Edvin Assarsson Edvin Assarsson 04, Eslövs AI 11.75	04	Eslövs AI	11.75	=PB
Heat 1 Vind: +0.4			Vind: +0.4
1	Marcus Blixt Marcus Blixt 02, Mölndal 11.53	02	Mölndals AIK	11.53	=PB
P14 Spjut (600 g) Final A Final
4	Filip Aasa Filip Aasa 03, Habo 35.28	03	Habo FIF-04	35.28	=PB
Kvinnor
K 200 m Vind: +1.9 Final A Final			Vind: +1.9
4	Marie Sönnerfors Marie Sönnerfors 93, Spårvägen 25.27	93	Spårvägens FK	25.27	=SB
5	Vanja Blomberg Vanja Blomberg 98, Klippan 25.51	98	Klippans FK	25.51	=SB
Heat 1 Vind: +1.5			Vind: +1.5
2	Frida Grindheim Frida Grindheim 96, Malmö 26.03	96	Malmö AI	26.03	=SB
4	Moa Kjellander Moa Kjellander 99, Åhus 26.53	99	Åhus FIK	26.53	=SB
Heat 3 Vind: +1.5			Vind: +1.5
4	Sara Liljegren Sara Liljegren 81, IS Göta 27.44	81	IS Göta	27.44	=PB
K 300 m Final A Final
4	Tindra Palmér Tindra Palmér 02, Helsingborg 44.98	02	IFK Helsingborg	44.98	=PB
K 1500 m Final A Final
1	Annika Faager Annika Faager 76, Björnstorp 4:50.17	76	Björnstorps IF	4:50.17	=SB
3	Amanda Ivehammar Amanda Ivehammar 01, Linköpings GIF 4:52.82	01	Linköpings GIF	4:52.82	=SB
4	Ebba Berglin Ebba Berglin 01, KA2 4:55.18	01	KA 2 IF	4:55.18	=PB
6	Freya Orban Freya Orban 97, Lund 5:12.46	97	IFK Lund	5:12.46	=SB
K 80 m häck (76.2 cm, 8 m) Vind: +1.7 Final A Final			Vind: +1.7
	Ida Boe Rasmussen Ida Boe Rasmussen 03, DEN 11.20	03	DEN	11.20	=PB DUR-14
	Ida Boe Rasmussen Ida Boe Rasmussen 03, DEN 11.54	03	DEN	11.54	= DUR-14
Final B Vind: +3.3			Vind: +3.3
1	Chanelle Lindvall Chanelle Lindvall 03, Malmö 12.35w	03	Malmö AI	12.35w
2	Anna Back Nilsson Anna Back Nilsson 02, Leksands FIK 12.36w	02	Leksands FIK	12.36w
4	Tilda Lilja Tilda Lilja 03, Helsingborg 12.45w	03	IFK Helsingborg	12.45w
K Stav Final A Final
1	Filippa Miller Filippa Miller 99, Hovslätt 3.58	99	Hovslätts IK	3.58	=PB
	Emma Giovanna Vitale Emma Giovanna Vitale 93, DEN 2.60	93	DEN	2.60	=
K Längd Final A Final
	Ida Boe Rasmussen Ida Boe Rasmussen 03, DEN 5.43	03	DEN	5.43	+1.6 =
K Tresteg Final A Final
1	Ellen Blomgren Ellen Blomgren 01, KA2 11.14w	01	KA 2 IF	11.14w	+2.3
1	Nike Thanner Nike Thanner 01, Örgryte 10.11w	01	Örgryte IS	10.11w	+2.8
K Kula Final A Final
	Thea Jensen Thea Jensen 99, DEN 14.05	99	DEN	14.05	=PB DUR-18
K Spjut Final A Final
5	Viktoria Johansson Viktoria Johansson 88, Klippan 32.31	88	Klippans FK	32.31	=SB
F19 Diskus Final A Final
1	Nicole Ridegård Nicole Ridegård 99, Helsingborg 38.63	99	IFK Helsingborg	38.63	=PB
F17 200 m Vind: +2.9 Final A Final			Vind: +2.9
2	Felicia Boqvist Felicia Boqvist 01, Rydö 25.73w	01	Rydö ASK	25.73w
Heat 3 Vind: +0.8			Vind: +0.8
3	Hannah Hansson Hannah Hansson 00, Åhus 27.49	00	Åhus FIK	27.49	=PB
F17 100 m häck (76.2 cm, 8.5 m) Vind: +1.4 Final A Final			Vind: +1.4
7	Ella Darrell Ella Darrell 01, Lerum 15.12	01	IK Lerum FI	15.12	=PB
Heat 1 Vind: +0.7			Vind: +0.7
4	Hilda Gyldén Hilda Gyldén 01, Kville 16.44	01	IF Kville	16.44	=PB
Heat 2 Vind: -0.1			Vind: -0.1
5	Sofia Overgaard Sofia Overgaard 01, Kville 15.84	01	IF Kville	15.84	=PB
F17 Höjd Final A Final
1	Ellen White Ellen White 01, Lund 1.66	01	IFK Lund	1.66	=PB
F17 Diskus Final A Final
4	Emma Ekberg Emma Ekberg 01, Klippan 25.25	01	Klippans FK	25.25	=PB
F15 80 m häck (76.2 cm, 8 m)
Heat 1 Vind: +1.8			Vind: +1.8
5	Clara Johansson Clara Johansson 02, KA2 13.08	02	KA 2 IF	13.08	=PB
Heat 3 Vind: +1.3			Vind: +1.3
3	Tilda Lilja Tilda Lilja 03, Helsingborg 12.63	03	IFK Helsingborg	12.63	=PB
Heat 4 Vind: +1.6			Vind: +1.6
2	Chanelle Lindvall Chanelle Lindvall 03, Malmö 12.50	03	Malmö AI	12.50	=PB
3	Anna Back Nilsson Anna Back Nilsson 02, Leksands FIK 12.53	02	Leksands FIK	12.53	=SB
Heat 5 Vind: +3.1			Vind: +3.1
3	Wilma Dahlberg Wilma Dahlberg 03, Malmö 12.77w	03	Malmö AI	12.77w
F15 Längd Final A Final
1	Tova Wickell Tova Wickell 02, KA2 5.28	02	KA 2 IF	5.28	+1.0 =PB
3	Cajsa Augustsson Cajsa Augustsson 02, Ymer 5.20	02	IK Ymer	5.20	+0.9 =SB
9	Hanna Persson Hanna Persson 02, Helsingborg 4.96	02	IFK Helsingborg	4.96	+0.0 =PB
F15 Kula (3.0 kg) Final A Final
4	Emilia Münchmeyer Emilia Münchmeyer 02, Helsingborg 10.55	02	IFK Helsingborg	10.55	=PB
6	Hanna Didricksson Hanna Didricksson 02, Malmö 10.12	02	Malmö AI	10.12	=PB
F14 Längd Final A Final
5	Thea Holmén Thea Holmén 03, Villstad 5.32	03	Villstad GIF	5.32	+1.8 =PB
6	Thea Hammarström Thea Hammarström 03, Villstad 5.14	03	Villstad GIF	5.14	+1.2 =PB
7	Tilda Lilja Tilda Lilja 03, Helsingborg 5.07	03	IFK Helsingborg	5.07	+0.0 =PB
F14 Spjut (500 g) Final A Final
3	Emma Svensson Emma Svensson 03, KA2 33.46	03	KA 2 IF	33.46	=PB