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 2 The Large And Small Of It Division I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #33665
 Calc.
Raw		 183.97
132.00		 42.21
30.67		 100.00
141.25		 0.00 326.18
 2  No Name #36233
 Calc.
Raw		 182.58
131.00		 40.37
29.33		 96.99
137.00		 0.00 319.94
 3  No Name #16925
 Calc.
Raw		 173.52
124.50		 33.48
24.33		 99.47
140.50		 0.00 306.47
 4  No Name #31535
 Calc.
Raw		 174.22
125.00		 44.04
32.00		 76.64
108.25		 0.00 294.90
 5  No Name #22423
 Calc.
Raw		 174.22
125.00		 43.57
31.66		 72.57
102.50		 0.00 290.36
 6  No Name #15064
 Calc.
Raw		 167.94
120.50		 40.39
29.35		 80.00
113.00		 0.00 288.33
 7  No Name #34601
 Calc.
Raw		 190.24
136.50		 37.61
27.33		 57.70
81.50		 1.00 284.55
 8  No Name #34325
 Calc.
Raw		 154.01
110.50		 35.34
25.68		 82.12
116.00		 0.00 271.47
 8  No Name #34123
 Calc.
Raw		 175.61
126.00		 37.16
27.00		 58.23
82.25		 0.00 271.00
 9  No Name #33866
 Calc.
Raw		 162.37
116.50		 38.08
27.67		 69.38
98.00		 0.00 269.83
 10  No Name #34320
 Calc.
Raw		 165.85
119.00		 30.28
22.00		 67.43
95.25		 0.00 263.56
 10  No Name #4636
 Calc.
Raw		 162.37
116.50		 44.49
32.33		 56.11
79.25		 0.00 262.97
 11  No Name #33744
 Calc.
Raw		 173.52
124.50		 37.16
27.00		 51.68
73.00		 0.00 262.36
 12  No Name #31032
 Calc.
Raw		 158.19
113.50		 30.75
22.34		 69.20
97.75		 0.00 258.14
 12  No Name #1009
 Calc.
Raw		 200.00
143.50		 39.46
28.67		 18.23
25.75		 0.00 257.69
 13  No Name #45
 Calc.
Raw		 176.31
126.50		 43.57
31.66		 35.93
50.75		 0.00 255.81
 14  No Name #31733
 Calc.
Raw		 139.37
100.00		 27.51
19.99		 94.34
133.25		 10.00 251.22
 14  No Name #36998
 Calc.
Raw		 159.58
114.50		 29.37
21.34		 62.12
87.75		 0.00 251.07
 14  No Name #33278
 Calc.
Raw		 158.89
114.00		 24.30
17.66		 77.52
109.50		 10.00 250.71
 15  No Name #36839
 Calc.
Raw		 159.58
114.50		 35.78
26.00		 52.57
74.25		 0.00 247.93
 15  No Name #14205
 Calc.
Raw		 140.77
101.00		 34.86
25.33		 72.04
101.75		 0.00 247.67
 16  No Name #37159
 Calc.
Raw		 186.06
133.50		 38.99
28.33		 16.64
23.50		 0.00 241.69
 16  No Name #33807
 Calc.
Raw		 164.46
118.00		 41.74
30.33		 34.87
49.25		 0.00 241.07
 17  No Name #26604
 Calc.
Raw		 174.22
125.00		 50.00
36.33		 11.50
16.25		 0.00 235.72
 18  No Name #28204
 Calc.
Raw		 158.19
113.50		 38.54
28.00		 35.93
50.75		 0.00 232.66
 19  No Name #2345
 Calc.
Raw		 154.01
110.50		 37.61
27.33		 37.17
52.50		 0.00 228.79
 19  No Name #5574
 Calc.
Raw		 158.89
114.00		 41.27
29.99		 27.79
39.25		 0.00 227.95
 20  No Name #12534
 Calc.
Raw		 168.64
121.00		 30.73
22.33		 26.02
36.75		 0.00 225.39
 21  No Name #36439
 Calc.
