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 2007 May 23rd
 Problem 2 The Large And Small Of It Division III
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #8496
Calc.
Raw
175.29
149.00
36.24
29.00
95.14
112.50
0.00 306.67
 2  No Name #22311
Calc.
Raw
151.18
128.50
37.90
30.33
97.46
115.25
15.00 271.54
 3  No Name #30949
Calc.
Raw
200.00
170.00
50.00
40.01
19.45
23.00
0.00 269.45
 4  No Name #27017
Calc.
Raw
196.47
167.00
46.24
37.00
23.04
27.25
0.00 265.75
 5  No Name #3887
Calc.
Raw
190.59
162.00
44.58
35.67
23.04
27.25
1.00 257.21
 6  No Name #10619
Calc.
Raw
120.00
102.00
35.42
28.34
100.00
118.25
0.00 255.42
 7  No Name #34393
Calc.
Raw
179.41
152.50
37.07
29.66
36.15
42.75
0.00 252.63
 8  No Name #37162
Calc.
Raw
171.18
145.50
39.15
31.33
26.00
30.75
0.00 236.33
 9  No Name #31230
Calc.
Raw
148.82
126.50
40.83
32.67
43.55
51.50
0.00 233.20
 10  No Name #35550
Calc.
Raw
170.59
145.00
39.15
31.33
20.08
23.75
0.00 229.82
 11  No Name #35519
Calc.
Raw
147.65
125.50
41.24
33.00
38.90
46.00
0.00 227.79
 12  No Name #1149
Calc.
Raw
140.59
119.50
44.99
36.00
41.01
48.50
0.00 226.59
 13  No Name #30595
Calc.
Raw
138.82
118.00
41.65
33.33
43.34
51.25
0.00 223.81
 14  No Name #5736
Calc.
Raw
174.71
148.50
40.41
32.34
23.47
27.75
17.00 221.59
 15  No Name #31437
Calc.
Raw
157.06
133.50
32.49
26.00
30.66
36.25
0.00 220.21
 16  No Name #22063
Calc.
Raw
160.59
136.50
40.40
32.33
31.50
37.25
16.00 216.49
 17  No Name #32939
Calc.
Raw
145.29
123.50
28.73
22.99
38.05
45.00
0.00 212.07
 18  No Name #33422
Calc.
Raw
154.71
131.50
34.59
27.68
20.08
23.75
2.00 207.38
 19  No Name #4307
Calc.
Raw
130.59
111.00
42.08
33.67
31.92
37.75
0.00 204.59
 20  No Name #35180
Calc.
Raw
137.06
116.50
33.74
27.00
27.06
32.00
0.00 197.86
 21  No Name #15074
Calc.
Raw
122.35
104.00
37.07
29.66
34.46
40.75
0.00 193.88
 21  No Name #14186
Calc.
Raw
119.41
101.50
34.58
27.67
38.90
46.00
0.00 192.89
 22  No Name #36451
Calc.
Raw
135.29
115.00
36.65
29.33
20.51
24.25
0.00 192.45
 22  No Name #7743
Calc.
Raw
131.18
111.50
33.33
26.67
27.27
32.25
0.00 191.78
 23  No Name #24436
Calc.
Raw
131.76
112.00
34.99
28.00
24.10
28.50
0.00 190.85
 24  No Name #28239
Calc.
Raw
114.12
97.00
32.08
25.67
39.96
47.25
0.00 186.16
 25  No Name #19512
Calc.
Raw
120.59
102.50
34.17
27.34
27.48
32.50
0.00 182.24
 26  No Name #31161
Calc.
Raw
120.59
102.50
28.74
23.00
30.66
36.25
2.00 177.99
 27  No Name #2215
Calc.
Raw
104.12
88.50
35.82
28.66
35.10
41.50
0.00 175.04
 28  No Name #34802
Calc.
Raw
131.76
112.00
32.49
26.00
20.93
24.75
15.00 170.18
 29  No Name #35824
Calc.
Raw
108.24
92.00
30.00
24.01
29.18
34.50
0.00 167.42
 30  No Name #15515
Calc.
Raw
111.18
94.50
20.83
16.67
33.62
39.75
0.00 165.63
 31  No Name #36979
Calc.
Raw
117.06
99.50
27.49
22.00
20.08
23.75
0.00 164.63
 32  No Name #7246
Calc.
Raw
111.18
94.50
31.24
25.00
23.04
27.25
2.00 163.46
 33  No Name #21290
Calc.
Raw
115.29
98.00
29.99
24.00
16.70
19.75
0.00 161.98
 34  No Name #34519
Calc.
Raw
90.59
77.00
31.24
25.00
38.90
46.00
0.00 160.73
 34  No Name #33415
Calc.
Raw
94.12
80.00
39.17
31.34
27.27
32.25
0.00 160.56
 34  No Name #8871
Calc.
Raw
113.53
96.50
22.07
17.66
24.31
28.75
0.00 159.91
 35  No Name #1412
Calc.
Raw
116.47
99.00
23.32
18.66
17.34
20.50
0.00 157.13
 36  No Name #31108
Calc.
Raw
105.88
90.00
28.33
22.67
21.35
25.25
0.00 155.56
 37  No Name #30551
Calc.
Raw
92.94
79.00
30.40
24.33
29.81
35.25
0.00 153.15
 38  No Name #8149
Calc.
Raw
80.59
68.50
34.99
28.00
12.68
15.00
0.00 128.26
 39  No Name #32640
Calc.
Raw
42.94
36.50
17.92
14.34
17.97
21.25
0.00 78.83
 40  No Name #16610
Calc.
Raw
31.18
26.50
22.07
17.66
23.26
27.50
0.00 76.51