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 5 The Eccentrics! Division I
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #34691
Calc.
Raw
200.00
167.25
41.78
37.33
100.00
112.67
0.00 341.78
 2  No Name #29007
Calc.
Raw
181.46
151.75
50.00
44.67
96.74
109.00
0.00 328.20
 3  No Name #2784
Calc.
Raw
186.25
155.75
41.41
37.00
90.24
101.67
0.00 317.90
 4  No Name #35672
Calc.
Raw
173.39
145.00
44.02
39.33
95.86
108.00
0.00 313.27
 4  No Name #34835
Calc.
Raw
177.88
148.75
38.43
34.33
96.15
108.33
0.00 312.46
 5  No Name #2770
Calc.
Raw
171.90
143.75
46.64
41.67
91.71
103.33
0.00 310.25
 6  No Name #30361
Calc.
Raw
168.31
140.75
44.77
40.00
95.86
108.00
0.00 308.94
 7  No Name #36092
Calc.
Raw
173.99
145.50
44.02
39.33
90.82
102.33
1.00 307.83
 7  No Name #37160
Calc.
Raw
172.80
144.50
49.62
44.33
95.26
107.33
10.00 307.68
 8  No Name #14491
Calc.
Raw
165.62
138.50
40.66
36.33
97.34
109.67
0.00 303.62
 8  No Name #36302
Calc.
Raw
170.10
142.25
37.31
33.33
97.63
110.00
2.00 303.04
 9  No Name #28109
Calc.
Raw
163.53
136.75
39.18
35.00
99.70
112.33
0.00 302.41
 10  No Name #1944
Calc.
Raw
172.50
144.25
37.31
33.33
90.53
102.00
0.00 300.34
 10  No Name #35454
Calc.
Raw
173.39
145.00
35.82
32.00
90.82
102.33
0.00 300.03
 11  No Name #36087
Calc.
Raw
162.33
135.75
38.81
34.67
96.74
109.00
0.00 297.88
 12  No Name #37858
Calc.
Raw
159.34
133.25
42.16
37.67
93.19
105.00
0.00 294.69
 12  No Name #32258
Calc.
Raw
164.72
137.75
38.06
34.00
94.97
107.00
4.00 293.75
 13  No Name #6428
Calc.
Raw
158.15
132.25
40.30
36.00
92.60
104.33
0.00 291.05
 13  No Name #37702
Calc.
Raw
159.04
133.00
40.30
36.00
91.12
102.67
0.00 290.46
 14  No Name #34905
Calc.
Raw
154.26
129.00
38.06
34.00
96.45
108.67
0.00 288.77
 14  No Name #237
Calc.
Raw
154.26
129.00
42.90
38.33
90.82
102.33
0.00 287.98
 15  No Name #37490
Calc.
Raw
156.35
130.75
38.43
34.33
92.60
104.33
0.00 287.38
 15  No Name #5418
Calc.
Raw
155.16
129.75
37.31
33.33
94.08
106.00
0.00 286.55
 16  No Name #34380
Calc.
Raw
151.27
126.50
35.82
32.00
98.81
111.33
0.00 285.90
 16  No Name #33282
Calc.
Raw
165.62
138.50
35.82
32.00
84.02
94.67
0.00 285.46
 16  No Name #37176
Calc.
Raw
148.58
124.25
40.30
36.00
96.15
108.33
0.00 285.03
 17  No Name #7130
Calc.
Raw
152.17
127.25
31.34
28.00
99.70
112.33
2.00 281.21
 17  No Name #37821
Calc.
Raw
151.57
126.75
36.57
32.67
92.60
104.33
0.00 280.74
 18  No Name #35727
Calc.
Raw
153.66
128.50
32.09
28.67
93.49
105.33
0.00 279.24
 18  No Name #32233
Calc.
Raw
156.95
131.25
28.73
25.67
92.90
104.67
0.00 278.58
 18  No Name #34123
Calc.
Raw
146.19
122.25
32.83
29.33
99.41
112.00
0.00 278.43
 19  No Name #28372