Raw		 164.46
118.00		 37.16
27.00		 22.48
31.75		 0.00 224.10
 21  No Name #15731
 Calc.
Raw		 172.13
123.50		 33.03
24.00		 18.41
26.00		 0.00 223.57
 21  No Name #11416
 Calc.
Raw		 158.19
113.50		 39.91
29.00		 25.31
35.75		 0.00 223.41
 22  No Name #3193
 Calc.
Raw		 160.28
115.00		 43.12
31.33		 17.17
24.25		 0.00 220.57
 23  No Name #12646
 Calc.
Raw		 140.77
101.00		 36.24
26.33		 39.12
55.25		 1.00 215.13
 23  No Name #37160
 Calc.
Raw		 135.19
97.00		 37.61
27.33		 41.77
59.00		 0.00 214.57
 24  No Name #8061
 Calc.
Raw		 165.16
118.50		 38.99
28.33		 7.61
10.75		 0.00 211.76
 25  No Name #15746
 Calc.
Raw		 126.13
90.50		 32.11
23.33		 49.38
69.75		 0.00 207.62
 25  No Name #37028
 Calc.
Raw		 139.37
100.00		 33.03
24.00		 35.04
49.50		 0.00 207.44
 25  No Name #28679
 Calc.
Raw		 141.46
101.50		 41.29
30.00		 24.25
34.25		 0.00 207.00
 26  No Name #14186
 Calc.
Raw		 150.52
108.00		 33.03
24.00		 19.65
27.75		 0.00 203.20
 27  No Name #36445
 Calc.
Raw		 118.47
85.00		 30.29
22.01		 53.10
75.00		 0.00 201.86
 27  No Name #4984
 Calc.
Raw		 158.19
113.50		 24.32
17.67		 18.94
26.75		 0.00 201.45
 28  No Name #35162
 Calc.
Raw		 134.49
96.50		 33.48
24.33		 24.07
34.00		 0.00 192.04
 29  No Name #3390
 Calc.
Raw		 133.10
95.50		 23.85
17.33		 28.67
40.50		 0.00 185.62
 29  No Name #32181
 Calc.
Raw		 124.74
89.50		 25.70
18.67		 34.69
49.00		 0.00 185.13
 30  No Name #33846
 Calc.
Raw		 107.32
77.00		 21.57
15.67		 44.78
63.25		 0.00 173.67
 31  No Name #36534
 Calc.
Raw		 129.62
93.00		 24.32
17.67		 14.87
21.00		 0.00 168.81
 32  No Name #30823
 Calc.
Raw		 109.41
78.50		 32.11
23.33		 23.01
32.50		 0.00 164.53
 Problem 2 The Large And Small Of It Division II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #28547
 Calc.
Raw		 183.85
148.00		 41.40
36.99		 100.00
107.33		 0.00 325.25
 1  No Name #322
 Calc.
Raw		 200.00
161.00		 50.00
44.67		 74.84
80.33		 0.00 324.84
 2  No Name #9745
 Calc.
Raw		 186.96
150.50		 44.03
39.34		 87.58
94.00		 0.00 318.57
 3  No Name #32490
 Calc.
Raw		 195.03
157.00		 45.89
41.00		 75.16
80.67		 0.00 316.08
 4  No Name #18227
 Calc.
Raw		 181.99
146.50		 39.56
35.34		 86.65
93.00		 0.00 308.20
 5  No Name #36480
 Calc.
Raw		 179.50
144.50		 38.43
34.33		 84.48
90.67		 0.00 302.41
 6  No Name #22311
 Calc.
Raw		 154.04
124.00		 41.03
36.66		 100.00
107.33		 0.00 295.07
 6  No Name #6538
 Calc.
Raw		 188.82
152.00		 41.78
37.33		 63.66
68.33		 0.00 294.26
 7  No Name #33591
 Calc.
Raw		 162.11
130.50		 35.82
32.00		 91.31
98.00		 0.00 289.24
 8  No Name #32663
 Calc.
