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 2 Tech Transfer Division I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #34094
 Calc.
Raw		 200.00
160.50		 46.79
34.00		 92.73
97.67		 0.00 339.52
 2  No Name #532
 Calc.
Raw		 191.28
153.50		 48.17
35.00		 78.49
82.67		 0.00 317.94
 3  No Name #18112
 Calc.
Raw		 188.16
151.00		 37.63
27.34		 82.28
86.67		 0.00 308.07
 4  No Name #35403
 Calc.
Raw		 179.44
144.00		 33.03
24.00		 89.88
94.67		 0.00 302.35
 5  No Name #17473
 Calc.
Raw		 176.95
142.00		 33.04
24.01		 91.14
96.00		 0.00 301.13
 6  No Name #10061
 Calc.
Raw		 170.09
136.50		 40.83
29.67		 88.61
93.33		 0.00 299.53
 7  No Name #3260
 Calc.
Raw		 177.57
142.50		 50.00
36.33		 69.62
73.33		 0.00 297.19
 7  No Name #34123
 Calc.
Raw		 171.34
137.50		 42.21
30.67		 83.55
88.00		 0.00 297.10
 8  No Name #5128
 Calc.
Raw		 170.72
137.00		 33.03
24.00		 83.86
88.33		 0.00 287.61
 9  No Name #26347
 Calc.
Raw		 177.57
142.50		 42.21
30.67		 63.30
66.67		 0.00 283.08
 10  No Name #18449
 Calc.
Raw		 164.49
132.00		 33.03
24.00		 81.01
85.33		 0.00 278.53
 11  No Name #35803
 Calc.
Raw		 173.21
139.00		 31.65
23.00		 72.15
76.00		 0.00 277.01
 12  No Name #34504
 Calc.
Raw		 160.12
128.50		 30.28
22.00		 82.28
86.67		 0.00 272.68
 13  No Name #30179
 Calc.
Raw		 171.96
138.00		 36.71
26.67		 62.02
65.33		 0.00 270.69
 14  No Name #27122
 Calc.
Raw		 165.11
132.50		 24.77
18.00		 79.75
84.00		 0.00 269.63
 15  No Name #30361
 Calc.
Raw		 165.11
132.50		 28.90
21.00		 73.42
77.33		 0.00 267.43
 16  No Name #34829
 Calc.
Raw		 166.36
133.50		 25.23
18.33		 73.42
77.33		 0.00 265.01
 17  No Name #35282
 Calc.
Raw		 165.11
132.50		 29.34
21.32		 68.36
72.00		 0.00 262.81
 18  No Name #36008
 Calc.
Raw		 171.96
138.00		 29.37
21.34		 58.23
61.33		 0.00 259.56
 19  No Name #1500
 Calc.
Raw		 142.68
114.50		 31.20
22.67		 83.55
88.00		 0.00 257.43
 20  No Name #34320
 Calc.
Raw		 148.91
119.50		 35.33
25.67		 70.89
74.67		 0.00 255.13
 20  No Name #2272
 Calc.
Raw		 163.24
131.00		 30.73
22.33		 60.76
64.00		 0.00 254.73
 21  No Name #31305
 Calc.
Raw		 151.40
121.50		 34.41
25.00		 67.09
70.67		 0.00 252.90
 22  No Name #35667
 Calc.
Raw		 171.34
137.50		 31.65
23.00		 48.11
50.67		 1.00 250.10
 22  No Name #35666
 Calc.
Raw		 156.39
125.50		 28.45
20.67		 64.56
68.00		 0.00 249.40
 23  No Name #12534
 Calc.
Raw		 157.63
126.50		 23.40
17.00		 67.09
70.67		 0.00 248.12
 24  No Name #9971
 Calc.
Raw		 150.16
120.50		 27.98
20.33		 68.36
72.00		 0.00 246.50
 24  No Name #34399
 Calc.
Raw		 152.02
122.00		 33.48
24.33		 60.76
64.00		 0.00 246.26
 24  No Name #2746
 Calc.
Raw		 123.36
99.00		 38.08
27.67		 84.81
89.33		 0.00 246.25
 25  No Name #715
 Calc.
Raw		 146.42
117.50		 22.96
16.68		 75.95
80.00		 0.00 245.33
 26  No Name #1011
 Calc.
Raw		 163.24
131.00		 27.07
19.67		 51.90
54.67		 0.00 242.21
 27  No Name #45
 Calc.
Raw		 157.63
126.50		 27.07
19.67		 51.90
54.67		 0.00 236.60
 28  No Name #35502
 Calc.
Raw		 141.43
113.50		 23.41
17.01		 68.99
72.67		 0.00 233.83
 29  No Name #1859
 Calc.
Raw		 129.60
104.00		 33.48
24.33		 67.09
70.67		 0.00 230.17
 30  No Name #35834
 Calc.
Raw		 130.22
104.50		 34.87
25.34		 56.96
60.00		 0.00 222.05
 31  No Name #35869
 Calc.
Raw		 165.11
132.50		 31.65
23.00		 18.99
20.00		 0.00 215.75
 32  No Name #14485
 Calc.
Raw		 94.08
75.50		 37.63
27.34		 81.01
85.33		 0.00 212.72
 33  No Name #35342
 Calc.
Raw		 69.78
56.00		 40.83
29.67		 100.00
105.33		 0.00 210.61
 34  No Name #35727
 Calc.
Raw		 104.67
84.00		 32.58
23.67		 69.62
73.33		 0.00 206.87
 35  No Name #15559
 Calc.
Raw		 113.40
91.00		 29.37
21.34		 56.96
60.00		 0.00 199.73
 35  No Name #33497
 Calc.
Raw		 123.36
99.00		 23.85
17.33		 53.17
56.00		 1.00 199.38
 36  No Name #33665
 Calc.
Raw		 74.77
60.00		 45.42
33.00		 82.28
86.67		 6.00 196.47
 37  No Name #31733
 Calc.
Raw		 114.64
92.00		 23.86
17.34		 55.70
58.67		 0.00 194.20
 38  No Name #31871
 Calc.
Raw		 81.62
65.50		 17.44
12.67		 92.40
97.33		 0.00 191.46
 39  No Name #28638
 Calc.
Raw		 100.93
81.00		 21.57
15.67		 56.96
60.00		 0.00 179.46
 40  No Name #24450
 Calc.
Raw		 94.70
76.00		 21.11
15.34		 59.50
62.67		 6.00 169.31
 41  No Name #35396
 Calc.
Raw		 86.60
69.50		 29.36
21.33		 49.37
52.00		 0.00 165.33
 42  No Name #8704
 Calc.
Raw		 67.29
54.00		 24.77
18.00		 67.09
70.67		 15.00 144.15
 43  No Name #35198
 Calc.
Raw		 79.13
63.50		 8.71
6.33		 53.17
56.00		 0.00 141.01