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 1 Tag 'em Division I
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #20906
Calc.
Raw
189.73
153.67
40.51
37.00
84.08
70.00
0.00 314.32
 2  No Name #1178
Calc.
Raw
174.49
141.33
39.40
35.99
96.70
80.50
0.00 310.59
 3  No Name #36233
Calc.
Raw
200.00
161.99
45.98
42.00
56.76
47.25
0.00 302.74
 3  No Name #33557
Calc.
Raw
198.38
160.68
50.00
45.67
54.05
45.00
0.00 302.43
 4  No Name #24450
Calc.
Raw
175.31
141.99
31.75
29.00
94.59
78.75
0.00 301.65
 4  No Name #26787
Calc.
Raw
193.42
156.66
42.34
38.67
65.17
54.25
0.00 300.93
 5  No Name #28072
Calc.
Raw
155.17
125.68
35.41
32.34
99.70
83.00
0.00 290.28
 5  No Name #36671
Calc.
Raw
179.46
145.35
34.67
31.67
75.68
63.00
0.00 289.81
 6  No Name #22293
Calc.
Raw
166.80
135.10
43.06
39.33
67.27
56.00
0.00 277.13
 7  No Name #35162
Calc.
Raw
166.47
134.83
35.03
32.00
74.47
62.00
0.00 275.97
 7  No Name #19754
Calc.
Raw
169.54
137.32
32.84
30.00
72.97
60.75
0.00 275.35
 8  No Name #34905
Calc.
Raw
160.50
130.00
35.77
32.67
78.08
65.00
0.00 274.35
 9  No Name #32181
Calc.
Raw
168.33
136.34
40.14
36.66
63.66
53.00
1.00 271.13
 10  No Name #34320
Calc.
Raw
159.26
128.99
33.95
31.01
74.17
61.75
0.00 267.38
 11  No Name #35277
Calc.
Raw
141.55
114.65
33.21
30.33
89.19
74.25
0.00 263.95
 12  No Name #35244
Calc.
Raw
176.95
143.32
35.76
32.66
49.55
41.25
0.00 262.26
 12  No Name #35896
Calc.
Raw
158.03
128.00
29.20
26.67
74.47
62.00
0.00 261.70
 13  No Name #36596
Calc.
Raw
175.74
142.34
25.56
23.35
59.76
49.75
0.00 261.06
 13  No Name #32957
Calc.
Raw
172.29
139.55
37.95
34.66
50.15
41.75
0.00 260.39
 14  No Name #5128
Calc.
Raw
133.34
108.00
25.93
23.68
100.00
83.25
0.00 259.27
 14  No Name #32121
Calc.
Raw
172.64
139.83
32.84
30.00
53.75
44.75
0.00 259.23
 15  No Name #29007
Calc.
Raw
157.64
127.68
40.88
37.34
58.86
49.00
0.00 257.38
 16  No Name #15003
Calc.
Raw
169.75
137.49
33.94
31.00
50.45
42.00
0.00 254.14
 17  No Name #36543
Calc.
Raw
156.80
127.00
24.47
22.35
84.38
70.25
20.00 245.65
 18  No Name #35975
Calc.
Raw
174.49
141.33
33.22
30.34
36.34
30.25
0.00 244.05
 19  No Name #35035
Calc.
Raw
145.28
117.67
30.65
28.00
65.17
54.25
0.00 241.10
 20  No Name #5637
Calc.
Raw
146.91
118.99
30.28
27.66
62.46
52.00
0.00 239.65
 21  No Name #31535
Calc.
Raw
134.16
108.66
33.58
30.67
63.66
53.00
0.00 231.40
 21  No Name #35727
Calc.
Raw
172.43
139.66
30.67
28.01
27.63
23.00
0.00 230.73
 22  No Name #37155
Calc.
Raw
176.76
143.17
42.71
39.01
13.51
11.25
4.00 228.98
 23  No Name #34189
Calc.
Raw
169.13
136.99
35.41
32.34
22.82
19.00
0.00 227.36
 24  No Name #36048
Calc.
Raw
153.50
124.33
15.69
14.33
56.16
46.75
0.00 225.35
 24  No Name #36971
Calc.
Raw
111.53
90.33
33.95
31.01
86.49
72.00
7.00 224.97
 25  No Name #19400
Calc.
Raw
151.03
122.33
36.49
33.33
35.74
29.75
0.00 223.26
 26  No Name #33044
Calc.
Raw
121.81
98.66
28.10
25.67
70.27
58.50
0.00 220.18
 27  No Name #36017
Calc.
Raw
117.70
95.33
31.03
28.34
67.27
56.00
2.00 214.00
 28  No Name #26181
Calc.
Raw
155.97
126.33
36.12
32.99
18.62
15.50
0.00 210.71
 29  No Name #2138
