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 2007 May 23rd
 Problem 5 I'm Only Thinking Of You! Division II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #31225
 Calc.
Raw		 196.56
157.25		 47.20
45.00		 95.60
87.00		 0.00 339.36
 1  No Name #16283
 Calc.
Raw		 190.94
152.75		 48.25
46.00		 100.00
91.00		 0.00 339.19
 2  No Name #32395
 Calc.
Raw		 182.81
146.25		 50.00
47.67		 80.96
73.67		 0.00 313.77
 2  No Name #22311
 Calc.
Raw		 184.06
147.25		 42.66
40.67		 86.81
79.00		 0.00 313.53
 3  No Name #17473
 Calc.
Raw		 186.56
149.25		 46.50
44.33		 78.02
71.00		 0.00 311.08
 4  No Name #17182
 Calc.
Raw		 200.00
160.00		 46.51
44.34		 61.90
56.33		 0.00 308.41
 5  No Name #36232
 Calc.
Raw		 187.50
150.00		 41.62
39.68		 73.63
67.00		 0.00 302.75
 6  No Name #2742
 Calc.
Raw		 196.56
157.25		 47.20
45.00		 57.51
52.33		 0.00 301.27
 7  No Name #33346
 Calc.
Raw		 178.44
142.75		 40.91
39.00		 78.02
71.00		 0.00 297.37
 8  No Name #13927
 Calc.
Raw		 190.31
152.25		 39.86
38.00		 63.37
57.67		 0.00 293.54
 9  No Name #34415
 Calc.
Raw		 188.44
150.75		 40.91
39.00		 58.98
53.67		 0.00 288.33
 10  No Name #33416
 Calc.
Raw		 188.44
150.75		 39.17
37.34		 57.51
52.33		 0.00 285.12
 11  No Name #35607
 Calc.
Raw		 189.38
151.50		 40.91
39.00		 53.48
48.67		 0.00 283.77
 12  No Name #30340
 Calc.
Raw		 192.81
154.25		 35.32
33.67		 67.77
61.67		 15.00 280.90
 12  No Name #19568
 Calc.
Raw		 169.69
135.75		 41.25
39.33		 69.23
63.00		 0.00 280.17
 13  No Name #10680
 Calc.
Raw		 190.31
152.25		 34.96
33.33		 54.58
49.67		 0.00 279.85
 13  No Name #28213
 Calc.
Raw		 178.13
142.50		 42.65
40.66		 58.98
53.67		 0.00 279.76
 13  No Name #32096
 Calc.
Raw		 176.25
141.00		 42.31
40.34		 60.44
55.00		 0.00 279.00
 14  No Name #36045
 Calc.
Raw		 175.63
140.50		 36.36
34.67		 66.30
60.33		 0.00 278.29
 14  No Name #1895
 Calc.
Raw		 174.06
139.25		 36.01
34.33		 67.77
61.67		 0.00 277.84
 14  No Name #35327
 Calc.
Raw		 173.13
138.50		 38.12
36.34		 66.30
60.33		 0.00 277.55
 15  No Name #35889
 Calc.
Raw		 175.63
140.50		 37.41
35.67		 63.37
57.67		 0.00 276.41
 16  No Name #8770
 Calc.
Raw		 178.13
142.50		 41.96
40.00		 54.58
49.67		 0.00 274.67
 16  No Name #18218
 Calc.
Raw		 178.44
142.75		 35.67
34.01		 60.44
55.00		 0.00 274.55
 16  No Name #21290
 Calc.
Raw		 168.44
134.75		 39.51
37.67		 66.30
60.33		 0.00 274.25
 17  No Name #1902
 Calc.
Raw		 174.69
139.75		 45.10
43.00		 53.11
48.33		 0.00 272.90
 17  No Name #8883
 Calc.
Raw		 166.88
133.50		 40.91
39.00		 64.84
59.00		 0.00 272.63
 18  No Name #28239
 Calc.
