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 2005 May 21st
 Problem 1 The Great Parade Division II
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #1701
Calc.
Raw
193.15
178.66
41.48
39.00
100.00
86.75
0.00 334.63
 2  No Name #28547
Calc.
Raw
187.03
173.00
50.00
47.01
72.62
63.00
0.00 309.65
 3  No Name #30595
Calc.
Raw
200.00
185.00
35.10
33.00
35.73
31.00
0.00 270.83
 4  No Name #5122
Calc.
Raw
140.90
130.33
35.81
33.67
86.46
75.00
0.00 263.17
 5  No Name #29726
Calc.
Raw
171.18
158.34
47.86
45.00
33.14
28.75
0.00 252.18
 5  No Name #33089
Calc.
Raw
160.37
148.34
42.18
39.66
48.99
42.50
0.00 251.54
 6  No Name #32190
Calc.
Raw
183.43
169.67
31.20
29.33
34.01
29.50
0.00 248.64
 7  No Name #26815
Calc.
Raw
148.82
137.66
37.23
35.00
61.10
53.00
0.00 247.15
 7  No Name #10706
Calc.
Raw
179.10
165.67
38.28
35.99
29.11
25.25
0.00 246.49
 8  No Name #32490
Calc.
Raw
151.72
140.34
40.78
38.34
43.52
37.75
0.00 236.02
 9  No Name #18503
Calc.
Raw
164.34
152.01
36.15
33.99
34.01
29.50
0.00 234.50
 10  No Name #467
Calc.
Raw
178.03
164.68
33.33
31.34
21.04
18.25
0.00 232.40
 11  No Name #28695
Calc.
Raw
175.14
162.00
37.58
35.33
17.87
15.50
0.00 230.59
 12  No Name #31458
Calc.
Raw
153.16
141.67
46.45
43.67
17.58
15.25
0.00 217.19
 12  No Name #32289
Calc.
Raw
151.71
140.33
46.09
43.33
18.44
16.00
0.00 216.24
 13  No Name #13338
Calc.
Raw
153.51
142.00
41.48
39.00
20.75
18.00
0.00 215.74
 14  No Name #8192
Calc.
Raw
162.52
150.33
31.56
29.67
19.60
17.00
0.00 213.68
 15  No Name #31604
Calc.
Raw
123.60
114.33
34.40
32.34
51.59
44.75
0.00 209.59
 15  No Name #19826
Calc.
Raw
147.38
136.33
26.24
24.67
35.16
30.50
0.00 208.78
 16  No Name #11901
Calc.
Raw
103.06
95.33
28.73
27.01
71.18
61.75
0.00 202.97
 17  No Name #33757
Calc.
Raw
150.26
138.99
30.13
28.33
18.73
16.25
0.00 199.12
 18  No Name #789
Calc.
Raw
65.95
61.00
39.35
37.00
92.80
80.50
0.00 198.10
 19  No Name #7991
Calc.
Raw
120.71
111.66
29.77
27.99
46.40
40.25
0.00 196.88
 19  No Name #33579
Calc.
Raw
102.70
95.00
30.86
29.01
63.11
54.75
0.00 196.67
 20  No Name #22130
Calc.
Raw
109.90
101.66
39.35
37.00
43.80
38.00
0.00 193.05
 21  No Name #11595
Calc.
Raw
120.37
111.34
19.51
18.34
44.96
39.00
0.00 184.84
 22  No Name #14078
Calc.
Raw
124.68
115.33
32.25
30.32
23.92
20.75
0.00 180.85
 23  No Name #3057
Calc.
Raw
112.42
103.99
34.39
32.33
31.99
27.75
0.00 178.80
 24  No Name #21243
Calc.
Raw
152.80
141.34
34.04
32.00
21.90
19.00
33.00 175.74
 25  No Name #10036
Calc.
Raw
102.35
94.67
40.79
38.35
23.92
20.75
0.00 167.06
 26  No Name #34690
Calc.
Raw
118.21
109.34
30.48
28.66
21.33
18.50
4.00 166.02
 27  No Name #32600
Calc.
Raw
86.49
80.00
22.69
21.33
51.01
44.25
0.00 160.19
 28  No Name #25443
Calc.
Raw
80.72
74.67
35.46
33.34
42.94
37.25
0.00 159.12
 28  No Name #26430
Calc.
Raw
94.42
87.34
34.75
32.67
29.39
25.50
0.00 158.56
 29  No Name #6538
Calc.
Raw
87.57
81.00
19.13
17.99
49.28
42.75
0.00 155.98
 29  No Name #34159
Calc.
Raw
109.55
101.33
25.16
23.66
22.19
19.25
1.00 155.90
 29  No Name #34917
Calc.
Raw
90.45
83.67
27.65
26.00
37.46
32.50
0.00 155.56
 29  No Name #8903
Calc.
Raw
112.43
104.00
25.88
24.33
16.71
14.50
0.00 155.02
 30  No Name #5471
Calc.
Raw
107.03
99.00
15.24
14.33
27.38
23.75
0.00 149.65
 30  No Name #34669
Calc.
Raw
78.19
72.33
35.81
33.67
35.45
30.75
0.00 149.45
 31  No Name #35071
Calc.
Raw
86.85
80.34
36.88
34.67
18.16
15.75
0.00 141.89
 32  No Name #34398
Calc.
Raw
83.98
77.68
26.59
25.00
28.53
24.75
0.00 139.10
 33  No Name #20480
Calc.
Raw
73.87
68.33
29.78
28.00
15.56
13.50
0.00 119.21
 34  No Name #31037
Calc.
Raw
58.02
53.67
20.55
19.32
31.41
27.25
0.00 109.98
 35  No Name #11324
Calc.
Raw
76.76
71.00
15.95
15.00
12.10
10.50
0.00 104.81
 35  No Name #34931
Calc.
Raw
59.11
54.68
30.84
29.00
14.70
12.75
0.00 104.65
 36  No Name #1548
Calc.
Raw
49.36
45.66
21.27
20.00
19.88
17.25
0.00 90.51
 36  No Name #34338
Calc.
Raw
54.78
50.67
18.79
17.67
16.43
14.25
0.00 90.00
 37  No Name #35382
Calc.
Raw
43.98
40.68
18.78
17.66
19.02
16.50
0.00 81.78
 38  No Name #33857
Calc.
Raw
16.94
15.67
20.21
19.00
24.50
21.25
0.00 61.65