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 3 Ancient Egypt Division II
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #29584
Calc.
Raw
200.00
136.75
50.00
32.67
82.74
102.33
0.00 332.74
 2  No Name #16756
Calc.
Raw
190.86
130.50
29.08
19.00
95.68
118.33
0.00 315.62
 3  No Name #31225
Calc.
Raw
182.82
125.00
46.43
30.34
80.59
99.67
0.00 309.84
 3  No Name #18918
Calc.
Raw
193.05
132.00
34.70
22.67
81.13
100.33
0.00 308.88
 4  No Name #32785
Calc.
Raw
178.43
122.00
43.36
28.33
81.67
101.00
0.00 303.46
 4  No Name #27729
Calc.
Raw
192.69
131.75
29.08
19.00
81.67
101.00
0.00 303.44
 5  No Name #24701
Calc.
Raw
180.26
123.25
16.33
10.67
100.00
123.67
0.00 296.59
 6  No Name #25964
Calc.
Raw
178.43
122.00
36.73
24.00
79.51
98.33
0.00 294.67
 6  No Name #15677
Calc.
Raw
198.17
135.50
33.16
21.67
62.80
77.67
0.00 294.13
 7  No Name #10378
Calc.
Raw
172.58
118.00
46.43
30.34
68.73
85.00
0.00 287.74
 8  No Name #28057
Calc.
Raw
179.89
123.00
34.18
22.33
70.89
87.67
0.00 284.96
 8  No Name #35890
Calc.
Raw
175.14
119.75
31.11
20.33
78.43
97.00
0.00 284.68
 9  No Name #5471
Calc.
Raw
169.29
115.75
30.12
19.68
78.43
97.00
1.00 276.84
 10  No Name #24942
Calc.
Raw
164.90
112.75
37.74
24.66
73.04
90.33
0.00 275.68
 11  No Name #32302
Calc.
Raw
161.24
110.25
26.00
16.99
84.90
105.00
0.00 272.14
 12  No Name #35456
Calc.
Raw
170.02
116.25
26.02
17.00
74.12
91.67
0.00 270.16
 12  No Name #34894
Calc.
Raw
169.29
115.75
19.90
13.00
80.59
99.67
0.00 269.78
 12  No Name #6653
Calc.
Raw
194.15
132.75
33.16
21.67
42.05
52.00
0.00 269.36
 12  No Name #13927
Calc.
Raw
174.41
119.25
21.92
14.32
87.87
108.67
15.00 269.20
 13  No Name #36009
Calc.
Raw
165.63
113.25
16.82
10.99
86.52
107.00
0.00 268.97
 14  No Name #1140
Calc.
Raw
166.00
113.50
21.93
14.33
79.51
98.33
0.00 267.44
 15  No Name #34083
Calc.
Raw
180.99
123.75
22.96
15.00
61.19
75.67
0.00 265.14
 16  No Name #13608
Calc.
Raw
158.32
108.25
24.49
16.00
80.59
99.67
0.00 263.40
 16  No Name #4185
Calc.
Raw
159.41
109.00
23.98
15.67
79.51
98.33
0.00 262.90
 16  No Name #16142
Calc.
Raw
167.82
114.75
22.97
15.01
71.97
89.00
0.00 262.76
 17  No Name #11901
Calc.
Raw
165.63
113.25
21.93
14.33
73.58
91.00
0.00 261.14
 18  No Name #5511
Calc.
Raw
172.21
117.75
25.51
16.67
62.26
77.00
0.00 259.98
 19  No Name #32600
Calc.
Raw
159.41
109.00
19.90
13.00
78.43
97.00
0.00 257.74
 19  No Name #35308
Calc.
Raw
167.82
114.75
33.69
22.01
55.25
68.33
0.00 256.76
 20  No Name #34803
Calc.
Raw
160.51
109.75
24.99
16.33
68.73
85.00
0.00 254.23
 20  No Name #2465
Calc.
Raw
165.27
113.00
24.49
16.00
64.42
79.67
0.00 254.18
 20  No Name #32570
