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 I
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #33665
Calc.
Raw
183.97
132.00
42.21
30.67
100.00
141.25
0.00 326.18
 2  No Name #36233
Calc.
Raw
182.58
131.00
40.37
29.33
96.99
137.00
0.00 319.94
 3  No Name #16925
Calc.
Raw
173.52
124.50
33.48
24.33
99.47
140.50
0.00 306.47
 4  No Name #31535
Calc.
Raw
174.22
125.00
44.04
32.00
76.64
108.25
0.00 294.90
 5  No Name #22423
Calc.
Raw
174.22
125.00
43.57
31.66
72.57
102.50
0.00 290.36
 6  No Name #15064
Calc.
Raw
167.94
120.50
40.39
29.35
80.00
113.00
0.00 288.33
 7  No Name #34601
Calc.
Raw
190.24
136.50
37.61
27.33
57.70
81.50
1.00 284.55
 8  No Name #34325
Calc.
Raw
154.01
110.50
35.34
25.68
82.12
116.00
0.00 271.47
 8  No Name #34123
Calc.
Raw
175.61
126.00
37.16
27.00
58.23
82.25
0.00 271.00
 9  No Name #33866
Calc.
Raw
162.37
116.50
38.08
27.67
69.38
98.00
0.00 269.83
 10  No Name #34320
Calc.
Raw
165.85
119.00
30.28
22.00
67.43
95.25
0.00 263.56
 10  No Name #4636
Calc.
Raw
162.37
116.50
44.49
32.33
56.11
79.25
0.00 262.97
 11  No Name #33744
Calc.
Raw
173.52
124.50
37.16
27.00
51.68
73.00
0.00 262.36
 12  No Name #31032
Calc.
Raw
158.19
113.50
30.75
22.34
69.20
97.75
0.00 258.14
 12  No Name #1009
Calc.
Raw
200.00
143.50
39.46
28.67
18.23
25.75
0.00 257.69
 13  No Name #45
Calc.
Raw
176.31
126.50
43.57
31.66
35.93
50.75
0.00 255.81
 14  No Name #31733
Calc.
Raw
139.37
100.00
27.51
19.99
94.34
133.25
10.00 251.22
 14  No Name #36998
Calc.
Raw
159.58
114.50
29.37
21.34
62.12
87.75
0.00 251.07
 14  No Name #33278
Calc.
Raw
158.89
114.00
24.30
17.66
77.52
109.50
10.00 250.71
 15  No Name #36839
Calc.
Raw
159.58
114.50
35.78
26.00
52.57
74.25
0.00 247.93
 15  No Name #14205
Calc.
Raw
140.77
101.00
34.86
25.33
72.04
101.75
0.00 247.67
 16  No Name #37159
Calc.
Raw
186.06
133.50
38.99
28.33
16.64
23.50
0.00 241.69
 16  No Name #33807
Calc.
Raw
164.46
118.00
41.74
30.33
34.87
49.25
0.00 241.07
 17  No Name #26604
Calc.
Raw
174.22
125.00
50.00
36.33
11.50
16.25
0.00 235.72
 18  No Name #28204
Calc.
Raw
158.19
113.50
38.54
28.00
35.93
50.75
0.00 232.66
 19  No Name #2345
Calc.
Raw
154.01
110.50
37.61
27.33
37.17
52.50
0.00 228.79
 19  No Name #5574
Calc.
Raw
158.89
114.00
41.27
29.99
27.79
39.25
0.00 227.95
 20  No Name #12534
Calc.
Raw
168.64
121.00
30.73
22.33
26.02
36.75
0.00 225.39
 21  No Name #36439
Calc.
Raw
164.46
118.00
37.16
27.00
22.48
31.75
0.00 224.10
 21  No Name #15731
Calc.
Raw
172.13
123.50
33.03
24.00
18.41
26.00
0.00 223.57
 21  No Name #11416
Calc.
Raw
158.19
113.50
39.91
29.00
25.31
35.75
0.00 223.41
 22  No Name #3193
Calc.
Raw
160.28
115.00
43.12
31.33
17.17
24.25
0.00 220.57
 23  No Name #12646
Calc.
Raw
140.77
101.00
36.24
26.33
39.12
55.25
1.00 215.13
 23  No Name #37160
Calc.
Raw
135.19
97.00
37.61
27.33
41.77
59.00
0.00 214.57
 24  No Name #8061
Calc.
Raw
165.16
118.50
38.99
28.33
7.61
10.75
0.00 211.76
 25  No Name #15746
Calc.
Raw
126.13
90.50
32.11
23.33
49.38
69.75
0.00 207.62
 25  No Name #37028
Calc.
Raw
139.37
100.00
33.03
24.00
35.04
49.50
0.00 207.44
 25  No Name #28679
Calc.
Raw
141.46
101.50
41.29
30.00
24.25
34.25
0.00 207.00
 26  No Name #14186
Calc.
Raw
150.52
108.00
33.03
24.00
19.65
27.75
0.00 203.20
 27  No Name #36445
Calc.
Raw
118.47
85.00
30.29
22.01
53.10
75.00
0.00 201.86
 27  No Name #4984
Calc.
Raw
158.19
113.50
24.32
17.67
18.94
26.75
0.00 201.45
 28  No Name #35162
Calc.
Raw
134.49
96.50
33.48
24.33
24.07
34.00
0.00 192.04
 29  No Name #3390
Calc.
Raw
133.10
95.50
23.85
17.33
28.67
40.50
0.00 185.62
 29  No Name #32181
Calc.
Raw
124.74
89.50
25.70
18.67
34.69
49.00
0.00 185.13
 30  No Name #33846
Calc.
Raw
107.32
77.00
21.57
15.67
44.78
63.25
0.00 173.67
 31  No Name #36534
Calc.
Raw
129.62
93.00
24.32
17.67
14.87
21.00
0.00 168.81
 32  No Name #30823
Calc.
Raw
109.41
78.50
32.11
23.33
23.01
32.50
0.00 164.53