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 4 Geometry Structure Division III
 Rank   Member    Long
Term
 Weight  Style  Spont  Penalty  Total
 1  No Name #2660
Calc.
Raw
190.52
37.00
150.00
980.00
38.49
35.67
77.95
137.00
10.00 296.96
 2  No Name #7158
Calc.
Raw
166.07
43.33
118.62
775.00
48.55
45.00
79.37
139.50
0.00 293.99
 3  No Name #2130
Calc.
Raw
167.86
38.67
125.51
820.00
42.80
39.67
78.81
138.50
0.00 289.47
 4  No Name #32995
Calc.
Raw
160.59
38.33
118.62
775.00
41.00
38.00
75.11
132.00
0.00 276.70
 5  No Name #11102
Calc.
Raw
158.64
39.34
115.56
755.00
38.84
36.00
76.39
134.25
0.00 273.87
 6  No Name #20368
Calc.
Raw
149.49
45.66
99.49
650.00
49.28
45.67
70.55
124.00
0.00 269.32
 7  No Name #17473
Calc.
Raw
139.27
36.33
99.49
650.00
41.37
38.34
87.20
153.25
0.00 267.84
 8  No Name #34398
Calc.
Raw
157.32
35.34
118.62
775.00
44.24
41.00
59.60
104.75
0.00 261.16
 9  No Name #3637
Calc.
Raw
188.80
40.33
144.64
945.00
39.20
36.33
27.88
49.00
0.00 255.88
 10  No Name #2680
Calc.
Raw
124.90
26.00
96.43
630.00
30.58
28.34
97.87
172.00
0.00 253.35
 11  No Name #5109
Calc.
Raw
172.60
43.00
125.51
820.00
48.91
45.33
21.48
37.75
0.00 242.99
 12  No Name #19945
Calc.
Raw
116.31
29.34
84.18
550.00
41.72
38.67
80.94
142.25
0.00 238.97
 13  No Name #26200
Calc.
Raw
127.09
42.67
80.36
525.00
46.04
42.67
63.73
112.00
0.00 236.86
 14  No Name #22063
Calc.
Raw
142.86
41.00
97.96
640.00
47.12
43.67
44.95
79.00
0.00 234.93
 15  No Name #24409
Calc.
Raw
107.78
31.33
73.47
480.00
43.52
40.33
79.94
140.50
0.00 231.24
 16  No Name #32374
Calc.
Raw
106.91
33.33
70.41
460.00
42.44
39.33
68.28
120.00
0.00 217.63
 16  No Name #34619
Calc.
Raw
97.96
43.33
50.51
330.00
50.00
46.34
68.85
121.00
0.00 216.81
 17  No Name #34281
Calc.
Raw
71.54
36.67
31.38
205.00
44.61
41.34
100.00
175.75
0.00 216.15
 18  No Name #32435
Calc.
Raw
118.79
33.00
82.65
540.00
35.25
32.67
53.63
94.25
0.00 207.67
 19  No Name #31161
Calc.
Raw
98.56
32.00
63.52
415.00
34.18
31.68
68.85
121.00
0.00 201.59
 20  No Name #1269
Calc.
Raw
132.32
37.67
91.07
595.00
42.44
39.33
23.04
40.50
0.00 197.80
 21  No Name #19633
Calc.
Raw
91.57
34.00
54.34
355.00
38.12
35.33
66.86
117.50
0.00 196.55
 21  No Name #3887
Calc.
Raw
114.90
34.34
77.30
505.00
42.80
39.67
38.69
68.00
0.00 196.39
 22  No Name #17250
Calc.
Raw
52.76
37.00
12.24
80.00
42.45
39.34
98.29
172.75
0.00 193.50
 23  No Name #34807
Calc.
Raw
89.33
32.66
53.57
350.00
42.08
39.00
59.89
105.25
0.00 191.30
 24  No Name #32441
Calc.
Raw
91.69
39.00
48.98
320.00
42.08
39.00
55.90
98.25
0.00 189.67
 24  No Name #13641
Calc.
Raw
96.39
37.00
55.87
365.00
35.25
32.67
57.89
101.75
0.00 189.53
 25  No Name #26319
Calc.
Raw
81.53
28.33
50.51
330.00
38.49
35.67
66.86
117.50
0.00 186.88
 26  No Name #14588
Calc.
Raw
124.76
35.66
85.71
560.00
38.49
35.67
22.62
39.75
0.00 185.87
 26  No Name #3069
Calc.
Raw
117.71
39.00
75.00
490.00
44.59
41.33
23.47
41.25
0.00 185.77
 27  No Name #21439
Calc.
Raw
81.51
36.00
42.09
275.00
40.29
37.34
58.61
103.00
0.00 180.41
 27  No Name #33343
Calc.
Raw
116.72
36.00
77.30
505.00
41.37
38.34
21.91
38.50
0.00 180.00
 28  No Name #30049
Calc.
Raw
111.61
38.33
69.64
455.00
43.17
40.01
20.34
35.75
0.00 175.12
 28  No Name #34806
Calc.
Raw
87.20
37.00
46.68
305.00
41.72
38.67
60.60
106.50
15.00 174.52
 29  No Name #32497
Calc.
Raw
100.83
39.66
57.40
375.00
47.83
44.33
21.91
38.50
0.00 170.57
 30  No Name #15515
Calc.
Raw
94.99
34.33
57.40
375.00
42.80
39.67
28.17
49.50
0.00 165.96
 31  No Name #35739
Calc.
Raw
97.43
38.66
55.10
360.00
43.16
40.00
21.05
37.00
0.00 161.64
 32  No Name #3473
Calc.
Raw
103.70
29.00
71.94
470.00
33.82
31.34
22.05
38.75
0.00 159.57
 33  No Name #17068
Calc.
Raw
103.96
31.34
69.64
455.00
34.53
32.00
19.77
34.75
0.00 158.26
 34  No Name #31228
Calc.
Raw
80.14
40.34
35.97
235.00
42.08
39.00
29.30
51.50
0.00 151.52
 35  No Name #32868
Calc.
Raw
81.34
39.33
38.27
250.00
40.65
37.67
25.18
44.25
0.00 147.17
 36  No Name #2149
Calc.
Raw
177.67
41.34
132.40
865.00
46.76
43.34
21.48
37.75
100.00 145.91
 37  No Name #786
Calc.
Raw
85.21
38.67
42.86
280.00
41.72
38.67
14.51
25.50
0.00 141.44
 38  No Name #2039
Calc.
Raw
65.46
28.33
34.44
225.00
34.89
32.34
21.62
38.00
0.00 121.97
 39  No Name #17622
Calc.
Raw
66.42
32.00
31.38
205.00
29.86
27.67
22.33
39.25
0.00 118.61
 40  No Name #33116
Calc.
Raw
43.35
27.00
13.78
90.00
35.97
33.34
24.18
42.50
0.00 103.50
 40  No Name #30579
Calc.
Raw
46.19
31.00
12.24
80.00
37.05
34.34
19.63
34.50
0.00 102.87
   No Name #35342
Calc.
Raw
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00