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 2006 May 24th
 Problem 1 The Great Parade Division I
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #9108
Calc.
Raw
200.00
151.99
50.00
31.34
54.15
55.50
0.00 304.15
 2  No Name #5462
Calc.
Raw
137.71
104.65
40.43
25.34
83.90
86.00
0.00 262.04
 3  No Name #1436
Calc.
Raw
171.95
130.67
32.45
20.34
40.73
41.75
0.00 245.13
 4  No Name #2271
Calc.
Raw
135.10
102.67
23.39
14.66
84.63
86.75
0.00 243.12
 4  No Name #32735
Calc.
Raw
139.48
106.00
35.11
22.01
68.29
70.00
0.00 242.88
 5  No Name #29543
Calc.
Raw
128.07
97.33
42.55
26.67
66.83
68.50
0.00 237.45
 6  No Name #16465
Calc.
Raw
129.39
98.33
22.89
14.35
83.66
85.75
0.00 235.94
 7  No Name #1010
Calc.
Raw
136.39
103.65
32.43
20.33
62.68
64.25
0.00 231.50
 8  No Name #17473
Calc.
Raw
164.04
124.66
47.34
29.67
18.29
18.75
0.00 229.67
 9  No Name #33957
Calc.
Raw
110.53
84.00
25.53
16.00
91.46
93.75
0.00 227.52
 10  No Name #28072
Calc.
Raw
87.69
66.64
35.64
22.34
100.00
102.50
1.00 222.33
 11  No Name #4645
Calc.
Raw
111.84
84.99
40.95
25.67
67.56
69.25
0.00 220.35
 12  No Name #1164
Calc.
Raw
130.73
99.35
38.82
24.33
45.61
46.75
0.00 215.16
 13  No Name #22144
Calc.
Raw
129.84
98.67
44.67
28.00
37.07
38.00
0.00 211.58
 14  No Name #45
Calc.
Raw
132.04
100.34
36.17
22.67
37.32
38.25
1.00 204.53
 15  No Name #35587
Calc.
Raw
105.70
80.33
31.92
20.01
64.15
65.75
0.00 201.77
 16  No Name #32163
Calc.
Raw
113.61
86.34
36.69
23.00
44.39
45.50
0.00 194.69
 17  No Name #35277
Calc.
Raw
95.61
72.66
14.89
9.33
82.44
84.50
0.00 192.94
 18  No Name #25057
Calc.
Raw
126.34
96.01
40.41
25.33
22.20
22.75
0.00 188.95
 18  No Name #31535
Calc.
Raw
109.23
83.01
41.48
26.00
42.93
44.00
5.00 188.64
 19  No Name #14032
Calc.
Raw
117.11
89.00
29.24
18.33
41.22
42.25
0.00 187.57
 19  No Name #32425
Calc.
Raw
127.67
97.02
43.08
27.00
16.10
16.50
0.00 186.85
 20  No Name #33282
Calc.
Raw
103.95
79.00
30.31
19.00
52.20
53.50
0.00 186.46
 21  No Name #569
Calc.
Raw
99.57
75.67
22.35
14.01
60.49
62.00
0.00 182.41
 22  No Name #30841
Calc.
Raw
118.43
90.00
34.05
21.34
26.59
27.25
0.00 179.07
 23  No Name #13391
Calc.
Raw
118.86
90.33
29.24
18.33
29.76
30.50
0.00 177.86
 23  No Name #34804
Calc.
Raw
114.94
87.35
42.55
26.67
19.76
20.25
0.00 177.25
 24  No Name #33665
Calc.
Raw
116.23
88.33
41.48
26.00
17.56
18.00
0.00 175.27
 25  No Name #15746
Calc.
Raw
79.40
60.34
26.60
16.67
67.80
69.50
0.00 173.80
 26  No Name #5728
Calc.
Raw
131.15
99.67
32.43
20.33
4.88
5.00
0.00 168.46
 26  No Name #34242
Calc.
Raw
104.85
79.68
16.48
10.33
46.34
47.50
0.00 167.67
 27  No Name #35727
