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 2008 May 31st
 Problem 4 Tee Structure Division II
 Rank   Member    Long
Term
 Weight  Style  Spont  Penalty  Total
 1  No Name #9083
Calc.
Raw
198.98
48.00
150.00
865.00
49.09
36.00
99.27
136.00
0.00 347.34
 2  No Name #1140
Calc.
Raw
174.16
40.67
132.66
765.00
49.09
36.00
85.40
117.00
0.00 308.65
 3  No Name #346
Calc.
Raw
153.18
49.00
103.18
595.00
41.82
30.67
93.43
128.00
0.00 288.43
 4  No Name #31482
Calc.
Raw
137.76
48.33
88.44
510.00
50.00
36.67
84.12
115.25
0.00 271.88
 5  No Name #13505
Calc.
Raw
133.87
34.33
98.84
570.00
42.27
31.00
87.41
119.75
0.00 263.55
 6  No Name #416
Calc.
Raw
124.77
39.00
84.97
490.00
36.36
26.67
100.00
137.00
0.00 261.13
 7  No Name #30390
Calc.
Raw
119.25
20.00
98.84
570.00
39.99
29.33
90.69
124.25
0.00 249.93
 8  No Name #36450
Calc.
Raw
140.19
39.67
99.71
575.00
42.72
31.33
63.14
86.50
0.00 246.05
 9  No Name #3060
Calc.
Raw
141.72
32.67
108.38
625.00
39.99
29.33
58.39
80.00
0.00 240.10
 10  No Name #7160
Calc.
Raw
104.69
19.33
84.97
490.00
42.27
31.00
83.94
115.00
0.00 230.90
 11  No Name #34374
Calc.
Raw
90.31
36.67
52.89
305.00
46.36
34.00
86.86
119.00
0.00 223.53
 12  No Name #36693
Calc.
Raw
90.74
15.00
75.43
435.00
34.54
25.33
89.78
123.00
0.00 215.06
 13  No Name #28378
Calc.
Raw
94.29
19.33
74.57
430.00
30.45
22.33
86.86
119.00
0.00 211.60
 14  No Name #32054
Calc.
Raw
80.61
18.67
61.56
355.00
35.45
26.00
90.51
124.00
0.00 206.57
 15  No Name #13653
Calc.
Raw
93.61
45.00
47.69
275.00
27.27
20.00
80.11
109.75
0.00 200.99
 16  No Name #36576
Calc.
Raw
89.95
19.33
70.23
405.00
49.54
36.33
60.04
82.25
0.00 199.53
 17  No Name #37300
Calc.
Raw
90.15
18.67
71.10
410.00
36.36
26.67
70.26
96.25
0.00 196.77
 18  No Name #32282
Calc.
Raw
165.69
30.67
134.39
775.00
34.54
25.33
20.26
27.75
25.00 195.49
 19  No Name #36216
Calc.
Raw
128.69
25.00
103.18
595.00
39.54
29.00
22.45
30.75
0.00 190.68
 20  No Name #1388
Calc.
Raw
87.02
19.00
67.63
390.00
30.45
22.33
69.34
95.00
0.00 186.81
 21  No Name #34546
Calc.
Raw
68.18
33.67
33.82
195.00
33.64
24.67
81.20
111.25
0.00 183.02
 22  No Name #36485
Calc.
Raw
54.89
30.00
24.28
140.00
34.09
25.00
91.06
124.75
0.00 180.04
 22  No Name #26367
Calc.
Raw
48.29
30.33
17.34
100.00
36.36
26.67
95.07
130.25
0.00 179.72
 23  No Name #17346
Calc.
Raw
54.94
19.00
35.55
205.00
32.27
23.67
87.77
120.25
0.00 174.98
 24  No Name #16088
Calc.
Raw
42.80
19.00
23.41
135.00
38.63
28.33
89.60
122.75
0.00 171.03
 24  No Name #36144
Calc.
Raw
41.59
18.67
22.54
130.00
44.55
32.67
84.67
116.00
0.00 170.81
 25  No Name #19264
Calc.
Raw
49.01
29.33
19.08
110.00
23.63
17.33
96.72
132.50
0.00 169.36
 26  No Name #22944
Calc.
Raw
51.05
48.33
1.73
10.00
23.18
17.00
92.70
127.00
0.00 166.93
 27  No Name #34916
Calc.
Raw
97.34
14.67
82.37
475.00
40.46
29.67
26.28
36.00
0.00 164.08
 28  No Name #32946
