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 1 The Great Parade Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #9084
 Calc.
Raw		 200.00
183.34		 50.00
40.33		 96.65
96.00		 0.00 346.65
 2  No Name #18255
 Calc.
Raw		 198.54
182.00		 44.22
35.67		 94.30
93.67		 0.00 337.06
 3  No Name #9744
 Calc.
Raw		 197.08
180.66		 46.70
37.67		 89.60
89.00		 0.00 333.38
 4  No Name #3887
 Calc.
Raw		 194.53
178.33		 33.05
26.66		 94.30
93.67		 0.00 321.88
 5  No Name #6905
 Calc.
Raw		 192.35
176.33		 35.14
28.34		 90.27
89.67		 0.00 317.76
 6  No Name #1412
 Calc.
Raw		 186.18
170.67		 30.18
24.34		 89.93
89.33		 0.00 306.29
 7  No Name #10103
 Calc.
Raw		 173.09
158.67		 28.11
22.67		 100.00
99.33		 0.00 301.20
 8  No Name #30400
 Calc.
Raw		 194.53
178.33		 26.02
20.99		 76.84
76.33		 1.00 296.39
 9  No Name #23931
 Calc.
Raw		 166.53
152.66		 28.51
23.00		 93.30
92.67		 0.00 288.34
 10  No Name #32441
 Calc.
Raw		 188.72
173.00		 28.51
23.00		 65.11
64.67		 0.00 282.34
 11  No Name #31161
 Calc.
Raw		 162.54
149.00		 18.60
15.00		 94.63
94.00		 0.00 275.77
 11  No Name #31230
 Calc.
Raw		 171.27
157.00		 40.09
32.34		 63.42
63.00		 0.00 274.78
 12  No Name #17473
 Calc.
Raw		 168.36
154.34		 29.75
24.00		 74.50
74.00		 0.00 272.61
 13  No Name #34281
 Calc.
Raw		 160.00
146.67		 28.53
23.01		 80.21
79.67		 0.00 268.74
 13  No Name #3823
 Calc.
Raw		 154.17
141.33		 19.41
15.66		 94.30
93.67		 0.00 267.88
 14  No Name #33488
 Calc.
Raw		 152.72
140.00		 27.27
22.00		 84.23
83.67		 0.00 264.22
 15  No Name #32781
 Calc.
Raw		 136.01
124.68		 30.16
24.33		 92.95
92.33		 0.00 259.12
 16  No Name #4627
 Calc.
Raw		 132.73
121.67		 31.01
25.01		 94.30
93.67		 0.00 258.04
 17  No Name #4307
 Calc.
Raw		 116.73
107.01		 48.77
39.34		 85.24
84.67		 0.00 250.74
 18  No Name #11606
 Calc.
Raw		 109.81
100.66		 46.28
37.33		 91.61
91.00		 0.00 247.70
 19  No Name #2271
 Calc.
Raw		 138.54
127.00		 30.16
24.33		 77.85
77.33		 0.00 246.55
 20  No Name #25346
 Calc.
Raw		 126.18
115.67		 31.40
25.33		 85.91
85.33		 0.00 243.49
 21  No Name #33323
 Calc.
Raw		 126.18
115.67		 27.27
22.00		 86.91
86.33		 0.00 240.36
 22  No Name #32415
 Calc.
Raw		 163.27
149.67		 22.73
18.33		 53.36
53.00		 0.00 239.36
 23  No Name #5736
 Calc.
Raw		 118.90
109.00		 36.77
29.66		 77.85
77.33		 0.00 233.52
 24  No Name #8496
 Calc.
Raw		 148.73
136.34		 38.84
31.33		 34.90
34.67		 0.00 222.47
 25  No Name #11392
 Calc.
Raw		 123.28
113.01		 14.05
11.33		 81.88
81.33		 0.00 219.21
 26  No Name #10102
 Calc.
Raw		 86.91
79.67		 33.47
27.00		 96.65
96.00		 0.00 217.03
 27  No Name #13857
 Calc.
Raw		 108.73
99.67		 30.57
24.66		 71.81
71.33		 2.00 209.11
 28  No Name #33986
 Calc.
Raw		 93.45
85.67		 17.77
14.33		 92.29
91.67		 0.00 203.51
 29  No Name #33189
 Calc.
Raw		 92.35
84.66		 25.20
20.33		 84.57
84.00		 0.00 202.12
 30  No Name #33991
 Calc.
Raw		 78.90
72.33		 25.63
20.67		 94.63
94.00		 0.00 199.16
 31  No Name #33084
 Calc.
Raw		 86.54
79.33		 23.98
19.34		 87.25
86.67		 0.00 197.77
 31  No Name #4673
 Calc.
Raw		 112.36
103.00		 26.02
20.99		 77.19
76.67		 18.00 197.57
 32  No Name #14231
 Calc.
Raw		 76.00
69.67		 34.30
27.67		 81.21
80.67		 0.00 191.51
 33  No Name #5730
 Calc.
Raw		 109.82
100.67		 17.36
14.00		 68.79
68.33		 25.00 170.97
 34  No Name #33978
 Calc.
Raw		 92.36
84.67		 23.57
19.01		 39.94
39.67		 0.00 155.87
 35  No Name #33010
 Calc.
Raw		 36.73
33.67		 18.18
14.66		 82.22
81.67		 2.00 135.13