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 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