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 2 Tech Transfer Division I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #34094
 Calc.
Raw		 200.00
160.50		 46.79
34.00		 92.73
97.67		 0.00 339.52
 2  No Name #532
 Calc.
Raw		 191.28
153.50		 48.17
35.00		 78.49
82.67		 0.00 317.94
 3  No Name #18112
 Calc.
Raw		 188.16
151.00		 37.63
27.34		 82.28
86.67		 0.00 308.07
 4  No Name #35403
 Calc.
Raw		 179.44
144.00		 33.03
24.00		 89.88
94.67		 0.00 302.35
 5  No Name #17473
 Calc.
Raw		 176.95
142.00		 33.04
24.01		 91.14
96.00		 0.00 301.13
 6  No Name #10061
 Calc.
Raw		 170.09
136.50		 40.83
29.67		 88.61
93.33		 0.00 299.53
 7  No Name #3260
 Calc.
Raw		 177.57
142.50		 50.00
36.33		 69.62
73.33		 0.00 297.19
 7  No Name #34123
 Calc.
Raw		 171.34
137.50		 42.21
30.67		 83.55
88.00		 0.00 297.10
 8  No Name #5128
 Calc.
Raw		 170.72
137.00		 33.03
24.00		 83.86
88.33		 0.00 287.61
 9  No Name #26347
 Calc.
Raw		 177.57
142.50		 42.21
30.67		 63.30
66.67		 0.00 283.08
 10  No Name #18449
 Calc.
Raw		 164.49
132.00		 33.03
24.00		 81.01
85.33		 0.00 278.53
 11  No Name #35803
 Calc.
Raw		 173.21
139.00		 31.65
23.00		 72.15
76.00		 0.00 277.01
 12  No Name #34504
 Calc.
Raw		 160.12
128.50		 30.28
22.00		 82.28
86.67		 0.00 272.68
 13  No Name #30179
 Calc.
Raw		 171.96
138.00		 36.71
26.67		 62.02
65.33		 0.00 270.69
 14  No Name #27122
 Calc.
Raw		 165.11
132.50		 24.77
18.00		 79.75
84.00		 0.00 269.63
 15  No Name #30361
 Calc.
Raw		 165.11
132.50		 28.90
21.00		 73.42
77.33		 0.00 267.43
 16  No Name #34829
 Calc.
Raw		 166.36
133.50		 25.23
18.33		 73.42
77.33		 0.00 265.01
 17  No Name #35282
 Calc.
Raw		 165.11
132.50		 29.34
21.32		 68.36
72.00		 0.00 262.81
 18  No Name #36008
 Calc.
Raw		 171.96
138.00		 29.37
21.34		 58.23
61.33		 0.00 259.56
 19  No Name #1500
 Calc.
Raw		 142.68
114.50		 31.20
22.67		 83.55
88.00		 0.00 257.43
 20  No Name #34320
 Calc.
Raw		 148.91
119.50		 35.33
25.67		 70.89
74.67		 0.00 255.13
 20  No Name #2272
 Calc.
Raw		 163.24
131.00		 30.73
22.33		 60.76
64.00		 0.00 254.73
 21  No Name #31305
 Calc.
Raw		 151.40
121.50		 34.41
25.00		 67.09
70.67		 0.00 252.90
 22  No Name #35667
 Calc.
Raw		 171.34
137.50		 31.65
23.00		 48.11
50.67		 1.00 250.10
 22  No Name #35666
 Calc.
Raw		 156.39
125.50		 28.45
20.67		 64.56
68.00		 0.00 249.40
 23  No Name #12534
 Calc.
Raw		 157.63
126.50		 23.40
17.00		 67.09
70.67		 0.00 248.12
 24  No Name #9971
 Calc.
Raw		 150.16
120.50		 27.98
20.33		 68.36
72.00		 0.00 246.50
 24  No Name #34399
 Calc.
Raw		 152.02
122.00		 33.48
24.33		 60.76
64.00		 0.00 246.26
 24  No Name #2746
 Calc.