Calc.
Raw
136.01
93.00
41.83
27.33
76.28
94.33
0.00 254.12
 20  No Name #35115
Calc.
Raw
167.46
114.50
20.40
13.33
65.50
81.00
0.00 253.36
 21  No Name #30746
Calc.
Raw
158.68
108.50
20.92
13.67
71.97
89.00
0.00 251.57
 22  No Name #5582
Calc.
Raw
153.93
105.25
13.27
8.67
82.74
102.33
0.00 249.94
 22  No Name #15407
Calc.
Raw
162.34
111.00
24.49
16.00
62.26
77.00
0.00 249.09
 23  No Name #34295
Calc.
Raw
159.41
109.00
18.37
12.00
75.74
93.67
5.00 248.52
 24  No Name #18415
Calc.
Raw
163.44
111.75
20.40
13.33
62.26
77.00
0.00 246.10
 24  No Name #6986
Calc.
Raw
163.44
111.75
12.26
8.01
69.81
86.33
0.00 245.51
 25  No Name #14989
Calc.
Raw
149.18
102.00
17.36
11.34
77.89
96.33
0.00 244.43
 26  No Name #33986
Calc.
Raw
155.39
106.25
26.02
17.00
66.57
82.33
5.00 242.98
 26  No Name #21290
Calc.
Raw
140.77
96.25
18.89
12.34
83.29
103.00
0.00 242.95
 26  No Name #1701
Calc.
Raw
146.98
100.50
24.49
16.00
70.89
87.67
0.00 242.36
 26  No Name #27409
Calc.
Raw
162.71
111.25
20.42
13.34
59.03
73.00
0.00 242.16
 27  No Name #3117
Calc.
Raw
139.31
95.25
21.93
14.33
77.36
95.67
0.00 238.60
 27  No Name #35867
Calc.
Raw
141.13
96.50
25.50
16.66
71.70
88.67
0.00 238.33
 27  No Name #33591
Calc.
Raw
179.16
122.50
31.63
20.67
56.87
70.33
30.00 237.66
 28  No Name #35511
Calc.
Raw
145.89
99.75
18.37
12.00
70.89
87.67
0.00 235.15
 28  No Name #1548
Calc.
Raw
162.71
111.25
18.87
12.33
53.10
65.67
0.00 234.68
 29  No Name #33946
Calc.
Raw
160.15
109.50
17.86
11.67
55.25
68.33
1.00 232.26
 30  No Name #34080
Calc.
Raw
150.27
102.75
18.89
12.34
60.65
75.00
0.00 229.81
 31  No Name #35317
Calc.
Raw
138.94
95.00
20.92
13.67
62.26
77.00
0.00 222.12
 32  No Name #33846
Calc.
Raw
141.50
96.75
15.81
10.33
63.34
78.33
1.00 219.65
 32  No Name #20005
Calc.
Raw
133.09
91.00
13.27
8.67
74.12
91.67
1.00 219.48
 32  No Name #33735
Calc.
Raw
141.13
96.50
14.28
9.33
63.34
78.33
0.00 218.75
 33  No Name #22248
Calc.
Raw
131.99
90.25
16.33
10.67
67.66
83.67
0.00 215.98
 34  No Name #35382
Calc.
Raw
126.51
86.50
14.28
9.33
71.42
88.33
0.00 212.21
 35  No Name #35769
Calc.
Raw
131.99
90.25
8.16
5.33
67.11
83.00
0.00 207.26
 36  No Name #7228
Calc.
Raw
130.90
89.50
9.69
6.33
65.50
81.00
1.00 205.09
 37  No Name #12905
Calc.
Raw
133.82
91.50
12.75
8.33
53.10
65.67
0.00 199.67
 38  No Name #497
Calc.
Raw
125.41
85.75
11.23
7.34
43.40
53.67
0.00 180.04
 39  No Name #35883
Calc.
Raw
116.64
79.75
11.72
7.66
62.26
77.00
70.00 120.62