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 I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #5494
 Calc.
Raw		 200.00
148.25		 46.47
35.00		 74.70
82.67		 0.00 321.17
 2  No Name #35157
 Calc.
Raw		 162.90
120.75		 33.63
25.33		 100.00
110.67		 0.00 296.53
 2  No Name #32407
 Calc.
Raw		 192.92
143.00		 43.37
32.67		 65.06
72.00		 5.00 296.35
 3  No Name #30660
 Calc.
Raw		 185.50
137.50		 38.94
29.33		 69.87
77.33		 0.00 294.31
 4  No Name #33795
 Calc.
Raw		 198.65
147.25		 42.49
32.00		 48.19
53.33		 0.00 289.33
 5  No Name #1567
 Calc.
Raw		 181.79
134.75		 42.03
31.66		 67.47
74.67		 5.00 286.29
 6  No Name #19400
 Calc.
Raw		 194.27
144.00		 37.63
28.34		 53.01
58.67		 0.00 284.91
 7  No Name #26787
 Calc.
Raw		 196.96
146.00		 32.30
24.33		 54.22
60.00		 0.00 283.48
 7  No Name #603
 Calc.
Raw		 162.90
120.75		 34.52
26.00		 85.54
94.67		 0.00 282.96
 7  No Name #27796
 Calc.
Raw		 175.72
130.25		 35.85
27.00		 71.09
78.67		 0.00 282.66
 8  No Name #17773
 Calc.
Raw		 185.50
137.50		 35.85
27.00		 59.03
65.33		 0.00 280.38
 8  No Name #11459
 Calc.
Raw		 174.37
129.25		 37.17
28.00		 68.67
76.00		 0.00 280.21
 9  No Name #23089
 Calc.
Raw		 182.80
135.50		 39.83
30.00		 55.42
61.33		 0.00 278.05
 9  No Name #5279
 Calc.
Raw		 167.28
124.00		 36.30
27.34		 73.49
81.33		 0.00 277.07
 10  No Name #1886
 Calc.
Raw		 172.68
128.00		 31.86
24.00		 72.29
80.00		 0.00 276.83
 10  No Name #1887
 Calc.
Raw		 153.46
113.75		 38.05
28.66		 84.33
93.33		 0.00 275.84
 11  No Name #34805
 Calc.
Raw		 185.83
137.75		 50.00
37.66		 43.37
48.00		 5.00 274.20
 12  No Name #32403
 Calc.
Raw		 173.69
128.75		 41.16
31.00		 57.83
64.00		 0.00 272.68
 12  No Name #14988
 Calc.
Raw		 171.67
127.25		 37.17
28.00		 68.67
76.00		 5.00 272.51
 13  No Name #3249
 Calc.
Raw		 159.19
118.00		 43.81
33.00		 67.47
74.67		 0.00 270.47
 13  No Name #34897
 Calc.
Raw		 174.70
129.50		 38.50
29.00		 60.24
66.67		 3.00 270.44
 14  No Name #30471
 Calc.
Raw		 151.43
112.25		 34.07
25.66		 85.54
94.67		 2.00 269.04
 15  No Name #9692
 Calc.
Raw		 181.45
134.50		 41.16
31.00		 44.57
49.33		 0.00 267.18
 15  No Name #34691
 Calc.
Raw		 178.41
132.25		 46.91
35.33		 44.57
49.33		 3.00 266.89
 15  No Name #24442
 Calc.
Raw		 158.85
117.75		 35.41
26.67		 72.29
80.00		 0.00 266.55
 16  No Name #3384
 Calc.
Raw		 185.16
137.25		 36.29
27.33		 44.28
49.00		 0.00 265.73
 17  No Name #34669
 Calc.
Raw		 183.81
136.25		 34.52
26.00		 49.40
54.67		 3.00 264.73
 18  No Name #20364
 Calc.
Raw		 171.33
127.00		 28.77
21.67		 61.44
68.00		 2.00 259.54
 19  No Name #34114
 Calc.
Raw		 147.72
109.50		 32.75
24.67		 73.49
81.33		 0.00 253.96
 20  No Name #7238
 Calc.
Raw		 161.89
120.00		 34.96
26.33		 55.42
61.33		 0.00 252.27
 20  No Name #16799
 Calc.
