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 I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #30361
 Calc.
Raw		 200.00
136.00		 48.34
39.00		 100.00
125.25		 5.00 343.34
 2  No Name #5931
 Calc.
Raw		 188.24
128.00		 50.00
40.34		 74.25
93.00		 0.00 312.49
 3  No Name #8628
 Calc.
Raw		 175.00
119.00		 40.07
32.33		 89.22
111.75		 0.00 304.29
 3  No Name #34805
 Calc.
Raw		 186.40
126.75		 43.80
35.34		 73.65
92.25		 0.00 303.85
 4  No Name #9043
 Calc.
Raw		 171.32
116.50		 40.90
33.00		 81.24
101.75		 0.00 293.46
 5  No Name #35839
 Calc.
Raw		 174.63
118.75		 38.83
31.33		 75.65
94.75		 0.00 289.11
 6  No Name #4137
 Calc.
Raw		 164.34
111.75		 37.18
30.00		 86.23
108.00		 0.00 287.75
 6  No Name #32407
 Calc.
Raw		 175.37
119.25		 49.58
40.00		 62.67
78.50		 0.00 287.62
 7  No Name #30963
 Calc.
Raw		 167.28
113.75		 41.72
33.66		 77.05
96.50		 0.00 286.05
 8  No Name #17473
 Calc.
Raw		 180.51
122.75		 35.94
29.00		 68.46
85.75		 0.00 284.91
 9  No Name #16708
 Calc.
Raw		 168.01
114.25		 34.72
28.01		 80.44
100.75		 0.00 283.17
 10  No Name #36051
 Calc.
Raw		 172.43
117.25		 45.04
36.34		 62.87
78.75		 0.00 280.34
 11  No Name #1956
 Calc.
Raw		 166.54
113.25		 41.72
33.66		 68.46
85.75		 0.00 276.72
 11  No Name #35672
 Calc.
Raw		 166.18
113.00		 31.82
25.67		 78.04
97.75		 0.00 276.04
 12  No Name #27729
 Calc.
Raw		 170.22
115.75		 45.04
36.34		 58.88
73.75		 0.00 274.14
 13  No Name #35577
 Calc.
Raw		 165.81
112.75		 42.56
34.34		 61.88
77.50		 0.00 270.25
 14  No Name #9971
 Calc.
Raw		 170.96
116.25		 38.83
31.33		 58.88
73.75		 0.00 268.67
 15  No Name #6444
 Calc.
Raw		 170.22
115.75		 36.37
29.34		 60.68
76.00		 0.00 267.27
 16  No Name #12936
 Calc.
Raw		 150.00
102.00		 34.30
27.67		 81.24
101.75		 0.00 265.54
 17  No Name #32908
 Calc.
Raw		 159.56
108.50		 47.52
38.34		 57.29
71.75		 0.00 264.37
 18  No Name #31234
 Calc.
Raw		 161.76
110.00		 37.61
30.34		 57.29
71.75		 0.00 256.66
 19  No Name #35162
 Calc.
Raw		 169.85
115.50		 43.39
35.01		 41.72
52.25		 0.00 254.96
 19  No Name #36622
 Calc.
Raw		 146.69
99.75		 35.94
29.00		 71.46
89.50		 0.00 254.09
 20  No Name #32315
 Calc.
Raw		 186.76
127.00		 32.23
26.00		 34.53
43.25		 0.00 253.52
 20  No Name #6428
 Calc.
Raw		 179.04
121.75		 35.54
28.67		 38.52
48.25		 0.00 253.10
 21  No Name #9642
 Calc.
Raw		 160.66
109.25		 30.16
24.33		 58.28
73.00		 0.00 249.10
 22  No Name #35327
 Calc.
Raw		 137.50
93.50		 29.34
23.67		 80.04
100.25		 0.00 246.88
 22  No Name #35115
 Calc.
Raw		 170.96
116.25		 33.06
26.67		 42.12
52.75		 0.00 246.14
 23  No Name #28581
 Calc.
Raw		 161.40
109.75		 36.35
29.33		 47.70
59.75		 0.00 245.45
 24  No Name #28372
 Calc.
Raw		 135.29
92.00		 30.58
24.67		 78.44
98.25		 0.00 244.31
 24  No Name #35727
 Calc.
