8.8
26.11
20.11
27.11
27.11
27.11
27.11
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
Arena: Slottsskogsvallen   Arrangör: Ullevi FK
Tävlande: 52 (29+23)   Starter: 55 (32+23)


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


Final A

Final

1Simon Wiklund
2.07
IK Wilske
2.07
  
2Isak Persson
2.07
Örgryte IS
2.07
=PB
  
3Joakim Wadstein
Joakim Wadstein 00, Tjalve IF Norrköping
2.03
Tjalve IF Norrköping
2.03
=PB
  
4Fredrik Sangberg
1.91
Örgryte IS
1.91
SB
  
5Sören Simonson PauliUllevi FK
1.81
  
6Philip Bayer
1.76
Mölndals AIK
1.76
  
7Hugo Tilldal
1.61
Ullevi FK
1.61
  
1.55
2.07
1.61
2.10
1.66
1.71
1.76
1.81
1.86
1.91
1.95
1.99
2.03
Wiklund-
o
-
xxx
-
-
-
-
-
o
o
o
o
Persson-
xo
-
xxx
-
-
-
o
o
o
o
o
o
Wadstein-
xxx
-
-
-
-
o
o
o
o
xxo
xo
Sangberg-
-
-
-
-
o
-
o
xxx


Simonson Pauli-
-
o
o
o
xo
xxx




Bayer-
-
-
o
o
xxx





Tilldalo
xo
xxx








M Stav     


Final A

Final

1Robin JacobssonUllevi FK
4.90
PB
  
Sten HagströmÖrgryte IS
NH
  
Patric RodåsUllevi FK
NH
  
3.804.004.604.804.905.00
Jacobsson--xxooxxoxxx
Hagströmxxx
Rodås-xxx
M Längd     


Final A

Final

1Tobias Carlryd
7.25w
Örgryte IS
7.25w
+2.3
  
2Victor Hering
7.18
Ullevi FK
7.18
+2.0 PB
  
3Jonatan Hirsh
7.14
Örgryte IS
7.14
0.0
  
4Jimmy HellströmUllevi FK
6.88
+1.7 PB
  
5Erik Olsson
6.60
Örgryte IS
6.60
+1.3
  
6David Ulstein
6.42w
Mölndals AIK
6.42w
+2.5
  
7Herman ForsbergUllevi FK
6.29
+1.2 =PB
  
8Fredrik Grund
6.28w
IF Kville
6.28w
+2.2
  
9Erik DahlqvistIK Orient
6.21
+2.0 SB
  
10Johannes LundqvistUllevi FK
6.03w
+3.0
  
11Jonas Gustén
5.21
Ullevi FK
5.21
+1.9
  
Carlryd4.74
-1.1
6.70
+1.6
x7.02
-0.2
5.01
+2.0
7.25w
+2.3
Hering6.80
+1.2
6.83w
+2.3
x7.18
+2.0
7.02w
+2.3
7.05w
+2.6
Hirsh6.96w
+2.7
7.06w
+3.6
7.12
+1.3
6.81
+0.7
7.14
0.0
x
Hellström6.56
+1.2
6.50
+1.3
6.42
+2.0
6.62
+0.6
6.88
+1.7
6.88
+1.7
Olssonx6.39w
+2.9
6.60
+1.3
6.60
+1.7
Ulstein6.33
+1.0
6.37w
+3.5
xx6.36
+1.7
6.42w
+2.5
Forsbergx6.23w
+3.0
6.24
+1.3
6.23
+0.8
6.29
+1.2
x
Grund6.01
+1.6
6.12w
+3.4
6.28w
+2.2
4.43
+1.4
6.06w
+2.5
6.03
-0.9
Dahlqvist6.21
+2.0
xx
Lundqvist5.84
+1.8
6.03w
+3.0
5.28
0.0
Gusténx5.21
+1.9
x
M Tresteg     


Final A

Final

1Isak Persson
15.94w
Örgryte IS
15.94w
+3.1
  
2Artur Engström
15.54
Örgryte IS
15.54
+1.6 SB
  
3Gustaf BålströmUllevi FK
15.28
+2.0 SB
  
4Markus Lundborg
14.90w
Ullevi FK
14.90w
+2.3
  
5Oskar Weidenholm
14.62w
Mölndals AIK
14.62w
+3.0
  
6Nils Thorin
13.39w
Örgryte IS
13.39w
+2.2
  
7Melker Manne
13.32
Ullevi FK
13.32
+1.8
  
8Johan Wahlgren
13.20w
Ullevi FK
13.20w
+3.4
  
9Agustin HilmerssonIK Orient
13.06w
+3.2
  
10Victor Hering
12.96
Ullevi FK
12.96
+1.9 SB
  
11Erik Dahlqvist
12.37
IK Orient
12.37
+1.1 SB
  
