24.10
17.10
4.9
21.11
10.10
26.9
17.8
25.8
26.8
6.9
19.8
8.9
9.10
31.8
23.8
4.9
20.11
21.11
13.11
10.10
16.10
21.11
19.9
20‐21.11
18.9
21.11
24.8
19.8
16.10
4.9
13.11
6.11
12‐14.11
6.11
3.10
2.10
8.10
12.9
19.8
28.8
30.10
19.9
12.9
7.11
7.11
24.10
16.10
19.9
7.11
19.9
10.10
18.9
16.10
5‐7.11
6.11
7.11
2.10
24.10
30.10
22.10
11.9
19.9
3.10
16.10
17.10
30.10
3.10
26.9
10.10
21.8
9.10
9.10
5.8
17.10
13.9
31.10
11.9
2.10
16.10
2.10
16.10
23.10
28.8
22.10
22.10
18.8
22.10
17.10
26.8
21‐22.9
24.10
24.10
9.10
9.10
3.10
3.10
23.10
4.9
16.10
17.10
Arrangör: Sävedalens AIK


select distinct results21.*, 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, results21.Ind AS Indiiy, results21.ID AS ID, results21.ID AS IDI, Events.TF AS type, results21.eventname AS en2, results21.Country AS RealCountry, IF(EndDate Is Null,'',CONCAT(DAYOFMONTH(results21.Date),' ')) AS Datti1, IF(EndDate Is Null,'',substring(Monthname(results21.Date),1,3)) AS Datti2, Round.Roundname, Events.Eventname, Pos.PosName, Sex.Sexi, CASE WHEN results21.AGO IN (12,15) THEN b.AGName ELSE a.AGName END AS AGName, CASE WHEN results21.AGO IN (12,15) THEN b.AGO ELSE a.AGO END AS agoo, `2010`.irrelagularities.Irrname, CASE WHEN results21.Sex = 1 THEN `2010`.menwl.BB ELSE `2010`.womenwl.BB END AS WL, CASE WHEN results21.Sex = 1 THEN `2010`.menwl.Standing ELSE `2010`.womenwl.Standing END AS Standingi, CASE WHEN results21.Date<=Club10end THEN Club10 WHEN results21.Date<=Club9end THEN Club9 WHEN results21.Date<=Club8end THEN Club8 WHEN results21.Date<=Club7end THEN Club7 WHEN results21.Date<=Club6end THEN Club6 WHEN results21.Date<=Club5end THEN Club5 WHEN results21.Date<=Club4end THEN Club4 WHEN results21.Date<=Club3end THEN Club3 WHEN results21.Date<=Club2end THEN Club2 ELSE sweclubsat.Club END AS RealClub, posswe.PosName AS posswe, combinedmen.eventno AS combM, combinedwomen.eventno AS combW FROM results21 LEFT JOIN `2010`.sweclubsat ON sweclubsat.ID=results21.ID AND CASE WHEN results21.Sex=1 and (results21.secondarypos not rlike ('K|F') or results21.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(results21.EventN AS UNSIGNED) = Events.Orderi LEFT JOIN Sex ON results21.Sex = Sex.Sex LEFT JOIN Comp ON results21.CID = Comp.CID LEFT JOIN AG as a ON results21.AGO = a.AGO LEFT JOIN AG as b ON results21.Points = b.AgeGroup LEFT OUTER JOIN Pos ON results21.PosOrderg = Pos.Orderi LEFT OUTER JOIN Round ON results21.Round = Round.Ro LEFT JOIN `2010`.irrelagularities ON `2010`.irrelagularities.Irr = results21.Irr LEFT JOIN `2010`.menwl ON `2010`.menwl.iid = results21.iid LEFT JOIN `2010`.womenwl ON `2010`.womenwl.iid = results21.iid LEFT JOIN world.countries ON results21.Country=countries.Country LEFT JOIN results.posswe ON results21.PosOrderg = posswe.Orderi LEFT JOIN `2010`.combinedmen ON results21.IID=combinedmen.parentid AND results21.Sex=1 LEFT JOIN `2010`.combinedwomen ON results21.IID=combinedwomen.parentid AND results21.Sex=2 LEFT JOIN `2010`.womenpbestsweden ON results21.iid=womenpbestsweden.iid AND (results21.Sex=2 OR results21.secondarypos rlike ('K|F')) AND womenpbestsweden.Roundi IS NULL LEFT JOIN `2010`.womensbestsweden ON results21.iid=womensbestsweden.iid AND (results21.Sex=2 OR results21.secondarypos rlike ('K|F')) AND womensbestsweden.Roundi IS NULL WHERE results21.CID= 12997783 AND `2010`.womenwl.Roundi IS NULL AND `2010`.menwl.Roundi IS NULL ORDER BY Sex, CASE WHEN results21.AGO=15 THEN COALESCE(agoo,0)+100000 ELSE agoo END, combM, combW, RealEventN2, RealEventN, CASE WHEN results21.AGO=12 THEN 999999 ELSE results21.AGO END, results21.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 10 km     


Final A

Final

1Jonatan Fridolfsson
30:43
Sävedalens AIK
30:43
  
Ej kontrollmätt bana
2Linus Hultegård
33:37
Sävedalens AIK
33:37
  
Ej kontrollmätt bana
3Per Rosén
35:07
  
Ej kontrollmätt bana
4Jonatan JungmalmHälle IF
35:25
  
Ej kontrollmätt bana
5Martin Henricson
36:09
Ulricehamns IF
36:09
  
Ej kontrollmätt bana
6Philip Persson
Philip Persson 95, Gbg-Majorna
36:57
Göteborg-Majorna OK
36:57
  
Ej kontrollmätt bana
7Lars Thorén
Lars Thorén 78, Sävedalen
37:08
Sävedalens AIK
37:08
  
Ej kontrollmätt bana
8Magnus Hultquist
37:56
Sävedalens AIK
37:56
  
Ej kontrollmätt bana
9Mikael LipschützHälle IF
38:34
  
Ej kontrollmätt bana
10Eric Bergstrand
38:56
  
Ej kontrollmätt bana
M 4 km terräng     


Final A

Final

1Nicklas GunnarssonÖrgryte IS
14:41
  
2Alfons Råwall
15:07
Sävedalens AIK
15:07
  
3Melker Tillenius
15:21
Sävedalens AIK
15:21
  
4Jimmy Nord
Jimmy Nord 06, Alingsås
15:47
Alingsås IF
15:47
  
5Dimitrios KiriazidisMajornas IK
16:02
  
6Kristoffer SidebyUllevi FK
16:13
  
7Jörgen Jonsson
16:23
  
8Marcus Gianneschi
18:43
  
9Gunnar Bengtsson
19:25
Majornas IK
19:25
  
10Anders Eriksson
19:48
Majornas IK
19:48
  
P13 2 km terräng     


Final A

Final

1Wille Hedström
8:34
Sävedalens AIK
8:34
  
2Oskar Holmes
Oskar Holmes 09, Triathlon Väst
8:34
Triathlon Väst
8:34
  
3Alfred Wendt
Alfred Wendt 09, Sävedalen
8:37
Sävedalens AIK
8:37
  
4Eliah Pettersson
8:47
Sävedalens AIK
8:47
  
5Gaston Wallin
Gaston Wallin 09, Sävedalen
8:49
Sävedalens AIK
8:49
  
Kvinnor
K 10 km     


Final A

Final

1Malin Strand
Malin Strand 93, Sävedalen
40:05
Sävedalens AIK
40:05
  
Ej kontrollmätt bana
2Johanna JohanssonIF Rigor
43:54
  
Ej kontrollmätt bana
3Vera Schultz
44:31
  
Ej kontrollmätt bana
4Sara Costa
45:46
  
Ej kontrollmätt bana
5Ulla Löfqvist
47:11
  
Ej kontrollmätt bana
6Hanna Locking
Hanna Locking 90, Gbg-Majorna
48:56
Göteborg-Majorna OK
48:56
  
Ej kontrollmätt bana
7Kristina Hamberg
50:30
Sävedalens AIK
50:30
  
Ej kontrollmätt bana
8Anna Pennbrant
51:18
  
Ej kontrollmätt bana
9Malin Dahlberg
51:47
  
Ej kontrollmätt bana
10Monika Forsberg
51:53
Runacademy IF
51:53
  
Ej kontrollmätt bana
K 4 km terräng     


Final A

Final

1Paulina Hultberg
15:54
Alingsås IF
15:54
  
2Desiree LilliehöökÖrgryte IS
16:14
  
3Alma Svantesson
16:33
Mölndals AIK
16:33
  
4Julia Törnblad
16:48
Mölndals AIK
16:48
  
5Lova Möller
Lova Möller 05, IFK Göteborg
17:47
IFK Göteborg
17:47
  
6Lovisa Emanuelsson
18:41
IFK Göteborg
18:41
  
7Karin Stagemyr
22:03
  
8Terese Amundin
23:17
Sävedalens AIK
23:17
  
9Ulla Littenheim
Ulla Littenheim 47, Uddevalla IS
24:43
Uddevalla IS
24:43
  
10Emelie Grantén
31:28
  
F15 2 km terräng     


Final A

Final

1Ella Pettersson
7:51
Sävedalens AIK
7:51
  
2Elsa Svantesson
8:06
Mölndals AIK
8:06
  
3Cornelia Ullsten
8:47
Mölndals AIK
8:47
  
4Siri Provci
Siri Provci 07, IFK Göteborg
8:56
IFK Göteborg
8:56
  
5Moa Stagemyr
10:31
Mölndals AIK
10:31
  
F13 2 km terräng     


Final A

Final

1Athina Ringfeldt
Athina Ringfeldt 09, IFK Göteborg
8:49
IFK Göteborg
8:49
  
2Miranda Edborg
8:55
Sävedalens AIK
8:55
  
3Elin Stagemyr
9:09
Mölndals AIK
9:09
  
4Vera Lidén
Vera Lidén 08, Sävedalen
9:18
Sävedalens AIK
9:18
  
5Nellie Redvik
10:07