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 2005 May 21st
 Problem 2 Tech Transfer Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #32032
 Calc.
Raw		 181.06
119.50		 48.28
37.00		 100.00
97.67		 0.00 329.34
 2  No Name #33415
 Calc.
Raw		 181.06
119.50		 50.00
38.32		 72.69
71.00		 0.00 303.75
 3  No Name #34665
 Calc.
Raw		 200.00
132.00		 38.69
29.65		 56.31
55.00		 0.00 295.00
 4  No Name #30358
 Calc.
Raw		 178.03
117.50		 43.93
33.67		 71.33
69.67		 0.00 293.29
 5  No Name #34393
 Calc.
Raw		 185.61
122.50		 45.67
35.00		 60.41
59.00		 0.00 291.69
 6  No Name #24409
 Calc.
Raw		 190.15
125.50		 42.18
32.33		 57.67
56.33		 0.00 290.00
 7  No Name #12264
 Calc.
Raw		 177.27
117.00		 44.38
34.01		 65.86
64.33		 0.00 287.51
 7  No Name #30360
 Calc.
Raw		 162.12
107.00		 45.67
35.00		 79.52
77.67		 0.00 287.31
 8  No Name #25285
 Calc.
Raw		 183.33
121.00		 37.84
29.00		 62.12
60.67		 0.00 283.29
 9  No Name #22311
 Calc.
Raw		 156.06
103.00		 41.75
32.00		 83.62
81.67		 0.00 281.43
 9  No Name #17312
 Calc.
Raw		 159.09
105.00		 44.81
34.34		 76.79
75.00		 0.00 280.69
 10  No Name #33217
 Calc.
Raw		 168.18
111.00		 43.03
32.98		 66.55
65.00		 0.00 277.76
 11  No Name #31043
 Calc.
Raw		 188.64
124.50		 36.55
28.01		 52.22
51.00		 1.00 276.41
 12  No Name #6688
 Calc.
Raw		 175.00
115.50		 44.78
34.32		 52.22
51.00		 0.00 272.00
 13  No Name #33343
 Calc.
Raw		 167.42
110.50		 45.24
34.67		 57.67
56.33		 0.00 270.33
 13  No Name #11606
 Calc.
Raw		 156.06
103.00		 46.54
35.67		 67.24
65.67		 0.00 269.84
 14  No Name #32348
 Calc.
Raw		 159.09
105.00		 31.73
24.32		 78.15
76.33		 0.00 268.97
 14  No Name #22172
 Calc.
Raw		 155.30
102.50		 27.84
21.34		 84.98
83.00		 0.00 268.12
 15  No Name #33084
 Calc.
Raw		 156.06
103.00		 44.77
34.31		 64.50
63.00		 0.00 265.33
 16  No Name #33345
 Calc.
Raw		 157.58
104.00		 35.66
27.33		 69.96
68.33		 0.00 263.20
 16  No Name #2397
 Calc.
Raw		 157.58
104.00		 41.75
32.00		 63.82
62.33		 0.00 263.15
 16  No Name #35180
 Calc.
Raw		 159.85
105.50		 43.93
33.67		 59.05
57.67		 0.00 262.83
 17  No Name #10102
 Calc.
Raw		 150.00
99.00		 41.32
31.67		 68.60
67.00		 0.00 259.92
 17  No Name #30326
 Calc.
Raw		 137.88
91.00		 36.10
27.67		 84.98
83.00		 0.00 258.96
 18  No Name #29034
 Calc.
Raw		 139.39
92.00		 39.59
30.34		 79.52
77.67		 0.00 258.50
 19  No Name #12307
 Calc.
Raw		 156.06
103.00		 39.57
30.33		 61.77
60.33		 0.00 257.40
 20  No Name #33089
 Calc.
Raw		 142.42
94.00		 40.41
30.97		 69.96
68.33		 0.00 252.79
 21  No Name #19945
 Calc.
Raw		 139.39
92.00		 41.75
32.00		 69.96
68.33		 0.00 251.10
 22  No Name #11117
 Calc.
Raw		 150.76
99.50		 38.71
29.67		 53.58
52.33		 0.00 243.05
 23  No Name #5736
 Calc.
Raw		 144.70
95.50		 33.05
25.33		 63.14
61.67		 0.00 240.89
 24  No Name #30349
 Calc.
Raw		 135.61
89.50		 42.20
32.34		 61.77
60.33		 0.00 239.58
 24  No Name #28449
 Calc.
Raw		 124.24
82.00		 36.52
27.99		 79.52
77.67		 1.00 239.28
 24  No Name #34916
 Calc.
Raw		 122.73
81.00		 37.84
29.00		 78.15
76.33		 0.00 238.72
 25  No Name #30426
 Calc.
Raw		 140.15
92.50		 35.66
27.33		 60.41
59.00		 0.00 236.22
 26  No Name #31161
 Calc.
Raw		 143.18
94.50		 30.88
23.67		 59.05
57.67		 0.00 233.11
 27  No Name #8871
 Calc.
Raw		 118.18
78.00		 33.05
25.33		 80.88
79.00		 0.00 232.11
 28  No Name #15074
 Calc.
Raw		 135.61
89.50		 36.97
28.33		 56.31
55.00		 0.00 228.89
 28  No Name #25049
 Calc.
Raw		 128.79
85.00		 41.75
32.00		 59.05
57.67		 1.00 228.59
 29  No Name #32425
 Calc.
Raw		 124.24
82.00		 36.95
28.32		 56.31
55.00		 0.00 217.50
 29  No Name #19727
 Calc.
Raw		 148.48
98.00		 22.19
17.01		 51.53
50.33		 5.00 217.20
 30  No Name #19729
 Calc.
Raw		 129.55
85.50		 32.19
24.67		 59.05
57.67		 5.00 215.79
 31  No Name #34990
 Calc.
Raw		 129.55
85.50		 38.26
29.32		 46.76
45.67		 0.00 214.57
 32  No Name #33880
 Calc.
Raw		 124.24
82.00		 29.58
22.67		 57.67
56.33		 0.00 211.49
 33  No Name #34203
 Calc.
Raw		 112.12
74.00		 33.92
26.00		 61.77
60.33		 0.00 207.81
 34  No Name #8149
 Calc.
Raw		 112.12
74.00		 39.59
30.34		 54.95
53.67		 0.00 206.66
 35  No Name #24436
 Calc.
Raw		 112.88
74.50		 34.36
26.33		 57.67
56.33		 0.00 204.91
 36  No Name #33840
 Calc.
Raw		 108.33
71.50		 25.65
19.66		 50.85
49.67		 0.00 184.83
 37  No Name #1228
 Calc.
Raw		 90.15
59.50		 27.37
20.98		 30.72
30.00		 0.00 148.24
   No Name #32166
 Calc.
Raw		 0.00
0.00		 0.00
0.00		 0.00
0.00		 0.00 0.00