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 5 I'm Only Thinking Of You! Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #27946
 Calc.
Raw		 200.00
154.00		 34.12
33.67		 76.61
75.33		 0.00 310.73
 2  No Name #7975
 Calc.
Raw		 177.27
136.50		 50.00
49.34		 82.04
80.67		 0.00 309.31
 3  No Name #32441
 Calc.
Raw		 170.78
131.50		 43.57
42.99		 95.26
93.67		 5.00 304.61
 4  No Name #31230
 Calc.
Raw		 185.39
142.75		 41.89
41.34		 78.64
77.33		 10.00 295.92
 5  No Name #31225
 Calc.
Raw		 173.05
133.25		 38.51
38.00		 80.34
79.00		 0.00 291.90
 6  No Name #35627
 Calc.
Raw		 165.58
127.50		 34.12
33.67		 87.46
86.00		 0.00 287.16
 7  No Name #32076
 Calc.
Raw		 176.95
136.25		 30.40
30.00		 76.27
75.00		 0.00 283.62
 7  No Name #34351
 Calc.
Raw		 173.70
133.75		 35.12
34.66		 74.24
73.00		 0.00 283.06
 8  No Name #36696
 Calc.
Raw		 173.38
133.50		 36.82
36.33		 72.21
71.00		 0.00 282.41
 9  No Name #10527
 Calc.
Raw		 167.21
128.75		 30.75
30.34		 83.06
81.67		 0.00 281.02
 10  No Name #37170
 Calc.
Raw		 176.30
135.75		 24.67
24.34		 75.94
74.67		 0.00 276.91
 10  No Name #10619
 Calc.
Raw		 144.81
111.50		 32.09
31.67		 100.00
98.33		 0.00 276.90
 10  No Name #3260
 Calc.
Raw		 167.21
128.75		 38.17
37.67		 70.85
69.67		 0.00 276.23
 11  No Name #11781
 Calc.
Raw		 163.64
126.00		 38.50
37.99		 73.22
72.00		 0.00 275.36
 11  No Name #35204
 Calc.
Raw		 159.42
122.75		 41.56
41.01		 74.24
73.00		 0.00 275.22
 12  No Name #19945
 Calc.
Raw		 155.51
119.74		 27.70
27.33		 89.49
88.00		 0.00 272.70
 12  No Name #2397
 Calc.
Raw		 157.14
121.00		 40.54
40.00		 74.92
73.67		 0.00 272.60
 13  No Name #30883
 Calc.
Raw		 164.61
126.75		 34.11
33.66		 96.61
95.00		 25.00 270.33
 13  No Name #9575
 Calc.
Raw		 167.53
129.00		 31.76
31.34		 70.85
69.67		 0.00 270.14
 14  No Name #3244
 Calc.
Raw		 184.42
142.00		 26.68
26.33		 57.97
57.00		 0.00 269.07
 15  No Name #34250
 Calc.
Raw		 163.96
126.25		 22.29
22.00		 80.34
79.00		 0.00 266.59
 16  No Name #30349
 Calc.
Raw		 163.31
125.75		 33.11
32.67		 66.79
65.67		 0.00 263.21
 17  No Name #26102
 Calc.
Raw		 156.82
120.75		 34.45
34.00		 70.85
69.67		 0.00 262.12
 18  No Name #1896
 Calc.
Raw		 138.96
107.00		 37.49
37.00		 79.66
78.33		 0.00 256.11
 19  No Name #32435
 Calc.
Raw		 150.65
116.00		 25.33
25.00		 77.97
76.67		 0.00 253.95
 20  No Name #30551
 Calc.
Raw		 145.45
112.00		 20.60
20.33		 86.44
85.00		 0.00 252.49
 21  No Name #34802
 Calc.
Raw		 146.10
112.50		 30.40
30.00		 70.17
69.00		 0.00 246.67
 22  No Name #32798
 Calc.
Raw		 143.18
110.25		 33.78
33.33		 61.70
60.67		 0.00 238.66
 22  No Name #35430
 Calc.
Raw		 162.66
125.25		 12.49
12.33		 63.39
62.33		 0.00 238.54
 23  No Name #3133
 Calc.
Raw		 135.71
104.50		 33.10
32.66		 64.07
63.00		 0.00 232.88
 24  No Name #35475
 Calc.
Raw		 127.92
98.50		 29.72
29.33		 73.56
72.33		 0.00 231.20
 24  No Name #33771
 Calc.
Raw		 126.95
97.75		 21.63
21.34		 82.38
81.00		 0.00 230.96
 25  No Name #34990
 Calc.
Raw		 126.30
97.25		 25.33
25.00		 74.24
73.00		 0.00 225.87
 26  No Name #35288
 Calc.
Raw		 129.55
99.75		 17.23
17.00		 74.24
73.00		 0.00 221.02
 27  No Name #3505
 Calc.
Raw		 128.57
99.00		 20.61
20.34		 69.15
68.00		 0.00 218.33
 28  No Name #21591
 Calc.
Raw		 119.16
91.75		 26.69
26.34		 71.19
70.00		 0.00 217.04
 29  No Name #23184
 Calc.
Raw		 136.69
105.25		 20.60
20.33		 58.30
57.33		 0.00 215.59
 30  No Name #8871
 Calc.
Raw		 117.86
90.75		 21.28
21.00		 74.58
73.33		 0.00 213.72
 31  No Name #25611
 Calc.
Raw		 119.16
91.75		 26.68
26.33		 66.10
65.00		 0.00 211.94
 32  No Name #27448
 Calc.
Raw		 134.42
103.50		 17.90
17.66		 53.90
53.00		 0.00 206.22
 33  No Name #30595
 Calc.
Raw		 119.16
91.75		 28.36
27.99		 52.20
51.33		 0.00 199.72
 34  No Name #34259
 Calc.
Raw		 116.88
90.00		 16.89
16.67		 57.29
56.33		 0.00 191.06
 34  No Name #8888
 Calc.
Raw		 101.62
78.25		 21.28
21.00		 68.14
67.00		 0.00 191.04