TABLE SQL =select * from cp_breakstbl where 1=0RESULTS =PDOResult Object ( [stmt] => PDOStatement Object ( [queryString] => select * from cp_breakstbl where 1=0 ) [_errno] => 0 [_error] => Array ( [0] => 00000 [1] => [2] => ) [sql] => select * from cp_breakstbl where 1=0 [id] => [_num] => 0 ) TABLE SQL =select t.*, coalesce( m.name, 'No Name' ) as mbr_name, c.location_ID, c.memberNbr, c.problem, c.div, c.rank, c.raw_penalty, c.total_scores, c.raw_lt1, c.raw_lt2, c.raw_style, c.raw_spont, c.calc_lt1, c.calc_lt2, c.calc_style, c.calc_spont, l.lt_name as lt_location, l.st_name as st_location, if( m.assoc != 'AE', concat( t.school_city, if( length( t.school_city ), ', ', '' ), if( a.international = 'Y', a.country, UPPER( m.assoc ) ) ), concat( if( a.international = 'Y', a.country, UPPER( m.assoc ) ), if( length( t.school_city ), ', ', '' ), t.school_city ) ) as wf_location, m.city, m.county from competitionstbl as c inner join eventstbl as e on e.event_ID = c.event_ID left join cp_locationstbl as l on l.event_ID = e.event_ID and l.problem = c.problem and l.div = c.div and l.location_ID = c.location_ID left join memberstbl as m on m.memberNbr = c.memberNbr and m.school_year = e.school_year left join assoctbl as a on a.assoc = m.assoc and a.international = 'Y' left join assocteamstbl as t on t.memberNbr = c.memberNbr and t.problem = c.problem and t.div = c.div and t.school_year = e.school_year where 0 RESULTS =PDOResult Object ( [stmt] => PDOStatement Object ( [queryString] => select t.*, coalesce( m.name, 'No Name' ) as mbr_name, c.location_ID, c.memberNbr, c.problem, c.div, c.rank, c.raw_penalty, c.total_scores, c.raw_lt1, c.raw_lt2, c.raw_style, c.raw_spont, c.calc_lt1, c.calc_lt2, c.calc_style, c.calc_spont, l.lt_name as lt_location, l.st_name as st_location, if( m.assoc != 'AE', concat( t.school_city, if( length( t.school_city ), ', ', '' ), if( a.international = 'Y', a.country, UPPER( m.assoc ) ) ), concat( if( a.international = 'Y', a.country, UPPER( m.assoc ) ), if( length( t.school_city ), ', ', '' ), t.school_city ) ) as wf_location, m.city, m.county from competitionstbl as c inner join eventstbl as e on e.event_ID = c.event_ID left join cp_locationstbl as l on l.event_ID = e.event_ID and l.problem = c.problem and l.div = c.div and l.location_ID = c.location_ID left join memberstbl as m on m.memberNbr = c.memberNbr and m.school_year = e.school_year left join assoctbl as a on a.assoc = m.assoc and a.international = 'Y' left join assocteamstbl as t on t.memberNbr = c.memberNbr and t.problem = c.problem and t.div = c.div and t.school_year = e.school_year where 0 ) [_errno] => 0 [_error] => Array ( [0] => 00000 [1] => [2] => ) [sql] => select t.*, coalesce( m.name, 'No Name' ) as mbr_name, c.location_ID, c.memberNbr, c.problem, c.div, c.rank, c.raw_penalty, c.total_scores, c.raw_lt1, c.raw_lt2, c.raw_style, c.raw_spont, c.calc_lt1, c.calc_lt2, c.calc_style, c.calc_spont, l.lt_name as lt_location, l.st_name as st_location, if( m.assoc != 'AE', concat( t.school_city, if( length( t.school_city ), ', ', '' ), if( a.international = 'Y', a.country, UPPER( m.assoc ) ) ), concat( if( a.international = 'Y', a.country, UPPER( m.assoc ) ), if( length( t.school_city ), ', ', '' ), t.school_city ) ) as wf_location, m.city, m.county from competitionstbl as c inner join eventstbl as e on e.event_ID = c.event_ID left join cp_locationstbl as l on l.event_ID = e.event_ID and l.problem = c.problem and l.div = c.div and l.location_ID = c.location_ID left join memberstbl as m on m.memberNbr = c.memberNbr and m.school_year = e.school_year left join assoctbl as a on a.assoc = m.assoc and a.international = 'Y' left join assocteamstbl as t on t.memberNbr = c.memberNbr and t.problem = c.problem and t.div = c.div and t.school_year = e.school_year where 0 [id] => [_num] => 0 ) Odyssey of the Mind
World Finals 2008 May 31st
 Problem 1 Odyssey Road Rally Division I
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #20906
Calc.
Raw
200.00
160.98
50.00
46.33
84.62
137.50
0.00 334.62
 2  No Name #32957
