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 4 Geometry Structure Division III
 Rank   Member    Long
Term
 Weight  Style  Spont  Penalty  Total
 1  No Name #2660
Calc.
Raw
200.00
32.66
150.00
1380.00
42.70
41.00
53.59
31.75
2.00 294.29
 2  No Name #34689
Calc.
Raw
186.66
37.33
133.15
1225.00
44.08
42.33
54.01
32.00
0.00 284.75
 2  No Name #32674
Calc.
Raw
192.92
34.34
141.85
1305.00
50.00
48.01
41.35
24.50
0.00 284.27
 3  No Name #22063
Calc.
Raw
138.71
32.66
94.02
865.00
44.78
43.00
100.00
59.25
0.00 283.49
 4  No Name #11606
Calc.
Raw
158.06
35.66
108.70
1000.00
45.47
43.66
60.76
36.00
0.00 264.29
 4  No Name #7158
Calc.
Raw
161.01
29.66
117.39
1080.00
42.35
40.66
60.76
36.00
0.00 264.12
 5  No Name #26200
Calc.
Raw
153.01
28.33
111.41
1025.00
45.13
43.33
63.29
37.50
0.00 261.43
 5  No Name #1965
Calc.
Raw
175.83
32.33
128.26
1180.00
44.09
42.34
41.35
24.50
0.00 261.27
 6  No Name #1595
Calc.
Raw
161.12
28.67
118.48
1090.00
41.65
39.99
57.38
34.00
0.00 260.15
 7  No Name #32995
Calc.
Raw
155.62
38.33
103.80
955.00
39.58
38.00
49.79
29.50
0.00 244.99
 8  No Name #32441
Calc.
Raw
129.95
39.33
79.35
730.00
50.00
48.01
62.87
37.25
0.00 242.82
 9  No Name #3637
Calc.
Raw
132.99
17.66
103.80
955.00
37.15
35.67
67.93
40.25
0.00 238.07
 10  No Name #24409
Calc.
Raw
143.41
35.33
95.65
880.00
36.10
34.66
55.27
32.75
0.00 234.78
 11  No Name #30704
Calc.
Raw
138.53
34.67
91.85
845.00
36.79
35.33
53.59
31.75
0.00 228.91
 12  No Name #5109
Calc.
Raw
124.35
29.33
84.24
775.00
42.35
40.66
60.34
35.75
0.00 227.04
 13  No Name #2680
Calc.
Raw
143.49
28.33
102.72
945.00
22.56
21.66
59.92
35.50
0.00 225.97
 14  No Name #12145
Calc.
Raw
139.77
32.00
95.65
880.00
40.26
38.66
43.04
25.50
0.00 223.07
 15  No Name #1149
Calc.
Raw
126.07
21.66
93.48
860.00
39.92
38.33
54.85
32.50
0.00 220.84
 16  No Name #11102
Calc.
Raw
130.70
21.00
98.37
905.00
38.53
37.00
54.85
32.50
10.00 214.08
 17  No Name #381
Calc.
Raw
112.73
26.33
76.63
705.00
39.58
38.00
56.12
33.25
0.00 208.43
 17  No Name #31232
Calc.
Raw
125.93
35.66
79.35
730.00
40.26
38.66
42.19
25.00
0.00 208.38
 18  No Name #33992
Calc.
Raw
121.92
32.00
79.35
730.00
27.08
26.00
57.38
34.00
0.00 206.38
 19  No Name #22311
Calc.
Raw
102.11
29.67
63.59
585.00
37.49
36.00
62.87
37.25
0.00 202.47
 20  No Name #28603
Calc.
Raw
106.97
34.66
63.04
580.00
35.42
34.01
56.96
33.75
0.00 199.35
 21  No Name #19063
Calc.
Raw
103.79
20.33
74.46
685.00
36.10
34.66
56.96
33.75
0.00 196.85
 22  No Name #6656
Calc.
Raw
103.97
33.00
61.96
570.00
39.23
37.67
45.99
27.25
0.00 189.19
 22  No Name #33422
Calc.
Raw
97.70
19.66
69.57
640.00
38.87
37.32
62.45
37.00
10.00 189.02
 23  No Name #786
Calc.
Raw
88.33
20.34
60.33
555.00
38.19
36.67
57.38
34.00
2.00 181.90
 23  No Name #23464
Calc.
Raw
88.08
20.66
59.78
550.00
27.42
26.33
66.24
39.25
0.00 181.74
 24  No Name #12897
Calc.
Raw
104.38
30.66
64.67
595.00
32.62
31.32
38.82
23.00
0.00 175.82
 25  No Name #26319
Calc.
Raw
46.93
21.66
21.20
195.00
32.97
31.66
90.30
53.50
0.00 170.20
 26  No Name #19945
Calc.
Raw
99.40
31.00
59.78
550.00
30.21
29.01
37.13
22.00
0.00 166.74
 27  No Name #3069
Calc.
Raw
71.17
25.33
39.67
365.00
37.84
36.33
54.01
32.00
0.00 163.02
 28  No Name #32969
Calc.
Raw
52.51
21.33
26.63
245.00
33.32
31.99
74.26
44.00
0.00 160.09
 29  No Name #13984
Calc.
Raw
71.25
33.00
32.07
295.00
47.56
45.67
37.97
22.50
0.00 156.78
 30  No Name #30941
Calc.
Raw
44.87
35.00
5.98
55.00
46.18
44.34
55.70
33.00
0.00 146.75
 31  No Name #13641
Calc.
Raw
49.18
31.33
13.59
125.00
35.06
33.66
57.38
34.00
0.00 141.62
 32  No Name #14991
Calc.
Raw
37.70
33.34
1.09
10.00
31.94
30.67
56.96
33.75
0.00 126.60
 33  No Name #33752
Calc.
Raw
29.59
22.67
4.35
40.00
25.34
24.33
58.65
34.75
0.00 113.58
 34  No Name #35285
Calc.
Raw
47.90
17.66
26.09
240.00
26.04
25.00
38.40
22.75
0.00 112.34
 35  No Name #32435
Calc.
Raw
22.87
16.00
4.89
45.00
24.65
23.67
54.01
32.00
0.00 101.53