Calc.
Raw
100.02
76.01
22.34
14.00
47.32
48.50
3.00 166.68
 28  No Name #23365
Calc.
Raw
93.85
71.32
44.13
27.66
26.34
27.00
0.00 164.32
 28  No Name #35570
Calc.
Raw
120.61
91.66
26.07
16.34
17.56
18.00
0.00 164.24
 28  No Name #34320
Calc.
Raw
111.39
84.65
23.40
14.67
28.54
29.25
0.00 163.33
 29  No Name #20522
Calc.
Raw
98.70
75.01
44.14
27.67
16.59
17.00
0.00 159.43
 29  No Name #30598
Calc.
Raw
121.93
92.66
28.72
18.00
8.05
8.25
0.00 158.70
 29  No Name #33246
Calc.
Raw
120.61
91.66
21.28
13.34
16.59
17.00
0.00 158.48
 30  No Name #24450
Calc.
Raw
111.42
84.67
30.86
19.34
15.85
16.25
0.00 158.13
 30  No Name #20797
Calc.
Raw
129.82
98.66
20.21
12.67
8.05
8.25
0.00 158.08
 31  No Name #24819
Calc.
Raw
89.93
68.34
26.58
16.66
39.76
40.75
5.00 151.27
 31  No Name #21969
Calc.
Raw
104.85
79.68
30.84
19.33
15.37
15.75
0.00 151.06
 32  No Name #30889
Calc.
Raw
84.62
64.31
26.08
16.35
38.05
39.00
0.00 148.75
 32  No Name #2481
Calc.
Raw
83.35
63.34
36.17
22.67
28.29
29.00
0.00 147.81
 33  No Name #35602
Calc.
Raw
116.22
88.32
14.36
9.00
21.22
21.75
6.00 145.80
 34  No Name #9358
Calc.
Raw
106.15
80.67
21.27
13.33
14.88
15.25
0.00 142.30
 34  No Name #2770
Calc.
Raw
106.11
80.64
24.47
15.34
10.73
11.00
0.00 141.31
 35  No Name #3390
Calc.
Raw
68.43
52.00
30.86
19.34
38.05
39.00
0.00 137.34
 35  No Name #35138
Calc.
Raw
88.16
67.00
29.26
18.34
19.27
19.75
0.00 136.69
 36  No Name #35146
Calc.
Raw
85.10
64.67
34.57
21.67
15.61
16.00
0.00 135.28
 37  No Name #22905
Calc.
Raw
91.24
69.34
21.27
13.33
20.98
21.50
0.00 133.49
 38  No Name #25354
Calc.
Raw
84.68
64.35
20.21
12.67
26.83
27.50
0.00 131.72
 39  No Name #25085
Calc.
Raw
73.70
56.01
26.60
16.67
28.54
29.25
0.00 128.84
 40  No Name #3422
Calc.
Raw
83.31
63.31
26.58
16.66
17.07
17.50
5.00 121.96
 41  No Name #12534
Calc.
Raw
75.89
57.67
21.83
13.68
19.51
20.00
0.00 117.23
 42  No Name #19826
Calc.
Raw
85.52
64.99
21.81
13.67
6.83
7.00
0.00 114.16
 43  No Name #23774
Calc.
Raw
67.56
51.34
30.84
19.33
19.27
19.75
5.00 112.67
 44  No Name #1859
Calc.
Raw
77.20
58.67
16.48
10.33
13.66
14.00
0.00 107.34
 45  No Name #34760
Calc.
Raw
55.27
42.00
27.66
17.34
17.32
17.75
0.00 100.25
 Problem 1 The Great Parade Division II
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #34622
Calc.
Raw
200.00
133.00
50.00
45.67
70.92
200.00
0.00 320.92
 2  No Name #1964
Calc.
Raw
191.46
127.32
39.79
36.34
75.53
213.00
0.00 306.78
 3  No Name #28057
Calc.
Raw
169.94
113.01
35.03
32.00
99.56
280.75
0.00 304.53
 4  No Name #9642
