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 III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #20868
 Calc.
Raw		 157.96
139.00		 39.28
29.33		 100.00
584.50		 0.00 297.24
 2  No Name #35901
 Calc.
Raw		 164.41
144.67		 41.96
31.33		 79.08
462.25		 0.00 285.45
 3  No Name #7975
 Calc.
Raw		 151.53
133.34		 31.25
23.33		 99.83
583.50		 0.00 282.61
 3  No Name #37674
 Calc.
Raw		 139.02
122.33		 43.76
32.67		 99.79
583.25		 0.00 282.57
 3  No Name #37802
 Calc.
Raw		 184.86
162.67		 39.74
29.67		 57.87
338.25		 0.00 282.47
 4  No Name #1149
 Calc.
Raw		 154.17
135.66		 49.56
37.00		 66.30
387.50		 0.00 270.03
 5  No Name #5736
 Calc.
Raw		 200.00
175.99		 46.44
34.67		 22.58
132.00		 0.00 269.02
 6  No Name #19512
 Calc.
Raw		 152.67
134.34		 27.69
20.67		 79.34
463.75		 0.00 259.70
 6  No Name #36232
 Calc.
Raw		 184.86
162.67		 48.66
36.33		 26.01
152.00		 0.00 259.53
 7  No Name #33986
 Calc.
Raw		 134.84
118.65		 36.16
27.00		 85.97
502.50		 0.00 256.97
 8  No Name #33894
 Calc.
Raw		 106.82
94.00		 38.40
28.67		 99.62
582.25		 0.00 244.84
 8  No Name #32490
 Calc.
Raw		 175.00
153.99		 49.12
36.67		 19.85
116.00		 0.00 243.97
 9  No Name #10102
 Calc.
Raw		 161.76
142.34		 47.78
35.67		 33.28
194.50		 0.00 242.82
 10  No Name #9103
 Calc.
Raw		 157.96
139.00		 48.66
36.33		 31.18
182.25		 0.00 237.80
 11  No Name #30663
 Calc.
Raw		 146.21
128.66		 39.28
29.33		 43.97
257.00		 0.00 229.46
 12  No Name #22311
 Calc.
Raw		 159.85
140.66		 39.28
29.33		 25.96
151.75		 0.00 225.09
 13  No Name #36451
 Calc.
Raw		 126.14
111.00		 39.28
29.33		 48.76
285.00		 0.00 214.18
 14  No Name #35911
 Calc.
Raw		 148.11
130.33		 31.70
23.67		 31.74
185.50		 0.00 211.55
 15  No Name #33488
 Calc.
Raw		 149.27
131.35		 37.50
28.00		 29.17
170.50		 6.00 209.94
 16  No Name #4637
 Calc.
Raw		 143.56
126.33		 39.28
29.33		 25.96
151.75		 0.00 208.80
 17  No Name #18255
 Calc.
Raw		 150.38
132.33		 50.00
37.33		 5.99
35.00		 0.00 206.37
 18  No Name #17068
 Calc.
Raw		 142.43
125.33		 38.40
28.67		 21.90
128.00		 0.00 202.73
 19  No Name #31161
 Calc.
Raw		 78.80
69.34		 33.93
25.33		 87.77
513.00		 2.00 198.50
 20  No Name #32441
 Calc.
Raw		 103.41
91.00		 37.50
28.00		 52.52
307.00		 0.00 193.43
 20  No Name #29018
 Calc.
Raw		 131.05
115.32		 36.16
27.00		 25.75
150.50		 0.00 192.96
 21  No Name #33292
 Calc.
Raw		 149.25
131.33		 25.01
18.67		 16.89
98.75		 0.00 191.15
 22  No Name #17622
 Calc.
Raw		 125.77
110.67		 35.27
26.33		 26.90
157.25		 0.00 187.94
 23  No Name #37852
 Calc.
Raw		 139.02
122.33		 38.40
28.67		 9.41
55.00		 0.00 186.83
 23  No Name #34802
 Calc.
Raw		 145.10
127.68		 29.02
21.67		 12.40
72.50		 0.00 186.52
 23  No Name #10146
 Calc.
Raw		 123.47
108.65		 36.16
27.00		 26.43
154.50		 0.00 186.06
 24  No Name #14186
 Calc.
Raw		 126.92
111.68		 25.45
19.00		 23.14
135.25		 0.00 175.51
 25  No Name #4307
 Calc.
Raw		 113.63
99.99		 43.30
32.33		 16.00
93.50		 0.00 172.93
 26  No Name #1412
 Calc.
Raw		 132.59
116.67		 22.77
17.00		 12.49
73.00		 0.00 167.85
 27  No Name #8451
 Calc.
Raw		 117.45
103.35		 35.72
26.67		 19.42
113.50		 8.00 164.59
 28  No Name #32144
 Calc.
Raw		 119.32
105.00		 25.01
18.67		 25.83
151.00		 20.00 150.16
 29  No Name #3148
 Calc.
Raw		 94.31
82.99		 23.21
17.33		 21.64
126.50		 6.00 133.16
 30  No Name #11105
 Calc.
Raw		 79.95
70.35		 37.50
28.00		 8.04
47.00		 0.00 125.49
 31  No Name #30595
 Calc.
Raw		 89.41
78.68		 24.55
18.33		 10.31
60.25		 12.00 112.27
 32  No Name #19633
 Calc.
Raw		 59.09
52.00		 32.15
24.00		 18.43
107.75		 2.00 107.67
 33  No Name #36469
 Calc.
Raw		 46.21
40.66		 39.74
29.67		 5.22
30.50		 0.00 91.17
 34  No Name #7940
 Calc.
Raw		 72.36
63.67		 15.18
11.33		 8.68
50.75		 7.00 89.22
 35  No Name #36540
 Calc.
Raw		 50.00
44.00		 10.72
8.00		 4.28
25.00		 3.00 62.00