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 3 Around The World In 8 Minutes Division II
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #22311
Calc.
Raw
189.62
155.25
40.84
28.33
86.85
105.67
0.00 317.31
 1  No Name #32462
Calc.
Raw
200.00
163.75
50.00
34.68
67.12
81.67
0.00 317.12
 2  No Name #32284
Calc.
Raw
168.55
138.00
33.65
23.34
100.00
121.67
0.00 302.20
 3  No Name #1375
Calc.
Raw
173.13
141.75
37.01
25.67
90.14
109.67
0.00 300.28
 4  No Name #31225
Calc.
Raw
181.37
148.50
37.98
26.34
79.17
96.33
0.00 298.52
 5  No Name #35850
Calc.
Raw
189.62
155.25
45.66
31.67
61.64
75.00
0.00 296.92
 6  No Name #6688
Calc.
Raw
195.73
160.25
33.17
23.01
66.02
80.33
0.00 294.92
 6  No Name #15677
Calc.
Raw
195.11
159.75
31.72
22.00
67.67
82.33
0.00 294.50
 7  No Name #37000
Calc.
Raw
167.94
137.50
33.64
23.33
87.94
107.00
0.00 289.52
 8  No Name #37089
Calc.
Raw
199.08
163.00
37.50
26.01
47.40
57.67
0.00 283.98
 9  No Name #18418
Calc.
Raw
187.18
153.25
35.54
24.65
59.45
72.33
0.00 282.17
 10  No Name #30604
Calc.
Raw
187.18
153.25
33.16
23.00
59.45
72.33
0.00 279.79
 11  No Name #32785
Calc.
Raw
171.60
140.50
37.96
26.33
67.12
81.67
0.00 276.68
 12  No Name #5465
Calc.
Raw
156.64
128.25
45.17
31.33
71.50
87.00
0.00 273.31
 13  No Name #10378
Calc.
Raw
167.02
136.75
42.30
29.34
57.26
69.67
0.00 266.58
 14  No Name #1790
Calc.
Raw
171.30
140.25
41.34
28.67
51.78
63.00
0.00 264.42
 15  No Name #16375
Calc.
Raw
164.89
135.00
31.72
22.00
66.02
80.33
0.00 262.63
 16  No Name #20184
Calc.
Raw
169.77
139.00
32.22
22.35
59.45
72.33
0.00 261.44
 17  No Name #37164
Calc.
Raw
174.96
143.25
32.21
22.34
71.50
87.00
20.00 258.67
 17  No Name #11781
Calc.
Raw
172.82
141.50
19.22
13.33
66.02
80.33
0.00 258.06
 18  No Name #3253
Calc.
Raw
162.44
133.00
35.09
24.34
59.45
72.33
0.00 256.98
 19  No Name #13927
Calc.
Raw
159.69
130.75
20.18
14.00
68.22
83.00
0.00 248.09
 20  No Name #34380
Calc.
Raw
174.35
142.75
31.70
21.99
40.82
49.67
0.00 246.87
 20  No Name #5511
Calc.
Raw
162.44
133.00
22.12
15.34
61.64
75.00
0.00 246.20
 20  No Name #33346
Calc.
Raw
162.14
132.75
16.83
11.67
67.12
81.67
0.00 246.09
 21  No Name #1493
Calc.
Raw
168.55
138.00
35.08
24.33
40.82
49.67
0.00 244.45
 22  No Name #35317
Calc.
Raw
145.95
119.50
26.92
18.67
68.77
83.67
0.00 241.64
 22  No Name #5570
Calc.
Raw
160.61
131.50
20.17
13.99
60.55
73.67
0.00 241.33
 23  No Name #10680
Calc.
Raw
146.56
120.00
20.66
14.33
72.60
88.33
0.00 239.82
 24  No Name #25991
Calc.
Raw
150.84
123.50
26.44
18.34
59.45
72.33
0.00 236.73
 25  No Name #28057
Calc.
Raw
138.02
113.00
36.53
25.34
55.07
67.00
0.00 229.62
 25  No Name #232
Calc.
Raw
144.73
118.50
33.16
23.00
50.96
62.00
0.00 228.85
 25  No Name #34897
Calc.
Raw
160.31
131.25
22.12
15.34
46.30
56.33
0.00 228.73
 25  No Name #34295