Raw		 183.85
148.00		 30.97
27.67		 69.88
75.00		 0.00 284.70
 9  No Name #1386
 Calc.
Raw		 175.16
141.00		 39.56
35.34		 63.66
68.33		 0.00 278.38
 10  No Name #32289
 Calc.
Raw		 175.16
141.00		 32.09
28.67		 67.39
72.33		 0.00 274.64
 11  No Name #12320
 Calc.
Raw		 148.45
119.50		 31.34
28.00		 92.86
99.67		 0.00 272.65
 12  No Name #31230
 Calc.
Raw		 156.52
126.00		 38.06
34.00		 75.47
81.00		 0.00 270.05
 13  No Name #28348
 Calc.
Raw		 152.17
122.50		 26.85
23.99		 87.27
93.67		 0.00 266.29
 13  No Name #17625
 Calc.
Raw		 165.84
133.50		 36.56
32.66		 63.66
68.33		 0.00 266.06
 13  No Name #34175
 Calc.
Raw		 147.20
118.50		 34.32
30.66		 84.48
90.67		 0.00 266.00
 14  No Name #17182
 Calc.
Raw		 150.31
121.00		 28.35
25.33		 76.09
81.67		 0.00 254.75
 14  No Name #31374
 Calc.
Raw		 163.35
131.50		 29.85
26.67		 61.49
66.00		 0.00 254.69
 14  No Name #35493
 Calc.
Raw		 152.80
123.00		 31.34
28.00		 70.50
75.67		 0.00 254.64
 15  No Name #37161
 Calc.
Raw		 154.66
124.50		 29.10
26.00		 68.32
73.33		 0.00 252.08
 15  No Name #33946
 Calc.
Raw		 167.70
135.00		 33.21
29.67		 50.62
54.33		 0.00 251.53
 15  No Name #1715
 Calc.
Raw		 132.30
106.50		 29.47
26.33		 89.75
96.33		 0.00 251.52
 16  No Name #33790
 Calc.
Raw		 154.04
124.00		 30.22
27.00		 66.78
71.67		 0.00 251.04
 17  No Name #32323
 Calc.
Raw		 135.40
109.00		 33.21
29.67		 80.43
86.33		 0.00 249.04
 18  No Name #2271
 Calc.
Raw		 129.19
104.00		 32.46
29.00		 77.96
83.67		 0.00 239.61
 19  No Name #34281
 Calc.
Raw		 144.10
116.00		 34.70
31.00		 59.00
63.33		 0.00 237.80
 19  No Name #2464
 Calc.
Raw		 139.75
112.50		 26.11
23.33		 71.43
76.67		 0.00 237.29
 19  No Name #5816
 Calc.
Raw		 147.83
119.00		 33.58
30.00		 55.59
59.67		 0.00 237.00
 20  No Name #11901
 Calc.
Raw		 127.33
102.50		 33.20
29.66		 65.84
70.67		 0.00 226.37
 20  No Name #16375
 Calc.
Raw		 127.95
103.00		 30.60
27.34		 67.71
72.67		 0.00 226.26
 21  No Name #37039
 Calc.
Raw		 137.27
110.50		 25.76
23.01		 54.35
58.33		 0.00 217.38
 21  No Name #31161
 Calc.
Raw		 113.66
91.50		 26.86
24.00		 76.40
82.00		 0.00 216.92
 22  No Name #28378
 Calc.
Raw		 135.40
109.00		 26.49
23.67		 54.35
58.33		 0.00 216.24
 23  No Name #35548
 Calc.
Raw		 124.22
100.00		 25.37
22.67		 57.46
61.67		 0.00 207.05
 24  No Name #29564
 Calc.
Raw		 127.33
102.50		 24.99
22.33		 50.62
54.33		 0.00 202.94
 24  No Name #31164
 Calc.
Raw		 120.50
97.00		 25.36
22.66		 56.53
60.67		 0.00 202.39
 25  No Name #15824
 Calc.