Calc.
Raw
160.91
130.33
36.13
33.00
12.61
10.50
0.00 209.65
 30  No Name #36864
Calc.
Raw
157.48
127.55
27.74
25.34
22.52
18.75
0.00 207.74
 31  No Name #30200
Calc.
Raw
147.33
119.33
43.06
39.33
16.22
13.50
0.00 206.61
 32  No Name #34284
Calc.
Raw
162.55
131.66
25.91
23.67
14.41
12.00
0.00 202.87
 33  No Name #16465
Calc.
Raw
118.09
95.65
33.22
30.34
45.05
37.50
0.00 196.36
 34  No Name #4538
Calc.
Raw
132.93
107.67
27.01
24.67
32.43
27.00
0.00 192.37
 35  No Name #35314
Calc.
Raw
146.91
118.99
19.33
17.66
23.72
19.75
5.00 184.96
 36  No Name #31310
Calc.
Raw
78.61
63.67
30.29
27.67
72.97
60.75
0.00 181.87
 37  No Name #6379
Calc.
Raw
125.92
101.99
20.44
18.67
26.43
22.00
0.00 172.79
 38  No Name #32066
Calc.
Raw
100.22
81.17
28.47
26.00
34.23
28.50
0.00 162.92
 39  No Name #35477
Calc.
Raw
83.13
67.33
31.39
28.67
30.03
25.00
0.00 144.55
 40  No Name #26773
Calc.
Raw
53.89
43.65
21.16
19.33
70.87
59.00
3.00 142.92
 41  No Name #35789
Calc.
Raw
76.54
61.99
33.58
30.67
27.63
23.00
0.00 137.75
 42  No Name #35329
Calc.
Raw
40.32
32.66
28.09
25.66
40.24
33.50
0.00 108.65
 43  No Name #2437
Calc.
Raw
60.50
49.00
21.17
19.34
25.23
21.00
0.00 106.90
 44  No Name #35396
Calc.
Raw
57.83
46.84
25.91
23.67
17.42
14.50
0.00 101.16
 Problem 1 Tag 'em Division II
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #18227
Calc.
Raw
200.00
158.99
40.92
33.01
85.34
33.00
0.00 326.26
 2  No Name #34754
Calc.
Raw
191.22
152.01
50.00
40.33
81.02
31.33
0.00 322.24
 3  No Name #33894
Calc.
Raw
183.52
145.89
42.15
34.00
85.34
33.00
0.00 311.01
 4  No Name #32490
Calc.
Raw
184.06
146.32
42.98
34.67
81.90
31.67
0.00 308.94
 5  No Name #35851
Calc.
Raw
182.79
145.31
45.05
36.34
76.73
29.67
0.00 304.57
 6  No Name #35071
Calc.
Raw
176.95
140.67
38.43
31.00
85.34
33.00
0.00 300.72
 7  No Name #1436
Calc.
Raw
172.90
137.45
41.74
33.67
84.48
32.67
0.00 299.12
 8  No Name #25320
Calc.
Raw
184.93
147.01
47.52
38.33
60.33
23.33
0.00 292.78
 9  No Name #33986
Calc.
Raw
179.46
142.66
33.88
27.33
74.99
29.00
0.00 288.33
 10  No Name #22311
Calc.
Raw
168.56
134.00
37.18
29.99
81.02
31.33
0.00 286.76
 11  No Name #34983
Calc.
Raw
171.08
136.00
29.33
23.66
84.48
32.67
0.00 284.89
 11  No Name #8020
Calc.
Raw
168.77
134.16
45.03
36.32
70.67
27.33
0.00 284.47
 12  No Name #35546
Calc.
Raw
170.04
135.17
32.25
26.01
80.17
31.00
0.00 282.46
 12  No Name #28072
Calc.
Raw
169.39
134.66
39.69
32.01
72.41
28.00
0.00 281.49
 13  No Name #31337
Calc.
Raw
157.24
125.00
41.73
33.66
81.02
31.33
0.00 279.99
 14  No Name #18112
Calc.
Raw
184.28
146.49
38.02
30.67
56.04
21.67
0.00 278.34
 15  No Name #35548
Calc.
Raw
145.92
116.00
29.75
24.00
100.00
38.67
0.00 275.67
 15  No Name #11901
Calc.
Raw
171.90
136.65
26.87
21.67
76.73
29.67
0.00 275.50
 16  No Name #2747
Calc.
Raw
172.34
137.00
32.23
26.00
68.97
26.67
0.00 273.54
 16  No Name #35493
Calc.
Raw
158.07
125.66
37.19
30.00
77.58
30.00
0.00 272.84
 17  No Name #36938