Raw		 123.36
99.00		 38.08
27.67		 84.81
89.33		 0.00 246.25
 25  No Name #715
 Calc.
Raw		 146.42
117.50		 22.96
16.68		 75.95
80.00		 0.00 245.33
 26  No Name #1011
 Calc.
Raw		 163.24
131.00		 27.07
19.67		 51.90
54.67		 0.00 242.21
 27  No Name #45
 Calc.
Raw		 157.63
126.50		 27.07
19.67		 51.90
54.67		 0.00 236.60
 28  No Name #35502
 Calc.
Raw		 141.43
113.50		 23.41
17.01		 68.99
72.67		 0.00 233.83
 29  No Name #1859
 Calc.
Raw		 129.60
104.00		 33.48
24.33		 67.09
70.67		 0.00 230.17
 30  No Name #35834
 Calc.
Raw		 130.22
104.50		 34.87
25.34		 56.96
60.00		 0.00 222.05
 31  No Name #35869
 Calc.
Raw		 165.11
132.50		 31.65
23.00		 18.99
20.00		 0.00 215.75
 32  No Name #14485
 Calc.
Raw		 94.08
75.50		 37.63
27.34		 81.01
85.33		 0.00 212.72
 33  No Name #35342
 Calc.
Raw		 69.78
56.00		 40.83
29.67		 100.00
105.33		 0.00 210.61
 34  No Name #35727
 Calc.
Raw		 104.67
84.00		 32.58
23.67		 69.62
73.33		 0.00 206.87
 35  No Name #15559
 Calc.
Raw		 113.40
91.00		 29.37
21.34		 56.96
60.00		 0.00 199.73
 35  No Name #33497
 Calc.
Raw		 123.36
99.00		 23.85
17.33		 53.17
56.00		 1.00 199.38
 36  No Name #33665
 Calc.
Raw		 74.77
60.00		 45.42
33.00		 82.28
86.67		 6.00 196.47
 37  No Name #31733
 Calc.
Raw		 114.64
92.00		 23.86
17.34		 55.70
58.67		 0.00 194.20
 38  No Name #31871
 Calc.
Raw		 81.62
65.50		 17.44
12.67		 92.40
97.33		 0.00 191.46
 39  No Name #28638
 Calc.
Raw		 100.93
81.00		 21.57
15.67		 56.96
60.00		 0.00 179.46
 40  No Name #24450
 Calc.
Raw		 94.70
76.00		 21.11
15.34		 59.50
62.67		 6.00 169.31
 41  No Name #35396
 Calc.
Raw		 86.60
69.50		 29.36
21.33		 49.37
52.00		 0.00 165.33
 42  No Name #8704
 Calc.
Raw		 67.29
54.00		 24.77
18.00		 67.09
70.67		 15.00 144.15
 43  No Name #35198
 Calc.
Raw		 79.13
63.50		 8.71
6.33		 53.17
56.00		 0.00 141.01
 Problem 2 Tech Transfer Division II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #29726
 Calc.
Raw		 178.05
146.00		 48.48
32.00		 95.78
204.50		 0.00 322.31
 2  No Name #30595
 Calc.
Raw		 185.37
152.00		 40.41
26.67		 91.80
196.00		 0.00 317.58
 3  No Name #11901
 Calc.
Raw		 181.71
149.00		 46.47
30.67		 87.82
187.50		 0.00 316.00
 4  No Name #1386
 Calc.
Raw		 200.00
164.00		 42.94
28.34		 61.12
130.50		 0.00 304.06
 5  No Name #31523
 Calc.
Raw		 175.61
144.00		 37.38
24.67		 87.70
187.25		 0.00 300.69
 6  No Name #30853
 Calc.
Raw		 184.15
151.00		 38.38
25.33		 73.77
157.50		 0.00 296.30
 7  No Name #31702
 Calc.
Raw		 170.12
139.50		 45.45
30.00		 79.51
169.75		 0.00 295.08
 8  No Name #32066
 Calc.
Raw		 183.54
150.50		 32.32
21.33		 76.70
163.75		 0.00 292.56
 8  No Name #10036
 Calc.
