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 II
 Rank   Member    Long
Term
 Weight  Style  Spont  Penalty  Total
 1  No Name #346
Calc.
Raw
178.38
21.00
150.00
1220.00
36.76
32.34
73.80
76.75
0.00 288.94
 2  No Name #5815
Calc.
Raw
146.45
24.67
113.11
920.00
50.00
43.99
64.90
67.50
0.00 261.35
 3  No Name #30390
Calc.
Raw
187.09
37.00
137.09
1115.00
27.65
24.33
43.99
45.75
0.00 258.73
 4  No Name #10720
Calc.
Raw
174.14
33.33
129.10
1050.00
20.85
18.34
59.38
61.75
0.00 254.37
 4  No Name #31523
Calc.
Raw
126.09
17.34
102.66
835.00
34.47
30.33
93.51
97.25
0.00 254.07
 5  No Name #35548
Calc.
Raw
120.84
18.00
96.52
785.00
18.95
16.67
100.00
104.00
0.00 239.79
 6  No Name #13505
Calc.
Raw
114.40
22.33
84.22
685.00
23.88
21.01
79.57
82.75
0.00 217.85
 7  No Name #416
Calc.
Raw
111.82
16.33
89.75
730.00
23.12
20.34
83.65
87.00
3.00 215.59
 8  No Name #1141
Calc.
Raw
126.12
26.00
90.98
740.00
16.67
14.67
69.71
72.50
0.00 212.50
 9  No Name #36481
Calc.
Raw
130.01
19.33
103.89
845.00
26.15
23.01
52.16
54.25
0.00 208.32
 10  No Name #36482
Calc.
Raw
121.21
16.00
99.59
810.00
34.09
29.99
48.32
50.25
0.00 203.62
 10  No Name #7958
Calc.
Raw
157.23
24.00
124.80
1015.00
23.87
21.00
26.68
27.75
5.00 202.78
 11  No Name #32282
Calc.
Raw
92.77
16.33
70.70
575.00
15.91
14.00
93.03
96.75
0.00 201.71
 12  No Name #31096
Calc.
Raw
124.24
17.33
100.82
820.00
26.90
23.67
45.19
47.00
0.00 196.33
 13  No Name #3060
Calc.
Raw
126.62
20.00
99.59
810.00
16.67
14.67
49.76
51.75
0.00 193.05
 13  No Name #18527
Calc.
Raw
92.31
26.00
57.17
465.00
29.55
26.00
70.67
73.50
0.00 192.53
 14  No Name #6986
Calc.
Raw
107.76
18.33
82.99
675.00
23.48
20.66
43.03
44.75
0.00 174.27
 15  No Name #32054
Calc.
Raw
91.70
16.00
70.08
570.00
28.42
25.00
51.44
53.50
0.00 171.56
 16  No Name #18918
Calc.
Raw
62.98
15.67
41.80
340.00
14.78
13.00
86.06
89.50
0.00 163.82
 17  No Name #35471
Calc.
Raw
81.29
14.66
61.48
500.00
29.56
26.01
50.24
52.25
0.00 161.09
 18  No Name #10029
Calc.
Raw
70.96
20.67
43.03
350.00
24.24
21.33
62.50
65.00
0.00 157.70
 19  No Name #16088
Calc.
Raw
96.38
19.00
70.70
575.00
23.10
20.32
34.38
35.75
0.00 153.86
 20  No Name #34374
Calc.
Raw
88.31
16.67
65.78
535.00
28.42
25.00
38.70
40.25
3.00 152.43
 21  No Name #34387
Calc.
Raw
71.91
15.00
51.64
420.00
29.93
26.33
49.04
51.00
0.00 150.88
 21  No Name #1140
Calc.
Raw
79.33
23.67
47.34
385.00
22.35
19.66
49.04
51.00
0.00 150.72
 22  No Name #14989
Calc.
Raw
53.55
12.33
36.89
300.00
30.31
26.67
65.14
67.75
0.00 149.00
 22  No Name #30515
Calc.
Raw
54.29
18.34
29.51
240.00
28.04
24.67
66.35
69.00
0.00 148.68
 23  No Name #25818
Calc.
Raw
72.06
29.67
31.97
260.00
30.69
27.00
41.35
43.00
0.00 144.10
 24  No Name #37168
Calc.
Raw
71.21
22.67
40.57
330.00
24.64
21.68
49.28
51.25
3.00 142.13
 25  No Name #37097
Calc.
Raw
19.87
8.33
8.61
70.00
28.04
24.67
92.31
96.00
0.00 140.22
 26  No Name #29418
Calc.
Raw
44.48
22.00
14.75
120.00
12.14
10.68
81.73
85.00
0.00 138.35
 27  No Name #36216
