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 II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #13927
 Calc.
Raw		 190.76
165.25		 45.94
37.67		 55.49
68.25		 0.00 292.19
 1  No Name #37089
 Calc.
Raw		 183.84
159.25		 50.00
41.00		 57.72
71.00		 0.00 291.56
 2  No Name #35883
 Calc.
Raw		 151.80
131.50		 37.80
31.00		 100.00
123.00		 0.00 289.60
 3  No Name #13158
 Calc.
Raw		 179.80
155.75		 41.46
34.00		 57.93
71.25		 0.00 279.19
 3  No Name #37258
 Calc.
Raw		 200.00
173.25		 43.09
35.33		 35.77
44.00		 0.00 278.86
 3  No Name #15370
 Calc.
Raw		 186.44
161.50		 41.06
33.67		 51.02
62.75		 0.00 278.52
 4  No Name #36531
 Calc.
Raw		 167.97
145.50		 31.30
25.67		 76.63
94.25		 0.00 275.90
 5  No Name #16372
 Calc.
Raw		 151.23
131.00		 31.71
26.00		 87.60
107.75		 0.00 270.54
 6  No Name #2742
 Calc.
Raw		 173.74
150.50		 41.46
34.00		 53.46
65.75		 0.00 268.66
 7  No Name #1744
 Calc.
Raw		 162.48
140.75		 35.77
29.33		 67.48
83.00		 0.00 265.73
 8  No Name #37861
 Calc.
Raw		 182.11
157.75		 49.60
40.67		 31.91
39.25		 0.00 263.62
 9  No Name #35052
 Calc.
Raw		 187.88
162.75		 43.09
35.33		 32.11
39.50		 1.00 262.08
 9  No Name #31225
 Calc.
Raw		 167.10
144.75		 37.80
31.00		 57.11
70.25		 0.00 262.01
 10  No Name #36303
 Calc.
Raw		 163.92
142.00		 35.77
29.33		 57.52
70.75		 0.00 257.21
 10  No Name #4691
 Calc.
Raw		 165.37
143.25		 42.28
34.67		 48.98
60.25		 0.00 256.63
 10  No Name #28109
 Calc.
Raw		 184.42
159.75		 39.84
32.67		 36.99
45.50		 5.00 256.25
 11  No Name #30853
 Calc.
Raw		 184.13
159.50		 39.02
32.00		 30.49
37.50		 0.00 253.64
 11  No Name #36480
 Calc.
Raw		 174.03
150.75		 49.60
40.67		 29.47
36.25		 0.00 253.10
 11  No Name #1493
 Calc.
Raw		 176.05
152.50		 45.52
37.33		 31.30
38.50		 0.00 252.87
 12  No Name #33422
 Calc.
Raw		 147.19
127.50		 40.24
33.00		 62.20
76.50		 0.00 249.63
 13  No Name #36756
 Calc.
Raw		 182.97
158.50		 30.09
24.67		 34.76
42.75		 0.00 247.82
 14  No Name #32284
 Calc.
Raw		 165.37
143.25		 39.84
32.67		 40.45
49.75		 0.00 245.66
 14  No Name #19690
 Calc.
Raw		 167.10
144.75		 33.74
27.67		 44.31
54.50		 0.00 245.15
 14  No Name #19568
 Calc.
Raw		 159.88
138.50		 41.87
34.33		 43.09
53.00		 0.00 244.84
 15  No Name #37860
 Calc.
Raw		 171.14
148.25		 40.24
33.00		 31.10
38.25		 0.00 242.48
 16  No Name #15417
 Calc.
Raw		 167.39
145.00		 35.77
29.33		 35.37
43.50		 0.00 238.53
 17  No Name #26110
 Calc.
Raw		 161.33
139.75		 34.96
28.67		 40.24
49.50		 0.00 236.53
 17  No Name #35327
 Calc.
Raw		 168.54
146.00		 34.96
28.67		 32.32
39.75		 0.00 235.82
 17  No Name #20480
 Calc.
Raw		 158.15
137.00		 32.52
26.67		 45.12
55.50		 0.00 235.79
 18  No Name #31337
 Calc.
Raw		 144.01
124.75		 39.43
32.33		 56.71
69.75		 5.00 235.15
 19  No Name #2770
 Calc.