Raw		 185.94
148.75		 39.85
37.99		 45.42
41.33		 0.00 271.21
 19  No Name #35911
 Calc.
Raw		 170.31
136.25		 39.15
37.33		 58.98
53.67		 0.00 268.44
 19  No Name #33422
 Calc.
Raw		 155.94
124.75		 36.71
35.00		 75.09
68.33		 0.00 267.74
 20  No Name #36617
 Calc.
Raw		 175.63
140.50		 43.00
41.00		 48.71
44.33		 0.00 267.34
 20  No Name #31337
 Calc.
Raw		 184.06
147.25		 35.32
33.67		 47.25
43.00		 0.00 266.63
 21  No Name #31523
 Calc.
Raw		 156.56
125.25		 32.52
31.00		 75.09
68.33		 0.00 264.17
 21  No Name #3422
 Calc.
Raw		 151.25
121.00		 30.07
28.67		 82.42
75.00		 0.00 263.74
 22  No Name #26102
 Calc.
Raw		 160.94
128.75		 30.07
28.67		 72.16
65.67		 0.00 263.17
 22  No Name #36756
 Calc.
Raw		 161.25
129.00		 37.76
36.00		 63.37
57.67		 0.00 262.38
 23  No Name #26110
 Calc.
Raw		 168.44
134.75		 37.40
35.66		 56.04
51.00		 0.00 261.88
 24  No Name #15407
 Calc.
Raw		 169.69
135.75		 35.66
34.00		 54.58
49.67		 0.00 259.93
 24  No Name #1790
 Calc.
Raw		 176.88
141.50		 37.41
35.67		 50.19
45.67		 5.00 259.48
 25  No Name #28837
 Calc.
Raw		 169.69
135.75		 34.61
33.00		 54.58
49.67		 0.00 258.88
 25  No Name #11901
 Calc.
Raw		 171.25
137.00		 37.07
35.34		 50.19
45.67		 0.00 258.51
 25  No Name #15417
 Calc.
Raw		 164.69
131.75		 40.91
39.00		 52.75
48.00		 0.00 258.35
 26  No Name #34080
 Calc.
Raw		 160.31
128.25		 39.51
37.67		 56.04
51.00		 0.00 255.86
 27  No Name #18931
 Calc.
Raw		 156.56
125.25		 42.31
40.34		 53.11
48.33		 0.00 251.98
 28  No Name #24459
 Calc.
Raw		 160.00
128.00		 36.36
34.67		 44.32
40.33		 0.00 240.68
 29  No Name #33295
 Calc.
Raw		 148.13
118.50		 33.91
32.33		 57.51
52.33		 0.00 239.55
 30  No Name #10806
 Calc.
Raw		 156.88
125.50		 30.06
28.66		 50.19
45.67		 0.00 237.13
 31  No Name #14375
 Calc.
Raw		 153.44
122.75		 29.37
28.00		 53.11
48.33		 0.00 235.92
 31  No Name #27152
 Calc.
Raw		 152.50
122.00		 31.47
30.00		 51.65
47.00		 0.00 235.62
 32  No Name #32345
 Calc.
Raw		 153.75
123.00		 36.35
34.66		 42.86
39.00		 0.00 232.96
 33  No Name #2437
 Calc.
Raw		 147.81
118.25		 24.48
23.34		 58.98
53.67		 0.00 231.27
 34  No Name #789
 Calc.
Raw		 160.94
128.75		 27.27
26.00		 41.40
37.67		 0.00 229.61
 35  No Name #36861
 Calc.
Raw		 149.06
119.25		 27.63
26.34		 43.96
40.00		 0.00 220.65
 36  No Name #36640
 Calc.
Raw		 150.31
120.25		 22.72
21.66		 53.11
48.33		 10.00 216.14
 37  No Name #34546
 Calc.
Raw		 149.38
119.50		 23.08
22.00		 50.19
45.67		 15.00 207.65
 38  No Name #6490
 Calc.
Raw		 160.63
128.50		 31.81
30.33		 42.86
39.00		 30.00 205.30