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 5 The Eccentrics! Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #31225
 Calc.
Raw		 200.00
154.00		 40.30
33.25		 97.66
111.33		 0.00 337.96
 2  No Name #31230
 Calc.
Raw		 173.38
133.50		 48.79
40.25		 93.86
107.00		 0.00 316.03
 3  No Name #35204
 Calc.
Raw		 182.14
140.25		 38.48
31.75		 90.64
103.33		 0.00 311.26
 4  No Name #36232
 Calc.
Raw		 177.92
137.00		 40.91
33.75		 79.82
91.00		 0.00 298.65
 4  No Name #12306
 Calc.
Raw		 164.61
126.75		 43.64
36.00		 90.06
102.67		 0.00 298.31
 5  No Name #27297
 Calc.
Raw		 187.01
144.00		 40.61
33.50		 68.13
77.67		 0.00 295.75
 6  No Name #30883
 Calc.
Raw		 164.94
127.00		 50.00
41.25		 72.81
83.00		 0.00 287.75
 7  No Name #34418
 Calc.
Raw		 165.58
127.50		 30.00
24.75		 85.09
97.00		 0.00 280.67
 8  No Name #11781
 Calc.
Raw		 144.81
111.50		 39.39
32.50		 92.39
105.33		 0.00 276.59
 9  No Name #5808
 Calc.
Raw		 160.06
123.25		 30.00
24.75		 91.82
104.67		 10.00 271.88
 9  No Name #3506
 Calc.
Raw		 153.57
118.25		 38.18
31.50		 79.54
90.67		 0.00 271.29
 10  No Name #16607
 Calc.
Raw		 155.52
119.75		 37.88
31.25		 87.43
99.67		 10.00 270.83
 10  No Name #27336
 Calc.
Raw		 144.48
111.25		 28.79
23.75		 96.78
110.33		 0.00 270.05
 11  No Name #32798
 Calc.
Raw		 154.55
119.00		 26.97
22.25		 88.31
100.67		 0.00 269.83
 11  No Name #7975
 Calc.
Raw		 160.39
123.50		 43.03
35.50		 65.50
74.67		 0.00 268.92
 12  No Name #30551
 Calc.
Raw		 148.38
114.25		 34.85
28.75		 84.50
96.33		 0.00 267.73
 12  No Name #30408
 Calc.
Raw		 166.56
128.25		 30.91
25.50		 69.59
79.33		 0.00 267.06
 13  No Name #36606
 Calc.
Raw		 137.01
105.50		 41.82
34.50		 85.38
97.33		 0.00 264.21
 14  No Name #19945
 Calc.
Raw		 136.04
104.75		 39.09
32.25		 86.25
98.33		 0.00 261.38
 14  No Name #10328
 Calc.
Raw		 141.88
109.25		 29.09
24.00		 100.00
114.00		 10.00 260.97
 15  No Name #4637
 Calc.
Raw		 158.44
122.00		 29.09
24.00		 72.22
82.33		 0.00 259.75
 16  No Name #27946
 Calc.
Raw		 154.55
119.00		 34.24
28.25		 69.59
79.33		 0.00 258.38
 16  No Name #9361
 Calc.
Raw		 172.40
132.75		 16.06
13.25		 69.30
79.00		 0.00 257.76
 17  No Name #34990
 Calc.
Raw		 144.81
111.50		 27.58
22.75		 83.62
95.33		 0.00 256.01
 17  No Name #35288
 Calc.
Raw		 150.32
115.75		 33.94
28.00		 71.34
81.33		 0.00 255.60
 18  No Name #21290
 Calc.
Raw		 149.35
115.00		 26.36
21.75		 78.07
89.00		 0.00 253.78
 18  No Name #3244
 Calc.
Raw		 151.30
116.50		 40.30
33.25		 66.96
76.33		 5.00 253.56
 18  No Name #11749
 Calc.
Raw		 150.32
115.75		 32.73
27.00		 69.89
79.67		 0.00 252.94
 19  No Name #26319
 Calc.
