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 2007 May 23rd
 Problem 1 Tag 'em Division I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #20906
 Calc.
Raw		 189.73
153.67		 40.51
37.00		 84.08
70.00		 0.00 314.32
 2  No Name #1178
 Calc.
Raw		 174.49
141.33		 39.40
35.99		 96.70
80.50		 0.00 310.59
 3  No Name #36233
 Calc.
Raw		 200.00
161.99		 45.98
42.00		 56.76
47.25		 0.00 302.74
 3  No Name #33557
 Calc.
Raw		 198.38
160.68		 50.00
45.67		 54.05
45.00		 0.00 302.43
 4  No Name #24450
 Calc.
Raw		 175.31
141.99		 31.75
29.00		 94.59
78.75		 0.00 301.65
 4  No Name #26787
 Calc.
Raw		 193.42
156.66		 42.34
38.67		 65.17
54.25		 0.00 300.93
 5  No Name #28072
 Calc.
Raw		 155.17
125.68		 35.41
32.34		 99.70
83.00		 0.00 290.28
 5  No Name #36671
 Calc.
Raw		 179.46
145.35		 34.67
31.67		 75.68
63.00		 0.00 289.81
 6  No Name #22293
 Calc.
Raw		 166.80
135.10		 43.06
39.33		 67.27
56.00		 0.00 277.13
 7  No Name #35162
 Calc.
Raw		 166.47
134.83		 35.03
32.00		 74.47
62.00		 0.00 275.97
 7  No Name #19754
 Calc.
Raw		 169.54
137.32		 32.84
30.00		 72.97
60.75		 0.00 275.35
 8  No Name #34905
 Calc.
Raw		 160.50
130.00		 35.77
32.67		 78.08
65.00		 0.00 274.35
 9  No Name #32181
 Calc.
Raw		 168.33
136.34		 40.14
36.66		 63.66
53.00		 1.00 271.13
 10  No Name #34320
 Calc.
Raw		 159.26
128.99		 33.95
31.01		 74.17
61.75		 0.00 267.38
 11  No Name #35277
 Calc.
Raw		 141.55
114.65		 33.21
30.33		 89.19
74.25		 0.00 263.95
 12  No Name #35244
 Calc.
Raw		 176.95
143.32		 35.76
32.66		 49.55
41.25		 0.00 262.26
 12  No Name #35896
 Calc.
Raw		 158.03
128.00		 29.20
26.67		 74.47
62.00		 0.00 261.70
 13  No Name #36596
 Calc.
Raw		 175.74
142.34		 25.56
23.35		 59.76
49.75		 0.00 261.06
 13  No Name #32957
 Calc.
Raw		 172.29
139.55		 37.95
34.66		 50.15
41.75		 0.00 260.39
 14  No Name #5128
 Calc.
Raw		 133.34
108.00		 25.93
23.68		 100.00
83.25		 0.00 259.27
 14  No Name #32121
 Calc.
Raw		 172.64
139.83		 32.84
30.00		 53.75
44.75		 0.00 259.23
 15  No Name #29007
 Calc.
Raw		 157.64
127.68		 40.88
37.34		 58.86
49.00		 0.00 257.38
 16  No Name #15003
 Calc.
Raw		 169.75
137.49		 33.94
31.00		 50.45
42.00		 0.00 254.14
 17  No Name #36543
 Calc.
Raw		 156.80
127.00		 24.47
22.35		 84.38
70.25		 20.00 245.65
 18  No Name #35975
 Calc.
Raw		 174.49
141.33		 33.22
30.34		 36.34
30.25		 0.00 244.05
 19  No Name #35035
 Calc.
Raw		 145.28
117.67		 30.65
28.00		 65.17
54.25		 0.00 241.10
 20  No Name #5637
 Calc.
Raw		 146.91
118.99		 30.28
27.66		 62.46
52.00		 0.00 239.65
 21  No Name #31535
 Calc.
Raw		 134.16
108.66		 33.58
30.67		 63.66
53.00		 0.00 231.40
 21  No Name #35727
 Calc.
Raw		 172.43
139.66		 30.67
28.01		 27.63
23.00		 0.00 230.73
 22  No Name #37155
 Calc.
Raw		 176.76
143.17		 42.71
39.01		 13.51
11.25		 4.00 228.98
 23  No Name #34189
 Calc.
Raw		 169.13
136.99		 35.41
32.34		 22.82
19.00		 0.00 227.36
 24  No Name #36048
 Calc.
Raw		 153.50
124.33		 15.69
14.33		 56.16
46.75		 0.00 225.35
 24  No Name #36971
 Calc.
Raw		 111.53
90.33		 33.95
31.01		 86.49
72.00		 7.00 224.97
 25  No Name #19400
 Calc.
Raw		 151.03
122.33		 36.49
33.33		 35.74
29.75		 0.00 223.26
 26  No Name #33044
 Calc.
Raw		 121.81
98.66		 28.10
25.67		 70.27
58.50		 0.00 220.18
 27  No Name #36017
 Calc.
Raw		 117.70
95.33		 31.03
28.34		 67.27
56.00		 2.00 214.00
 28  No Name #26181
 Calc.
Raw		 155.97
126.33		 36.12
32.99		 18.62
15.50		 0.00 210.71
 29  No Name #2138
 Calc.
Raw		 160.91
130.33		 36.13
33.00		 12.61
10.50		 0.00 209.65
 30  No Name #36864
 Calc.
Raw		 157.48
127.55		 27.74
25.34		 22.52
18.75		 0.00 207.74
 31  No Name #30200
 Calc.
Raw		 147.33
119.33		 43.06
39.33		 16.22
13.50		 0.00 206.61
 32  No Name #34284
 Calc.
Raw		 162.55
131.66		 25.91
23.67		 14.41
12.00		 0.00 202.87
 33  No Name #16465
 Calc.
Raw		 118.09
95.65		 33.22
30.34		 45.05
37.50		 0.00 196.36
 34  No Name #4538
 Calc.
Raw		 132.93
107.67		 27.01
24.67		 32.43
27.00		 0.00 192.37
 35  No Name #35314
 Calc.
Raw		 146.91
118.99		 19.33
17.66		 23.72
19.75		 5.00 184.96
 36  No Name #31310
 Calc.
Raw		 78.61
63.67		 30.29
27.67		 72.97
60.75		 0.00 181.87
 37  No Name #6379
 Calc.
Raw		 125.92
101.99		 20.44
18.67		 26.43
22.00		 0.00 172.79
 38  No Name #32066
 Calc.
Raw		 100.22
81.17		 28.47
26.00		 34.23
28.50		 0.00 162.92
 39  No Name #35477
 Calc.
Raw		 83.13
67.33		 31.39
28.67		 30.03
25.00		 0.00 144.55
 40  No Name #26773
 Calc.
Raw		 53.89
43.65		 21.16
19.33		 70.87
59.00		 3.00 142.92
 41  No Name #35789
 Calc.
Raw		 76.54
61.99		 33.58
30.67		 27.63
23.00		 0.00 137.75
 42  No Name #35329
 Calc.
Raw		 40.32
32.66		 28.09
25.66		 40.24
33.50		 0.00 108.65
 43  No Name #2437
 Calc.
Raw		 60.50
49.00		 21.17
19.34		 25.23
21.00		 0.00 106.90
 44  No Name #35396
 Calc.
Raw		 57.83
46.84		 25.91
23.67		 17.42
14.50		 0.00 101.16