Raw		 170.32
126.25		 40.71
30.66		 43.37
48.00		 3.00 251.40
 21  No Name #34573
 Calc.
Raw		 176.39
130.75		 34.96
26.33		 39.46
43.67		 0.00 250.81
 21  No Name #8582
 Calc.
Raw		 168.63
125.00		 37.17
28.00		 44.57
49.33		 0.00 250.37
 21  No Name #35570
 Calc.
Raw		 150.76
111.75		 31.86
24.00		 67.47
74.67		 0.00 250.09
 22  No Name #2271
 Calc.
Raw		 163.58
121.25		 32.75
24.67		 51.80
57.33		 0.00 248.13
 23  No Name #33485
 Calc.
Raw		 156.16
115.75		 34.08
25.67		 54.22
60.00		 0.00 244.46
 23  No Name #30484
 Calc.
Raw		 149.41
110.75		 28.77
21.67		 66.26
73.33		 0.00 244.44
 24  No Name #24942
 Calc.
Raw		 162.56
120.50		 38.50
29.00		 46.69
51.67		 5.00 242.75
 24  No Name #30542
 Calc.
Raw		 156.83
116.25		 36.30
27.34		 59.34
65.67		 10.00 242.47
 25  No Name #30643
 Calc.
Raw		 150.76
111.75		 34.08
25.67		 60.24
66.67		 5.00 240.08
 26  No Name #22575
 Calc.
Raw		 173.69
128.75		 30.97
23.33		 38.56
42.67		 6.00 237.22
 27  No Name #18527
 Calc.
Raw		 150.76
111.75		 25.66
19.33		 59.03
65.33		 5.00 230.45
 27  No Name #29891
 Calc.
Raw		 156.83
116.25		 28.33
21.34		 45.18
50.00		 0.00 230.34
 27  No Name #34422
 Calc.
Raw		 146.04
108.25		 30.97
23.33		 53.31
59.00		 0.00 230.32
 27  No Name #35458
 Calc.
Raw		 159.19
118.00		 29.21
22.00		 42.17
46.67		 1.00 229.57
 28  No Name #27122
 Calc.
Raw		 145.03
107.50		 31.43
23.67		 49.40
54.67		 0.00 225.86
 28  No Name #20005
 Calc.
Raw		 137.61
102.00		 27.44
20.67		 60.24
66.67		 0.00 225.29
 28  No Name #32346
 Calc.
Raw		 160.54
119.00		 28.77
21.67		 38.56
42.67		 3.00 224.87
 29  No Name #35765
 Calc.
Raw		 149.07
110.50		 34.52
26.00		 40.66
45.00		 0.00 224.25
 29  No Name #34220
 Calc.
Raw		 139.97
103.75		 30.54
23.00		 53.01
58.67		 0.00 223.52
 30  No Name #16862
 Calc.
Raw		 149.07
110.50		 31.43
23.67		 42.17
46.67		 0.00 222.67
 30  No Name #32117
 Calc.
Raw		 144.69
107.25		 27.88
21.00		 53.01
58.67		 3.00 222.58
 31  No Name #35337
 Calc.
Raw		 154.47
114.50		 26.55
20.00		 61.44
68.00		 25.00 217.46
 31  No Name #3390
 Calc.
Raw		 143.68
106.50		 30.97
23.33		 42.17
46.67		 0.00 216.82
 32  No Name #35857
 Calc.
Raw		 149.07
110.50		 32.29
24.32		 39.76
44.00		 6.00 215.12
 33  No Name #27409
 Calc.
Raw		 144.35
107.00		 30.11
22.68		 40.96
45.33		 2.00 213.42
 34  No Name #32772
 Calc.
Raw		 141.99
105.25		 30.97
23.33		 42.17
46.67		 5.00 210.13
 35  No Name #33381
 Calc.
Raw		 141.99
105.25		 27.88
21.00		 34.94
38.67		 0.00 204.81
 36  No Name #35747
 Calc.
Raw		 135.24
100.25		 26.55
20.00		 49.40
54.67		 10.00 201.19
 37  No Name #34980
 Calc.
Raw		 132.88
98.50		 29.21
22.00		 41.27
45.67		 6.00 197.36