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 I
 Rank   Member    Long
Term
 Weight  Style  Spont  Penalty  Total
 1  No Name #37787
Calc.
Raw
200.00
48.00
150.00
730.00
34.80
29.00
85.25
96.33
0.00 320.05
 2  No Name #4639
Calc.
Raw
153.51
30.00
122.26
595.00
38.00
31.67
100.00
113.00
0.00 291.51
 3  No Name #14138
Calc.
Raw
158.52
44.67
111.99
545.00
37.59
31.33
56.64
64.00
0.00 252.75
 4  No Name #8147
Calc.
Raw
170.14
19.33
150.00
730.00
34.40
28.67
40.71
46.00
0.00 245.25
 5  No Name #37166
Calc.
Raw
126.88
36.00
89.38
435.00
39.60
33.00
67.85
76.67
0.00 234.33
 6  No Name #34412
Calc.
Raw
146.43
38.00
106.85
520.00
26.78
22.32
59.88
67.67
5.00 228.09
 7  No Name #30823
Calc.
Raw
153.99
15.67
137.67
670.00
14.40
12.00
53.10
60.00
0.00 221.49
 8  No Name #28072
Calc.
Raw
91.15
28.33
61.64
300.00
38.79
32.33
77.58
87.67
0.00 207.52
 8  No Name #2432
Calc.
Raw
123.95
46.00
76.03
370.00
43.59
36.33
39.23
44.33
0.00 206.77
 9  No Name #31388
Calc.
Raw
113.76
28.33
84.25
410.00
39.60
33.00
64.89
73.33
20.00 198.25
 10  No Name #36467
Calc.
Raw
123.22
43.33
78.08
380.00
34.40
28.67
36.58
41.33
0.00 194.20
 11  No Name #36864
Calc.
Raw
88.63
19.00
68.84
335.00
30.00
25.00
72.27
81.67
0.00 190.90
 12  No Name #37309
Calc.
Raw
95.11
41.00
52.40
255.00
35.60
29.67
56.04
63.33
0.00 186.75
 13  No Name #34123
Calc.
Raw
66.64
38.33
26.71
130.00
36.39
30.33
81.71
92.33
0.00 184.74
 14  No Name #1388
Calc.
Raw
113.45
31.00
81.16
395.00
37.59
31.33
28.91
32.67
0.00 179.95
 15  No Name #36158
Calc.
Raw
69.09
41.67
25.68
125.00
31.20
26.00
78.47
88.67
0.00 178.76
 16  No Name #34231
Calc.
Raw
84.87
19.33
64.73
315.00
20.40
17.00
78.47
88.67
6.00 177.74
 16  No Name #30339
Calc.
Raw
51.31
19.67
30.82
150.00
44.00
36.67
81.71
92.33
0.00 177.02
 17  No Name #34814
Calc.
Raw
65.00
19.00
45.21
220.00
50.00
41.67
57.23
64.67
0.00 172.23
 18  No Name #34897
Calc.
Raw
52.31
42.33
8.22
40.00
36.80
30.67
78.17
88.33
0.00 167.28
 19  No Name #36576
Calc.
Raw
41.37
19.00
21.58
105.00
39.60
33.00
79.05
89.33
0.00 160.02
 20  No Name #35490
Calc.
Raw
58.83
19.00
39.04
190.00
32.00
26.67
66.66
75.33
0.00 157.49
 20  No Name #15746
Calc.
Raw
55.75
19.00
35.96
175.00
21.99
18.33
78.76
89.00
0.00 156.50
 21  No Name #603
Calc.
Raw
79.05
19.67
58.56
285.00
33.60
28.00
39.53
44.67
0.00 152.18
 21  No Name #34521
Calc.
Raw
54.54
29.67
23.63
115.00
32.40
27.00
64.31
72.67
0.00 151.25
 22  No Name #36616
Calc.
Raw
33.83
18.67
14.38
70.00
39.60
33.00
69.32
78.33
0.00 142.75
 23  No Name #1244
Calc.
Raw
60.94
46.67
12.33
60.00
25.59
21.33
55.16
62.33
0.00 141.69
 23  No Name #35727
