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 2006 May 24th
 Problem 5 The Jungle Bloke Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #30883
 Calc.
Raw		 193.64
137.00		 49.60
42.66		 88.24
120.00		 0.00 331.48
 2  No Name #31225
 Calc.
Raw		 187.63
132.75		 41.08
35.33		 100.00
136.00		 0.00 328.71
 3  No Name #34519
 Calc.
Raw		 199.65
141.25		 44.19
38.00		 84.32
114.67		 5.00 323.16
 4  No Name #31283
 Calc.
Raw		 187.63
132.75		 45.35
39.00		 92.15
125.33		 5.00 320.13
 5  No Name #4637
 Calc.
Raw		 191.17
135.25		 41.08
35.33		 85.29
116.00		 0.00 317.54
 6  No Name #35519
 Calc.
Raw		 177.74
125.75		 35.66
30.67		 100.00
136.00		 0.00 313.40
 7  No Name #12306
 Calc.
Raw		 187.28
132.50		 46.13
39.67		 81.38
110.67		 5.00 309.79
 8  No Name #3137
 Calc.
Raw		 182.33
129.00		 45.35
39.00		 73.53
100.00		 0.00 301.21
 8  No Name #29034
 Calc.
Raw		 200.00
141.50		 47.29
40.67		 58.82
80.00		 5.00 301.11
 8  No Name #7975
 Calc.
Raw		 198.94
140.75		 42.24
36.33		 59.80
81.33		 0.00 300.98
 9  No Name #16284
 Calc.
Raw		 177.39
125.50		 50.00
43.00		 71.57
97.33		 0.00 298.96
 9  No Name #35756
 Calc.
Raw		 193.99
137.25		 46.12
39.66		 57.85
78.67		 0.00 297.96
 10  No Name #34293
 Calc.
Raw		 180.92
128.00		 38.76
33.33		 77.45
105.33		 0.00 297.13
 10  No Name #15504
 Calc.
Raw		 180.57
127.75		 47.28
40.66		 68.63
93.33		 0.00 296.48
 11  No Name #27297
 Calc.
Raw		 170.32
120.50		 49.62
42.67		 75.49
102.67		 0.00 295.43
 12  No Name #32072
 Calc.
Raw		 170.32
120.50		 48.45
41.67		 72.55
98.67		 0.00 291.32
 13  No Name #15417
 Calc.
Raw		 188.69
133.50		 31.40
27.00		 68.38
93.00		 0.00 288.47
 14  No Name #3703
 Calc.
Raw		 185.87
131.50		 38.76
33.33		 71.57
97.33		 10.00 286.20
 14  No Name #28508
 Calc.
Raw		 176.33
124.75		 33.34
28.67		 76.47
104.00		 0.00 286.14
 15  No Name #34281
 Calc.
Raw		 180.92
128.00		 46.13
39.67		 54.90
74.67		 5.00 276.95
 16  No Name #1896
 Calc.
Raw		 171.38
121.25		 39.15
33.67		 65.68
89.33		 5.00 271.21
 17  No Name #30451
 Calc.
Raw		 176.68
125.00		 36.43
31.33		 53.92
73.33		 0.00 267.03
 17  No Name #36011
 Calc.
Raw		 186.93
132.25		 32.56
28.00		 62.26
84.67		 15.00 266.75
 18  No Name #19633
 Calc.
Raw		 168.90
119.50		 43.41
37.33		 67.65
92.00		 15.00 264.96
 19  No Name #381
 Calc.
Raw		 168.20
119.00		 36.43
31.33		 68.63
93.33		 10.00 263.26
 20  No Name #30832
 Calc.
Raw		 169.26
119.75		 37.99
32.67		 63.73
86.67		 10.00 260.98
 21  No Name #14231
 Calc.
Raw		 163.25
115.50		 22.48
19.33		 77.45
105.33		 5.00 258.18
 21  No Name #3133
 Calc.
Raw		 172.79
122.25		 27.13
23.33		 57.85
78.67		 0.00 257.77
 21  No Name #22172
 Calc.
Raw		 161.13
114.00		 31.01
26.67		 70.59
96.00		 5.00 257.73
 21  No Name #35355
 Calc.
Raw		 164.31
116.25		 46.90
40.33		 50.98
69.33		 5.00 257.19
 22  No Name #35492
 Calc.
Raw		 160.78
113.75		 21.70
18.66		 64.71
88.00		 0.00 247.19
 23  No Name #28781
 Calc.
Raw		 176.68
125.00		 30.60
26.32		 52.94
72.00		 20.00 240.22
 23  No Name #8888
 Calc.
Raw		 171.73
121.50		 22.09
19.00		 50.98
69.33		 5.00 239.80
 24  No Name #4553
 Calc.
Raw		 161.84
114.50		 27.91
24.00		 49.02
66.67		 0.00 238.77
 25  No Name #21591
 Calc.
Raw		 149.82
106.00		 32.56
28.00		 58.82
80.00		 5.00 236.20
 26  No Name #32435
 Calc.
Raw		 155.48
110.00		 31.40
27.00		 48.04
65.33		 1.00 233.92
 26  No Name #18242
 Calc.
Raw		 142.76
101.00		 39.14
33.66		 66.67
90.67		 15.00 233.57
 27  No Name #21290
 Calc.
Raw		 150.53
106.50		 30.23
26.00		 47.06
64.00		 0.00 227.82
 27  No Name #5994
 Calc.
Raw		 144.88
102.50		 30.23
26.00		 56.86
77.33		 5.00 226.97
 28  No Name #36204
 Calc.
Raw		 156.89
111.00		 12.79
11.00		 52.94
72.00		 0.00 222.62
 29  No Name #11105
 Calc.
Raw		 151.94
107.50		 27.52
23.67		 50.98
69.33		 15.00 215.44
 30  No Name #8149
 Calc.
Raw		 140.64
99.50		 25.97
22.33		 45.10
61.33		 5.00 206.71
 31  No Name #32144
 Calc.
Raw		 147.35
104.25		 19.38
16.67		 44.61
60.67		 10.00 201.34
 31  No Name #31043
 Calc.
Raw		 143.82
101.75		 22.87
19.67		 39.21
53.33		 5.00 200.90
 32  No Name #24304
 Calc.
Raw		 144.52
102.25		 22.09
19.00		 44.12
60.00		 15.00 195.73
 32  No Name #31161
 Calc.
Raw		 126.86
89.75		 19.77
17.00		 58.82
80.00		 10.00 195.45
 32  No Name #34259
 Calc.
Raw		 131.80
93.25		 20.55
17.67		 48.04
65.33		 5.00 195.39
 33  No Name #33345
 Calc.
Raw		 133.22
94.25		 17.44
15.00		 42.15
57.33		 5.00 187.81
 34  No Name #26319
 Calc.
Raw		 115.19
81.50		 19.38
16.67		 43.14
58.67		 20.00 157.71
   No Name #32863
 Calc.
Raw		 0.00
0.00		 0.00
0.00		 0.00
0.00		 0.00 0.00