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 2 DinoStories Division II
 Rank   Member    Long
Term
 Style  Spont  Penalty  Total
 1  No Name #34754
Calc.
Raw
200.00
174.50
43.76
32.67
52.90
54.75
0.00 296.66
 2  No Name #30949
Calc.
Raw
189.11
165.00
38.84
29.00
50.97
52.75
0.00 278.92
 3  No Name #35548
Calc.
Raw
142.69
124.50
26.35
19.67
100.00
103.50
0.00 269.04
 4  No Name #36480
Calc.
Raw
193.12
168.50
50.00
37.33
22.71
23.50
0.00 265.83
 4  No Name #2344
Calc.
Raw
175.36
153.00
39.28
29.33
50.97
52.75
0.00 265.61
 5  No Name #31230
Calc.
Raw
173.07
151.00
33.49
25.00
51.93
53.75
0.00 258.49
 6  No Name #322
Calc.
Raw
165.62
144.50
38.84
29.00
50.00
51.75
0.00 254.46
 7  No Name #2477
Calc.
Raw
178.80
156.00
41.96
31.33
21.74
22.50
1.00 241.50
 7  No Name #37853
Calc.
Raw
133.52
116.50
36.62
27.34
70.53
73.00
0.00 240.67
 8  No Name #30595
Calc.
Raw
147.85
129.00
36.16
27.00
52.17
54.00
0.00 236.18
 9  No Name #14989
Calc.
Raw
146.70
128.00
28.57
21.33
55.56
57.50
0.00 230.83
 9  No Name #33344
Calc.
Raw
132.95
116.00
26.79
20.00
70.77
73.25
0.00 230.51
 10  No Name #14032
Calc.
Raw
154.73
135.00
24.11
18.00
50.72
52.50
0.00 229.56
 11  No Name #13372
Calc.
Raw
139.26
121.50
34.82
26.00
51.93
53.75
0.00 226.01
 12  No Name #26110
Calc.
Raw
129.51
113.00
33.04
24.67
62.32
64.50
0.00 224.87
 13  No Name #35750
Calc.
Raw
127.22
111.00
26.79
20.00
69.57
72.00
0.00 223.58
 14  No Name #36120
Calc.
Raw
143.84
125.50
29.02
21.67
48.31
50.00
0.00 221.17
 15  No Name #1009
Calc.
Raw
137.54
120.00
30.36
22.67
51.93
53.75
0.00 219.83
 16  No Name #29596
Calc.
Raw
123.78
108.00
41.52
31.00
50.48
52.25
0.00 215.78
 17  No Name #28072
Calc.
Raw
147.85
129.00
24.11
18.00
41.55
43.00
0.00 213.51
 18  No Name #32284
Calc.
Raw
154.15
134.50
35.27
26.33
21.74
22.50
0.00 211.16
 19  No Name #5482
Calc.
Raw
110.60
96.50
25.01
18.67
64.73
67.00
0.00 200.34
 20  No Name #11905
Calc.
Raw
120.34
105.00
23.67
17.67
51.45
53.25
0.00 195.46
 20  No Name #6538
Calc.
Raw
146.13
127.50
29.02
21.67
20.29
21.00
0.00 195.44
 21  No Name #28212
Calc.
Raw
132.95
116.00
34.38
25.67
25.36
26.25
0.00 192.69
 21  No Name #28547
Calc.
Raw
139.26
121.50
30.81
23.00
22.46
23.25
0.00 192.53
 22  No Name #10414
Calc.
Raw
142.69
124.50
23.67
17.67
22.95
23.75
0.00 189.31
 23  No Name #7069
Calc.
Raw
114.61
100.00
23.67
17.67
49.52
51.25
0.00 187.80
 24  No Name #34601
Calc.
Raw
148.42
129.50
20.09
15.00
17.39
18.00
0.00 185.90
 24  No Name #4391
Calc.
Raw
134.67
117.50
29.47
22.00
21.74
22.50
0.00 185.88
 24  No Name #33956
Calc.
Raw
140.40
122.50
26.79
20.00
18.12
18.75
0.00 185.31
 25  No Name #10680
Calc.
Raw
151.86
132.50
32.59
24.33
0.00
0.00
0.00 184.45
 26  No Name #21303
Calc.
Raw
134.10
117.00
29.02
21.67
19.32
20.00
0.00 182.44
 26  No Name #28057
Calc.
Raw
130.66
114.00
31.25
23.33
19.57
20.25
0.00 181.48
 27  No Name #33010
Calc.
Raw
108.31
94.50
19.19
14.33
53.14
55.00
0.00 180.64
 27  No Name #10102
Calc.
Raw
126.65
110.50
31.70
23.67
21.74
22.50
0.00 180.09
 28  No Name #33099
Calc.
Raw
135.24
118.00
25.45
19.00
17.39
18.00
0.00 178.08
 28  No Name #15417
Calc.
Raw
134.67
117.50
24.11
18.00
19.08
19.75
0.00 177.86
 28  No Name #35380
Calc.
Raw
132.38
115.50
28.57
21.33
16.18
16.75
0.00 177.13
 29  No Name #17182
Calc.
Raw
142.12
124.00
19.19
14.33
15.46
16.00
0.00 176.77
 30  No Name #32462
Calc.
Raw
144.99
126.50
29.02
21.67
1.69
1.75
0.00 175.70
 31  No Name #11901
Calc.
Raw
128.37
112.00
25.45
19.00
20.05
20.75
0.00 173.87
 32  No Name #36216
Calc.
Raw
123.78
108.00
24.11
18.00
21.98
22.75
0.00 169.87
 33  No Name #15407
Calc.
Raw
104.30
91.00
9.82
7.33
51.69
53.50
0.00 165.81
 34  No Name #16142
Calc.
Raw
123.78
108.00
20.09
15.00
20.53
21.25
0.00 164.40
 35  No Name #36980
Calc.
Raw
108.31
94.50
25.01
18.67
20.77
21.50
0.00 154.09
 36  No Name #3422
Calc.
Raw
71.63
62.50
20.53
15.33
60.87
63.00
0.00 153.03
 36  No Name #27133
Calc.
Raw
113.47
99.00
21.87
16.33
16.91
17.50
0.00 152.25
 37  No Name #33292
Calc.
Raw
121.49
106.00
22.77
17.00
7.49
7.75
0.00 151.75
 38  No Name #36225
Calc.
Raw
103.15
90.00
24.55
18.33
22.46
23.25
0.00 150.16
 39  No Name #37848
Calc.
Raw
73.93
64.50
23.21
17.33
50.24
52.00
0.00 147.38
 40  No Name #37369
Calc.
Raw
104.30
91.00
18.31
13.67
21.26
22.00
0.00 143.87
 41  No Name #36148
Calc.
Raw
97.42
85.00
28.57
21.33
21.50
22.25
10.00 137.49
 42  No Name #36629
Calc.
Raw
68.19
59.50
14.29
10.67
51.45
53.25
0.00 133.93
 43  No Name #34298
Calc.
Raw
92.26
80.50
19.64
14.66
19.81
20.50
0.00 131.71
 44  No Name #19877
Calc.
Raw
93.98
82.00
15.18
11.33
16.91
17.50
0.00 126.07
 45  No Name #36617
Calc.
Raw
79.66
69.50
15.63
11.67
17.87
18.50
0.00 113.16
 46  No Name #1722
Calc.
Raw
68.77
60.00
22.33
16.67
21.50
22.25
2.00 110.60
 47  No Name #18919
Calc.
Raw
73.35
64.00
16.51
12.33
22.46
23.25
5.00 107.32