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 2 Tech Transfer Division I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #1956
 Calc.
Raw		 200.00
145.50		 44.33
36.34		 87.55
79.67		 0.00 331.88
 2  No Name #5494
 Calc.
Raw		 177.32
129.00		 46.76
38.33		 91.95
83.67		 0.00 316.03
 3  No Name #34449
 Calc.
Raw		 173.88
126.50		 46.35
38.00		 93.77
85.33		 0.00 314.00
 4  No Name #31060
 Calc.
Raw		 179.38
130.50		 50.00
40.99		 80.22
73.00		 0.00 309.60
 4  No Name #30484
 Calc.
Raw		 180.07
131.00		 40.24
32.99		 88.65
80.67		 0.00 308.96
 5  No Name #13791
 Calc.
Raw		 189.00
137.50		 38.22
31.33		 72.53
66.00		 0.00 299.75
 5  No Name #1263
 Calc.
Raw		 159.45
116.00		 40.25
33.00		 100.00
91.00		 0.00 299.70
 6  No Name #23089
 Calc.
Raw		 171.13
124.50		 43.91
36.00		 76.92
70.00		 0.00 291.96
 7  No Name #32803
 Calc.
Raw		 178.69
130.00		 37.81
31.00		 71.07
64.67		 0.00 287.57
 7  No Name #25778
 Calc.
Raw		 161.51
117.50		 46.36
38.01		 79.12
72.00		 0.00 286.99
 8  No Name #468
 Calc.
Raw		 169.07
123.00		 38.63
31.67		 77.29
70.33		 0.00 284.99
 9  No Name #29453
 Calc.
Raw		 161.51
117.50		 37.81
31.00		 83.15
75.67		 0.00 282.47
 10  No Name #34691
 Calc.
Raw		 147.77
107.50		 40.25
33.00		 97.07
88.33		 4.00 281.09
 11  No Name #28384
 Calc.
Raw		 156.01
113.50		 37.00
30.33		 86.45
78.67		 0.00 279.46
 12  No Name #729
 Calc.
Raw		 156.70
114.00		 28.46
23.33		 86.45
78.67		 0.00 271.61
 13  No Name #34674
 Calc.
Raw		 180.07
131.00		 31.72
26.00		 57.88
52.67		 0.00 269.67
 14  No Name #31535
 Calc.
Raw		 156.01
113.50		 43.91
36.00		 66.67
60.67		 0.00 266.59
 14  No Name #15442
 Calc.
Raw		 173.20
126.00		 33.34
27.33		 59.70
54.33		 0.00 266.24
 14  No Name #13018
 Calc.
Raw		 156.01
113.50		 31.73
26.01		 78.02
71.00		 0.00 265.76
 15  No Name #23531
 Calc.
Raw		 144.33
105.00		 28.46
23.33		 92.67
84.33		 0.00 265.46
 15  No Name #32986
 Calc.
Raw		 149.83
109.00		 37.81
31.00		 77.29
70.33		 0.00 264.93
 16  No Name #1164
 Calc.
Raw		 139.52
101.50		 23.99
19.67		 99.64
90.67		 0.00 263.15
 17  No Name #11451
 Calc.
Raw		 142.27
103.50		 34.14
27.99		 83.15
75.67		 0.00 259.56
 17  No Name #9941
 Calc.
Raw		 154.64
112.50		 33.76
27.68		 70.33
64.00		 0.00 258.73
 18  No Name #29042
 Calc.
Raw		 146.39
106.50		 22.77
18.67		 88.27
80.33		 0.00 257.43
 18  No Name #1500
 Calc.
Raw		 150.52
109.50		 28.46
23.33		 78.02
71.00		 0.00 257.00
 19  No Name #31453
 Calc.
Raw		 142.27
103.50		 39.03
32.00		 67.77
61.67		 0.00 249.07
 19  No Name #465
 Calc.
Raw		 149.83
109.00		 32.53
26.67		 65.93
60.00		 0.00 248.29
 20  No Name #23365
 Calc.
Raw		 151.89
110.50		 32.93
27.00		 63.00
57.33		 0.00 247.82
 21  No Name #32265
 Calc.
Raw		 141.58
103.00		 39.03
32.00		 64.84
59.00		 0.00 245.45
 22  No Name #35162
 Calc.
Raw		 150.52
109.50		 25.21
20.67		 67.03
61.00		 0.00 242.76
 23  No Name #34199
 Calc.
Raw		 124.40
90.50		 26.02
21.33		 83.88
76.33		 0.00 234.30
 24  No Name #18449
 Calc.
Raw		 144.33
105.00		 22.36
18.33		 65.93
60.00		 0.00 232.62
 25  No Name #22341
 Calc.
Raw		 132.65
96.50		 34.15
28.00		 62.27
56.67		 0.00 229.07
 25  No Name #237
 Calc.
Raw		 129.21
94.00		 31.72
26.00		 67.40
61.33		 0.00 228.33
 25  No Name #27653
 Calc.
Raw		 161.51
117.50		 29.68
24.33		 37.00
33.67		 0.00 228.19
 26  No Name #14988
 Calc.
Raw		 120.96
88.00		 27.24
22.33		 76.56
69.67		 0.00 224.76
 27  No Name #10228
 Calc.
Raw		 135.40
98.50		 34.56
28.33		 44.69
40.67		 0.00 214.65
 28  No Name #7781
 Calc.
Raw		 125.09
91.00		 16.67
13.67		 71.79
65.33		 0.00 213.55
 28  No Name #3390
 Calc.
Raw		 124.40
90.50		 32.93
27.00		 55.68
50.67		 0.00 213.01
 29  No Name #22058
 Calc.
Raw		 129.90
94.50		 28.46
23.33		 50.19
45.67		 0.00 208.55
 30  No Name #30179
 Calc.
Raw		 116.84
85.00		 21.96
18.00		 72.89
66.33		 5.00 206.69
 30  No Name #34302
 Calc.
Raw		 114.09
83.00		 23.59
19.34		 68.49
62.33		 0.00 206.17
 30  No Name #22211
 Calc.
Raw		 132.65
96.50		 24.40
20.00		 48.71
44.33		 0.00 205.76
 31  No Name #35202
 Calc.
Raw		 117.53
85.50		 21.96
18.00		 62.27
56.67		 0.00 201.76
 32  No Name #33836
 Calc.
Raw		 130.58
95.00		 23.99
19.67		 40.66
37.00		 3.00 192.23
 33  No Name #33345
 Calc.
Raw		 109.97
80.00		 16.67
13.67		 61.18
55.67		 0.00 187.82
 34  No Name #497
 Calc.
Raw		 92.10
67.00		 13.82
11.33		 76.92
70.00		 0.00 182.84
 35  No Name #33846
 Calc.
Raw		 102.41
74.50		 21.15
17.34		 60.44
55.00		 3.00 181.00
 35  No Name #34462
 Calc.
Raw		 114.09
83.00		 15.04
12.33		 56.78
51.67		 5.00 180.91
 36  No Name #34242
 Calc.
Raw		 90.03
65.50		 15.45
12.67		 57.14
52.00		 0.00 162.62