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 2008 May 31st
 Problem 3 The Wonderful Muses Division II
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #31225
Calc.
Raw
200.00
155.25
40.47
28.33
100.00
175.50
0.00 340.47
 2  No Name #29696
Calc.
Raw
189.37
147.00
48.10
33.67
83.62
146.75
0.00 321.09
 3  No Name #22311
Calc.
Raw
191.95
149.00
49.04
34.33
76.35
134.00
4.00 313.34
 4  No Name #37403
Calc.
Raw
175.20
136.00
49.53
34.67
81.77
143.50
0.00 306.50
 5  No Name #35456
Calc.
Raw
186.15
144.50
45.71
32.00
73.36
128.75
0.00 305.22
 6  No Name #1901
Calc.
Raw
168.76
131.00
43.81
30.67
89.46
157.00
0.00 302.03
 6  No Name #29596
Calc.
Raw
173.27
134.50
50.00
35.00
77.92
136.75
0.00 301.19
 7  No Name #9745
Calc.
Raw
189.69
147.25
39.53
27.67
68.23
119.75
0.00 297.45
 8  No Name #26609
Calc.
Raw
177.13
137.50
27.61
19.33
88.89
156.00
0.00 293.63
 9  No Name #36715
Calc.
Raw
183.25
142.25
50.00
35.00
58.97
103.50
0.00 292.22
 10  No Name #34894
Calc.
Raw
177.78
138.00
34.29
24.00
78.35
137.50
0.00 290.42
 10  No Name #36617
Calc.
Raw
184.22
143.00
37.14
26.00
68.80
120.75
0.00 290.16
 11  No Name #21059
Calc.
Raw
192.27
149.25
29.04
20.33
67.38
118.25
0.00 288.69
 12  No Name #30780
Calc.
Raw
184.86
143.50
48.57
34.00
53.13
93.25
0.00 286.56
 13  No Name #3260
Calc.
Raw
172.95
134.25
33.33
23.33
77.78
136.50
0.00 284.06
 13  No Name #22248
Calc.
Raw
178.10
138.25
32.39
22.67
75.36
132.25
2.00 283.85
 13  No Name #13927
Calc.
Raw
180.03
139.75
31.90
22.33
71.51
125.50
0.00 283.44
 14  No Name #35343
Calc.
Raw
179.07
139.00
24.29
17.00
79.20
139.00
0.00 282.56
 15  No Name #11781
Calc.
Raw
163.29
126.75
34.76
24.33
80.34
141.00
0.00 278.39
 16  No Name #2342
Calc.
Raw
176.81
137.25
40.47
28.33
59.69
104.75
0.00 276.97
 17  No Name #28600
Calc.
Raw
177.46
137.75
41.90
29.33
55.98
98.25
0.00 275.34
 18  No Name #37089
Calc.
Raw
186.15
144.50
35.24
24.67
52.71
92.50
0.00 274.10
 18  No Name #35848
Calc.
Raw
165.86
128.75
42.39
29.67
65.67
115.25
0.00 273.92
 19  No Name #30532
Calc.
Raw
163.61
127.00
36.19
25.33
71.65
125.75
0.00 271.45
 20  No Name #33407
Calc.
Raw
175.20
136.00
42.86
30.00
49.29
86.50
0.00 267.35
 21  No Name #11901
Calc.
Raw
168.44
130.75
25.71
18.00
70.66
124.00
0.00 264.81
 22  No Name #37478
Calc.
Raw
169.08
131.25
41.43
29.00
51.57
90.50
0.00 262.08
 23  No Name #34083
Calc.
Raw
163.61
127.00
43.33
30.33
53.28
93.50
0.00 260.22
 24  No Name #12905
Calc.
Raw
165.22
128.25
32.86
23.00
61.11
107.25
0.00 259.19
 24  No Name #33416
Calc.
Raw
154.27
119.75
28.10
19.67
76.64
134.50
0.00 259.01
 24  No Name #36629
Calc.
Raw
165.22
128.25
26.67
18.67
66.52
116.75
0.00 258.41
 25  No Name #29564
Calc.
Raw
169.40
131.50
13.81
9.67
74.50
130.75
0.00 257.71
 25  No Name #30867
Calc.
Raw
176.81
137.25
27.14
19.00
67.81
119.00
15.00 256.76
 26  No Name #15417
Calc.
Raw
159.42
123.75
34.29
24.00
67.38
118.25
10.00 251.09
 26  No Name #34557
Calc.
Raw
173.27
134.50
33.33
23.33
44.02
77.25
0.00 250.62
 26  No Name #32251
Calc.
Raw
172.95
134.25
28.57
20.00
48.72
85.50
0.00 250.24
 27  No Name #30515
Calc.
Raw
160.71
124.75
41.43
29.00
48.72
85.50
1.00 249.86
 27  No Name #232
Calc.
Raw
155.56
120.75
44.76
31.33
49.15
86.25
0.00 249.47
 28  No Name #35511
Calc.
Raw
156.52
121.50
20.47
14.33
70.23
123.25
0.00 247.22
 29  No Name #3421
Calc.
Raw
153.62
119.25
33.33
23.33
58.69
103.00
0.00 245.64
 29  No Name #30469
Calc.
Raw
143.32
111.25
30.96
21.67
70.80
124.25
0.00 245.08
 30  No Name #36548
Calc.
Raw
149.11
115.75
26.19
18.33
69.23
121.50
0.00 244.53
 31  No Name #11548
Calc.
Raw
156.84
121.75
42.39
29.67
43.16
75.75
0.00 242.39
 31  No Name #30126
Calc.
Raw
138.49
107.50
36.19
25.33
72.65
127.50
5.00 242.33
 32  No Name #34916
Calc.
Raw
166.18
129.00
29.04
20.33
44.59
78.25
0.00 239.81
 32  No Name #20480
Calc.
Raw
151.05
117.25
23.81
16.67
64.81
113.75
0.00 239.67
 33  No Name #36211
Calc.
Raw
154.59
120.00
31.43
22.00
52.28
91.75
0.00 238.30
 33  No Name #37368
Calc.
Raw
153.95
119.50
25.71
18.00
58.26
102.25
0.00 237.92
 34  No Name #37730
Calc.
Raw
152.66
118.50
13.33
9.33
63.68
111.75
0.00 229.67
 35  No Name #33979
Calc.
Raw
136.55
106.00
14.29
10.00
77.49
136.00
0.00 228.33
 36  No Name #10595
Calc.
Raw
145.25
112.75
16.67
11.67
64.96
114.00
0.00 226.88
 37  No Name #28239
Calc.
Raw
111.76
86.75
34.76
24.33
79.34
139.25
0.00 225.86
 37  No Name #35883
Calc.
Raw
144.93
112.50
22.86
16.00
57.69
101.25
0.00 225.48
 38  No Name #36756
Calc.
Raw
145.89
113.25
30.00
21.00
43.73
76.75
0.00 219.62
 39  No Name #19185
Calc.
Raw
145.25
112.75
15.24
10.67
53.56
94.00
0.00 214.05
 39  No Name #37856
Calc.
Raw
151.37
117.50
27.14
19.00
36.75
64.50
2.00 213.26
 40  No Name #19568
Calc.
Raw
131.40
102.00
12.86
9.00
56.84
99.75
2.00 199.10