Calc.
Raw
60.10
36.00
22.60
110.00
35.19
29.33
45.73
51.67
0.00 141.02
 24  No Name #37595
Calc.
Raw
67.38
42.00
23.63
115.00
13.20
11.00
56.64
64.00
0.00 137.22
 25  No Name #1544
Calc.
Raw
42.05
18.67
22.60
110.00
36.80
30.67
57.23
64.67
0.00 136.08
 26  No Name #36693
Calc.
Raw
53.29
14.67
38.01
185.00
26.79
22.33
54.27
61.33
0.00 134.35
 27  No Name #3422
Calc.
Raw
67.74
43.33
22.60
110.00
40.40
33.67
21.53
24.33
0.00 129.67
 27  No Name #12646
Calc.
Raw
65.93
35.67
28.77
140.00
32.40
27.00
31.27
35.33
0.00 129.60
 28  No Name #24052
Calc.
Raw
26.26
16.33
9.25
45.00
23.19
19.33
77.88
88.00
0.00 127.33
 29  No Name #31655
Calc.
Raw
38.28
19.00
18.49
90.00
18.39
15.33
63.72
72.00
0.00 120.39
 30  No Name #35602
Calc.
Raw
41.37
19.00
21.58
105.00
18.00
15.00
58.12
65.67
0.00 117.49
 30  No Name #31535
Calc.
Raw
48.53
17.00
30.82
150.00
23.19
19.33
45.42
51.33
0.00 117.14
 30  No Name #30904
Calc.
Raw
29.31
14.33
14.38
70.00
34.80
29.00
52.50
59.33
0.00 116.61
 31  No Name #18898
Calc.
Raw
55.72
17.00
38.01
185.00
18.39
15.33
40.42
45.67
0.00 114.53
 31  No Name #2900
Calc.
Raw
44.05
14.67
28.77
140.00
25.59
21.33
43.96
49.67
0.00 113.60
 32  No Name #11374
Calc.
Raw
43.36
38.67
3.08
15.00
40.40
33.67
28.91
32.67
0.00 112.67
 32  No Name #21688
Calc.
Raw
41.62
37.00
3.08
15.00
17.19
14.33
53.69
60.67
0.00 112.50
 33  No Name #32197
Calc.
Raw
25.93
17.00
8.22
40.00
34.40
28.67
44.84
50.67
0.00 105.17
 34  No Name #35846
Calc.
Raw
22.88
20.00
2.05
10.00
24.80
20.67
53.98
61.00
0.00 101.66
 35  No Name #34298
Calc.
Raw
60.52
41.33
17.47
85.00
31.59
26.33
7.08
8.00
0.00 99.19
 35  No Name #1829
Calc.
Raw
20.42
14.67
5.14
25.00
19.20
16.00
58.70
66.33
0.00 98.32
 36  No Name #33953
Calc.
Raw
63.29
19.33
43.15
210.00
24.39
20.33
30.09
34.00
20.00 97.77
 37  No Name #35604
Calc.
Raw
51.64
19.00
31.85
155.00
17.19
14.33
27.73
31.33
0.00 96.56
 38  No Name #33375
Calc.
Raw
21.14
18.33
2.05
10.00
23.60
19.67
49.85
56.33
0.00 94.59
 39  No Name #30889
Calc.
Raw
19.39
14.67
4.11
20.00
36.00
30.00
37.46
42.33
0.00 92.85
 39  No Name #35314
Calc.
Raw
22.45
12.67
9.25
45.00
15.60
13.00
54.58
61.67
0.00 92.63
 40  No Name #37359
Calc.
Raw
19.45
18.67
0.00
0.00
32.00
26.67
41.59
47.00
5.00 88.04
 41  No Name #33381
Calc.
Raw
44.09
42.33
0.00
0.00
14.40
12.00
17.11
19.33
0.00 75.60
 42  No Name #29062
Calc.
Raw
32.47
19.33
12.33
60.00
23.19
19.33
6.19
7.00
0.00 61.85
 43  No Name #32181
Calc.
Raw
40.34
19.00
20.55
100.00
31.59
26.33
37.76
42.67
65.00 44.69