Calc.
Raw
156.61
124.50
31.01
25.01
84.48
32.67
0.00 272.10
 17  No Name #37146
Calc.
Raw
173.87
138.22
22.33
18.01
76.73
29.67
1.00 271.93
 18  No Name #11548
Calc.
Raw
168.98
134.33
34.71
28.00
67.24
26.00
0.00 270.93
 19  No Name #36467
Calc.
Raw
174.02
138.34
45.45
36.66
49.13
19.00
0.00 268.60
 20  No Name #37100
Calc.
Raw
152.21
121.00
32.23
26.00
80.17
31.00
0.00 264.61
 20  No Name #2271
Calc.
Raw
165.22
131.34
30.18
24.34
68.97
26.67
0.00 264.37
 21  No Name #35687
Calc.
Raw
155.14
123.33
26.05
21.01
80.17
31.00
0.00 261.36
 22  No Name #32144
Calc.
Raw
156.25
124.21
35.53
28.66
64.65
25.00
0.00 256.43
 22  No Name #8192
Calc.
Raw
182.60
145.16
37.61
30.34
36.20
14.00
0.00 256.41
 23  No Name #34601
Calc.
Raw
158.06
125.65
31.81
25.66
58.62
22.67
0.00 248.49
 23  No Name #16088
Calc.
Raw
165.63
131.67
27.68
22.33
54.31
21.00
0.00 247.62
 24  No Name #35907
Calc.
Raw
168.56
134.00
26.88
21.68
50.87
19.67
0.00 246.31
 25  No Name #18929
Calc.
Raw
148.42
117.99
29.75
24.00
66.38
25.67
0.00 244.55
 25  No Name #36641
Calc.
Raw
154.71
122.99
26.44
21.33
62.92
24.33
0.00 244.07
 26  No Name #35662
Calc.
Raw
147.18
117.00
38.85
31.34
56.04
21.67
0.00 242.07
 27  No Name #37039
Calc.
Raw
135.87
108.01
29.35
23.67
75.85
29.33
0.00 241.07
 28  No Name #1386
Calc.
Raw
160.60
127.67
29.35
23.67
46.55
18.00
0.00 236.50
 29  No Name #32184
Calc.
Raw
139.00
110.50
30.59
24.67
60.33
23.33
0.00 229.92
 30  No Name #35502
Calc.
Raw
152.63
121.33
22.32
18.00
52.57
20.33
0.00 227.52
 31  No Name #36211
Calc.
Raw
122.88
97.68
32.66
26.34
63.80
24.67
0.00 219.34
 32  No Name #35507
Calc.
Raw
126.22
100.34
30.59
24.67
59.48
23.00
0.00 216.29
 33  No Name #14485
Calc.
Raw
130.40
103.66
27.68
22.33
56.89
22.00
0.00 214.97
 34  No Name #15407
Calc.
Raw
124.95
99.33
24.80
20.00
63.80
24.67
0.00 213.55
 35  No Name #36051
Calc.
Raw
115.73
92.00
31.81
25.66
61.21
23.67
1.00 207.75
 36  No Name #35327
Calc.
Raw
116.15
92.33
28.53
23.01
56.89
22.00
1.00 200.57
 37  No Name #32289
Calc.
Raw
102.33
81.35
25.61
20.66
69.82
27.00
0.00 197.76
 37  No Name #17346
Calc.
Raw
127.30
101.20
18.60
15.00
50.87
19.67
0.00 196.77
 38  No Name #31230
Calc.
Raw
119.09
94.67
33.05
26.66
41.38
16.00
0.00 193.52
 39  No Name #9565
Calc.
Raw
80.63
64.10
32.64
26.33
77.58
30.00
0.00 190.85
 39  No Name #37156
Calc.
Raw
102.32
81.34
39.26
31.67
49.13
19.00
0.00 190.71
 40  No Name #35212
Calc.
Raw
76.31
60.66
26.04
21.00
87.92
34.00
2.00 188.27
 41  No Name #35889
Calc.
Raw
114.89
91.33
30.59
24.67
40.52
15.67
0.00 186.00
 42  No Name #36643
Calc.
Raw
82.17
65.32
21.49
17.33
25.86
10.00
0.00 129.52
 Problem 1 Tag 'em Division III
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #22311
Calc.
Raw
191.32
152.11
50.00
43.99
90.65
121.25
0.00 331.97
 2  No Name #18255
Calc.
Raw
173.36
137.83
46.99
41.34
96.82
129.50
0.00 317.17
 3  No Name #36232
Calc.
Raw
193.70
154.00
46.60
41.00
65.05
87.00
0.00 305.35
 4  No Name #31161
Calc.
Raw
186.15
148.00
15.16
13.34
100.00
133.75
0.00 301.31
 5  No Name #5736