Calc.
Raw
153.40
102.01
44.53
40.67
100.00
282.00
0.00 297.93
 5  No Name #2269
Calc.
Raw
177.44
118.00
37.96
34.67
73.58
207.50
0.00 288.98
 6  No Name #32289
Calc.
Raw
174.44
116.00
29.57
27.01
82.45
232.50
0.00 286.46
 7  No Name #3249
Calc.
Raw
185.98
123.68
36.13
33.00
60.73
171.25
0.00 282.84
 8  No Name #5758
Calc.
Raw
183.44
121.99
34.67
31.67
61.97
174.75
0.00 280.08
 9  No Name #31893
Calc.
Raw
159.89
106.33
40.88
37.34
72.16
203.50
0.00 272.93
 10  No Name #4328
Calc.
Raw
190.51
126.69
34.67
31.67
45.57
128.50
0.00 270.75
 11  No Name #4323
Calc.
Raw
176.95
117.67
38.68
35.33
47.16
133.00
0.00 262.79
 12  No Name #3763
Calc.
Raw
164.95
109.69
33.95
31.01
62.32
175.75
0.00 261.22
 12  No Name #31562
Calc.
Raw
179.43
119.32
32.48
29.67
48.58
137.00
0.00 260.49
 13  No Name #22311
Calc.
Raw
163.41
108.67
33.21
30.33
62.32
175.75
0.00 258.94
 14  No Name #29469
Calc.
Raw
176.95
117.67
40.87
37.33
36.17
102.00
0.00 253.99
 15  No Name #31458
Calc.
Raw
171.44
114.01
36.50
33.34
44.77
126.25
0.00 252.71
 16  No Name #20868
Calc.
Raw
168.93
112.34
28.84
26.34
53.01
149.50
0.00 250.78
 17  No Name #30710
Calc.
Raw
178.45
118.67
29.21
26.68
41.49
117.00
0.00 249.15
 18  No Name #18218
Calc.
Raw
162.90
108.33
29.20
26.67
55.05
155.25
0.00 247.15
 19  No Name #30686
Calc.
Raw
150.39
100.01
42.34
38.67
50.89
143.50
0.00 243.62
 19  No Name #31852
Calc.
Raw
156.90
104.34
36.13
33.00
50.35
142.00
0.00 243.38
 20  No Name #32184
Calc.
Raw
144.87
96.34
30.29
27.67
67.20
189.50
0.00 242.36
 20  No Name #11901
Calc.
Raw
151.38
100.67
33.21
30.33
57.45
162.00
0.00 242.04
 21  No Name #31696
Calc.
Raw
179.94
119.66
31.75
29.00
29.61
83.50
0.00 241.30
 22  No Name #11548
Calc.
Raw
167.43
111.34
32.84
30.00
39.27
110.75
0.00 239.54
 23  No Name #34080
Calc.
Raw
129.82
86.33
30.65
28.00
76.77
216.50
0.00 237.24
 23  No Name #31230
Calc.
Raw
162.39
107.99
31.75
29.00
42.91
121.00
0.00 237.05
 24  No Name #27796
Calc.
Raw
146.83
97.64
30.65
28.00
57.80
163.00
0.00 235.28
 25  No Name #10076
Calc.
Raw
143.86
95.67
20.07
18.33
68.53
193.25
0.00 232.46
 26  No Name #34546
Calc.
Raw
131.85
87.68
19.35
17.67
76.60
216.00
0.00 227.80
 27  No Name #9939
Calc.
Raw
159.38
105.99
29.92
27.33
36.52
103.00
0.00 225.82
 28  No Name #13304
Calc.
Raw
155.88
103.66
29.20
26.67
37.50
105.75
0.00 222.58
 28  No Name #26110
Calc.
Raw
149.35
99.32
31.75
29.00
41.31
116.50
0.00 222.41
 29  No Name #32168
Calc.
Raw
149.89
99.68
39.79
36.34
28.72
81.00
0.00 218.40
 30  No Name #33816
