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 II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #28541
 Calc.
Raw		 200.00
155.75		 47.26
28.99		 80.57
77.75		 5.00 322.83
 2  No Name #22311
 Calc.
Raw		 192.94
150.25		 48.91
30.00		 77.20
74.50		 0.00 319.05
 3  No Name #25808
 Calc.
Raw		 170.14
132.50		 41.85
25.67		 100.00
96.50		 0.00 311.99
 4  No Name #1573
 Calc.
Raw		 197.43
153.75		 47.82
29.33		 58.03
56.00		 0.00 303.28
 5  No Name #1839
 Calc.
Raw		 189.73
147.75		 36.96
22.67		 73.32
70.75		 0.00 300.01
 6  No Name #2477
 Calc.
Raw		 200.00
155.75		 48.37
29.67		 49.62
47.88		 0.00 297.99
 7  No Name #31230
 Calc.
Raw		 189.73
147.75		 42.39
26.00		 67.62
65.25		 5.00 294.74
 8  No Name #2269
 Calc.
Raw		 195.18
152.00		 46.19
28.33		 50.65
48.88		 0.00 292.02
 9  No Name #18929
 Calc.
Raw		 158.59
123.50		 42.92
26.33		 80.83
78.00		 0.00 282.34
 9  No Name #10680
 Calc.
Raw		 169.50
132.00		 50.00
30.67		 62.44
60.25		 0.00 281.94
 10  No Name #12320
 Calc.
Raw		 169.50
132.00		 36.94
22.66		 78.76
76.00		 5.00 280.20
 11  No Name #30604
 Calc.
Raw		 169.82
132.25		 42.39
26.00		 70.73
68.25		 5.00 277.94
 12  No Name #1722
 Calc.
Raw		 146.07
113.75		 36.40
22.33		 97.41
94.00		 5.00 274.88
 13  No Name #18931
 Calc.
Raw		 166.29
129.50		 42.92
26.33		 63.21
61.00		 0.00 272.42
 13  No Name #3137
 Calc.
Raw		 166.61
129.75		 40.76
25.00		 64.64
62.38		 0.00 272.01
 14  No Name #20022
 Calc.
Raw		 178.49
139.00		 42.39
26.00		 49.22
47.50		 0.00 270.10
 14  No Name #31433
 Calc.
Raw		 181.38
141.25		 43.48
26.67		 49.48
47.75		 5.00 269.34
 15  No Name #36206
 Calc.
Raw		 170.47
132.75		 41.29
25.33		 55.70
53.75		 0.00 267.46
 16  No Name #35004
 Calc.
Raw		 171.11
133.25		 37.50
23.00		 57.13
55.13		 0.00 265.74
 17  No Name #32095
 Calc.
Raw		 186.20
145.00		 45.11
27.67		 32.38
31.25		 0.00 263.69
 17  No Name #2119
 Calc.
Raw		 183.31
142.75		 38.07
23.35		 41.71
40.25		 0.00 263.09
 18  No Name #16375
 Calc.
Raw		 172.39
134.25		 41.85
25.67		 53.11
51.25		 5.00 262.35
 18  No Name #3505
 Calc.
Raw		 188.12
146.50		 43.46
26.66		 29.93
28.88		 0.00 261.51
 19  No Name #34249
 Calc.
Raw		 178.81
139.25		 34.79
21.34		 47.67
46.00		 0.00 261.27
 20  No Name #7934
 Calc.
Raw		 183.63
143.00		 47.82
29.33		 33.68
32.50		 5.00 260.13
 21  No Name #9385
 Calc.
Raw		 161.48
125.75		 40.76
25.00		 56.22
54.25		 0.00 258.46
 21  No Name #14724
 Calc.
Raw		 165.33
128.75		 41.29
25.33		 51.81
50.00		 0.00 258.43
 22  No Name #10102
 Calc.
Raw		 179.78
140.00		 48.37
29.67		 29.27
28.25		 0.00 257.42
 22  No Name #32743
 Calc.
Raw		 152.17
118.50		 33.14
20.33		 71.24
68.75		 0.00 256.55
 23  No Name #34080
 Calc.
Raw		 156.02
121.50		 42.92
26.33		 62.44
60.25		 5.00 256.38
 24  No Name #34649
 Calc.
Raw		 182.66
142.25		 45.11
27.67		 35.49
34.25		 8.00 255.26
 25  No Name #13158
 Calc.