Raw		 122.36
98.50		 22.39
20.00		 57.77
62.00		 1.00 201.52
 25  No Name #16372
 Calc.
Raw		 118.01
95.00		 27.61
24.67		 55.59
59.67		 0.00 201.21
 26  No Name #1722
 Calc.
Raw		 122.36
98.50		 23.88
21.33		 53.73
57.67		 0.00 199.97
 27  No Name #36211
 Calc.
Raw		 115.53
93.00		 30.59
27.33		 51.87
55.67		 0.00 197.99
 28  No Name #1140
 Calc.
Raw		 93.17
75.00		 20.52
18.33		 80.75
86.67		 0.00 194.44
 28  No Name #8704
 Calc.
Raw		 104.97
84.50		 22.76
20.33		 66.46
71.33		 0.00 194.19
 29  No Name #36496
 Calc.
Raw		 107.45
86.50		 28.73
25.67		 48.76
52.33		 0.00 184.94
 30  No Name #32252
 Calc.
Raw		 86.96
70.00		 30.97
27.67		 67.08
72.00		 2.00 183.01
 31  No Name #20480
 Calc.
Raw		 80.75
65.00		 23.51
21.00		 56.53
60.67		 0.00 160.79
 32  No Name #35698
 Calc.
Raw		 77.02
62.00		 20.52
18.33		 56.21
60.33		 0.00 153.75
 33  No Name #34082
 Calc.
Raw		 90.68
73.00		 21.27
19.00		 55.90
60.00		 20.00 147.85
 34  No Name #33846
 Calc.
Raw		 95.65
77.00		 17.54
15.67		 31.37
33.67		 0.00 144.56
 35  No Name #2437
 Calc.
Raw		 44.72
36.00		 16.79
15.00		 50.62
54.33		 0.00 112.13
 Problem 2 The Large And Small Of It Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #8496
 Calc.
Raw		 175.29
149.00		 36.24
29.00		 95.14
112.50		 0.00 306.67
 2  No Name #22311
 Calc.
Raw		 151.18
128.50		 37.90
30.33		 97.46
115.25		 15.00 271.54
 3  No Name #30949
 Calc.
Raw		 200.00
170.00		 50.00
40.01		 19.45
23.00		 0.00 269.45
 4  No Name #27017
 Calc.
Raw		 196.47
167.00		 46.24
37.00		 23.04
27.25		 0.00 265.75
 5  No Name #3887
 Calc.
Raw		 190.59
162.00		 44.58
35.67		 23.04
27.25		 1.00 257.21
 6  No Name #10619
 Calc.
Raw		 120.00
102.00		 35.42
28.34		 100.00
118.25		 0.00 255.42
 7  No Name #34393
 Calc.
Raw		 179.41
152.50		 37.07
29.66		 36.15
42.75		 0.00 252.63
 8  No Name #37162
 Calc.
Raw		 171.18
145.50		 39.15
31.33		 26.00
30.75		 0.00 236.33
 9  No Name #31230
 Calc.
Raw		 148.82
126.50		 40.83
32.67		 43.55
51.50		 0.00 233.20
 10  No Name #35550
 Calc.
Raw		 170.59
145.00		 39.15
31.33		 20.08
23.75		 0.00 229.82
 11  No Name #35519
 Calc.
Raw		 147.65
125.50		 41.24
33.00		 38.90
46.00		 0.00 227.79
 12  No Name #1149
 Calc.
Raw		 140.59
119.50		 44.99
36.00		 41.01
48.50		 0.00 226.59
 13  No Name #30595
 Calc.
Raw		 138.82
118.00		 41.65
33.33		 43.34
51.25		 0.00 223.81
 14  No Name #5736
 Calc.
Raw		 174.71
148.50		 40.41
32.34		 23.47
27.75		 17.00 221.59
 15  No Name #31437
 Calc.
Raw		 157.06
133.50		 32.49
26.00		 30.66
36.25		 0.00 220.21
 16  No Name #22063
 Calc.
