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 2006 May 24th
 Problem 1 The Great Parade Division II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #34622
 Calc.
Raw		 200.00
133.00		 50.00
45.67		 70.92
200.00		 0.00 320.92
 2  No Name #1964
 Calc.
Raw		 191.46
127.32		 39.79
36.34		 75.53
213.00		 0.00 306.78
 3  No Name #28057
 Calc.
Raw		 169.94
113.01		 35.03
32.00		 99.56
280.75		 0.00 304.53
 4  No Name #9642
 Calc.
Raw		 153.40
102.01		 44.53
40.67		 100.00
282.00		 0.00 297.93
 5  No Name #2269
 Calc.
Raw		 177.44
118.00		 37.96
34.67		 73.58
207.50		 0.00 288.98
 6  No Name #32289
 Calc.
Raw		 174.44
116.00		 29.57
27.01		 82.45
232.50		 0.00 286.46
 7  No Name #3249
 Calc.
Raw		 185.98
123.68		 36.13
33.00		 60.73
171.25		 0.00 282.84
 8  No Name #5758
 Calc.
Raw		 183.44
121.99		 34.67
31.67		 61.97
174.75		 0.00 280.08
 9  No Name #31893
 Calc.
Raw		 159.89
106.33		 40.88
37.34		 72.16
203.50		 0.00 272.93
 10  No Name #4328
 Calc.
Raw		 190.51
126.69		 34.67
31.67		 45.57
128.50		 0.00 270.75
 11  No Name #4323
 Calc.
Raw		 176.95
117.67		 38.68
35.33		 47.16
133.00		 0.00 262.79
 12  No Name #3763
 Calc.
Raw		 164.95
109.69		 33.95
31.01		 62.32
175.75		 0.00 261.22
 12  No Name #31562
 Calc.
Raw		 179.43
119.32		 32.48
29.67		 48.58
137.00		 0.00 260.49
 13  No Name #22311
 Calc.
Raw		 163.41
108.67		 33.21
30.33		 62.32
175.75		 0.00 258.94
 14  No Name #29469
 Calc.
Raw		 176.95
117.67		 40.87
37.33		 36.17
102.00		 0.00 253.99
 15  No Name #31458
 Calc.
Raw		 171.44
114.01		 36.50
33.34		 44.77
126.25		 0.00 252.71
 16  No Name #20868
 Calc.
Raw		 168.93
112.34		 28.84
26.34		 53.01
149.50		 0.00 250.78
 17  No Name #30710
 Calc.
Raw		 178.45
118.67		 29.21
26.68		 41.49
117.00		 0.00 249.15
 18  No Name #18218
 Calc.
Raw		 162.90
108.33		 29.20
26.67		 55.05
155.25		 0.00 247.15
 19  No Name #30686
 Calc.
Raw		 150.39
100.01		 42.34
38.67		 50.89
143.50		 0.00 243.62
 19  No Name #31852
 Calc.
Raw		 156.90
104.34		 36.13
33.00		 50.35
142.00		 0.00 243.38
 20  No Name #32184
 Calc.
Raw		 144.87
96.34		 30.29
27.67		 67.20
189.50		 0.00 242.36
 20  No Name #11901
 Calc.
Raw		 151.38
100.67		 33.21
30.33		 57.45
162.00		 0.00 242.04
 21  No Name #31696
 Calc.
Raw		 179.94
119.66		 31.75
29.00		 29.61
83.50		 0.00 241.30
 22  No Name #11548
 Calc.
Raw		 167.43
111.34		 32.84
30.00		 39.27
110.75		 0.00 239.54
 23  No Name #34080
 Calc.
Raw		 129.82
86.33		 30.65
28.00		 76.77
216.50		 0.00 237.24
 23  No Name #31230
 Calc.
Raw		 162.39
107.99		 31.75
29.00		 42.91
121.00		 0.00 237.05
 24  No Name #27796
 Calc.
