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 1 Odyssey Road Rally Division I
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #20906
Calc.
Raw
200.00
160.98
50.00
46.33
84.62
137.50
0.00 334.62
 2  No Name #32957
Calc.
Raw
192.20
154.70
42.45
39.33
84.31
137.00
0.00 318.96
 3  No Name #28072
Calc.
Raw
173.54
139.68
30.94
28.67
97.38
158.25
0.00 301.86
 4  No Name #28819
Calc.
Raw
186.77
150.33
31.30
29.00
81.54
132.50
0.00 299.61
 5  No Name #387
Calc.
Raw
153.62
123.65
32.38
30.00
100.00
162.50
0.00 286.00
 6  No Name #34320
Calc.
Raw
159.86
128.67
35.26
32.67
83.69
136.00
0.00 278.81
 6  No Name #9108
Calc.
Raw
151.56
121.99
42.09
39.00
84.77
137.75
0.00 278.42
 7  No Name #35789
Calc.
Raw
156.96
126.34
30.57
28.33
84.15
136.75
0.00 271.68
 7  No Name #34835
Calc.
Raw
162.34
130.67
37.77
35.00
71.23
115.75
0.00 271.34
 8  No Name #6162
Calc.
Raw
168.13
135.33
28.42
26.33
70.62
114.75
0.00 267.17
 9  No Name #29453
Calc.
Raw
168.57
135.68
31.30
29.00
61.85
100.50
0.00 261.72
 9  No Name #16465
Calc.
Raw
130.87
105.34
33.46
31.00
97.38
158.25
0.00 261.71
 10  No Name #35477
Calc.
Raw
145.35
116.99
31.65
29.33
82.77
134.50
2.00 257.77
 10  No Name #37176
Calc.
Raw
128.36
103.32
32.38
30.00
96.92
157.50
0.00 257.66
 11  No Name #5637
Calc.
Raw
150.33
121.00
36.34
33.67
66.00
107.25
0.00 252.67
 11  No Name #34814
Calc.
Raw
143.26
115.31
33.81
31.33
74.92
121.75
0.00 251.99
 12  No Name #33665
Calc.
Raw
150.74
121.33
38.13
35.33
60.31
98.00
0.00 249.18
 13  No Name #35446
Calc.
Raw
153.22
123.33
22.31
20.67
71.69
116.50
0.00 247.22
 14  No Name #34298
Calc.
Raw
132.10
106.33
29.14
27.00
84.77
137.75
0.00 246.01
 14  No Name #37850
Calc.
Raw
142.04
114.33
34.53
32.00
68.77
111.75
0.00 245.34
 15  No Name #4999
Calc.
Raw
161.52
130.01
25.90
24.00
56.46
91.75
0.00 243.88
 15  No Name #34889
Calc.
Raw
151.99
122.34
32.02
29.67
59.38
96.50
0.00 243.39
 16  No Name #32908
Calc.
Raw
135.00
108.66
36.69
34.00
70.92
115.25
0.00 242.61
 16  No Name #715
Calc.
Raw
132.51
106.66
16.91
15.67
92.92
151.00
0.00 242.34
 17  No Name #8582
Calc.
Raw
139.15
112.00
28.06
26.00
72.00
117.00
0.00 239.21
 18  No Name #34310
Calc.
Raw
115.53
92.99
23.74
22.00
96.00
156.00
0.00 235.27
 19  No Name #3895
Calc.
Raw
122.79
98.83
16.91
15.67
93.69
152.25
0.00 233.39
 20  No Name #36671
Calc.
Raw
106.83
85.99
27.34
25.33
97.08
157.75
0.00 231.25
 21  No Name #37815
Calc.
Raw
122.57
98.66
22.66
21.00
83.54
135.75
0.00 228.77
 21  No Name #37354
Calc.
Raw
145.77
117.33
19.43
18.00
62.77
102.00
0.00 227.97
 22  No Name #30618
Calc.
Raw
133.36
107.34
19.07
17.67
71.85
116.75
0.00 224.28
 22  No Name #1386
Calc.
Raw
124.65
100.33
27.70
25.67
71.85
116.75
0.00 224.20
 23  No Name #16597
Calc.
Raw
135.01
108.67
20.52
19.01
65.08
105.75
0.00 220.61
 24  No Name #36300
Calc.
Raw
106.01
85.33
29.49
27.33
83.85
136.25
0.00 219.35
 25  No Name #37234
Calc.
Raw
119.68
96.33
29.86
27.67
95.69
155.50
30.00 215.23
 26  No Name #35035
Calc.
Raw
123.82
99.66
25.18
23.33
64.62
105.00
0.00 213.62
 26  No Name #37612
Calc.
Raw
125.08
100.68
23.74
22.00
67.08
109.00
3.00 212.90
 27  No Name #34242
Calc.
Raw
118.86
95.67
20.15
18.67
72.62
118.00
0.00 211.63
 28  No Name #37715
Calc.
Raw
113.05
90.99
25.18
23.33
71.69
116.50
0.00 209.92
 29  No Name #9599
Calc.
Raw
126.31
101.67
25.55
23.67
56.62
92.00
0.00 208.48
 30  No Name #35727
Calc.
Raw
124.24
100.00
17.62
16.33
64.77
105.25
0.00 206.63
 31  No Name #20733
Calc.
Raw
121.73
97.98
17.62
16.33
66.00
107.25
0.00 205.35
 31  No Name #30823
Calc.
Raw
122.98
98.99
17.99
16.67
63.69
103.50
0.00 204.66
 32  No Name #36769
Calc.
Raw
82.83
66.67
33.81
31.33
84.31
137.00
1.00 199.95
 32  No Name #31535
Calc.
Raw
117.18
94.32
31.65
29.33
50.46
82.00
0.00 199.29
 33  No Name #5128
Calc.
Raw
94.41
75.99
19.07
17.67
84.00
136.50
0.00 197.48
 34  No Name #13857
Calc.
Raw
91.08
73.31
29.49
27.33
71.54
116.25
2.00 190.11
 34  No Name #11451
Calc.
Raw
121.31
97.64
28.42
26.33
39.54
64.25
0.00 189.27
 35  No Name #21099
Calc.
Raw
108.93
87.68
14.39
13.33
64.46
104.75
0.00 187.78
 36  No Name #36158
Calc.
Raw
121.33
97.66
21.94
20.33
36.46
59.25
0.00 179.73
 37  No Name #36616
Calc.
Raw
128.81
103.68
21.23
19.67
21.85
35.50
0.00 171.89
 38  No Name #32600
Calc.
Raw
73.72
59.34
26.62
24.67
67.23
109.25
0.00 167.57
 39  No Name #37851
Calc.
Raw
83.66
67.34
35.26
32.67
42.77
69.50
0.00 161.69
 40  No Name #19400
Calc.
Raw
78.06
62.83
33.81
31.33
46.62
75.75
0.00 158.49
 40  No Name #34796
Calc.
Raw
113.87
91.65
36.34
33.67
7.69
12.50
0.00 157.90
 41  No Name #37378
Calc.
Raw
72.89
58.67
8.28
7.67
68.92
112.00
0.00 150.09
 41  No Name #34080
Calc.
Raw
39.74
31.99
28.42
26.33
81.85
133.00
0.00 150.01