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 3 Around The World In 8 Minutes Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #31225
 Calc.
Raw		 192.49
141.00		 50.00
39.99		 89.06
97.67		 0.00 331.55
 2  No Name #4186
 Calc.
Raw		 200.00
146.50		 46.67
37.33		 76.89
84.33		 0.00 323.56
 3  No Name #4634
 Calc.
Raw		 185.32
135.75		 43.35
34.67		 85.41
93.67		 0.00 314.08
 4  No Name #8451
 Calc.
Raw		 162.12
118.75		 43.35
34.67		 100.00
109.67		 0.00 305.47
 4  No Name #31230
 Calc.
Raw		 172.70
126.50		 46.67
37.33		 85.41
93.67		 0.00 304.78
 5  No Name #19512
 Calc.
Raw		 172.35
126.25		 46.26
37.00		 85.41
93.67		 0.00 304.02
 6  No Name #34158
 Calc.
Raw		 155.63
114.00		 47.92
38.33		 95.13
104.33		 0.00 298.68
 7  No Name #35547
 Calc.
Raw		 170.31
124.75		 48.76
39.00		 76.89
84.33		 0.00 295.96
 8  No Name #14577
 Calc.
Raw		 176.45
129.25		 47.92
38.33		 70.51
77.33		 0.00 294.88
 9  No Name #35495
 Calc.
Raw		 159.39
116.75		 46.27
37.01		 80.54
88.33		 0.00 286.20
 10  No Name #1691
 Calc.
Raw		 169.62
124.25		 45.85
36.67		 69.60
76.33		 0.00 285.07
 11  No Name #27297
 Calc.
Raw		 150.51
110.25		 44.60
35.67		 90.57
99.33		 5.00 280.68
 12  No Name #32441
 Calc.
Raw		 163.82
120.00		 38.35
30.67		 74.47
81.67		 0.00 276.64
 13  No Name #30709
 Calc.
Raw		 152.90
112.00		 40.42
32.33		 70.82
77.67		 0.00 264.14
 13  No Name #36574
 Calc.
Raw		 161.77
118.50		 37.51
30.00		 64.74
71.00		 0.00 264.02
 13  No Name #15467
 Calc.
Raw		 134.81
98.75		 44.16
35.32		 84.19
92.33		 0.00 263.16
 14  No Name #3506
 Calc.
Raw		 149.83
109.75		 35.00
27.99		 74.47
81.67		 0.00 259.30
 14  No Name #3381
 Calc.
Raw		 153.58
112.50		 40.85
32.67		 64.74
71.00		 0.00 259.17
 15  No Name #34293
 Calc.
Raw		 146.42
107.25		 27.52
22.01		 82.98
91.00		 0.00 256.92
 15  No Name #1386
 Calc.
Raw		 144.03
105.50		 43.77
35.01		 68.39
75.00		 0.00 256.19
 16  No Name #14670
 Calc.
Raw		 136.52
100.00		 30.42
24.33		 85.41
93.67		 0.00 252.35
 17  No Name #31212
 Calc.
Raw		 140.96
103.25		 27.92
22.33		 78.12
85.67		 0.00 247.00
 17  No Name #35756
 Calc.
Raw		 134.81
98.75		 35.85
28.67		 75.68
83.00		 0.00 246.34
 18  No Name #23095
 Calc.
Raw		 131.06
96.00		 40.44
32.34		 74.47
81.67		 0.00 245.97
 19  No Name #36828
 Calc.
Raw		 147.78
108.25		 32.52
26.01		 63.53
69.67		 0.00 243.83
 19  No Name #30883
 Calc.
Raw		 126.62
92.75		 37.51
30.00		 79.33
87.00		 0.00 243.46
 20  No Name #3473
 Calc.
Raw		 137.54
100.75		 32.93
26.34		 72.03
79.00		 0.00 242.50
 21  No Name #9744
 Calc.
Raw		 131.40
96.25		 39.18
31.34		 70.82
77.67		 0.00 241.40
 22  No Name #8888
 Calc.
Raw		 141.98
104.00		 21.67
17.33		 75.68
83.00		 0.00 239.33
 23  No Name #1790
 Calc.
Raw		 141.98
104.00		 30.42
24.33		 79.33
87.00		 15.00 236.73
 23  No Name #5169
 Calc.
Raw		 124.23
91.00		 27.09
21.67		 85.41
93.67		 0.00 236.73
 24  No Name #197
 Calc.
Raw		 139.59
102.25		 30.43
24.34		 64.74
71.00		 0.00 234.76
 24  No Name #2472
 Calc.
Raw		 122.18
89.50		 29.99
23.99		 81.76
89.67		 0.00 233.93
 25  No Name #34505
 Calc.
Raw		 146.76
107.50		 20.43
16.34		 64.74
71.00		 0.00 231.93
 25  No Name #34802
 Calc.
Raw		 116.38
85.25		 40.01
32.00		 75.38
82.67		 0.00 231.77
 26  No Name #33819
 Calc.
Raw		 131.06
96.00		 27.93
22.34		 67.17
73.67		 0.00 226.16
 27  No Name #33358
 Calc.
Raw		 125.94
92.25		 26.26
21.00		 72.03
79.00		 0.00 224.23
 27  No Name #36112
 Calc.
Raw		 143.69
105.25		 31.67
25.33		 58.06
63.67		 10.00 223.42
 28  No Name #33345
 Calc.
Raw		 119.11
87.25		 23.34
18.67		 78.12
85.67		 0.00 220.57
 29  No Name #31161
 Calc.
Raw		 120.48
88.25		 31.26
25.00		 65.95
72.33		 0.00 217.69
 29  No Name #29618
 Calc.
Raw		 126.62
92.75		 35.00
27.99		 65.95
72.33		 10.00 217.57
 29  No Name #34897
 Calc.
Raw		 126.28
92.50		 29.18
23.34		 62.31
68.33		 1.00 216.77
 30  No Name #35871
 Calc.
Raw		 117.75
86.25		 30.42
24.33		 63.53
69.67		 0.00 211.70
 31  No Name #23774
 Calc.
Raw		 110.24
80.75		 22.92
18.33		 75.68
83.00		 0.00 208.84
 32  No Name #32640
 Calc.
Raw		 122.87
90.00		 21.26
17.00		 63.53
69.67		 0.00 207.66
 33  No Name #34990
 Calc.
Raw		 129.01
94.50		 24.17
19.33		 67.17
73.67		 20.00 200.35
 34  No Name #33010
 Calc.
Raw		 111.95
82.00		 13.75
11.00		 73.25
80.33		 0.00 198.95
 35  No Name #11781
 Calc.
Raw		 118.43
86.75		 33.76
27.00		 40.73
44.67		 0.00 192.92
 36  No Name #13857
 Calc.
Raw		 106.83
78.25		 32.51
26.00		 62.31
68.33		 10.00 191.65
 37  No Name #35115
 Calc.
Raw		 102.39
75.00		 27.09
21.67		 57.45
63.00		 0.00 186.93
 38  No Name #16610
 Calc.
Raw		 97.61
71.50		 26.26
21.00		 68.39
75.00		 30.00 162.26