Raw		 146.83
97.64		 30.65
28.00		 57.80
163.00		 0.00 235.28
 25  No Name #10076
 Calc.
Raw		 143.86
95.67		 20.07
18.33		 68.53
193.25		 0.00 232.46
 26  No Name #34546
 Calc.
Raw		 131.85
87.68		 19.35
17.67		 76.60
216.00		 0.00 227.80
 27  No Name #9939
 Calc.
Raw		 159.38
105.99		 29.92
27.33		 36.52
103.00		 0.00 225.82
 28  No Name #13304
 Calc.
Raw		 155.88
103.66		 29.20
26.67		 37.50
105.75		 0.00 222.58
 28  No Name #26110
 Calc.
Raw		 149.35
99.32		 31.75
29.00		 41.31
116.50		 0.00 222.41
 29  No Name #32168
 Calc.
Raw		 149.89
99.68		 39.79
36.34		 28.72
81.00		 0.00 218.40
 30  No Name #33816
 Calc.
Raw		 127.83
85.01		 27.37
25.00		 61.26
172.75		 0.00 216.46
 31  No Name #1715
 Calc.
Raw		 137.85
91.67		 35.41
32.34		 42.02
118.50		 0.00 215.28
 31  No Name #34576
 Calc.
Raw		 138.33
91.99		 32.48
29.67		 44.33
125.00		 0.00 215.14
 32  No Name #13338
 Calc.
Raw		 139.83
92.99		 27.73
25.33		 46.28
130.50		 0.00 213.84
 33  No Name #31604
 Calc.
Raw		 139.85
93.00		 31.39
28.67		 40.43
114.00		 0.00 211.67
 34  No Name #34082
 Calc.
Raw		 123.80
82.33		 28.47
26.00		 57.00
160.75		 0.00 209.27
 35  No Name #2993
 Calc.
Raw		 129.32
86.00		 42.34
38.67		 36.52
103.00		 0.00 208.18
 35  No Name #32909
 Calc.
Raw		 140.33
93.32		 27.74
25.34		 39.45
111.25		 0.00 207.52
 36  No Name #35698
 Calc.
Raw		 121.31
80.67		 19.35
17.67		 61.61
173.75		 0.00 202.27
 36  No Name #35687
 Calc.
Raw		 143.37
95.34		 18.25
16.67		 50.09
141.25		 10.00 201.71
 36  No Name #20184
 Calc.
Raw		 119.82
79.68		 34.31
31.34		 47.52
134.00		 0.00 201.65
 37  No Name #20480
 Calc.
Raw		 130.33
86.67		 25.18
23.00		 44.33
125.00		 0.00 199.84
 38  No Name #3422
 Calc.
Raw		 118.77
78.98		 32.11
29.33		 56.74
160.00		 10.00 197.62
 39  No Name #22504
 Calc.
Raw		 119.31
79.34		 32.11
29.33		 40.16
113.25		 0.00 191.58
 40  No Name #33946
 Calc.
Raw		 128.83
85.67		 28.11
25.68		 29.17
82.25		 0.00 186.11
 41  No Name #35337
 Calc.
Raw		 118.27
78.65		 22.63
20.67		 42.11
118.75		 0.00 183.01
 42  No Name #15824
 Calc.
Raw		 111.80
74.35		 27.01
24.67		 29.26
82.50		 0.00 168.07
 42  No Name #34897
 Calc.
Raw		 100.75
67.00		 32.48
29.67		 43.97
124.00		 10.00 167.20
 43  No Name #7069
 Calc.
Raw		 97.25
64.67		 19.35
17.67		 37.32
105.25		 0.00 153.92
 44  No Name #33846
 Calc.
Raw		 92.23
61.33		 18.61
17.00		 37.94
107.00		 5.00 143.78
 45  No Name #35989
 Calc.
Raw		 78.18
51.99		 13.14
12.00		 32.00
90.25		 0.00 123.32