Raw		 134.42
103.50		 26.67
22.00		 89.47
102.00		 0.00 250.56
 19  No Name #35174
 Calc.
Raw		 144.48
111.25		 37.27
30.75		 68.42
78.00		 0.00 250.17
 19  No Name #29601
 Calc.
Raw		 153.57
118.25		 35.76
29.50		 60.53
69.00		 0.00 249.86
 20  No Name #31346
 Calc.
Raw		 136.36
105.00		 27.27
22.50		 84.21
96.00		 0.00 247.84
 21  No Name #27017
 Calc.
Raw		 150.65
116.00		 35.76
29.50		 59.65
68.00		 0.00 246.06
 22  No Name #31865
 Calc.
Raw		 138.96
107.00		 30.91
25.50		 72.52
82.67		 0.00 242.39
 22  No Name #35578
 Calc.
Raw		 140.91
108.50		 30.00
24.75		 71.05
81.00		 0.00 241.96
 23  No Name #35475
 Calc.
Raw		 135.71
104.50		 41.82
34.50		 61.99
70.67		 0.00 239.52
 24  No Name #33819
 Calc.
Raw		 138.96
107.00		 31.82
26.25		 66.08
75.33		 0.00 236.86
 25  No Name #37825
 Calc.
Raw		 153.90
118.50		 23.33
19.25		 57.61
65.67		 0.00 234.84
 25  No Name #30426
 Calc.
Raw		 138.64
106.75		 26.97
22.25		 68.71
78.33		 0.00 234.32
 26  No Name #35658
 Calc.
Raw		 138.64
106.75		 25.45
21.00		 69.01
78.67		 0.00 233.10
 27  No Name #37764
 Calc.
Raw		 143.51
110.50		 20.91
17.25		 66.67
76.00		 0.00 231.09
 28  No Name #36810
 Calc.
Raw		 135.39
104.25		 18.48
15.25		 73.68
84.00		 0.00 227.55
 28  No Name #10806
 Calc.
Raw		 141.56
109.00		 26.06
21.50		 69.01
78.67		 10.00 226.63
 29  No Name #23202
 Calc.
Raw		 154.22
118.75		 24.85
20.50		 47.08
53.67		 0.00 226.15
 29  No Name #1386
 Calc.
Raw		 131.49
101.25		 23.33
19.25		 70.76
80.67		 0.00 225.58
 30  No Name #32969
 Calc.
Raw		 134.74
103.75		 23.33
19.25		 71.64
81.67		 5.00 224.71
 31  No Name #19063
 Calc.
Raw		 137.66
106.00		 25.76
21.25		 78.07
89.00		 25.00 216.49
 32  No Name #31108
 Calc.
Raw		 130.84
100.75		 23.64
19.50		 56.43
64.33		 0.00 210.91
 33  No Name #33010
 Calc.
Raw		 126.95
97.75		 26.06
21.50		 56.14
64.00		 0.00 209.15
 34  No Name #35302
 Calc.
Raw		 133.77
103.00		 17.27
14.25		 54.68
62.33		 0.00 205.72
 35  No Name #1790
 Calc.
Raw		 108.12
83.25		 18.79
15.50		 69.89
79.67		 0.00 196.80
 36  No Name #11172
 Calc.
Raw		 116.56
89.75		 20.91
17.25		 57.61
65.67		 0.00 195.08
 37  No Name #6091
 Calc.
Raw		 118.51
91.25		 15.76
13.00		 52.34
59.67		 0.00 186.61
 38  No Name #8871
 Calc.
Raw		 105.52
81.25		 22.12
18.25		 66.38
75.67		 15.00 179.02
 39  No Name #33846
 Calc.
Raw		 110.71
85.25		 15.76
13.00		 47.66
54.33		 0.00 174.13
 40  No Name #37302
 Calc.
Raw		 104.22
80.25		 15.76
13.00		 50.00
57.00		 0.00 169.98
 41  No Name #30723
 Calc.
Raw		 121.10
93.25		 17.58
14.50		 50.29
57.33		 20.00 168.97