Calc.
Raw
48.87
19.00
29.48
170.00
26.36
19.33
85.58
117.25
0.00 160.81
 28  No Name #10605
Calc.
Raw
32.92
18.67
13.87
80.00
36.81
27.00
90.33
123.75
0.00 160.06
 29  No Name #37464
Calc.
Raw
47.22
23.33
23.41
135.00
41.82
30.67
65.88
90.25
0.00 154.92
 30  No Name #36280
Calc.
Raw
52.47
29.33
22.54
130.00
41.36
30.33
59.85
82.00
0.00 153.68
 30  No Name #36181
Calc.
Raw
73.15
19.00
53.76
310.00
29.08
21.33
51.28
70.25
0.00 153.51
 31  No Name #2111
Calc.
Raw
31.19
18.67
12.14
70.00
28.63
21.00
92.34
126.50
0.00 152.16
 31  No Name #35471
Calc.
Raw
48.00
19.00
28.61
165.00
30.91
22.67
73.18
100.25
0.00 152.09
 31  No Name #3422
Calc.
Raw
50.38
38.33
11.27
65.00
27.72
20.33
73.91
101.25
0.00 152.01
 31  No Name #10706
Calc.
Raw
27.72
18.67
8.67
50.00
35.45
26.00
88.69
121.50
0.00 151.86
 31  No Name #37801
Calc.
Raw
30.66
19.00
11.27
65.00
36.36
26.67
84.49
115.75
0.00 151.51
 31  No Name #30515
Calc.
Raw
65.63
30.33
34.68
200.00
42.72
31.33
43.07
59.00
0.00 151.42
 32  No Name #30879
Calc.
Raw
43.75
40.33
2.60
15.00
20.00
14.67
68.98
94.50
0.00 132.73
 32  No Name #36701
Calc.
Raw
14.62
14.33
0.00
0.00
31.36
23.00
86.68
118.75
0.00 132.66
 32  No Name #31604
Calc.
Raw
53.02
19.67
32.95
190.00
26.82
19.67
52.19
71.50
0.00 132.03
 33  No Name #35273
Calc.
Raw
82.63
30.00
52.02
300.00
29.55
21.67
13.87
19.00
0.00 126.05
 34  No Name #13791
Calc.
Raw
49.65
14.67
34.68
200.00
31.81
23.33
41.24
56.50
0.00 122.70
 34  No Name #37316
Calc.
Raw
32.99
32.33
0.00
0.00
19.09
14.00
69.89
95.75
0.00 121.97
 35  No Name #37168
Calc.
Raw
52.34
19.00
32.95
190.00
38.63
28.33
27.01
37.00
0.00 117.98
 35  No Name #35698
Calc.
Raw
50.90
47.33
2.60
15.00
15.45
11.33
50.91
69.75
0.00 117.26
 36  No Name #29418
Calc.
Raw
46.47
26.00
19.94
115.00
33.17
24.33
25.18
34.50
0.00 104.82
 37  No Name #33956
Calc.
Raw
34.13
19.00
14.74
85.00
26.36
19.33
42.88
58.75
0.00 103.37
 38  No Name #22248
Calc.
Raw
35.94
32.67
2.60
15.00
30.00
22.00
31.93
43.75
0.00 97.87
 39  No Name #34935
Calc.
Raw
48.87
19.00
29.48
170.00
22.73
16.67
18.43
25.25
0.00 90.03
 40  No Name #7720
Calc.
Raw
35.52
18.67
16.47
95.00
30.00
22.00
18.25
25.00
0.00 83.77
 41  No Name #6688
Calc.
Raw
24.51
14.67
9.54
55.00
33.17
24.33
24.64
33.75
0.00 82.32
 42  No Name #37865
Calc.
Raw
29.26
28.67
0.00
0.00
20.00
14.67
26.82
36.75
0.00 76.08
 43  No Name #37449
Calc.
Raw
32.68
30.33
1.73
10.00
24.09
17.67
15.51
21.25
0.00 72.28
 44  No Name #1991
Calc.
Raw
32.38
28.33
3.47
20.00
20.45
15.00
18.07
24.75
0.00 70.90
 45  No Name #37276
Calc.
Raw
22.55
17.00
5.20
30.00
14.55
10.67
24.45
33.50
0.00 61.55
 46  No Name #34512
Calc.
Raw
15.31
15.00
0.00
0.00
29.55
21.67
14.78
20.25
0.00 59.64