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 I
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #18449
Calc.
Raw
200.00
176.34
37.71
31.67
86.42
70.00
0.00 324.13
 2  No Name #33557
Calc.
Raw
182.98
161.33
46.83
39.33
91.67
74.25
0.00 321.48
 3  No Name #34928
Calc.
Raw
187.15
165.01
32.56
27.34
95.68
77.50
1.00 314.39
 3  No Name #16465
Calc.
Raw
192.42
169.66
48.82
41.00
72.53
58.75
0.00 313.77
 4  No Name #16873
Calc.
Raw
192.81
170.00
32.95
27.67
86.73
70.25
0.00 312.49
 4  No Name #5002
Calc.
Raw
198.09
174.66
40.89
34.34
72.53
58.75
0.00 311.51
 5  No Name #16868
Calc.
Raw
170.89
150.67
42.87
36.00
94.14
76.25
0.00 307.90
 6  No Name #33368
Calc.
Raw
188.27
166.00
26.60
22.34
90.74
73.50
0.00 305.61
 7  No Name #28072
Calc.
Raw
188.66
166.34
29.38
24.67
81.79
66.25
0.00 299.83
 8  No Name #34325
Calc.
Raw
182.98
161.33
42.47
35.67
70.37
57.00
0.00 295.82
 9  No Name #32122
Calc.
Raw
153.49
135.33
33.35
28.01
93.21
75.50
0.00 280.05
 10  No Name #1436
Calc.
Raw
139.13
122.67
36.52
30.67
94.44
76.50
0.00 270.09
 11  No Name #27796
Calc.
Raw
142.53
125.67
31.36
26.34
94.44
76.50
0.00 268.33
 11  No Name #32521
Calc.
Raw
151.60
133.67
32.15
27.00
83.64
67.75
0.00 267.39
 11  No Name #20906
Calc.
Raw
140.25
123.66
46.84
39.34
80.25
65.00
0.00 267.34
 12  No Name #6424
Calc.
Raw
187.89
165.66
23.80
19.99
52.16
42.25
0.00 263.85
 13  No Name #31531
Calc.
Raw
134.97
119.00
34.52
28.99
90.74
73.50
0.00 260.23
 14  No Name #32061
Calc.
Raw
120.21
105.99
38.09
31.99
93.83
76.00
0.00 252.13
 14  No Name #8174
Calc.
Raw
144.80
127.67
32.15
27.00
74.69
60.50
0.00 251.64
 15  No Name #26787
Calc.
Raw
127.41
112.34
35.72
30.00
82.72
67.00
0.00 245.85
 16  No Name #1567
Calc.
Raw
148.95
131.33
50.00
41.99
48.77
39.50
3.00 244.72
 17  No Name #24450
Calc.
Raw
142.52
125.66
32.95
27.67
61.73
50.00
0.00 237.20
 18  No Name #28577
Calc.
Raw
88.84
78.33
48.43
40.67
91.98
74.50
0.00 229.25
 19  No Name #5735
Calc.
Raw
108.12
95.33
35.33
29.67
79.32
64.25
0.00 222.77
 20  No Name #33705
Calc.
Raw
111.91
98.67
42.47
35.67
54.94
44.50
0.00 209.32
 21  No Name #237
Calc.
Raw
108.89
96.01
17.06
14.33
82.10
66.50
5.00 203.05
 22  No Name #35008
Calc.
Raw
105.48
93.00
18.66
15.67
79.32
64.25
2.00 201.46
 23  No Name #5469
Calc.
Raw
74.87
66.01
24.60
20.66
100.00
81.00
0.00 199.47
 23  No Name #34320
Calc.
Raw
135.34
119.33
19.05
16.00
47.22
38.25
3.00 198.61
 24  No Name #34917
Calc.
Raw
100.57
88.67
17.06
14.33
80.56
65.25
0.00 198.19
 25  No Name #35125
Calc.
Raw
117.58
103.67
14.68
12.33
63.27
51.25
0.00 195.53
 26  No Name #34242
Calc.
Raw
94.51
83.33
19.45
16.33
80.25
65.00
0.00 194.21
 27  No Name #28204
Calc.
Raw
105.86
93.34
37.31
31.33
50.00
40.50
0.00 193.17
 28  No Name #14485
Calc.
Raw
104.34
92.00
36.13
30.34
46.91
38.00
0.00 187.38
 29  No Name #5821
Calc.
Raw
108.13
95.34
19.85
16.67
54.94
44.50
0.00 182.92
 29  No Name #33039
Calc.
Raw
97.55
86.01
37.70
31.66
48.77
39.50
2.00 182.02
 30  No Name #30749
Calc.
Raw
64.65
57.00
23.83
20.01
85.80
69.50
0.00 174.28
 31  No Name #27122
Calc.
Raw
85.05
74.99
16.27
13.66
76.85
62.25
5.00 173.17
 32  No Name #33087
Calc.
Raw
73.72
65.00
18.25
15.33
84.57
68.50
10.00 166.54
 33  No Name #9971
Calc.
Raw
118.33
104.33
33.34
28.00
13.58
11.00
0.00 165.25
 34  No Name #22144
Calc.
Raw
66.92
59.00
29.77
25.00
66.05
53.50
2.00 160.74
 35  No Name #34284
Calc.
Raw
63.50
55.99
37.32
31.34
52.78
42.75
1.00 152.60
 36  No Name #2925
Calc.
Raw
26.85
23.67
39.70
33.34
84.57
68.50
0.00 151.12
 37  No Name #33278
Calc.
Raw
90.36
79.67
26.99
22.67
30.56
24.75
0.00 147.91
 38  No Name #5470
Calc.
Raw
100.18
88.33
10.73
9.01
30.56
24.75
0.00 141.47
 39  No Name #35277
Calc.
Raw
96.02
84.66
19.46
16.34
21.60
17.50
0.00 137.08
 40  No Name #31036
Calc.
Raw
79.39
70.00
20.64
17.33
31.48
25.50
1.00 130.51
 41  No Name #35357
Calc.
Raw
41.59
36.67
16.27
13.66
73.15
59.25
3.00 128.01
 42  No Name #33979
Calc.
Raw
25.71
22.67
16.67
14.00
77.47
62.75
0.00 119.85
 43  No Name #12905
Calc.
Raw
22.30
19.66
21.43
18.00
53.70
43.50
0.00 97.43
 44  No Name #32847
Calc.
Raw
19.28
17.00
12.71
10.67
56.17
45.50
0.00 88.16