Calc.
Raw
127.83
85.01
27.37
25.00
61.26
172.75
0.00 216.46
 31  No Name #1715
Calc.
Raw
137.85
91.67
35.41
32.34
42.02
118.50
0.00 215.28
 31  No Name #34576
Calc.
Raw
138.33
91.99
32.48
29.67
44.33
125.00
0.00 215.14
 32  No Name #13338
Calc.
Raw
139.83
92.99
27.73
25.33
46.28
130.50
0.00 213.84
 33  No Name #31604
Calc.
Raw
139.85
93.00
31.39
28.67
40.43
114.00
0.00 211.67
 34  No Name #34082
Calc.
Raw
123.80
82.33
28.47
26.00
57.00
160.75
0.00 209.27
 35  No Name #2993
Calc.
Raw
129.32
86.00
42.34
38.67
36.52
103.00
0.00 208.18
 35  No Name #32909
Calc.
Raw
140.33
93.32
27.74
25.34
39.45
111.25
0.00 207.52
 36  No Name #35698
Calc.
Raw
121.31
80.67
19.35
17.67
61.61
173.75
0.00 202.27
 36  No Name #35687
Calc.
Raw
143.37
95.34
18.25
16.67
50.09
141.25
10.00 201.71
 36  No Name #20184
Calc.
Raw
119.82
79.68
34.31
31.34
47.52
134.00
0.00 201.65
 37  No Name #20480
Calc.
Raw
130.33
86.67
25.18
23.00
44.33
125.00
0.00 199.84
 38  No Name #3422
Calc.
Raw
118.77
78.98
32.11
29.33
56.74
160.00
10.00 197.62
 39  No Name #22504
Calc.
Raw
119.31
79.34
32.11
29.33
40.16
113.25
0.00 191.58
 40  No Name #33946
Calc.
Raw
128.83
85.67
28.11
25.68
29.17
82.25
0.00 186.11
 41  No Name #35337
Calc.
Raw
118.27
78.65
22.63
20.67
42.11
118.75
0.00 183.01
 42  No Name #15824
Calc.
Raw
111.80
74.35
27.01
24.67
29.26
82.50
0.00 168.07
 42  No Name #34897
Calc.
Raw
100.75
67.00
32.48
29.67
43.97
124.00
10.00 167.20
 43  No Name #7069
Calc.
Raw
97.25
64.67
19.35
17.67
37.32
105.25
0.00 153.92
 44  No Name #33846
Calc.
Raw
92.23
61.33
18.61
17.00
37.94
107.00
5.00 143.78
 45  No Name #35989
Calc.
Raw
78.18
51.99
13.14
12.00
32.00
90.25
0.00 123.32
 Problem 1 The Great Parade Division III
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #18255
Calc.
Raw
200.00
159.33
28.98
24.34
79.53
68.00
0.00 308.51
 2  No Name #33488
Calc.
Raw
166.11
132.33
37.70
31.67
100.00
85.50
0.00 303.81
 3  No Name #9744
Calc.
Raw
176.15
140.33
41.29
34.68
74.27
63.50
0.00 291.71
 4  No Name #27017
Calc.
Raw
187.03
149.00
50.00
42.00
29.24
25.00
0.00 266.27
 5  No Name #35550
Calc.
Raw
167.36
133.33
26.60
22.34
71.05
60.75
0.00 265.01
 6  No Name #26200
Calc.
Raw
165.68
131.99
40.88
34.34
56.43
48.25
0.00 262.99
 7  No Name #9116
Calc.
Raw
182.01
145.00
33.73
28.33
44.15
37.75
0.00 259.89
 8  No Name #291
Calc.
Raw
169.05
134.67
32.15
27.01
54.68
46.75
0.00 255.88
 9  No Name #24553
Calc.
Raw
140.20
111.69
41.27
34.67
66.37
56.75
0.00 247.84
 9  No Name #31230
Calc.
Raw
166.86
132.93
38.50
32.34
42.40
36.25
0.00 247.76
 10  No Name #32441
Calc.
Raw
147.29
117.34
38.11
32.01
59.65
51.00
0.00 245.05
 11  No Name #3887
