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