Calc.
Raw
192.20
154.70
42.45
39.33
84.31
137.00
0.00 318.96
 3  No Name #28072
Calc.
Raw
173.54
139.68
30.94
28.67
97.38
158.25
0.00 301.86
 4  No Name #28819
Calc.
Raw
186.77
150.33
31.30
29.00
81.54
132.50
0.00 299.61
 5  No Name #387
Calc.
Raw
153.62
123.65
32.38
30.00
100.00
162.50
0.00 286.00
 6  No Name #34320
Calc.
Raw
159.86
128.67
35.26
32.67
83.69
136.00
0.00 278.81
 6  No Name #9108
Calc.
Raw
151.56
121.99
42.09
39.00
84.77
137.75
0.00 278.42
 7  No Name #35789
Calc.
Raw
156.96
126.34
30.57
28.33
84.15
136.75
0.00 271.68
 7  No Name #34835
Calc.
Raw
162.34
130.67
37.77
35.00
71.23
115.75
0.00 271.34
 8  No Name #6162
Calc.
Raw
168.13
135.33
28.42
26.33
70.62
114.75
0.00 267.17
 9  No Name #29453
Calc.
Raw
168.57
135.68
31.30
29.00
61.85
100.50
0.00 261.72
 9  No Name #16465
Calc.
Raw
130.87
105.34
33.46
31.00
97.38
158.25
0.00 261.71
 10  No Name #35477
Calc.
Raw
145.35
116.99
31.65
29.33
82.77
134.50
2.00 257.77
 10  No Name #37176
Calc.
Raw
128.36
103.32
32.38
30.00
96.92
157.50
0.00 257.66
 11  No Name #5637
Calc.
Raw
150.33
121.00
36.34
33.67
66.00
107.25
0.00 252.67
 11  No Name #34814
Calc.
Raw
143.26
115.31
33.81
31.33
74.92
121.75
0.00 251.99
 12  No Name #33665
Calc.
Raw
150.74
121.33
38.13
35.33
60.31
98.00
0.00 249.18
 13  No Name #35446
Calc.
Raw
153.22
123.33
22.31
20.67
71.69
116.50
0.00 247.22
 14  No Name #34298
Calc.
Raw
132.10
106.33
29.14
27.00
84.77
137.75
0.00 246.01
 14  No Name #37850
Calc.
Raw
142.04
114.33
34.53
32.00
68.77
111.75
0.00 245.34
 15  No Name #4999
Calc.
Raw
161.52
130.01
25.90
24.00
56.46
91.75
0.00 243.88
 15  No Name #34889
Calc.
Raw
151.99
122.34
32.02
29.67
59.38
96.50
0.00 243.39
 16  No Name #32908
Calc.
Raw
135.00
108.66
36.69
34.00
70.92
115.25
0.00 242.61
 16  No Name #715
Calc.
Raw
132.51
106.66
16.91
15.67
92.92
151.00
0.00 242.34
 17  No Name #8582
Calc.
Raw
139.15
112.00
28.06
26.00
72.00
117.00
0.00 239.21
 18  No Name #34310
Calc.
Raw
115.53
92.99
23.74
22.00
96.00
156.00
0.00 235.27
 19  No Name #3895
Calc.
Raw
122.79
98.83
16.91
15.67
93.69
152.25
0.00 233.39
 20  No Name #36671
Calc.
Raw
106.83
85.99
27.34
25.33
97.08
157.75
0.00 231.25
 21  No Name #37815