Persson15.94w
+3.1
15.12w
+2.4
15.48
+1.3
15.76w
+2.8
15.78
+0.2
Engströmx15.07
+0.2
15.07
+1.2
15.28w
+2.2
15.21
+1.9
15.54
+1.6
Bålström14.79
+1.6
x15.02
+1.7
15.28
+2.0
xx
Lundborg14.90w
+2.3
14.54
+0.8
14.78
+1.3
xxx
Weidenholm14.05
+1.9
14.14w
+2.7
14.47
+1.8
14.30w
+2.7
x14.62w
+3.0
Thorinx13.02
+1.9
13.39w
+2.2
xx13.13
+1.1
Manne13.25w
+2.3
13.30
+2.0
13.32
+1.8
13.16
+1.8
Wahlgren13.20w
+3.4
x12.73
+0.8
Hilmerssonx13.06w
+3.2
12.84
-0.7
Hering12.65w
+2.5
12.96
+1.9
Dahlqvist12.37
+1.1
12.34
+1.3
Kvinnor
K Höjd     


Final A

Final

1Maja Nilsson
1.79
Örgryte IS
1.79
  
2Vendela von CorswantÖrgryte IS
1.71
SB
  
3Lina LöfqvistUllevi FK
1.66
=SB
  
Ellen EkholmUllevi FK
NH
  
1.561.611.661.711.751.791.83
Nilsson---ooxoxxx
von Corswant-ooxoxxx
Löfqvistooxoxxx
Ekholm---xxx
K Stav     


Final A

Final

1Ester Schenck
3.05
Ullevi FK
3.05
PB
  
2.752.802.852.902.953.003.053.10
Schenckoxoooooxoxxx
K Längd     


Final A

Final

1Emilia HammarströmMölndals AIK
5.92
+1.2
  
2Jenny Lestander
5.92w
Örgryte IS
5.92w
+2.5
  
3Judith Wagersten
5.56
Örgryte IS
5.56
+1.3
  
4Sara Sjögren
5.45w
Mölndals AIK
5.45w
+3.2
  
5Tindra Redenfors
5.10w
IFK Halmstad
5.10w
+2.6
  
6Ida Kühnel Pappila
5.07
IFK Göteborg
5.07
0.0 PB
  
7Ivana Pekic
Ivana Pekic 05, IFK Göteborg
4.81
IFK Göteborg
4.81
+0.9
  
Hammarström5.87
+2.0
x5.90
+1.6
5.80
+0.9
5.91
+1.7
5.92
+1.2
Lestanderx5.92w
+2.5
5.88
+1.2
x5.88
+1.7
x
Wagerstenx5.49w
+3.0
5.47
0.0
x5.56
+1.3
5.41
+1.4
Sjögrenx5.45w
+3.2
5.44
+1.9
xxx
Redenfors4.78
+1.3
x3.38
+1.4
4.80
0.0
4.91
+1.3
5.10w
+2.6
Kühnel Pappila5.04w
+2.4
x4.68
+1.2
x5.07
0.0
x
Pekic4.81
+0.9
xx3.11
+1.3
3.70
+1.3
3.02w
+2.4
K Tresteg     


Final A

Final

1Rebecka AbrahamssonÖrgryte IS
13.10
–0.1
  
2Amanda Hjalmarsson
12.09
IFK Växjö
12.09
+1.8 SB
  
3Lisa Weyhenmeyer
12.05
Upsala IF
12.05
+1.8
  
4Nora Jolbäck
Nora Jolbäck 04, Lidköpings IS
11.87
Lidköpings IS
11.87
+1.4 PB
  
5Johanna KonséleusUllevi FK
11.60w
+2.4
  
6Elvira Richardsson
Elvira Richardsson 96, Göteborgs KIK
11.56
Göteborgs KIK
11.56
+1.3
  
7Linn Hertz Saebbö
Linn Hertz Saebbö 00, Göteborgs KIK
11.55w
Göteborgs KIK
11.55w
+2.6
  
8Hilma Hofström
10.92
Örgryte IS
10.92
+0.4
  
9Moa Bertilsson
Moa Bertilsson 05, IFK Göteborg
10.78
IFK Göteborg
10.78
+1.5 PB
  
10Sofie Hallman
10.30
Ullevi FK
10.30
+1.1 SB
  
11Jeriel KabongoUllevi FK
9.77
+1.3
  
Abrahamssonx12.14
-1.4
x13.07
0.0
13.10
-0.1
x
Hjalmarsson11.98
+1.1
xx11.82
+1.3
x12.09
+1.8
Weyhenmeyerx11.70
+2.0
xx12.05
+1.8
11.97w
+2.8
Jolbäck11.80w
+2.6
11.74
+0.9
11.73w
+2.8
11.70w
+2.6
11.56
+1.9
11.87
+1.4
Konséleus11.53
+0.4
11.60w
+2.4
11.42
+1.0
xxx
Richardsson11.20
+1.5
xx11.28
+1.2
11.56
+1.3
11.49w
+2.8
Hertz Saebbö11.42w
+2.8
11.04
-0.8
11.29
+0.4
11.55w
+2.6
xx
Hofström10.87w
+3.8
10.80
0.0
x10.90
+1.9
10.78
+1.2
10.92
+0.4
Bertilsson10.40
+1.4
10.34
+1.8
10.78
+1.5
Hallman9.70
0.0
10.18
+0.1
10.30
+1.1
Kabongox9.77
+1.3
9.57w
+2.2