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 2007 May 23rd
 Problem 4 Out Of The Box Balsa Division I
 Rank   Member    Long
Term
 Weight  Style  Spont  Penalty  Total
 1  No Name #34768
Calc.
Raw
175.72
34.00
127.15
1085.00
50.00
46.00
66.85
61.50
5.00 287.57
 2  No Name #31486
Calc.
Raw
183.80
23.66
150.00
1280.00
40.58
37.33
52.45
48.25
30.00 246.83
 3  No Name #14138
Calc.
Raw
139.12
27.66
99.61
850.00
35.14
32.33
67.66
62.25
0.00 241.92
 4  No Name #11374
Calc.
Raw
113.46
22.00
82.03
700.00
38.77
35.67
80.98
74.50
2.00 231.21
 5  No Name #4645
Calc.
Raw
118.26
32.33
72.07
615.00
21.74
20.00
85.05
78.25
0.00 225.05
 6  No Name #1388
Calc.
Raw
134.93
22.67
102.54
875.00
40.22
37.00
44.02
40.50
5.00 214.17
 7  No Name #34903
Calc.
Raw
114.81
25.00
79.10
675.00
19.21
17.67
60.60
55.75
0.00 194.62
 8  No Name #2432
Calc.
Raw
134.05
25.34
97.85
835.00
31.16
28.67
25.27
23.25
0.00 190.48
 9  No Name #4639
Calc.
Raw
105.47
21.33
75.00
640.00
36.59
33.66
44.29
40.75
0.00 186.35
 10  No Name #36971
Calc.
Raw
96.46
27.33
57.42
490.00
40.22
37.00
35.60
32.75
0.00 172.28
 11  No Name #30339
Calc.
Raw
130.56
16.33
107.23
915.00
32.25
29.67
24.46
22.50
20.00 167.27
 11  No Name #37166
Calc.
Raw
104.49
35.00
54.49
465.00
30.79
28.33
31.25
28.75
0.00 166.53
 12  No Name #35273
Calc.
Raw
77.86
18.00
52.15
445.00
34.79
32.01
58.42
53.75
5.00 166.07
 13  No Name #35282
Calc.
Raw
46.56
17.00
22.27
190.00
14.13
13.00
100.00
92.00
0.00 160.69
 13  No Name #8147
Calc.
Raw
124.92
21.00
94.92
810.00
26.46
24.34
13.59
12.50
5.00 159.97
 14  No Name #20906
Calc.
Raw
90.71
21.66
59.77
510.00
40.58
37.33
27.45
25.25
0.00 158.74
 14  No Name #31388
Calc.
Raw
109.08
19.34
81.45
695.00
23.20
21.34
26.36
24.25
0.00 158.64
 15  No Name #34320
Calc.
Raw
96.03
23.33
62.70
535.00
25.72
23.66
35.87
33.00
0.00 157.62
 16  No Name #30242
Calc.
Raw
47.03
17.33
22.27
190.00
26.82
24.67
80.98
74.50
0.00 154.83
 16  No Name #31310
Calc.
Raw
64.24
16.67
40.43
345.00
30.43
28.00
60.33
55.50
1.00 154.00
 17  No Name #30200
Calc.
Raw
67.47
24.67
32.23
275.00
43.84
40.33
37.77
34.75
0.00 149.08
 17  No Name #32164
Calc.
Raw
61.83
18.67
35.16
300.00
28.62
26.33
57.88
53.25
0.00 148.33
 18  No Name #35789
Calc.
Raw
82.76
22.66
50.39
430.00
21.37
19.66
43.75
40.25
0.00 147.88
 19  No Name #35477
Calc.
Raw
78.44
18.00
52.73
450.00
22.11
20.34
45.65
42.00
0.00 146.20
 20  No Name #36495
Calc.
Raw
36.89
19.67
8.79
75.00
18.84
17.33
85.33
78.50
0.00 141.06
 21  No Name #36576
Calc.
Raw
47.25
16.67
23.44
200.00
34.41
31.66
53.80
49.50
0.00 135.46
 21  No Name #20039
Calc.
Raw
84.56
24.33
49.80
425.00
16.67
15.34
33.70
31.00
0.00 134.93
 22  No Name #15746
Calc.
Raw
34.55
14.34
14.06
120.00
22.83
21.00
75.54
69.50
0.00 132.92
 23  No Name #27311
Calc.
Raw
43.99
17.67
18.75
160.00
16.66
15.33
68.21
62.75
0.00 128.86
 24  No Name #37165
Calc.
Raw
62.88
19.00
35.74
305.00
23.92
22.01
45.65
42.00
5.00 127.45
 25  No Name #30823
Calc.
Raw
80.55
27.67
41.02
350.00
23.55
21.67
15.76
14.50
0.00 119.86
 25  No Name #1544
Calc.
Raw
44.20
22.33
12.30
105.00
23.90
21.99
51.09
47.00
0.00 119.19
 26  No Name #24450
Calc.
Raw
56.11
20.00
27.54
235.00
30.08
27.67
32.34
29.75
0.00 118.53
 26  No Name #32181
Calc.
Raw
67.53
17.33
42.77
365.00
38.41
35.34
22.55
20.75
10.00 118.49
 27  No Name #35570
Calc.
Raw
47.39
18.00
21.68
185.00
22.11
20.34
47.28
43.50
0.00 116.78
 28  No Name #36048
Calc.
Raw
38.31
26.00
1.17
10.00
23.18
21.33
52.72
48.50
0.00 114.21
 29  No Name #35604
Calc.
Raw
41.40
11.34
25.20
215.00
25.00
23.00
45.65
42.00
0.00 112.05
 29  No Name #3422
Calc.
Raw
50.37
30.34
7.03
60.00
25.73
23.67
35.05
32.25
0.00 111.15
 30  No Name #31899
Calc.
Raw
35.09
18.00
9.38
80.00
22.47
20.67
52.45
48.25
0.00 110.01
 30  No Name #36460
Calc.
Raw
47.39
18.00
21.68
185.00
27.90
25.67
34.51
31.75
0.00 109.80
 31  No Name #16925
Calc.
Raw
56.11
25.33
19.92
170.00
24.27
22.33
26.63
24.50
5.00 102.01
 32  No Name #37028
Calc.
Raw
41.14
15.67
18.75
160.00
27.53
25.33
32.07
29.50
0.00 100.74
 33  No Name #32898
Calc.
Raw
33.81
18.33
7.62
65.00
10.14
9.33
55.16
50.75
0.00 99.11
 34  No Name #8704
Calc.
Raw
25.93
17.33
1.17
10.00
28.26
26.00
42.93
39.50
0.00 97.12
 35  No Name #10655
Calc.
Raw
26.14
16.66
2.34
20.00
32.24
29.66
35.05
32.25
0.00 93.43
 36  No Name #2437
Calc.
Raw
21.90
15.33
0.00
0.00
15.95
14.67
53.80
49.50
0.00 91.65
 36  No Name #35727
Calc.
Raw
30.83
16.66
7.03
60.00
20.29
18.67
40.22
37.00
0.00 91.34
 37  No Name #30595
Calc.
Raw
50.51
21.00
20.51
175.00
24.64
22.67
13.86
12.75
0.00 89.01