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 2005 May 21st
 Problem 5 The Jungle Bloke Division I
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #31310
Calc.
Raw
200.00
154.25
29.90
21.33
69.23
60.00
0.00 299.13
 1  No Name #1887
Calc.
Raw
188.01
145.00
45.79
32.67
64.99
56.33
0.00 298.79
 2  No Name #27729
Calc.
Raw
182.50
140.75
49.52
35.33
57.31
49.67
0.00 289.33
 3  No Name #4645
Calc.
Raw
175.36
135.25
50.00
35.67
56.54
49.00
0.00 281.90
 4  No Name #33665
Calc.
Raw
173.42
133.75
38.79
27.67
68.07
59.00
0.00 280.28
 5  No Name #19400
Calc.
Raw
167.26
129.00
40.65
29.00
64.23
55.67
0.00 272.14
 6  No Name #2118
Calc.
Raw
140.03
108.00
29.89
21.32
100.00
86.67
0.00 269.92
 7  No Name #15517
Calc.
Raw
141.65
109.25
40.65
29.00
86.54
75.00
0.00 268.84
 7  No Name #31535
Calc.
Raw
180.55
139.25
35.04
25.00
52.69
45.67
0.00 268.28
 8  No Name #30389
Calc.
Raw
162.72
125.50
30.38
21.67
75.38
65.33
5.00 263.48
 8  No Name #32908
Calc.
Raw
155.59
120.00
45.32
32.33
62.31
54.00
0.00 263.22
 8  No Name #750
Calc.
Raw
146.52
113.00
42.51
30.33
73.84
64.00
0.00 262.87
 9  No Name #7529
Calc.
Raw
177.31
136.75
25.23
18.00
55.38
48.00
0.00 257.92
 10  No Name #5574
Calc.
Raw
157.54
121.50
47.67
34.01
48.08
41.67
0.00 253.29
 10  No Name #2768
Calc.
Raw
131.93
101.75
41.13
29.34
79.99
69.33
0.00 253.05
 11  No Name #6379
Calc.
Raw
164.34
126.75
30.38
21.67
55.00
47.67
0.00 249.72
 12  No Name #33320
Calc.
Raw
140.03
108.00
28.02
19.99
80.39
69.67
0.00 248.44
 13  No Name #31305
Calc.
Raw
143.92
111.00
29.91
21.34
72.31
62.67
0.00 246.14
 13  No Name #1375
Calc.
Raw
137.44
106.00
42.07
30.01
70.76
61.33
5.00 245.27
 14  No Name #10566
Calc.
Raw
132.58
102.25
33.63
23.99
76.53
66.33
0.00 242.74
 14  No Name #33795
Calc.
Raw
143.60
110.75
39.26
28.01
59.22
51.33
0.00 242.08
 14  No Name #20522
Calc.
Raw
146.52
113.00
34.10
24.33
61.15
53.00
0.00 241.77
 15  No Name #34298
Calc.
Raw
133.55
103.00
27.10
19.33
75.00
65.00
0.00 235.65
 15  No Name #32349
Calc.
Raw
145.87
112.50
34.10
24.33
55.38
48.00
0.00 235.35
 15  No Name #13391
Calc.
Raw
146.84
113.25
30.84
22.00
57.31
49.67
0.00 234.99
 16  No Name #9926
Calc.
Raw
136.14
105.00
31.30
22.33
63.84
55.33
0.00 231.28
 17  No Name #28057
Calc.
Raw
144.89
111.75
35.04
25.00
49.99
43.33
0.00 229.92
 18  No Name #1164
Calc.
Raw
159.16
122.75
26.63
19.00
43.07
37.33
0.00 228.86
 18  No Name #34674
Calc.
Raw
145.87
112.50
37.38
26.67
75.38
65.33
30.00 228.63
 18  No Name #1785
Calc.
Raw
140.03
108.00
29.44
21.00
58.84
51.00
0.00 228.31
 18  No Name #35033
Calc.
Raw
140.36
108.25
25.23
18.00
62.31
54.00
0.00 227.90
 19  No Name #25354
Calc.
Raw
128.36
99.00
37.37
26.66
57.31
49.67
0.00 223.04
 19  No Name #30686
Calc.
Raw
134.52
103.75
38.79
27.67
48.84
42.33
0.00 222.15
 20  No Name #13004
Calc.
Raw
135.82
104.75
33.18
23.67
64.23
55.67
15.00 218.23
 20  No Name #30361
Calc.
Raw
117.02
90.25
29.90
21.33
70.38
61.00
0.00 217.30
 21  No Name #24442
Calc.
Raw
117.99
91.00
29.44
21.00
64.23
55.67
0.00 211.66
 21  No Name #2271
Calc.
Raw
123.82
95.50
31.78
22.67
60.77
52.67
5.00 211.37
 22  No Name #8239
Calc.
Raw
115.07
88.75
26.17
18.67
68.85
59.67
0.00 210.09
 22  No Name #32346
Calc.
Raw
130.96
101.00
26.63
19.00
52.30
45.33
0.00 209.89
 23  No Name #33395
Calc.
Raw
125.77
97.00
28.05
20.01
48.84
42.33
0.00 202.66
 24  No Name #4087
Calc.
Raw
105.02
81.00
31.30
22.33
61.53
53.33
0.00 197.85
 25  No Name #21969
Calc.
Raw
113.13
87.25
28.02
19.99
55.00
47.67
0.00 196.15
 26  No Name #33295
Calc.
Raw
122.20
94.25
21.49
15.33
52.69
45.67
3.00 193.38
 27  No Name #2437
Calc.
Raw
106.32
82.00
22.90
16.34
58.07
50.33
0.00 187.29
 27  No Name #25437
Calc.
Raw
114.75
88.50
25.23
18.00
46.93
40.67
0.00 186.91
 28  No Name #34912
Calc.
Raw
113.78
87.75
24.77
17.67
56.54
49.00
10.00 185.09
 29  No Name #33843
Calc.
Raw
110.86
85.50
19.61
13.99
50.39
43.67
0.00 180.86
 30  No Name #33381
Calc.
Raw
98.87
76.25
22.43
16.00
53.07
46.00
0.00 174.37
 31  No Name #35382
Calc.
Raw
102.11
78.75
15.90
11.34
53.07
46.00
2.00 169.08
 32  No Name #32918
Calc.
Raw
103.08
79.50
19.62
14.00
49.23
42.67
5.00 166.93
 33  No Name #14544
Calc.
Raw
89.47
69.00
21.97
15.67
53.46
46.33
0.00 164.90