Calc.
Raw
122.57
98.66
22.66
21.00
83.54
135.75
0.00 228.77
 21  No Name #37354
Calc.
Raw
145.77
117.33
19.43
18.00
62.77
102.00
0.00 227.97
 22  No Name #30618
Calc.
Raw
133.36
107.34
19.07
17.67
71.85
116.75
0.00 224.28
 22  No Name #1386
Calc.
Raw
124.65
100.33
27.70
25.67
71.85
116.75
0.00 224.20
 23  No Name #16597
Calc.
Raw
135.01
108.67
20.52
19.01
65.08
105.75
0.00 220.61
 24  No Name #36300
Calc.
Raw
106.01
85.33
29.49
27.33
83.85
136.25
0.00 219.35
 25  No Name #37234
Calc.
Raw
119.68
96.33
29.86
27.67
95.69
155.50
30.00 215.23
 26  No Name #35035
Calc.
Raw
123.82
99.66
25.18
23.33
64.62
105.00
0.00 213.62
 26  No Name #37612
Calc.
Raw
125.08
100.68
23.74
22.00
67.08
109.00
3.00 212.90
 27  No Name #34242
Calc.
Raw
118.86
95.67
20.15
18.67
72.62
118.00
0.00 211.63
 28  No Name #37715
Calc.
Raw
113.05
90.99
25.18
23.33
71.69
116.50
0.00 209.92
 29  No Name #9599
Calc.
Raw
126.31
101.67
25.55
23.67
56.62
92.00
0.00 208.48
 30  No Name #35727
Calc.
Raw
124.24
100.00
17.62
16.33
64.77
105.25
0.00 206.63
 31  No Name #20733
Calc.
Raw
121.73
97.98
17.62
16.33
66.00
107.25
0.00 205.35
 31  No Name #30823
Calc.
Raw
122.98
98.99
17.99
16.67
63.69
103.50
0.00 204.66
 32  No Name #36769
Calc.
Raw
82.83
66.67
33.81
31.33
84.31
137.00
1.00 199.95
 32  No Name #31535
Calc.
Raw
117.18
94.32
31.65
29.33
50.46
82.00
0.00 199.29
 33  No Name #5128
Calc.
Raw
94.41
75.99
19.07
17.67
84.00
136.50
0.00 197.48
 34  No Name #13857
Calc.
Raw
91.08
73.31
29.49
27.33
71.54
116.25
2.00 190.11
 34  No Name #11451
Calc.
Raw
121.31
97.64
28.42
26.33
39.54
64.25
0.00 189.27
 35  No Name #21099
Calc.
Raw
108.93
87.68
14.39
13.33
64.46
104.75
0.00 187.78
 36  No Name #36158
Calc.
Raw
121.33
97.66
21.94
20.33
36.46
59.25
0.00 179.73
 37  No Name #36616
Calc.
Raw
128.81
103.68
21.23
19.67
21.85
35.50
0.00 171.89
 38  No Name #32600
Calc.
Raw
73.72
59.34
26.62
24.67
67.23
109.25
0.00 167.57
 39  No Name #37851
Calc.
Raw
83.66
67.34
35.26
32.67
42.77
69.50
0.00 161.69
 40  No Name #19400
Calc.
Raw
78.06
62.83
33.81
31.33
46.62
75.75
0.00 158.49
 40  No Name #34796
Calc.
Raw
113.87
91.65
36.34
33.67
7.69
12.50
0.00 157.90
 41  No Name #37378
Calc.
Raw
72.89
58.67
8.28
7.67
68.92
112.00
0.00 150.09
 41  No Name #34080
Calc.
Raw
39.74
31.99
28.42
26.33
81.85
133.00
0.00 150.01
 Problem 1 Odyssey Road Rally Division II
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #33956
Calc.
Raw
177.59
142.67
39.67
32.00
98.43
42.00
0.00 315.69
 2  No Name #36233
Calc.
Raw
200.00
160.67
41.74
33.67
48.44
20.67
0.00 290.18
 3  No Name #37198
Calc.
Raw
155.19
124.67
30.99
25.00
100.00
42.67
0.00 286.18
 4  No Name #2464
