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 2 DinoStories Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #31437
 Calc.
Raw		 187.29
140.00		 46.74
38.33		 93.58
116.67		 0.00 327.61
 2  No Name #11519
 Calc.
Raw		 177.93
133.00		 48.38
39.67		 92.51
115.33		 0.00 318.82
 3  No Name #22311
 Calc.
Raw		 199.33
149.00		 48.38
39.67		 65.24
81.33		 0.00 312.95
 4  No Name #27471
 Calc.
Raw		 192.64
144.00		 44.72
36.67		 74.33
92.67		 0.00 311.69
 5  No Name #21504
 Calc.
Raw		 199.33
149.00		 32.52
26.67		 76.47
95.33		 0.00 308.32
 5  No Name #35621
 Calc.
Raw		 200.00
149.50		 28.87
23.67		 79.41
99.00		 0.00 308.28
 6  No Name #9744
 Calc.
Raw		 183.95
137.50		 39.02
32.00		 80.75
100.67		 0.00 303.72
 7  No Name #32032
 Calc.
Raw		 177.93
133.00		 39.02
32.00		 82.62
103.00		 0.00 299.57
 8  No Name #28508
 Calc.
Raw		 173.91
130.00		 40.65
33.33		 83.96
104.67		 0.00 298.52
 9  No Name #31230
 Calc.
Raw		 157.19
117.50		 42.28
34.67		 96.79
120.67		 0.00 296.26
 10  No Name #34393
 Calc.
Raw		 165.89
124.00		 46.34
38.00		 80.75
100.67		 0.00 292.98
 10  No Name #3746
 Calc.
Raw		 168.56
126.00		 50.00
41.00		 74.33
92.67		 0.00 292.89
 11  No Name #8451
 Calc.
Raw		 171.24
128.00		 44.72
36.67		 70.59
88.00		 0.00 286.55
 11  No Name #32441
 Calc.
Raw		 158.53
118.50		 43.09
35.33		 83.96
104.67		 0.00 285.58
 12  No Name #7246
 Calc.
Raw		 179.93
134.50		 33.33
27.33		 69.78
87.00		 0.00 283.04
 12  No Name #32939
 Calc.
Raw		 175.25
131.00		 30.09
24.67		 77.27
96.33		 0.00 282.61
 12  No Name #5808
 Calc.
Raw		 137.79
103.00		 44.72
36.67		 100.00
124.67		 0.00 282.51
 12  No Name #8496
 Calc.
Raw		 159.20
119.00		 39.02
32.00		 83.96
104.67		 0.00 282.18
 13  No Name #10527
 Calc.
Raw		 153.18
114.50		 41.06
33.67		 80.75
100.67		 0.00 274.99
 14  No Name #32563
 Calc.
Raw		 163.21
122.00		 34.55
28.33		 68.98
86.00		 0.00 266.74
 15  No Name #32969
 Calc.
Raw		 144.48
108.00		 33.33
27.33		 80.75
100.67		 0.00 258.56
 16  No Name #2324
 Calc.
Raw		 154.52
115.50		 37.80
31.00		 65.24
81.33		 0.00 257.56
 17  No Name #32076
 Calc.
Raw		 135.79
101.50		 33.74
27.67		 77.54
96.67		 0.00 247.07
 17  No Name #32530
 Calc.
Raw		 146.49
109.50		 26.02
21.34		 74.33
92.67		 0.00 246.84
 18  No Name #35327
 Calc.
Raw		 132.44
99.00		 32.93
27.00		 76.20
95.00		 0.00 241.57
 19  No Name #1691
 Calc.
Raw		 124.41
93.00		 37.40
30.67		 77.00
96.00		 0.00 238.81
 19  No Name #34418
 Calc.
Raw		 135.12
101.00		 28.45
23.33		 74.60
93.00		 0.00 238.17
 20  No Name #8888
 Calc.
Raw		 124.41
93.00		 34.96
28.67		 77.54
96.67		 0.00 236.91
 21  No Name #1790
 Calc.
Raw		 131.77
98.50		 33.33
27.33		 70.59
88.00		 0.00 235.69
 22  No Name #19730
 Calc.
Raw		 135.79
101.50		 19.91
16.33		 75.13
93.67		 0.00 230.83
 23  No Name #10146
 Calc.
Raw		 119.73
89.50		 38.21
31.33		 70.85
88.33		 0.00 228.79
 23  No Name #19512
 Calc.
Raw		 109.70
82.00		 32.52
26.67		 85.83
107.00		 0.00 228.05
 24  No Name #1412
 Calc.
Raw		 123.08
92.00		 29.67
24.33		 70.85
88.33		 0.00 223.60
 24  No Name #30326
 Calc.
Raw		 125.08
93.50		 26.84
22.01		 71.12
88.67		 0.00 223.04
 25  No Name #4679
 Calc.
Raw		 110.37
82.50		 34.15
28.00		 77.54
96.67		 0.00 222.06
 25  No Name #8871
 Calc.
Raw		 123.75
92.50		 35.37
29.00		 62.30
77.67		 0.00 221.42
 26  No Name #36828
 Calc.
Raw		 105.69
79.00		 31.30
25.67		 80.75
100.67		 0.00 217.74
 27  No Name #19945
 Calc.
Raw		 97.66
73.00		 30.89
25.33		 74.33
92.67		 0.00 202.88
 27  No Name #3506
 Calc.
Raw		 115.05
86.00		 25.21
20.67		 62.30
77.67		 0.00 202.56
 28  No Name #37170
 Calc.
Raw		 114.38
85.50		 29.27
24.00		 56.69
70.67		 0.00 200.34
 29  No Name #37542
 Calc.
Raw		 96.32
72.00		 26.43
21.67		 71.12
88.67		 0.00 193.87
 30  No Name #17068
 Calc.
Raw		 111.04
83.00		 28.87
23.67		 50.53
63.00		 0.00 190.44
 30  No Name #33846
 Calc.
Raw		 110.37
82.50		 17.07
14.00		 62.57
78.00		 0.00 190.01
 31  No Name #10076
 Calc.
Raw		 91.64
68.50		 19.91
16.33		 72.99
91.00		 0.00 184.54
 32  No Name #9014
 Calc.
Raw		 86.29
64.50		 31.71
26.00		 65.24
81.33		 0.00 183.24
 33  No Name #34351
 Calc.
Raw		 74.92
56.00		 19.91
16.33		 80.75
100.67		 0.00 175.58