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 2005 May 21st
 Problem 3 Ancient Egypt Division I
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #12320
Calc.
Raw
197.97
146.63
33.48
26.34
92.96
105.67
0.00 324.41
 2  No Name #15677
Calc.
Raw
180.76
133.88
34.32
27.00
100.00
113.67
0.00 315.08
 3  No Name #28156
Calc.
Raw
185.84
137.64
50.00
39.34
76.54
87.00
0.00 312.38
 4  No Name #33665
Calc.
Raw
190.05
140.76
50.00
39.34
63.63
72.33
0.00 303.68
 5  No Name #30963
Calc.
Raw
194.44
144.01
28.81
22.67
78.89
89.67
0.00 302.14
 6  No Name #31960
Calc.
Raw
200.00
148.13
41.93
32.99
57.77
65.67
0.00 299.70
 7  No Name #9971
Calc.
Raw
183.97
136.26
39.40
31.00
69.50
79.00
0.00 292.87
 8  No Name #4850
Calc.
Raw
175.20
129.76
32.61
25.66
82.41
93.67
0.00 290.22
 8  No Name #12282
Calc.
Raw
187.35
138.76
28.39
22.34
78.89
89.67
5.00 289.63
 9  No Name #28344
Calc.
Raw
190.39
141.01
32.19
25.33
64.81
73.67
0.00 287.39
 10  No Name #11416
Calc.
Raw
190.89
141.38
30.08
23.67
64.81
73.67
0.00 285.78
 11  No Name #11374
Calc.
Raw
173.50
128.50
26.70
21.01
83.58
95.00
0.00 283.78
 12  No Name #2746
Calc.
Raw
174.68
129.38
28.37
22.32
77.71
88.33
0.00 280.76
 13  No Name #28440
Calc.
Raw
192.74
142.75
25.42
20.00
85.92
97.67
25.00 279.08
 14  No Name #9883
Calc.
Raw
184.97
137.00
24.14
18.99
68.33
77.67
0.00 277.44
 14  No Name #30361
Calc.
Raw
171.47
127.00
28.80
22.66
76.54
87.00
0.00 276.81
 15  No Name #4650
Calc.
Raw
180.42
133.63
24.58
19.34
68.33
77.67
0.00 273.33
 16  No Name #28372
Calc.
Raw
172.82
128.00
30.07
23.66
67.15
76.33
0.00 270.04
 16  No Name #28581
Calc.
Raw
167.76
124.25
31.35
24.67
70.67
80.33
0.00 269.78
 17  No Name #31733
Calc.
Raw
192.06
142.25
33.05
26.00
48.39
55.00
5.00 268.50
 18  No Name #15128
Calc.
Raw
165.57
122.63
28.81
22.67
67.15
76.33
0.00 261.53
 19  No Name #1748
Calc.
Raw
165.57
122.63
26.69
21.00
63.63
72.33
0.00 255.89
 19  No Name #5126
Calc.
Raw
170.30
126.13
23.73
18.67
65.98
75.00
5.00 255.01
 20  No Name #30405
Calc.
Raw
162.36
120.25
28.81
22.67
61.29
69.67
0.00 252.46
 21  No Name #12534
Calc.
Raw
178.07
131.89
20.32
15.99
56.59
64.33
5.00 249.98
 21  No Name #34320
Calc.
Raw
165.91
122.88
20.34
16.00
68.33
77.67
5.00 249.58
 21  No Name #3390
Calc.
Raw
166.08
123.01
26.27
20.67
57.77
65.67
1.00 249.12
 22  No Name #15322
Calc.
Raw
172.50
127.76
19.48
15.33
61.29
69.67
5.00 248.27
 23  No Name #10001
Calc.
Raw
159.67
118.26
13.99
11.01
69.50
79.00
0.00 243.16
 24  No Name #20797
Calc.
Raw
147.17
109.00
25.41
19.99
64.81
73.67
0.00 237.39
 25  No Name #1545
Calc.
Raw
153.59
113.76
17.36
13.66
63.63
72.33
0.00 234.58
 25  No Name #2342
Calc.
Raw
158.33
117.27
21.17
16.66
54.25
61.67
0.00 233.75
 26  No Name #6067
Calc.
Raw
146.84
108.76
22.46
17.67
62.46
71.00
0.00 231.76
 27  No Name #17516
Calc.
Raw
145.66
107.88
27.11
21.33
57.77
65.67
0.00 230.54
 28  No Name #35008
Calc.
Raw
162.69
120.50
9.30
7.32
62.46
71.00
5.00 229.45
 29  No Name #33087
Calc.
Raw
133.67
99.00
23.72
18.66
74.19
84.33
5.00 226.58
 30  No Name #34980
Calc.
Raw
143.12
106.00
24.16
19.01
54.25
61.67
0.00 221.53
 31  No Name #34897
Calc.
Raw
145.49
107.76
11.87
9.34
64.81
73.67
5.00 217.17
 32  No Name #232
Calc.
Raw
146.33
108.38
20.77
16.34
65.98
75.00
20.00 213.08
 33  No Name #532
Calc.
Raw
158.32
117.26
34.75
27.34
55.42
63.00
40.00 208.49
 34  No Name #26714
Calc.
Raw
140.93
104.38
13.98
11.00
76.54
87.00
25.00 206.45
 35  No Name #11117
Calc.
Raw
135.87
100.63
13.13
10.33
61.29
69.67
5.00 205.29
 36  No Name #9358
Calc.
Raw
128.44
95.13
12.28
9.66
68.33
77.67
5.00 204.05
 36  No Name #34302
Calc.
Raw
132.32
98.00
32.61
25.66
63.63
72.33
25.00 203.56
 37  No Name #31535
Calc.
Raw
150.54
111.50
9.74
7.66
50.73
57.67
30.00 181.01
 37  No Name #35337
Calc.
Raw
101.60
75.25
12.29
9.67
66.86
76.00
0.00 180.75