Calc.
Raw
143.16
115.01
38.43
31.00
96.86
41.33
0.00 278.45
 5  No Name #789
Calc.
Raw
181.34
145.68
30.99
25.00
49.99
21.33
0.00 262.32
 6  No Name #35548
Calc.
Raw
184.65
148.34
31.40
25.33
42.18
18.00
0.00 258.23
 7  No Name #34754
Calc.
Raw
169.94
136.52
46.28
37.33
35.15
15.00
0.00 251.37
 7  No Name #820
Calc.
Raw
180.48
144.99
42.56
34.33
27.35
11.67
0.00 250.39
 8  No Name #1375
Calc.
Raw
125.33
100.68
38.02
30.67
88.28
37.67
2.00 249.63
 9  No Name #37306
Calc.
Raw
126.98
102.01
26.44
21.33
94.52
40.33
0.00 247.94
 10  No Name #29469
Calc.
Raw
161.83
130.01
49.18
39.67
33.58
14.33
0.00 244.59
 11  No Name #17625
Calc.
Raw
169.08
135.83
32.23
26.00
42.18
18.00
0.00 243.49
 12  No Name #1386
Calc.
Raw
154.35
124.00
41.32
33.33
48.44
20.67
3.00 241.11
 12  No Name #17473
Calc.
Raw
170.13
136.67
43.80
35.33
26.55
11.33
0.00 240.48
 13  No Name #14485
Calc.
Raw
168.88
135.67
36.78
29.67
34.38
14.67
0.00 240.04
 13  No Name #25443
Calc.
Raw
166.79
133.99
35.54
28.67
37.50
16.00
0.00 239.83
 13  No Name #30680
Calc.
Raw
171.37
137.67
30.59
24.67
37.50
16.00
0.00 239.46
 14  No Name #36468
Calc.
Raw
166.81
134.01
50.00
40.33
21.09
9.00
0.00 237.90
 15  No Name #36145
Calc.
Raw
149.15
119.82
37.60
30.33
44.53
19.00
0.00 231.28
 15  No Name #30603
Calc.
Raw
167.22
134.34
26.44
21.33
37.50
16.00
0.00 231.16
 16  No Name #22841
Calc.
Raw
158.09
127.00
40.50
32.67
29.69
12.67
0.00 228.28
 17  No Name #35493
Calc.
Raw
158.49
127.32
37.19
30.00
30.47
13.00
0.00 226.15
 17  No Name #37097
Calc.
Raw
174.89
140.50
21.49
17.33
29.69
12.67
0.00 226.07
 18  No Name #36617
Calc.
Raw
99.99
80.33
26.04
21.00
97.66
41.67
2.00 221.69
 19  No Name #35714
Calc.
Raw
155.59
124.99
42.15
34.00
21.87
9.33
0.00 219.61
 20  No Name #11901
Calc.
Raw
160.55
128.98
36.36
29.33
23.44
10.00
2.00 218.35
 20  No Name #35507
Calc.
Raw
157.25
126.33
31.40
25.33
28.90
12.33
0.00 217.55
 21  No Name #11548
Calc.
Raw
152.27
122.33
35.95
29.00
28.12
12.00
0.00 216.34
 22  No Name #35154
Calc.
Raw
135.26
108.66
35.95
29.00
44.53
19.00
1.00 214.74
 23  No Name #37318
Calc.
Raw
146.46
117.66
33.47
27.00
28.90
12.33
0.00 208.83
 24  No Name #34698
Calc.
Raw
137.34
110.33
36.36
29.33
32.04
13.67
0.00 205.74
 25  No Name #35896
Calc.
Raw
149.37
120.00
35.12
28.33
17.18
7.33
0.00 201.67
 25  No Name #37039
Calc.
Raw
158.29
127.16
28.92
23.33
16.40
7.00
2.00 201.61
 26  No Name #35542
Calc.
Raw
112.85
90.66
28.51
23.00
57.82
24.67
0.00 199.18
 26  No Name #35212
Calc.
Raw
123.66
99.34
23.56
19.00
51.56
22.00
0.00 198.78
 27  No Name #33986
Calc.
Raw
142.15
114.20
30.99
25.00
28.90
12.33
5.00 197.04
 28  No Name #34983