Calc.
Raw
144.73
118.50
28.84
20.00
55.07
67.00
0.00 228.64
 26  No Name #18527
Calc.
Raw
150.23
123.00
23.08
16.01
55.07
67.00
0.00 228.38
 27  No Name #16142
Calc.
Raw
139.85
114.50
30.28
21.00
56.16
68.33
0.00 226.29
 27  No Name #25551
Calc.
Raw
145.04
118.75
28.34
19.66
52.87
64.33
0.00 226.25
 28  No Name #1715
Calc.
Raw
151.15
123.75
12.96
8.99
60.55
73.67
0.00 224.66
 28  No Name #28004
Calc.
Raw
146.56
120.00
35.57
24.67
51.78
63.00
10.00 223.91
 28  No Name #35848
Calc.
Raw
146.87
120.25
28.34
19.66
48.49
59.00
0.00 223.70
 29  No Name #34083
Calc.
Raw
137.40
112.50
25.00
17.34
59.73
72.67
0.00 222.13
 30  No Name #36629
Calc.
Raw
142.29
116.50
13.45
9.33
63.84
77.67
0.00 219.58
 31  No Name #11901
Calc.
Raw
132.52
108.50
25.48
17.67
60.55
73.67
0.00 218.55
 32  No Name #26110
Calc.
Raw
154.20
126.25
13.45
9.33
49.58
60.33
0.00 217.23
 33  No Name #28695
Calc.
Raw
139.24
114.00
20.67
14.34
53.97
65.67
0.00 213.88
 34  No Name #32252
Calc.
Raw
136.18
111.50
20.67
14.34
57.26
69.67
5.00 209.11
 35  No Name #28837
Calc.
Raw
145.65
119.25
19.71
13.67
43.29
52.67
3.00 205.65
 36  No Name #13570
Calc.
Raw
128.85
105.50
9.60
6.66
59.45
72.33
0.00 197.90
 37  No Name #36640
Calc.
Raw
116.95
95.75
25.95
18.00
53.97
65.67
0.00 196.87
 38  No Name #36902
Calc.
Raw
129.47
106.00
21.63
15.00
43.29
52.67
0.00 194.39
 38  No Name #3193
Calc.
Raw
135.57
111.00
17.78
12.33
40.82
49.67
0.00 194.17
 38  No Name #35737
Calc.
Raw
116.34
95.25
20.18
14.00
57.26
69.67
0.00 193.78
 39  No Name #25718
Calc.
Raw
122.44
100.25
12.98
9.00
57.26
69.67
0.00 192.68
 40  No Name #3606
Calc.
Raw
131.30
107.50
19.22
13.33
38.63
47.00
0.00 189.15
 41  No Name #34546
Calc.
Raw
112.37
92.00
18.25
12.66
57.26
69.67
0.00 187.88
 41  No Name #2437
Calc.
Raw
118.47
97.00
14.89
10.33
53.97
65.67
0.00 187.33
 42  No Name #35658
Calc.
Raw
129.16
105.75
16.83
11.67
40.54
49.33
0.00 186.53
 43  No Name #497
Calc.
Raw
120.61
98.75
15.38
10.67
45.20
55.00
0.00 181.19
 44  No Name #2464
Calc.
Raw
104.43
85.50
16.83
11.67
57.26
69.67
0.00 178.52
 45  No Name #35883
Calc.
Raw
97.10
79.50
24.51
17.00
55.07
67.00
0.00 176.68
 46  No Name #33010
Calc.
Raw
115.11
94.25
15.35
10.65
41.92
51.00
3.00 169.38
 47  No Name #11548
Calc.
Raw
98.02
80.25
16.34
11.33
52.87
64.33
0.00 167.23
 47  No Name #177
Calc.
Raw
125.80
103.00
15.86
11.00
24.93
30.33
0.00 166.59
 48  No Name #820
Calc.
Raw
110.23
90.25
12.01
8.33
32.88
40.00
1.00 154.12
 49  No Name #33846
Calc.
Raw
91.91
75.25
9.11
6.32
49.58
60.33
0.00 150.60
 50  No Name #33747
Calc.
Raw
101.07
82.75
9.60
6.66
35.89
43.67
0.00 146.56
   No Name #36827
Calc.
Raw
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00