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 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