Calc.
Raw
98.34
79.00
25.20
20.33
71.88
30.67
0.00 195.42
 29  No Name #1722
Calc.
Raw
146.03
117.31
23.56
19.00
24.21
10.33
0.00 193.80
 29  No Name #20480
Calc.
Raw
137.35
110.34
34.71
28.00
21.09
9.00
0.00 193.15
 30  No Name #37388
Calc.
Raw
102.06
81.99
22.73
18.33
67.19
28.67
0.00 191.98
 31  No Name #31293
Calc.
Raw
146.05
117.33
15.71
12.67
28.90
12.33
0.00 190.66
 31  No Name #36148
Calc.
Raw
123.66
99.34
37.19
30.00
29.69
12.67
0.00 190.54
 32  No Name #19264
Calc.
Raw
133.62
107.34
10.33
8.33
49.21
21.00
5.00 188.16
 32  No Name #5993
Calc.
Raw
127.79
102.66
28.92
23.33
31.24
13.33
0.00 187.95
 32  No Name #36541
Calc.
Raw
136.94
110.01
33.88
27.33
21.09
9.00
4.00 187.91
 33  No Name #2395
Calc.
Raw
135.28
108.68
33.06
26.67
17.98
7.67
0.00 186.32
 34  No Name #35471
Calc.
Raw
131.11
105.33
30.99
25.00
22.66
9.67
0.00 184.76
 35  No Name #13568
Calc.
Raw
133.39
107.16
20.67
16.67
28.12
12.00
0.00 182.18
 35  No Name #16088
Calc.
Raw
119.49
95.99
33.06
26.67
28.90
12.33
0.00 181.45
 36  No Name #26609
Calc.
Raw
132.36
106.33
27.27
22.00
20.32
8.67
0.00 179.95
 36  No Name #36971
Calc.
Raw
125.71
100.99
17.77
14.33
35.93
15.33
0.00 179.41
 37  No Name #17135
Calc.
Raw
102.92
82.68
28.92
23.33
46.10
19.67
0.00 177.94
 38  No Name #37094
Calc.
Raw
119.08
95.66
24.80
20.00
35.15
15.00
6.00 173.03
 39  No Name #36643
Calc.
Raw
127.19
102.18
28.51
23.00
19.52
8.33
4.00 171.22
 40  No Name #4085
Calc.
Raw
119.92
96.34
21.08
17.00
25.78
11.00
5.00 161.78
 40  No Name #37478
Calc.
Raw
110.15
88.49
27.68
22.33
23.44
10.00
0.00 161.27
 41  No Name #37206
Calc.
Raw
96.68
77.67
12.81
10.33
27.35
11.67
0.00 136.84
 42  No Name #37176
Calc.
Raw
47.30
38.00
19.01
15.33
37.50
16.00
0.00 103.81
 43  No Name #37316
Calc.
Raw
53.94
43.33
16.12
13.00
26.55
11.33
0.00 96.61
 Problem 1 Odyssey Road Rally Division III
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #20868
Calc.
Raw
157.96
139.00
39.28
29.33
100.00
584.50
0.00 297.24
 2  No Name #35901
Calc.
Raw
164.41
144.67
41.96
31.33
79.08
462.25
0.00 285.45
 3  No Name #7975
Calc.
Raw
151.53
133.34
31.25
23.33
99.83
583.50
0.00 282.61
 3  No Name #37674
Calc.
Raw
139.02
122.33
43.76
32.67
99.79
583.25
0.00 282.57
 3  No Name #37802
Calc.
Raw
184.86
162.67
39.74
29.67
57.87
338.25
0.00 282.47
 4  No Name #1149
Calc.
Raw
154.17
135.66
49.56
37.00
66.30
387.50
0.00 270.03
 5  No Name #5736
Calc.
Raw
200.00
175.99
46.44
34.67
22.58
132.00
0.00 269.02
 6  No Name #19512
Calc.
Raw
152.67
134.34
27.69
20.67
79.34
463.75
0.00 259.70
 6  No Name #36232
Calc.
Raw
184.86
162.67
48.66
36.33
26.01
152.00
0.00 259.53
 7  No Name #33986
