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 4 Out Of The Box Balsa Division III
 Rank   Member    Long
Term		  Weight  Style  Spont  Penalty  Total
 1  No Name #32660
 Calc.
Raw		 190.29
27.66		 150.00
980.00		 50.00
42.00		 100.00
139.50		 0.00 340.29
 2  No Name #2130
 Calc.
Raw		 178.51
31.66		 132.40
865.00		 46.82
39.33		 83.43
116.38		 0.00 308.76
 3  No Name #32868
 Calc.
Raw		 131.57
14.67		 110.20
720.00		 42.07
35.34		 99.46
138.75		 0.00 273.10
 4  No Name #7158
 Calc.
Raw		 149.91
8.34		 137.76
900.00		 43.25
36.33		 69.27
96.63		 0.00 262.43
 5  No Name #2660
 Calc.
Raw		 166.02
11.00		 150.00
980.00		 32.13
26.99		 58.70
81.88		 0.00 256.85
 5  No Name #3694
 Calc.
Raw		 115.31
24.00		 80.36
525.00		 43.25
36.33		 97.31
135.75		 0.00 255.87
 6  No Name #2149
 Calc.
Raw		 119.88
14.00		 99.49
650.00		 34.51
28.99		 98.75
137.75		 0.00 253.14
 6  No Name #26200
 Calc.
Raw		 157.85
18.00		 131.63
860.00		 32.54
27.33		 62.64
87.38		 0.00 253.03
 7  No Name #19945
 Calc.
Raw		 116.67
16.00		 93.37
610.00		 32.95
27.68		 99.64
139.00		 0.00 249.26
 8  No Name #3260
 Calc.
Raw		 127.03
17.33		 101.79
665.00		 42.85
35.99		 63.44
88.50		 0.00 233.32
 9  No Name #13390
 Calc.
Raw		 131.49
19.34		 103.32
675.00		 28.58
24.01		 67.48
94.13		 0.00 227.55
 10  No Name #3637
 Calc.
Raw		 107.26
19.00		 79.59
520.00		 44.83
37.66		 70.34
98.13		 0.00 222.43
 11  No Name #5109
 Calc.
Raw		 116.97
12.00		 99.49
650.00		 36.11
30.33		 67.92
94.75		 0.00 221.00
 12  No Name #32995
 Calc.
Raw		 113.98
11.00		 97.96
640.00		 44.44
37.33		 52.78
73.63		 0.00 211.20
 13  No Name #24409
 Calc.
Raw		 120.30
11.66		 103.32
675.00		 36.50
30.66		 52.15
72.75		 0.00 208.95
 14  No Name #35752
 Calc.
Raw		 101.58
16.67		 77.30
505.00		 33.33
28.00		 68.91
96.13		 0.00 203.82
 15  No Name #11102
 Calc.
Raw		 63.82
13.34		 44.39
290.00		 36.92
31.01		 98.39
137.25		 0.00 199.13
 16  No Name #33516
 Calc.
Raw		 119.25
29.33		 76.53
500.00		 40.48
34.00		 37.99
53.00		 0.00 197.72
 17  No Name #786
 Calc.
Raw		 79.71
19.00		 52.04
340.00		 25.00
21.00		 83.61
116.63		 0.00 188.32
 18  No Name #20819
 Calc.
Raw		 89.56
10.00		 75.00
490.00		 22.62
19.00		 67.66
94.38		 0.00 179.84
 18  No Name #20528
 Calc.
Raw		 72.43
27.66		 32.14
210.00		 37.31
31.34		 69.18
96.50		 0.00 178.92
 19  No Name #23464
 Calc.
Raw		 89.20
15.00		 67.35
440.00		 24.60
20.66		 63.62
88.75		 0.00 177.42
 20  No Name #2039
 Calc.
Raw		 38.06
16.67		 13.78
90.00		 40.48
34.00		 97.41
135.88		 0.00 175.95
 21  No Name #34606
 Calc.
Raw		 92.92
23.34		 58.93
385.00		 29.36
24.66		 52.15
72.75		 0.00 174.43
 22  No Name #8451
 Calc.
Raw		 60.98
10.34		 45.92
300.00		 38.89
32.67		 68.28
95.25		 0.00 168.15
 23  No Name #3506
 Calc.
Raw		 92.86
20.67		 62.76
410.00		 28.18
23.67		 62.54
87.25		 20.00 163.58
 23  No Name #31228
 Calc.
Raw		 61.19
7.33		 50.51
330.00		 40.08
33.67		 61.83
86.25		 0.00 163.10
 24  No Name #3069
 Calc.
Raw		 39.69
22.00		 7.65
50.00		 24.20
20.33		 97.94
136.63		 0.00 161.83
 25  No Name #3473
 Calc.
Raw		 58.10
14.67		 36.73
240.00		 31.35
26.33		 68.82
96.00		 0.00 158.27
 26  No Name #33422
 Calc.
Raw		 45.90
21.00		 15.31
100.00		 38.49
32.33		 69.27
96.63		 0.00 153.66
 27  No Name #32417
 Calc.
Raw		 37.01
13.33		 17.60
115.00		 16.26
13.66		 98.39
137.25		 0.00 151.66
 27  No Name #30958
 Calc.
Raw		 56.64
13.67		 36.73
240.00		 34.12
28.66		 60.13
83.88		 0.00 150.89
 28  No Name #183
 Calc.
Raw		 44.15
20.33		 14.54
95.00		 25.80
21.67		 78.32
109.25		 0.00 148.27
 29  No Name #32435
 Calc.
Raw		 39.47
25.00		 3.06
20.00		 31.75
26.67		 68.10
95.00		 0.00 139.32
 30  No Name #8871
 Calc.
Raw		 31.17
13.00		 12.24
80.00		 33.74
28.34		 68.55
95.63		 0.00 133.46
 30  No Name #34922
 Calc.
Raw		 37.84
16.00		 14.54
95.00		 26.19
22.00		 69.09
96.38		 0.00 133.12
 31  No Name #36490
 Calc.
Raw		 22.96
13.66		 3.06
20.00		 21.02
17.66		 81.28
113.38		 0.00 125.26
 31  No Name #37169
 Calc.
Raw		 20.89
14.34		 0.00
0.00		 36.50
30.66		 67.66
94.38		 0.00 125.05
 32  No Name #32969
 Calc.
Raw		 46.83
11.66		 29.85
195.00		 34.13
28.67		 52.69
73.50		 10.00 123.65
 33  No Name #17068
 Calc.
Raw		 67.40
16.33		 43.62
285.00		 13.48
11.32		 36.29
50.63		 0.00 117.17
 34  No Name #17250
 Calc.
Raw		 11.17
7.67		 0.00
0.00		 27.38
23.00		 67.03
93.50		 0.00 105.58
 35  No Name #26319
 Calc.
Raw		 50.00
34.33		 0.00
0.00		 25.39
21.33		 24.55
34.25		 0.00 99.94
 36  No Name #36505
 Calc.
Raw		 19.08
11.00		 3.06
20.00		 14.29
12.00		 47.49
66.25		 0.00 80.86
 37  No Name #37143
 Calc.
Raw		 7.28
5.00		 0.00
0.00		 9.92
8.33		 57.17
79.75		 0.00 74.37
 38  No Name #30532
 Calc.
Raw		 29.28
18.00		 3.06
20.00		 26.98
22.66		 10.04
14.00		 0.00 66.30