Calc.
Raw
144.99
121.25
36.57
32.67
95.56
107.67
0.00 277.12
 19  No Name #37365
Calc.
Raw
141.41
118.25
38.06
34.00
97.63
110.00
0.00 277.10
 20  No Name #36839
Calc.
Raw
145.59
121.75
37.69
33.67
92.30
104.00
0.00 275.58
 20  No Name #11374
Calc.
Raw
149.18
124.75
32.09
28.67
94.08
106.00
0.00 275.35
 21  No Name #2746
Calc.
Raw
144.99
121.25
38.06
34.00
90.24
101.67
0.00 273.29
 21  No Name #36693
Calc.
Raw
147.09
123.00
31.71
28.33
93.79
105.67
0.00 272.59
 22  No Name #13857
Calc.
Raw
144.39
120.75
35.45
31.67
92.01
103.67
0.00 271.85
 22  No Name #16874
Calc.
Raw
141.70
118.50
35.45
31.67
93.79
105.67
0.00 270.94
 23  No Name #37102
Calc.
Raw
139.61
116.75
37.69
33.67
92.01
103.67
0.00 269.31
 23  No Name #27653
Calc.
Raw
138.12
115.50
40.30
36.00
90.82
102.33
0.00 269.24
 23  No Name #18836
Calc.
Raw
140.81
117.75
35.82
32.00
92.01
103.67
0.00 268.64
 24  No Name #6161
Calc.
Raw
141.11
118.00
36.19
32.33
90.53
102.00
0.00 267.83
 24  No Name #37859
Calc.
Raw
147.98
123.75
45.52
40.67
73.37
82.67
0.00 266.87
 25  No Name #27409
Calc.
Raw
132.74
111.00
35.82
32.00
97.92
110.33
0.00 266.48
 25  No Name #31210
Calc.
Raw
138.12
115.50
33.21
29.67
94.37
106.33
0.00 265.70
 26  No Name #33291
Calc.
Raw
154.56
129.25
36.94
33.00
81.95
92.33
10.00 263.45
 26  No Name #30749
Calc.
Raw
139.61
116.75
30.59
27.33
92.90
104.67
0.00 263.10
 26  No Name #4984
Calc.
Raw
142.30
119.00
37.31
33.33
83.14
93.67
0.00 262.75
 27  No Name #34242
Calc.
Raw
139.91
117.00
28.35
25.33
93.19
105.00
0.00 261.45
 28  No Name #35925
Calc.
Raw
135.72
113.50
31.71
28.33
91.12
102.67
0.00 258.55
 28  No Name #9090
Calc.
Raw
136.02
113.75
35.82
32.00
86.39
97.33
0.00 258.23
 29  No Name #36478
Calc.
Raw
128.85
107.75
34.70
31.00
92.90
104.67
0.00 256.45
 30  No Name #3606
Calc.
Raw
134.53
112.50
32.83
29.33
87.87
99.00
0.00 255.23
 31  No Name #6603
Calc.
Raw
141.11
118.00
26.11
23.33
91.42
103.00
5.00 253.64
 32  No Name #35714
Calc.
Raw
139.31
116.50
39.18
35.00
73.07
82.33
0.00 251.56
 33  No Name #34430
Calc.
Raw
134.23
112.25
29.85
26.67
86.39
97.33
0.00 250.47
 34  No Name #30598
Calc.
Raw
141.70
118.50
33.95
30.33
83.72
94.33
15.00 244.37
 35  No Name #25437
Calc.
Raw
111.51
93.25
22.02
19.67
98.52
111.00
0.00 232.05
 36  No Name #37234
Calc.
Raw
119.58
100.00
27.98
25.00
82.54
93.00
0.00 230.10
 37  No Name #19400
Calc.
Raw
136.32
114.00
32.83
29.33
49.11
55.33
0.00 218.26
 38  No Name #17220
Calc.
Raw
112.71
94.25
24.99
22.33
63.61
71.67
20.00 181.31