Calc.
Raw
96.78
20.67
68.85
560.00
14.03
12.34
23.56
24.50
0.00 134.37
 28  No Name #31873
Calc.
Raw
52.27
13.66
33.81
275.00
14.40
12.67
63.22
65.75
0.00 129.89
 29  No Name #2661
Calc.
Raw
35.64
20.00
8.61
70.00
26.90
23.67
65.87
68.50
0.00 128.41
 30  No Name #3422
Calc.
Raw
39.81
24.00
7.38
60.00
26.14
23.00
55.29
57.50
0.00 121.24
 31  No Name #34690
Calc.
Raw
30.68
16.33
8.61
70.00
21.98
19.34
66.11
68.75
0.00 118.77
 31  No Name #33956
Calc.
Raw
35.47
15.33
14.75
120.00
21.22
18.67
66.59
69.25
5.00 118.28
 32  No Name #30867
Calc.
Raw
37.31
25.34
3.07
25.00
19.70
17.33
59.13
61.50
0.00 116.14
 32  No Name #30704
Calc.
Raw
35.39
18.00
11.07
90.00
24.63
21.67
56.01
58.25
0.00 116.03
 32  No Name #37167
Calc.
Raw
44.95
17.34
21.52
175.00
26.89
23.66
43.51
45.25
0.00 115.35
 33  No Name #33527
Calc.
Raw
39.99
13.67
21.52
175.00
12.12
10.66
62.26
64.75
0.00 114.37
 34  No Name #35971
Calc.
Raw
19.69
13.66
1.23
10.00
15.92
14.01
76.68
79.75
0.00 112.29
 34  No Name #35161
Calc.
Raw
25.85
13.67
7.38
60.00
21.98
19.34
63.70
66.25
0.00 111.53
 35  No Name #33345
Calc.
Raw
52.38
29.66
12.30
100.00
23.12
20.34
28.13
29.25
0.00 103.63
 35  No Name #2437
Calc.
Raw
24.77
18.33
0.00
0.00
14.40
12.67
64.42
67.00
0.00 103.59
 36  No Name #30595
Calc.
Raw
39.48
14.66
19.67
160.00
22.73
20.00
38.94
40.50
0.00 101.15
 37  No Name #36669
Calc.
Raw
47.20
19.00
21.52
175.00
20.85
18.34
40.63
42.25
10.00 98.68
 37  No Name #13318
Calc.
Raw
29.08
13.33
11.07
90.00
22.73
20.00
46.63
48.50
0.00 98.44
 38  No Name #21189
Calc.
Raw
50.35
16.33
28.28
230.00
13.28
11.68
33.41
34.75
0.00 97.04
 38  No Name #22186
Calc.
Raw
28.31
13.67
9.84
80.00
25.01
22.00
43.51
45.25
0.00 96.83
 38  No Name #17231
Calc.
Raw
36.17
22.67
5.53
45.00
15.54
13.67
44.47
46.25
0.00 96.18
 39  No Name #35698
Calc.
Raw
24.66
17.34
1.23
10.00
12.49
10.99
56.25
58.50
0.00 93.40
 39  No Name #34899
Calc.
Raw
36.95
22.34
6.76
55.00
23.88
21.01
32.21
33.50
0.00 93.04
 40  No Name #36225
Calc.
Raw
19.81
14.66
0.00
0.00
17.81
15.67
53.37
55.50
0.00 90.99
 41  No Name #21059
Calc.
Raw
22.19
12.33
5.53
45.00
23.87
21.00
42.31
44.00
0.00 88.37
 42  No Name #21030
Calc.
Raw
24.33
13.00
6.76
55.00
24.24
21.33
38.70
40.25
0.00 87.27
 42  No Name #2271
Calc.
Raw
49.54
13.00
31.97
260.00
15.53
13.66
22.12
23.00
0.00 87.19
 43  No Name #36640
Calc.
Raw
33.66
24.00
1.23
10.00
19.70
17.33
32.21
33.50
0.00 85.57
 43  No Name #31624
Calc.
Raw
28.19
12.67
11.07
90.00
24.63
21.67
32.45
33.75
0.00 85.27
 43  No Name #21803
Calc.
Raw
25.23
18.67
0.00
0.00
28.05
24.68
31.97
33.25
0.00 85.25
 43  No Name #22504
Calc.
Raw
35.84
13.33
17.83
145.00
18.20
16.01
33.89
35.25
3.00 84.93
 44  No Name #33816
Calc.
Raw
27.03
20.00
0.00
0.00
14.41
12.68
25.48
26.50
0.00 66.92
 45  No Name #30579
Calc.
Raw
22.73
15.00
2.46
20.00
12.88
11.33
27.88
29.00
10.00 53.49