Raw		 195.12
160.00		 50.00
33.00		 47.07
100.50		 0.00 292.19
 9  No Name #33422
 Calc.
Raw		 157.93
129.50		 36.86
24.33		 96.72
206.50		 0.00 291.51
 10  No Name #17182
 Calc.
Raw		 188.41
154.50		 38.89
25.67		 61.94
132.25		 0.00 289.24
 11  No Name #1375
 Calc.
Raw		 187.80
154.00		 37.88
25.00		 61.94
132.25		 0.00 287.62
 11  No Name #29467
 Calc.
Raw		 181.10
148.50		 44.44
29.33		 61.36
131.00		 0.00 286.90
 12  No Name #18227
 Calc.
Raw		 185.98
152.50		 44.44
29.33		 54.33
116.00		 0.00 284.75
 13  No Name #10414
 Calc.
Raw		 186.59
153.00		 36.86
24.33		 53.51
114.25		 0.00 276.96
 13  No Name #2344
 Calc.
Raw		 154.88
127.00		 33.83
22.33		 88.88
189.75		 1.00 276.59
 13  No Name #11324
 Calc.
Raw		 155.49
127.50		 20.71
13.67		 100.00
213.50		 0.00 276.20
 14  No Name #34422
 Calc.
Raw		 162.20
133.00		 31.82
21.00		 73.42
156.75		 0.00 267.44
 14  No Name #34983
 Calc.
Raw		 155.49
127.50		 32.33
21.34		 81.26
173.50		 2.00 267.08
 15  No Name #35139
 Calc.
Raw		 137.80
113.00		 28.80
19.01		 97.42
208.00		 0.00 264.02
 15  No Name #34760
 Calc.
Raw		 160.37
131.50		 34.35
22.67		 72.48
154.75		 4.00 263.20
 16  No Name #3249
 Calc.
Raw		 175.61
144.00		 44.44
29.33		 36.89
78.75		 0.00 256.94
 16  No Name #2269
 Calc.
Raw		 179.27
147.00		 34.85
23.00		 42.74
91.25		 0.00 256.86
 17  No Name #31161
 Calc.
Raw		 172.56
141.50		 31.32
20.67		 51.76
110.50		 0.00 255.64
 17  No Name #28695
 Calc.
Raw		 170.73
140.00		 37.88
25.00		 66.51
142.00		 20.00 255.12
 17  No Name #34175
 Calc.
Raw		 164.63
135.00		 32.32
21.33		 60.77
129.75		 3.00 254.72
 18  No Name #9361
 Calc.
Raw		 145.73
119.50		 26.27
17.34		 82.20
175.50		 0.00 254.20
 19  No Name #10680
 Calc.
Raw		 125.61
103.00		 38.88
25.66		 87.94
187.75		 0.00 252.43
 20  No Name #21101
 Calc.
Raw		 150.61
123.50		 27.79
18.34		 68.97
147.25		 0.00 247.37
 21  No Name #31230
 Calc.
Raw		 107.93
88.50		 36.86
24.33		 98.24
209.75		 0.00 243.03
 21  No Name #31873
 Calc.
Raw		 137.80
113.00		 21.73
14.34		 82.67
176.50		 0.00 242.20
 22  No Name #31912
 Calc.
Raw		 176.83
145.00		 36.88
24.34		 24.36
52.00		 0.00 238.07
 23  No Name #35907
 Calc.
Raw		 131.10
107.50		 21.21
14.00		 84.31
180.00		 0.00 236.62
 24  No Name #32908
 Calc.
Raw		 167.07
137.00		 34.33
22.66		 32.55
69.50		 0.00 233.95
 25  No Name #35647
 Calc.
Raw		 143.90
118.00		 25.76
17.00		 62.76
134.00		 2.00 230.42
 26  No Name #31604
 Calc.
Raw		 101.22
83.00		 31.82
21.00		 94.38
201.50		 0.00 227.42
 27  No Name #35658
 Calc.
Raw		 106.10
87.00		 28.79
19.00		 90.87
194.00		 0.00 225.76
 28  No Name #16559
 Calc.
