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 2008 May 31st
 Problem 3 The Wonderful Muses Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #1691
 Calc.
Raw		 173.23
144.00		 44.59
33.00		 84.11
90.00		 0.00 301.93
 2  No Name #36887
 Calc.
Raw		 171.13
142.25		 40.99
30.33		 83.88
89.75		 0.00 296.00
 3  No Name #37221
 Calc.
Raw		 185.86
154.50		 40.54
30.00		 55.84
59.75		 0.00 282.24
 4  No Name #32441
 Calc.
Raw		 138.95
115.50		 34.69
25.67		 100.00
107.00		 0.00 273.64
 5  No Name #27017
 Calc.
Raw		 200.00
166.25		 48.20
35.67		 13.32
14.25		 0.00 261.52
 6  No Name #26102
 Calc.
Raw		 150.08
124.75		 30.64
22.67		 76.64
82.00		 0.00 257.36
 7  No Name #1386
 Calc.
Raw		 152.78
127.00		 38.74
28.67		 56.54
60.50		 0.00 248.06
 8  No Name #35547
 Calc.
Raw		 158.20
131.50		 43.69
32.33		 26.17
28.00		 0.00 228.06
 9  No Name #4634
 Calc.
Raw		 125.11
104.00		 37.84
28.00		 56.07
60.00		 0.00 219.02
 10  No Name #35756
 Calc.
Raw		 167.22
139.00		 33.34
24.67		 11.92
12.75		 0.00 212.48
 10  No Name #5808
 Calc.
Raw		 121.80
101.25		 28.82
21.33		 61.45
65.75		 0.00 212.07
 11  No Name #1896
 Calc.
Raw		 157.89
131.25		 37.39
27.67		 13.32
14.25		 0.00 208.60
 11  No Name #3473
 Calc.
Raw		 141.95
118.00		 38.28
28.33		 33.18
35.50		 5.00 208.41
 12  No Name #17473
 Calc.
Raw		 104.96
87.25		 22.53
16.67		 77.34
82.75		 0.00 204.83
 13  No Name #23095
 Calc.
Raw		 151.58
126.00		 36.49
27.00		 15.42
16.50		 0.00 203.49
 13  No Name #2472
 Calc.
Raw		 132.03
109.75		 32.88
24.33		 37.85
40.50		 0.00 202.76
 13  No Name #25443
 Calc.
Raw		 129.02
107.25		 43.24
32.00		 30.37
32.50		 0.00 202.63
 14  No Name #37705
 Calc.
Raw		 143.46
119.25		 30.18
22.33		 28.50
30.50		 0.00 202.14
 15  No Name #31225
 Calc.
Raw		 134.14
111.50		 50.00
37.00		 13.08
14.00		 0.00 197.22
 16  No Name #31230
 Calc.
Raw		 145.26
120.75		 40.09
29.67		 10.28
11.00		 0.00 195.63
 16  No Name #381
 Calc.
Raw		 119.10
99.00		 33.34
24.67		 42.99
46.00		 0.00 195.43
 17  No Name #14577
 Calc.
Raw		 120.00
99.75		 40.99
30.33		 29.21
31.25		 0.00 190.20
 18  No Name #23774
 Calc.
Raw		 147.37
122.50		 28.82
21.33		 27.57
29.50		 15.00 188.76
 19  No Name #14670
 Calc.
Raw		 111.58
92.75		 37.84
28.00		 31.07
33.25		 0.00 180.49
 20  No Name #9744
 Calc.
Raw		 140.75
117.00		 27.93
20.67		 10.05
10.75		 0.00 178.73
 21  No Name #1965
 Calc.
Raw		 132.63
110.25		 29.28
21.67		 14.95
16.00		 0.00 176.86
 21  No Name #1790
 Calc.
Raw		 135.34
112.50		 24.77
18.33		 15.89
17.00		 0.00 176.00
 22  No Name #11780
 Calc.
Raw		 136.24
113.25		 29.28
21.67		 12.62
13.50		 5.00 173.14
 22  No Name #34351
 Calc.
Raw		 119.10
99.00		 29.73
22.00		 28.50
30.50		 5.00 172.33
 23  No Name #36134
 Calc.
Raw		 138.95
115.50		 27.47
20.33		 15.42
16.50		 10.00 171.84
 23  No Name #32435
 Calc.
Raw		 101.95
84.75		 15.77
11.67		 53.74
57.50		 0.00 171.46
 24  No Name #37405
 Calc.
Raw		 120.30
100.00		 35.58
26.33		 13.79
14.75		 0.00 169.67
 24  No Name #10146
 Calc.
Raw		 107.97
89.75		 22.97
17.00		 38.08
40.75		 0.00 169.02
 25  No Name #30595
 Calc.
Raw		 111.58
92.75		 19.36
14.33		 37.38
40.00		 0.00 168.32
 26  No Name #29473
 Calc.
Raw		 107.97
89.75		 25.23
18.67		 30.14
32.25		 0.00 163.34
 26  No Name #27946
 Calc.
Raw		 120.00
99.75		 26.58
19.67		 18.93
20.25		 3.00 162.51
 27  No Name #30883
 Calc.
Raw		 121.50
101.00		 24.77
18.33		 11.92
12.75		 0.00 158.19
 28  No Name #30329
 Calc.
Raw		 104.96
87.25		 18.92
14.00		 26.40
28.25		 0.00 150.28
 29  No Name #33852
 Calc.
Raw		 124.81
103.75		 27.03
20.00		 11.68
12.50		 15.00 148.52
 30  No Name #3244
 Calc.
Raw		 104.36
86.75		 29.73
22.00		 10.75
11.50		 0.00 144.84
 31  No Name #29857
 Calc.
Raw		 113.68
94.50		 18.01
13.33		 10.28
11.00		 7.00 134.97
 31  No Name #33986
 Calc.
Raw		 98.05
81.50		 21.18
15.67		 15.42
16.50		 0.00 134.65
 32  No Name #28695
 Calc.
Raw		 106.17
88.25		 18.01
13.33		 8.64
9.25		 1.00 131.82
 33  No Name #33422
 Calc.
Raw		 98.35
81.75		 16.66
12.33		 12.15
13.00		 0.00 127.16
 34  No Name #3962
 Calc.
Raw		 90.53
75.25		 24.32
18.00		 10.75
11.50		 5.00 120.60
 34  No Name #8871
 Calc.
Raw		 74.59
62.00		 22.07
16.33		 25.47
27.25		 2.00 120.13
 35  No Name #32530
 Calc.
Raw		 92.03
76.50		 16.66
12.33		 11.92
12.75		 3.00 117.61
 36  No Name #37429
 Calc.
Raw		 86.02
71.50		 22.07
16.33		 7.94
8.50		 2.00 114.03