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 1 Tag 'em Division III
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #22311
Calc.
Raw
191.32
152.11
50.00
43.99
90.65
121.25
0.00 331.97
 2  No Name #18255
Calc.
Raw
173.36
137.83
46.99
41.34
96.82
129.50
0.00 317.17
 3  No Name #36232
Calc.
Raw
193.70
154.00
46.60
41.00
65.05
87.00
0.00 305.35
 4  No Name #31161
Calc.
Raw
186.15
148.00
15.16
13.34
100.00
133.75
0.00 301.31
 5  No Name #5736
Calc.
Raw
195.18
155.18
43.58
38.34
60.37
80.75
0.00 299.13
 6  No Name #7246
Calc.
Raw
173.35
137.82
31.44
27.66
91.59
122.50
0.00 296.38
 7  No Name #33516
Calc.
Raw
189.91
150.99
40.53
35.66
63.18
84.50
0.00 293.62
 8  No Name #30595
Calc.
Raw
182.58
145.16
29.94
26.34
80.00
107.00
0.00 292.52
 8  No Name #32441
Calc.
Raw
174.82
138.99
42.44
37.34
75.14
100.50
0.00 292.40
 9  No Name #32223
Calc.
Raw
171.06
136.00
21.97
19.33
97.38
130.25
0.00 290.41
 10  No Name #3887
Calc.
Raw
193.70
154.00
49.64
43.67
42.24
56.50
0.00 285.58
 11  No Name #3381
Calc.
Raw
164.35
130.67
15.91
14.00
99.63
133.25
0.00 279.89
 12  No Name #9125
Calc.
Raw
185.94
147.83
30.68
26.99
59.07
79.00
0.00 275.69
 13  No Name #31579
Calc.
Raw
166.01
131.99
29.93
26.33
78.50
105.00
0.00 274.44
 13  No Name #26200
Calc.
Raw
139.20
110.67
42.82
37.67
92.34
123.50
0.00 274.36
 14  No Name #33757
Calc.
Raw
189.91
150.99
30.31
26.67
50.84
68.00
0.00 271.06
 14  No Name #31230
Calc.
Raw
185.88
147.78
44.33
39.00
40.19
53.75
0.00 270.40
 15  No Name #36469
Calc.
Raw
200.00
159.01
36.37
32.00
33.27
44.50
0.00 269.64
 16  No Name #1149
Calc.
Raw
174.00
138.34
46.60
41.00
46.92
62.75
0.00 267.52
 17  No Name #31043
Calc.
Raw
183.22
145.67
27.28
24.00
55.70
74.50
0.00 266.20
 17  No Name #30951
Calc.
Raw
178.18
141.66
31.06
27.33
56.07
75.00
0.00 265.31
 18  No Name #35621
Calc.
Raw
177.35
141.00
42.43
37.33
42.80
57.25
0.00 262.58
 19  No Name #33488
Calc.
Raw
139.63
111.01
26.14
23.00
90.84
121.50
0.00 256.61
 20  No Name #1412
Calc.
Raw
152.19
121.00
23.88
21.01
78.88
105.50
0.00 254.95
 20  No Name #33422
Calc.
Raw
160.58
127.67
15.54
13.67
77.94
104.25
0.00 254.06
 21  No Name #20868
Calc.
Raw
179.45
142.67
28.40
24.99
45.42
60.75
0.00 253.27
 21  No Name #10146
Calc.
Raw
132.07
105.00
26.53
23.34
93.83
125.50
0.00 252.43
 22  No Name #34393
Calc.
Raw
167.07
132.83
23.87
21.00
59.63
79.75
0.00 250.57
 23  No Name #35758
Calc.
Raw
178.62
142.01
21.98
19.34
48.41
64.75
2.00 247.01
 24  No Name #36865
Calc.
Raw
141.50
112.50
15.54
13.67
84.11
112.50
0.00 241.15
 25  No Name #17068
Calc.
Raw
170.00
135.16
30.68
26.99
36.45
48.75
0.00 237.13
 26  No Name #4637
Calc.
Raw
169.79
134.99
21.22
18.67
38.32
51.25
0.00 229.33
 27  No Name #32530
Calc.
Raw
165.18
131.33
20.07
17.66
41.50
55.50
0.00 226.75
 28  No Name #37109
Calc.
Raw
97.26
77.33
23.12
20.34
96.64
129.25
0.00 217.02
 29  No Name #31734
Calc.
Raw
113.20
90.00
12.89
11.34
84.11
112.50
0.00 210.20
 30  No Name #36823
Calc.
Raw
157.64
125.33
25.38
22.33
25.23
33.75
0.00 208.25
 31  No Name #5420
Calc.
Raw
157.21
124.99
26.53
23.34
22.06
29.50
0.00 205.80
 32  No Name #25049
Calc.
Raw
154.57
122.89
19.32
17.00
29.91
40.00
0.00 203.80
 33  No Name #37158
Calc.
Raw
89.53
71.18
26.90
23.67
46.92
62.75
0.00 163.35
 34  No Name #33292
Calc.
Raw
78.85
62.69
27.65
24.33
53.08
71.00
0.00 159.58