Raw		 132.93
109.00		 17.68
11.67		 67.80
144.75		 1.00 217.41
 29  No Name #2437
 Calc.
Raw		 126.83
104.00		 32.85
21.68		 51.64
110.25		 0.00 211.32
 30  No Name #35576
 Calc.
Raw		 144.51
118.50		 22.73
15.00		 32.08
68.50		 0.00 199.32
 30  No Name #468
 Calc.
Raw		 130.49
107.00		 41.92
27.67		 26.93
57.50		 1.00 198.34
 31  No Name #33017
 Calc.
Raw		 143.90
118.00		 22.23
14.67		 30.33
64.75		 0.00 196.46
 32  No Name #30749
 Calc.
Raw		 101.22
83.00		 34.35
22.67		 83.61
178.50		 25.00 194.18
 32  No Name #34811
 Calc.
Raw		 114.63
94.00		 38.89
25.67		 40.40
86.25		 0.00 193.92
 32  No Name #23293
 Calc.
Raw		 87.20
71.50		 31.82
21.00		 74.59
159.25		 0.00 193.61
 32  No Name #13791
 Calc.
Raw		 146.34
120.00		 43.94
29.00		 28.22
60.25		 25.00 193.50
 33  No Name #10706
 Calc.
Raw		 120.12
98.50		 32.83
21.67		 38.76
82.75		 0.00 191.71
 34  No Name #20708
 Calc.
Raw		 73.17
60.00		 26.26
17.33		 86.53
184.75		 0.00 185.96
 35  No Name #11548
 Calc.
Raw		 107.93
88.50		 39.89
26.33		 33.14
70.75		 0.00 180.96
 36  No Name #25320
 Calc.
Raw		 89.63
73.50		 38.88
25.66		 49.41
105.50		 0.00 177.92
 37  No Name #32743
 Calc.
Raw		 55.49
45.50		 17.68
11.67		 97.54
208.25		 1.00 169.71
 37  No Name #22248
 Calc.
Raw		 119.51
98.00		 18.20
12.01		 33.14
70.75		 2.00 168.85
 38  No Name #789
 Calc.
Raw		 71.34
58.50		 43.94
29.00		 42.04
89.75		 1.00 156.32
 39  No Name #32199
 Calc.
Raw		 67.68
55.50		 25.76
17.00		 35.71
76.25		 15.00 114.15
 Problem 2 Tech Transfer Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #30358
 Calc.
Raw		 198.80
165.00		 48.23
36.34		 96.78
80.33		 0.00 343.81
 2  No Name #10619
 Calc.
Raw		 194.58
161.50		 44.24
33.33		 95.18
79.00		 0.00 334.00
 3  No Name #11519
 Calc.
Raw		 187.35
155.50		 45.13
34.00		 100.00
83.00		 0.00 332.48
 4  No Name #34393
 Calc.
Raw		 200.00
166.00		 46.46
35.00		 69.48
57.67		 0.00 315.94
 5  No Name #10527
 Calc.
Raw		 171.08
142.00		 48.23
36.34		 95.18
79.00		 0.00 314.49
 6  No Name #381
 Calc.
Raw		 168.67
140.00		 46.00
34.66		 98.40
81.67		 10.00 303.07
 7  No Name #3473
 Calc.
Raw		 176.51
146.50		 41.60
31.34		 79.12
65.67		 0.00 297.23
 8  No Name #35519
 Calc.
Raw		 168.07
139.50		 41.13
30.99		 88.76
73.67		 2.00 295.96
 8  No Name #3260
 Calc.
Raw		 186.75
155.00		 42.47
32.00		 66.27
55.00		 0.00 295.49
 8  No Name #35792
 Calc.
Raw		 165.06
137.00		 42.93
32.34		 87.14
72.33		 0.00 295.13
 9  No Name #35758
 Calc.
Raw		 179.52
149.00		 27.44
20.67		 91.96
76.33		 5.00 293.92
 10  No Name #34810
 Calc.
Raw		 190.36
158.00		 33.18
25.00		 67.87
56.33		 0.00 291.41
 11  No Name #32441
 Calc.