Raw		 160.59
136.50		 40.40
32.33		 31.50
37.25		 16.00 216.49
 17  No Name #32939
 Calc.
Raw		 145.29
123.50		 28.73
22.99		 38.05
45.00		 0.00 212.07
 18  No Name #33422
 Calc.
Raw		 154.71
131.50		 34.59
27.68		 20.08
23.75		 2.00 207.38
 19  No Name #4307
 Calc.
Raw		 130.59
111.00		 42.08
33.67		 31.92
37.75		 0.00 204.59
 20  No Name #35180
 Calc.
Raw		 137.06
116.50		 33.74
27.00		 27.06
32.00		 0.00 197.86
 21  No Name #15074
 Calc.
Raw		 122.35
104.00		 37.07
29.66		 34.46
40.75		 0.00 193.88
 21  No Name #14186
 Calc.
Raw		 119.41
101.50		 34.58
27.67		 38.90
46.00		 0.00 192.89
 22  No Name #36451
 Calc.
Raw		 135.29
115.00		 36.65
29.33		 20.51
24.25		 0.00 192.45
 22  No Name #7743
 Calc.
Raw		 131.18
111.50		 33.33
26.67		 27.27
32.25		 0.00 191.78
 23  No Name #24436
 Calc.
Raw		 131.76
112.00		 34.99
28.00		 24.10
28.50		 0.00 190.85
 24  No Name #28239
 Calc.
Raw		 114.12
97.00		 32.08
25.67		 39.96
47.25		 0.00 186.16
 25  No Name #19512
 Calc.
Raw		 120.59
102.50		 34.17
27.34		 27.48
32.50		 0.00 182.24
 26  No Name #31161
 Calc.
Raw		 120.59
102.50		 28.74
23.00		 30.66
36.25		 2.00 177.99
 27  No Name #2215
 Calc.
Raw		 104.12
88.50		 35.82
28.66		 35.10
41.50		 0.00 175.04
 28  No Name #34802
 Calc.
Raw		 131.76
112.00		 32.49
26.00		 20.93
24.75		 15.00 170.18
 29  No Name #35824
 Calc.
Raw		 108.24
92.00		 30.00
24.01		 29.18
34.50		 0.00 167.42
 30  No Name #15515
 Calc.
Raw		 111.18
94.50		 20.83
16.67		 33.62
39.75		 0.00 165.63
 31  No Name #36979
 Calc.
Raw		 117.06
99.50		 27.49
22.00		 20.08
23.75		 0.00 164.63
 32  No Name #7246
 Calc.
Raw		 111.18
94.50		 31.24
25.00		 23.04
27.25		 2.00 163.46
 33  No Name #21290
 Calc.
Raw		 115.29
98.00		 29.99
24.00		 16.70
19.75		 0.00 161.98
 34  No Name #34519
 Calc.
Raw		 90.59
77.00		 31.24
25.00		 38.90
46.00		 0.00 160.73
 34  No Name #33415
 Calc.
Raw		 94.12
80.00		 39.17
31.34		 27.27
32.25		 0.00 160.56
 34  No Name #8871
 Calc.
Raw		 113.53
96.50		 22.07
17.66		 24.31
28.75		 0.00 159.91
 35  No Name #1412
 Calc.
Raw		 116.47
99.00		 23.32
18.66		 17.34
20.50		 0.00 157.13
 36  No Name #31108
 Calc.
Raw		 105.88
90.00		 28.33
22.67		 21.35
25.25		 0.00 155.56
 37  No Name #30551
 Calc.
Raw		 92.94
79.00		 30.40
24.33		 29.81
35.25		 0.00 153.15
 38  No Name #8149
 Calc.
Raw		 80.59
68.50		 34.99
28.00		 12.68
15.00		 0.00 128.26
 39  No Name #32640
 Calc.
Raw		 42.94
36.50		 17.92
14.34		 17.97
21.25		 0.00 78.83
 40  No Name #16610
 Calc.
Raw		 31.18
26.50		 22.07
17.66		 23.26
27.50		 0.00 76.51