Raw		 162.12
126.25		 44.55
27.33		 52.07
50.25		 5.00 253.74
 26  No Name #2785
 Calc.
Raw		 192.30
149.75		 35.87
22.00		 29.53
28.50		 5.00 252.70
 26  No Name #35737
 Calc.
Raw		 149.92
116.75		 45.65
28.00		 56.48
54.50		 0.00 252.05
 27  No Name #11901
 Calc.
Raw		 179.45
139.75		 38.03
23.33		 31.48
30.38		 0.00 248.96
 28  No Name #1790
 Calc.
Raw		 153.45
119.50		 41.29
25.33		 57.51
55.50		 5.00 247.25
 29  No Name #35750
 Calc.
Raw		 163.40
127.25		 36.96
22.67		 49.74
48.00		 5.00 245.10
 30  No Name #19568
 Calc.
Raw		 170.14
132.50		 45.11
27.67		 32.90
31.75		 5.00 243.15
 31  No Name #10236
 Calc.
Raw		 151.85
118.25		 38.03
23.33		 56.22
54.25		 5.00 241.10
 31  No Name #27471
 Calc.
Raw		 167.90
130.75		 45.11
27.67		 32.90
31.75		 5.00 240.91
 32  No Name #27797
 Calc.
Raw		 168.86
131.50		 38.59
23.67		 36.53
35.25		 5.00 238.98
 33  No Name #5557
 Calc.
Raw		 139.65
108.75		 37.48
22.99		 58.29
56.25		 0.00 235.42
 33  No Name #35487
 Calc.
Raw		 158.91
123.75		 40.22
24.67		 41.07
39.63		 5.00 235.20
 33  No Name #32117
 Calc.
Raw		 153.13
119.25		 44.02
27.00		 42.49
41.00		 5.00 234.64
 34  No Name #32346
 Calc.
Raw		 148.96
116.00		 38.05
23.34		 47.41
45.75		 0.00 234.42
 34  No Name #8653
 Calc.
Raw		 163.08
127.00		 33.68
20.66		 44.69
43.13		 8.00 233.45
 35  No Name #21290
 Calc.
Raw		 149.28
116.25		 40.22
24.67		 47.80
46.13		 5.00 232.30
 36  No Name #13133
 Calc.
Raw		 153.77
119.75		 33.14
20.33		 48.45
46.75		 5.00 230.36
 37  No Name #34082
 Calc.
Raw		 146.71
114.25		 36.40
22.33		 49.74
48.00		 5.00 227.85
 37  No Name #8401
 Calc.
Raw		 150.88
117.50		 34.24
21.00		 42.23
40.75		 0.00 227.35
 38  No Name #34759
 Calc.
Raw		 160.19
124.75		 36.40
22.33		 33.68
32.50		 5.00 225.27
 39  No Name #16610
 Calc.
Raw		 127.13
99.00		 32.61
20.00		 66.06
63.75		 5.00 220.80
 39  No Name #35511
 Calc.
Raw		 134.19
104.50		 32.07
19.67		 53.63
51.75		 0.00 219.89
 40  No Name #3422
 Calc.
Raw		 151.85
118.25		 39.13
24.00		 41.19
39.75		 20.00 212.17
 40  No Name #17066
 Calc.
Raw		 138.04
107.50		 31.53
19.34		 42.36
40.88		 0.00 211.93
 41  No Name #17855
 Calc.
Raw		 148.64
115.75		 34.24
21.00		 41.97
40.50		 15.00 209.85
 42  No Name #18527
 Calc.
Raw		 137.40
107.00		 37.48
22.99		 33.94
32.75		 0.00 208.82
 43  No Name #31338
 Calc.
Raw		 129.37
100.75		 34.24
21.00		 43.01
41.50		 0.00 206.62
 44  No Name #33946
 Calc.
Raw		 141.57
110.25		 31.51
19.33		 32.38
31.25		 0.00 205.46
 45  No Name #35337
 Calc.
Raw		 139.97
109.00		 30.97
19.00		 46.63
45.00		 15.00 202.57
 46  No Name #33010
 Calc.
Raw		 124.88
97.25		 35.33
21.67		 33.94
32.75		 5.00 189.15
 47  No Name #5482
 Calc.
Raw		 135.15
105.25		 32.07
19.67		 18.65
18.00		 5.00 180.87