Calc.
Raw
195.18
155.18
43.58
38.34
60.37
80.75
0.00 299.13
 6  No Name #7246
Calc.
Raw
173.35
137.82
31.44
27.66
91.59
122.50
0.00 296.38
 7  No Name #33516
Calc.
Raw
189.91
150.99
40.53
35.66
63.18
84.50
0.00 293.62
 8  No Name #30595
Calc.
Raw
182.58
145.16
29.94
26.34
80.00
107.00
0.00 292.52
 8  No Name #32441
Calc.
Raw
174.82
138.99
42.44
37.34
75.14
100.50
0.00 292.40
 9  No Name #32223
Calc.
Raw
171.06
136.00
21.97
19.33
97.38
130.25
0.00 290.41
 10  No Name #3887
Calc.
Raw
193.70
154.00
49.64
43.67
42.24
56.50
0.00 285.58
 11  No Name #3381
Calc.
Raw
164.35
130.67
15.91
14.00
99.63
133.25
0.00 279.89
 12  No Name #9125
Calc.
Raw
185.94
147.83
30.68
26.99
59.07
79.00
0.00 275.69
 13  No Name #31579
Calc.
Raw
166.01
131.99
29.93
26.33
78.50
105.00
0.00 274.44
 13  No Name #26200
Calc.
Raw
139.20
110.67
42.82
37.67
92.34
123.50
0.00 274.36
 14  No Name #33757
Calc.
Raw
189.91
150.99
30.31
26.67
50.84
68.00
0.00 271.06
 14  No Name #31230
Calc.
Raw
185.88
147.78
44.33
39.00
40.19
53.75
0.00 270.40
 15  No Name #36469
Calc.
Raw
200.00
159.01
36.37
32.00
33.27
44.50
0.00 269.64
 16  No Name #1149
Calc.
Raw
174.00
138.34
46.60
41.00
46.92
62.75
0.00 267.52
 17  No Name #31043
Calc.
Raw
183.22
145.67
27.28
24.00
55.70
74.50
0.00 266.20
 17  No Name #30951
Calc.
Raw
178.18
141.66
31.06
27.33
56.07
75.00
0.00 265.31
 18  No Name #35621
Calc.
Raw
177.35
141.00
42.43
37.33
42.80
57.25
0.00 262.58
 19  No Name #33488
Calc.
Raw
139.63
111.01
26.14
23.00
90.84
121.50
0.00 256.61
 20  No Name #1412
Calc.
Raw
152.19
121.00
23.88
21.01
78.88
105.50
0.00 254.95
 20  No Name #33422
Calc.
Raw
160.58
127.67
15.54
13.67
77.94
104.25
0.00 254.06
 21  No Name #20868
Calc.
Raw
179.45
142.67
28.40
24.99
45.42
60.75
0.00 253.27
 21  No Name #10146
Calc.
Raw
132.07
105.00
26.53
23.34
93.83
125.50
0.00 252.43
 22  No Name #34393
Calc.
Raw
167.07
132.83
23.87
21.00
59.63
79.75
0.00 250.57
 23  No Name #35758
Calc.
Raw
178.62
142.01
21.98
19.34
48.41
64.75
2.00 247.01
 24  No Name #36865
Calc.
Raw
141.50
112.50
15.54
13.67
84.11
112.50
0.00 241.15
 25  No Name #17068
Calc.
Raw
170.00
135.16
30.68
26.99
36.45
48.75
0.00 237.13
 26  No Name #4637
Calc.
Raw
169.79
134.99
21.22
18.67
38.32
51.25
0.00 229.33
 27  No Name #32530
Calc.
Raw
165.18
131.33
20.07
17.66
41.50
55.50
0.00 226.75
 28  No Name #37109
Calc.
Raw
97.26
77.33
23.12
20.34
96.64
129.25
0.00 217.02
 29  No Name #31734
Calc.
Raw
113.20
90.00
12.89
11.34
84.11
112.50
0.00 210.20
 30  No Name #36823
Calc.
Raw
157.64
125.33
25.38
22.33
25.23
33.75
0.00 208.25
 31  No Name #5420
Calc.
Raw
157.21
124.99
26.53
23.34
22.06
29.50
0.00 205.80
 32  No Name #25049
Calc.
Raw
154.57
122.89
19.32
17.00
29.91
40.00
0.00 203.80
 33  No Name #37158
Calc.
Raw
89.53
71.18
26.90
23.67
46.92
62.75
0.00 163.35
 34  No Name #33292
Calc.
Raw
78.85
62.69
27.65
24.33
53.08
71.00
0.00 159.58
 Problem 1 Tag 'em Division IV
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #35388
Calc.
Raw
200.00
120.32
50.00
22.66
100.00
50.00
0.00 350.00