Calc.
Raw
134.84
118.65
36.16
27.00
85.97
502.50
0.00 256.97
 8  No Name #33894
Calc.
Raw
106.82
94.00
38.40
28.67
99.62
582.25
0.00 244.84
 8  No Name #32490
Calc.
Raw
175.00
153.99
49.12
36.67
19.85
116.00
0.00 243.97
 9  No Name #10102
Calc.
Raw
161.76
142.34
47.78
35.67
33.28
194.50
0.00 242.82
 10  No Name #9103
Calc.
Raw
157.96
139.00
48.66
36.33
31.18
182.25
0.00 237.80
 11  No Name #30663
Calc.
Raw
146.21
128.66
39.28
29.33
43.97
257.00
0.00 229.46
 12  No Name #22311
Calc.
Raw
159.85
140.66
39.28
29.33
25.96
151.75
0.00 225.09
 13  No Name #36451
Calc.
Raw
126.14
111.00
39.28
29.33
48.76
285.00
0.00 214.18
 14  No Name #35911
Calc.
Raw
148.11
130.33
31.70
23.67
31.74
185.50
0.00 211.55
 15  No Name #33488
Calc.
Raw
149.27
131.35
37.50
28.00
29.17
170.50
6.00 209.94
 16  No Name #4637
Calc.
Raw
143.56
126.33
39.28
29.33
25.96
151.75
0.00 208.80
 17  No Name #18255
Calc.
Raw
150.38
132.33
50.00
37.33
5.99
35.00
0.00 206.37
 18  No Name #17068
Calc.
Raw
142.43
125.33
38.40
28.67
21.90
128.00
0.00 202.73
 19  No Name #31161
Calc.
Raw
78.80
69.34
33.93
25.33
87.77
513.00
2.00 198.50
 20  No Name #32441
Calc.
Raw
103.41
91.00
37.50
28.00
52.52
307.00
0.00 193.43
 20  No Name #29018
Calc.
Raw
131.05
115.32
36.16
27.00
25.75
150.50
0.00 192.96
 21  No Name #33292
Calc.
Raw
149.25
131.33
25.01
18.67
16.89
98.75
0.00 191.15
 22  No Name #17622
Calc.
Raw
125.77
110.67
35.27
26.33
26.90
157.25
0.00 187.94
 23  No Name #37852
Calc.
Raw
139.02
122.33
38.40
28.67
9.41
55.00
0.00 186.83
 23  No Name #34802
Calc.
Raw
145.10
127.68
29.02
21.67
12.40
72.50
0.00 186.52
 23  No Name #10146
Calc.
Raw
123.47
108.65
36.16
27.00
26.43
154.50
0.00 186.06
 24  No Name #14186
Calc.
Raw
126.92
111.68
25.45
19.00
23.14
135.25
0.00 175.51
 25  No Name #4307
Calc.
Raw
113.63
99.99
43.30
32.33
16.00
93.50
0.00 172.93
 26  No Name #1412
Calc.
Raw
132.59
116.67
22.77
17.00
12.49
73.00
0.00 167.85
 27  No Name #8451
Calc.
Raw
117.45
103.35
35.72
26.67
19.42
113.50
8.00 164.59
 28  No Name #32144
Calc.
Raw
119.32
105.00
25.01
18.67
25.83
151.00
20.00 150.16
 29  No Name #3148
Calc.
Raw
94.31
82.99
23.21
17.33
21.64
126.50
6.00 133.16
 30  No Name #11105
Calc.
Raw
79.95
70.35
37.50
28.00
8.04
47.00
0.00 125.49
 31  No Name #30595
Calc.
Raw
89.41
78.68
24.55
18.33
10.31
60.25
12.00 112.27
 32  No Name #19633
Calc.
Raw
59.09
52.00
32.15
24.00
18.43
107.75
2.00 107.67
 33  No Name #36469
Calc.
Raw
46.21
40.66
39.74
29.67
5.22
30.50
0.00 91.17
 34  No Name #7940
Calc.
Raw
72.36
63.67
15.18
11.33
8.68
50.75
7.00 89.22
 35  No Name #36540
Calc.
Raw
50.00
44.00
10.72
8.00
4.28
25.00
3.00 62.00