Raw		 166.27
138.00		 31.42
23.67		 91.96
76.33		 0.00 289.65
 11  No Name #30049
 Calc.
Raw		 175.30
145.50		 33.18
25.00		 80.72
67.00		 0.00 289.20
 12  No Name #5736
 Calc.
Raw		 193.98
161.00		 42.02
31.66		 50.20
41.67		 0.00 286.20
 12  No Name #31043
 Calc.
Raw		 192.17
159.50		 38.07
28.68		 58.23
48.33		 3.00 285.47
 13  No Name #33084
 Calc.
Raw		 183.13
152.00		 30.54
23.01		 71.08
59.00		 0.00 284.75
 14  No Name #33516
 Calc.
Raw		 175.90
146.00		 36.29
27.34		 67.87
56.33		 0.00 280.06
 14  No Name #31579
 Calc.
Raw		 153.61
127.50		 37.60
28.33		 88.76
73.67		 0.00 279.97
 14  No Name #8496
 Calc.
Raw		 162.05
134.50		 26.97
20.32		 90.36
75.00		 0.00 279.38
 15  No Name #19945
 Calc.
Raw		 173.49
144.00		 35.40
26.67		 64.66
53.67		 0.00 273.55
 15  No Name #11172
 Calc.
Raw		 166.87
138.50		 31.87
24.01		 74.30
61.67		 0.00 273.04
 16  No Name #33393
 Calc.
Raw		 124.10
103.00		 50.00
37.67		 93.58
77.67		 0.00 267.68
 17  No Name #33640
 Calc.
Raw		 146.39
121.50		 43.35
32.66		 74.30
61.67		 3.00 261.04
 17  No Name #34812
 Calc.
Raw		 165.06
137.00		 35.39
26.66		 70.28
58.33		 10.00 260.73
 18  No Name #30951
 Calc.
Raw		 121.08
100.50		 38.04
28.66		 96.78
80.33		 0.00 255.90
 19  No Name #31161
 Calc.
Raw		 148.19
123.00		 30.08
22.66		 83.53
69.33		 10.00 251.80
 20  No Name #20135
 Calc.
Raw		 154.22
128.00		 36.73
27.67		 66.27
55.00		 10.00 247.22
 21  No Name #5404
 Calc.
Raw		 122.89
102.00		 47.33
35.66		 79.12
65.67		 5.00 244.34
 21  No Name #32530
 Calc.
Raw		 140.96
117.00		 32.29
24.33		 71.08
59.00		 0.00 244.33
 22  No Name #17068
 Calc.
Raw		 126.51
105.00		 32.74
24.67		 79.12
65.67		 0.00 238.37
 23  No Name #14231
 Calc.
Raw		 113.25
94.00		 38.93
29.33		 79.12
65.67		 0.00 231.30
 24  No Name #30883
 Calc.
Raw		 104.82
87.00		 33.18
25.00		 80.72
67.00		 0.00 218.72
 25  No Name #35545
 Calc.
Raw		 123.49
102.50		 34.06
25.66		 58.23
48.33		 0.00 215.78
 25  No Name #15074
 Calc.
Raw		 101.20
84.00		 44.21
33.31		 69.48
57.67		 0.00 214.89
 26  No Name #1412
 Calc.
Raw		 124.70
103.50		 28.31
21.33		 62.65
52.00		 10.00 205.66
 27  No Name #8871
 Calc.
Raw		 98.19
81.50		 34.52
26.01		 69.48
57.67		 0.00 202.19
 28  No Name #6905
 Calc.
Raw		 78.92
65.50		 38.49
29.00		 82.33
68.33		 5.00 194.74
 28  No Name #28292
 Calc.
Raw		 92.77
77.00		 33.63
25.34		 67.47
56.00		 0.00 193.87
 29  No Name #11606
 Calc.
Raw		 105.42
87.50		 31.84
23.99		 49.00
40.67		 0.00 186.26
 30  No Name #6379
 Calc.
Raw		 70.48
58.50		 29.64
22.33		 66.27
55.00		 0.00 166.39