Raw		 142.65
97.00		 26.86
21.67		 74.65
93.50		 0.00 244.16
 25  No Name #3519
 Calc.
Raw		 150.74
102.50		 33.47
27.00		 59.08
74.00		 0.00 243.29
 25  No Name #3606
 Calc.
Raw		 128.31
87.25		 31.40
25.33		 82.63
103.50		 0.00 242.34
 26  No Name #35602
 Calc.
Raw		 167.65
114.00		 38.86
31.35		 33.13
41.50		 0.00 239.64
 26  No Name #6161
 Calc.
Raw		 141.18
96.00		 28.51
23.00		 69.66
87.25		 0.00 239.35
 26  No Name #22341
 Calc.
Raw		 141.18
96.00		 38.01
30.67		 59.88
75.00		 0.00 239.07
 27  No Name #36728
 Calc.
Raw		 156.25
106.25		 29.34
23.67		 52.30
65.50		 0.00 237.89
 27  No Name #35665
 Calc.
Raw		 143.01
97.25		 38.01
30.67		 56.29
70.50		 0.00 237.31
 28  No Name #34220
 Calc.
Raw		 147.79
100.50		 30.58
24.67		 58.08
72.75		 0.00 236.45
 28  No Name #3390
 Calc.
Raw		 142.28
96.75		 34.71
28.00		 58.48
73.25		 0.00 235.47
 29  No Name #20153
 Calc.
Raw		 149.63
101.75		 31.82
25.67		 53.89
67.50		 0.00 235.34
 30  No Name #32346
 Calc.
Raw		 141.18
96.00		 26.85
21.66		 65.47
82.00		 0.00 233.50
 30  No Name #31899
 Calc.
Raw		 143.75
97.75		 31.00
25.01		 58.48
73.25		 0.00 233.23
 31  No Name #27653
 Calc.
Raw		 155.88
106.00		 42.56
34.34		 33.73
42.25		 0.00 232.17
 32  No Name #1164
 Calc.
Raw		 159.19
108.25		 32.65
26.34		 38.32
48.00		 0.00 230.16
 33  No Name #14989
 Calc.
Raw		 153.31
104.25		 32.23
26.00		 42.91
53.75		 0.00 228.45
 34  No Name #14988
 Calc.
Raw		 156.99
106.75		 38.42
31.00		 31.54
39.50		 0.00 226.95
 35  No Name #35570
 Calc.
Raw		 138.97
94.50		 30.99
25.00		 55.69
69.75		 0.00 225.65
 36  No Name #36864
 Calc.
Raw		 150.37
102.25		 36.35
29.33		 37.72
47.25		 0.00 224.44
 37  No Name #35489
 Calc.
Raw		 150.00
102.00		 36.35
29.33		 36.53
45.75		 0.00 222.88
 37  No Name #31733
 Calc.
Raw		 158.82
108.00		 31.82
25.67		 31.94
40.00		 0.00 222.58
 37  No Name #36693
 Calc.
Raw		 147.79
100.50		 27.68
22.33		 46.71
58.50		 0.00 222.18
 38  No Name #28057
 Calc.
Raw		 150.74
102.50		 37.20
30.01		 48.50
60.75		 15.00 221.44
 39  No Name #34380
 Calc.
Raw		 144.12
98.00		 28.51
23.00		 47.70
59.75		 0.00 220.33
 40  No Name #33044
 Calc.
Raw		 141.54
96.25		 39.65
31.99		 51.50
64.50		 15.00 217.69
 41  No Name #8407
 Calc.
Raw		 129.04
87.75		 29.33
23.66		 57.49
72.00		 0.00 215.86
 42  No Name #22534
 Calc.
Raw		 126.84
86.25		 28.51
23.00		 58.88
73.75		 0.00 214.23
 43  No Name #29084
 Calc.
Raw		 147.06
100.00		 28.51
23.00		 36.13
45.25		 0.00 211.70
 44  No Name #31384
 Calc.
Raw		 132.72
90.25		 33.89
27.34		 40.32
50.50		 0.00 206.93
 45  No Name #19400
 Calc.
Raw		 127.21
86.50		 29.34
23.67		 45.91
57.50		 0.00 202.46