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 3 The Wonderful Muses Division I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #36128
 Calc.
Raw		 200.00
149.25		 42.62
34.67		 97.96
79.67		 0.00 340.58
 2  No Name #28109
 Calc.
Raw		 183.92
137.25		 50.00
40.67		 100.00
81.33		 0.00 333.92
 3  No Name #34691
 Calc.
Raw		 197.32
147.25		 43.43
35.33		 89.35
72.67		 0.00 330.10
 4  No Name #37855
 Calc.
Raw		 187.94
140.25		 45.08
36.67		 85.66
69.67		 0.00 318.68
 5  No Name #28584
 Calc.
Raw		 173.87
129.75		 38.11
31.00		 84.84
69.00		 0.00 296.82
 6  No Name #35458
 Calc.
Raw		 166.50
124.25		 40.57
33.00		 82.79
67.33		 0.00 289.86
 7  No Name #30963
 Calc.
Raw		 194.64
145.25		 40.98
33.33		 51.24
41.67		 0.00 286.86
 8  No Name #12573
 Calc.
Raw		 158.12
118.00		 33.19
27.00		 91.81
74.67		 0.00 283.12
 8  No Name #20522
 Calc.
Raw		 150.75
112.50		 40.98
33.33		 91.39
74.33		 0.00 283.12
 8  No Name #30348
 Calc.
Raw		 176.55
131.75		 40.16
32.67		 66.40
54.00		 0.00 283.11
 9  No Name #22341
 Calc.
Raw		 149.41
111.50		 35.65
29.00		 97.96
79.67		 2.00 281.02
 9  No Name #33807
 Calc.
Raw		 151.42
113.00		 36.48
29.67		 93.04
75.67		 0.00 280.94
 9  No Name #32073
 Calc.
Raw		 170.52
127.25		 37.29
30.33		 72.54
59.00		 0.00 280.35
 10  No Name #16465
 Calc.
Raw		 164.49
122.75		 37.71
30.67		 72.95
59.33		 0.00 275.15
 11  No Name #32994
 Calc.
Raw		 170.85
127.50		 38.11
31.00		 65.17
53.00		 0.00 274.13
 12  No Name #6379
 Calc.
Raw		 152.76
114.00		 38.94
31.67		 79.10
64.33		 0.00 270.80
 13  No Name #1178
 Calc.
Raw		 168.17
125.50		 37.29
30.33		 63.53
51.67		 0.00 268.99
 14  No Name #35162
 Calc.
Raw		 181.24
135.25		 43.03
35.00		 40.58
33.00		 0.00 264.85
 15  No Name #34320
 Calc.
Raw		 171.52
128.00		 24.18
19.67		 67.22
54.67		 2.00 260.92
 16  No Name #1423
 Calc.
Raw		 177.55
132.50		 34.02
27.67		 47.95
39.00		 0.00 259.52
 17  No Name #28057
 Calc.
Raw		 156.78
117.00		 40.57
33.00		 65.17
53.00		 5.00 257.52
 17  No Name #33109
 Calc.
Raw		 133.67
99.75		 30.33
24.67		 93.04
75.67		 0.00 257.04
 18  No Name #33315
 Calc.
Raw		 164.49
122.75		 36.48
29.67		 55.33
45.00		 0.00 256.30
 19  No Name #25994
 Calc.
Raw		 186.93
139.50		 46.31
37.67		 11.89
9.67		 0.00 245.13
 19  No Name #37222
 Calc.
Raw		 116.92
87.25		 29.10
23.67		 98.77
80.33		 0.00 244.79
 20  No Name #28679
 Calc.
Raw		 153.10
114.25		 37.29
30.33		 56.56
46.00		 5.00 241.95
 21  No Name #31535
 Calc.
Raw		 157.12
117.25		 47.12
38.33		 31.14
25.33		 0.00 235.38
 22  No Name #34111
 Calc.
Raw		 174.87
130.50		 43.85
35.67		 11.07
9.00		 0.00 229.79
 22  No Name #34974
 Calc.
Raw		 162.14
121.00		 38.52
31.33		 28.69
23.33		 0.00 229.35
 23  No Name #14485
 Calc.
Raw		 173.20
129.25		 36.06
29.33		 19.27
15.67		 0.00 228.53
 23  No Name #34910
 Calc.
Raw		 149.08
111.25		 30.33
24.67		 48.78
39.67		 0.00 228.19
 24  No Name #603
 Calc.
Raw		 158.46
118.25		 24.59
20.00		 42.63
34.67		 0.00 225.68
 25  No Name #36149
 Calc.
Raw		 168.51
125.75		 42.62
34.67		 13.53
11.00		 0.00 224.66
 25  No Name #35490
 Calc.
Raw		 154.44
115.25		 27.45
22.33		 42.21
34.33		 0.00 224.10
 26  No Name #15746
 Calc.
Raw		 130.99
97.75		 19.26
15.67		 72.14
58.67		 0.00 222.39
 27  No Name #37234
 Calc.
Raw		 144.39
107.75		 33.60
27.33		 42.21
34.33		 0.00 220.20
 28  No Name #28844
 Calc.
Raw		 146.73
109.50		 22.95
18.67		 48.36
39.33		 0.00 218.04
 28  No Name #28372
 Calc.
Raw		 127.30
95.00		 31.14
25.33		 59.02
48.00		 0.00 217.46
 29  No Name #19400
 Calc.
Raw		 153.77
114.75		 35.25
28.67		 23.77
19.33		 0.00 212.79
 29  No Name #35577
 Calc.
Raw		 153.10
114.25		 31.14
25.33		 27.87
22.67		 0.00 212.11
 30  No Name #13800
 Calc.
Raw		 169.85
126.75		 38.94
31.67		 12.70
10.33		 15.00 206.49
 31  No Name #14186
 Calc.
Raw		 141.37
105.50		 34.02
27.67		 27.46
22.33		 0.00 202.85
 32  No Name #34487
 Calc.
Raw		 141.04
105.25		 30.74
25.00		 27.46
22.33		 0.00 199.24
 33  No Name #32345
 Calc.
Raw		 147.74
110.25		 36.48
29.67		 11.89
9.67		 0.00 196.11
 34  No Name #13857
 Calc.
Raw		 149.75
111.75		 31.96
26.00		 11.89
9.67		 0.00 193.60
 35  No Name #177
 Calc.
Raw		 135.01
100.75		 23.76
19.33		 33.60
27.33		 0.00 192.37
 36  No Name #34916
 Calc.
Raw		 149.08
111.25		 31.14
25.33		 10.66
8.67		 0.00 190.88
 36  No Name #6161
 Calc.
Raw		 158.46
118.25		 26.22
21.33		 6.15
5.00		 0.00 190.83
 36  No Name #1164
 Calc.
Raw		 138.02
103.00		 35.25
28.67		 27.46
22.33		 10.00 190.73
 37  No Name #36534
 Calc.
Raw		 129.31
96.50		 26.64
21.67		 14.75
12.00		 0.00 170.70
 38  No Name #37854
 Calc.
Raw		 124.96
93.25		 29.91
24.33		 10.24
8.33		 0.00 165.11