Raw		 153.25
132.75		 35.77
29.33		 43.90
54.00		 0.00 232.92
 19  No Name #34310
 Calc.
Raw		 147.47
127.75		 37.80
31.00		 47.56
58.50		 0.00 232.83
 20  No Name #1715
 Calc.
Raw		 157.58
136.50		 39.84
32.67		 34.15
42.00		 0.00 231.57
 20  No Name #11901
 Calc.
Raw		 163.64
141.75		 37.40
30.67		 30.49
37.50		 0.00 231.53
 20  No Name #36861
 Calc.
Raw		 163.35
141.50		 32.11
26.33		 35.77
44.00		 0.00 231.23
 21  No Name #21059
 Calc.
Raw		 152.38
132.00		 33.33
27.33		 44.11
54.25		 0.00 229.82
 21  No Name #36287
 Calc.
Raw		 158.44
137.25		 28.45
23.33		 42.28
52.00		 0.00 229.17
 22  No Name #3909
 Calc.
Raw		 152.96
132.50		 40.24
33.00		 34.96
43.00		 0.00 228.16
 22  No Name #32819
 Calc.
Raw		 164.79
142.75		 30.49
25.00		 32.52
40.00		 0.00 227.80
 23  No Name #8704
 Calc.
Raw		 150.36
130.25		 28.45
23.33		 44.92
55.25		 0.00 223.73
 24  No Name #21290
 Calc.
Raw		 162.48
140.75		 33.33
27.33		 30.89
38.00		 5.00 221.70
 24  No Name #26675
 Calc.
Raw		 156.13
135.25		 35.37
29.00		 29.88
36.75		 0.00 221.38
 24  No Name #29075
 Calc.
Raw		 134.20
116.25		 29.67
24.33		 56.91
70.00		 0.00 220.78
 25  No Name #37527
 Calc.
Raw		 140.84
122.00		 33.33
27.33		 46.34
57.00		 0.00 220.51
 26  No Name #32345
 Calc.
Raw		 153.25
132.75		 24.79
20.33		 41.06
50.50		 0.00 219.10
 26  No Name #37478
 Calc.
Raw		 153.54
133.00		 32.11
26.33		 32.52
40.00		 0.00 218.17
 27  No Name #21475
 Calc.
Raw		 141.99
123.00		 30.49
25.00		 44.92
55.25		 0.00 217.40
 28  No Name #14186
 Calc.
Raw		 152.96
132.50		 29.27
24.00		 31.91
39.25		 0.00 214.14
 29  No Name #5471
 Calc.
Raw		 148.34
128.50		 25.61
21.00		 38.01
46.75		 0.00 211.96
 29  No Name #36474
 Calc.
Raw		 141.41
122.50		 30.09
24.67		 39.84
49.00		 0.00 211.34
 29  No Name #8883
 Calc.
Raw		 146.61
127.00		 34.15
28.00		 30.28
37.25		 0.00 211.04
 30  No Name #25553
 Calc.
Raw		 120.35
104.25		 23.17
19.00		 66.87
82.25		 0.00 210.39
 31  No Name #28440
 Calc.
Raw		 145.74
126.25		 29.27
24.00		 34.35
42.25		 0.00 209.36
 32  No Name #35548
 Calc.
Raw		 144.30
125.00		 23.99
19.67		 39.43
48.50		 0.00 207.72
 33  No Name #36705
 Calc.
Raw		 148.63
128.75		 28.45
23.33		 29.47
36.25		 0.00 206.55
 33  No Name #36156
 Calc.
Raw		 120.63
104.50		 28.05
23.00		 57.52
70.75		 0.00 206.20
 33  No Name #36589
 Calc.
Raw		 131.31
113.75		 27.23
22.33		 47.56
58.50		 0.00 206.10
 34  No Name #17346
 Calc.
Raw		 136.51
118.25		 24.79
20.33		 44.11
54.25		 0.00 205.41
 35  No Name #36629
 Calc.
Raw		 128.14
111.00		 17.48
14.33		 40.24
49.50		 0.00 185.86
 35  No Name #16610
 Calc.
Raw		 129.29
112.00		 26.01
21.33		 30.49
37.50		 0.00 185.79
 35  No Name #33295
 Calc.
Raw		 126.98
110.00		 28.45
23.33		 29.88
36.75		 0.00 185.31