Calc.
Raw
159.00
126.67
32.94
27.67
46.49
39.75
0.00 238.43
 12  No Name #33516
Calc.
Raw
149.34
118.97
30.95
26.00
54.68
46.75
0.00 234.97
 13  No Name #35901
Calc.
Raw
163.60
130.33
19.85
16.67
49.71
42.50
0.00 233.16
 14  No Name #4307
Calc.
Raw
150.63
120.00
35.32
29.67
40.64
34.75
0.00 226.59
 15  No Name #5730
Calc.
Raw
142.28
113.35
25.81
21.68
57.02
48.75
0.00 225.11
 15  No Name #1149
Calc.
Raw
129.69
103.32
40.08
33.67
54.68
46.75
0.00 224.45
 16  No Name #2215
Calc.
Raw
139.74
111.32
25.80
21.67
57.31
49.00
0.00 222.85
 16  No Name #35621
Calc.
Raw
116.74
93.00
30.15
25.33
75.15
64.25
0.00 222.04
 17  No Name #35824
Calc.
Raw
115.06
91.66
23.40
19.66
83.04
71.00
0.00 221.50
 18  No Name #1412
Calc.
Raw
124.67
99.32
21.42
17.99
73.10
62.50
0.00 219.19
 19  No Name #27336
Calc.
Raw
97.91
78.00
30.15
25.33
84.80
72.50
0.00 212.86
 20  No Name #35509
Calc.
Raw
130.53
103.99
34.92
29.33
42.40
36.25
0.00 207.85
 20  No Name #31161
Calc.
Raw
125.91
100.31
18.64
15.66
62.87
53.75
0.00 207.42
 21  No Name #35880
Calc.
Raw
124.71
99.35
36.12
30.34
38.60
33.00
0.00 199.43
 22  No Name #35430
Calc.
Raw
100.03
79.69
16.65
13.99
75.15
64.25
0.00 191.83
 23  No Name #33323
Calc.
Raw
99.15
78.99
29.37
24.67
59.65
51.00
0.00 188.17
 24  No Name #33986
Calc.
Raw
102.10
81.34
38.50
32.34
43.57
37.25
0.00 184.17
 25  No Name #3047
Calc.
Raw
134.71
107.32
23.42
19.67
24.85
21.25
0.00 182.98
 25  No Name #11392
Calc.
Raw
123.43
98.33
14.29
12.00
44.74
38.25
0.00 182.46
 26  No Name #29482
Calc.
Raw
133.87
106.65
24.21
20.34
20.76
17.75
0.00 178.84
 27  No Name #7975
Calc.
Raw
97.92
78.01
26.20
22.01
48.25
41.25
0.00 172.37
 28  No Name #8888
Calc.
Raw
106.30
84.68
22.21
18.66
42.11
36.00
0.00 170.62
 29  No Name #1386
Calc.
Raw
78.24
62.33
29.76
25.00
55.56
47.50
0.00 163.56
 29  No Name #30595
Calc.
Raw
108.37
86.33
24.61
20.67
30.41
26.00
0.00 163.39
 30  No Name #16610
Calc.
Raw
111.73
89.01
26.58
22.33
18.42
15.75
0.00 156.73
 31  No Name #24436
Calc.
Raw
46.87
37.34
19.05
16.00
83.92
71.75
0.00 149.84
 32  No Name #11753
Calc.
Raw
81.99
65.32
17.86
15.00
21.05
18.00
0.00 120.90
 33  No Name #36007
Calc.
Raw
46.46
37.01
28.57
24.00
32.16
27.50
0.00 107.19
 34  No Name #35428
Calc.
Raw
89.12
71.00
15.88
13.34
22.22
19.00
30.00 97.22
 35  No Name #5144
Calc.
Raw
26.77
21.33
15.08
12.67
41.81
35.75
0.00 83.66
 Problem 1 The Great Parade Division IV
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #35754
Calc.
Raw
200.00
83.35
50.00
18.67
100.00
81.67
0.00 350.00