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 II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #26206
 Calc.
Raw		 200.00
170.00		 50.00
44.00		 79.68
100.00		 0.00 329.68
 2  No Name #20720
 Calc.
Raw		 162.94
138.50		 48.86
43.00		 90.84
114.00		 0.00 302.64
 2  No Name #32600
 Calc.
Raw		 164.12
139.50		 41.67
36.67		 96.41
121.00		 0.00 302.20
 3  No Name #10378
 Calc.
Raw		 163.53
139.00		 38.26
33.67		 98.21
123.25		 0.00 300.00
 4  No Name #28541
 Calc.
Raw		 152.94
130.00		 49.24
43.33		 92.03
115.50		 0.00 294.21
 5  No Name #1430
 Calc.
Raw		 191.76
163.00		 44.32
39.00		 53.98
67.75		 0.00 290.06
 6  No Name #29467
 Calc.
Raw		 166.47
141.50		 43.94
38.67		 77.09
96.75		 0.00 287.50
 6  No Name #33959
 Calc.
Raw		 172.94
147.00		 43.94
38.67		 69.72
87.50		 0.00 286.60
 7  No Name #11901
 Calc.
Raw		 140.00
119.00		 39.77
35.00		 100.00
125.50		 0.00 279.77
 8  No Name #9642
 Calc.
Raw		 148.24
126.00		 32.95
29.00		 89.04
111.75		 0.00 270.23
 9  No Name #2477
 Calc.
Raw		 172.94
147.00		 41.28
36.33		 48.61
61.00		 1.00 261.83
 10  No Name #34596
 Calc.
Raw		 167.06
142.00		 31.44
27.67		 61.75
77.50		 0.00 260.25
 11  No Name #27639
 Calc.
Raw		 171.18
145.50		 28.41
25.00		 54.98
69.00		 0.00 254.57
 11  No Name #33978
 Calc.
Raw		 131.18
111.50		 28.78
25.33		 94.22
118.25		 0.00 254.18
 12  No Name #1722
 Calc.
Raw		 124.12
105.50		 30.68
27.00		 93.23
117.00		 1.00 247.03
 13  No Name #26110
 Calc.
Raw		 147.06
125.00		 40.16
35.34		 56.37
70.75		 0.00 243.59
 14  No Name #30390
 Calc.
Raw		 182.35
155.00		 45.83
40.33		 13.94
17.50		 0.00 242.12
 15  No Name #30879
 Calc.
Raw		 146.47
124.50		 35.23
31.00		 56.77
71.25		 0.00 238.47
 15  No Name #31230
 Calc.
Raw		 159.41
135.50		 30.68
27.00		 48.21
60.50		 0.00 238.30
 16  No Name #21303
 Calc.
Raw		 117.06
99.50		 27.66
24.34		 92.23
115.75		 0.00 236.95
 16  No Name #22504
 Calc.
Raw		 143.53
122.00		 34.85
30.67		 57.97
72.75		 0.00 236.35
 17  No Name #28109
 Calc.
Raw		 141.76
120.50		 34.85
30.67		 59.16
74.25		 0.00 235.77
 18  No Name #10706
 Calc.
Raw		 143.53
122.00		 38.27
33.68		 50.20
63.00		 0.00 232.00
 19  No Name #11459
 Calc.
Raw		 157.06
133.50		 32.58
28.67		 34.86
43.75		 0.00 224.50
 20  No Name #25051
 Calc.
Raw		 140.00
119.00		 30.68
27.00		 52.59
66.00		 0.00 223.27
 20  No Name #31798
 Calc.
Raw		 115.29
98.00		 26.52
23.34		 80.88
101.50		 0.00 222.69
 20  No Name #30746
 Calc.
Raw		 138.82
118.00		 32.95
29.00		 50.60
63.50		 0.00 222.37
 21  No Name #23506
 Calc.
Raw		 144.71
123.00		 29.93
26.34		 46.41
58.25		 0.00 221.05
 22  No Name #34897
 Calc.
Raw		 141.18
120.00		 37.13
32.67		 39.44
49.50		 0.00 217.75
 22  No Name #11548
 Calc.
Raw		 122.94
104.50		 35.99
31.67		 58.37
73.25		 0.00 217.30
 23  No Name #35337
 Calc.
Raw		 112.35
95.50		 21.59
19.00		 80.28
100.75		 0.00 214.22
 24  No Name #15542
 Calc.
Raw		 138.82
118.00		 28.03
24.67		 44.62
56.00		 0.00 211.47
 24  No Name #32909
 Calc.
Raw		 98.82
84.00		 19.70
17.34		 92.83
116.50		 0.00 211.35
 24  No Name #29048
 Calc.
Raw		 134.12
114.00		 30.68
27.00		 46.22
58.00		 0.00 211.02
 25  No Name #16088
 Calc.
Raw		 153.53
130.50		 24.25
21.34		 32.27
40.50		 0.00 210.05
 25  No Name #18931
 Calc.
Raw		 120.00
102.00		 35.63
31.35		 53.78
67.50		 0.00 209.41
 26  No Name #31624
 Calc.
Raw		 114.12
97.00		 29.17
25.67		 62.75
78.75		 0.00 206.04
 26  No Name #30608
 Calc.
Raw		 105.29
89.50		 25.38
22.33		 74.90
94.00		 0.00 205.57
 27  No Name #27164
 Calc.
Raw		 122.35
104.00		 29.92
26.33		 52.59
66.00		 0.00 204.86
 28  No Name #2269
 Calc.
Raw		 135.29
115.00		 32.58
28.67		 35.66
44.75		 0.00 203.53
 29  No Name #25649
 Calc.
Raw		 152.35
129.50		 33.72
29.67		 12.95
16.25		 0.00 199.02
 30  No Name #9565
 Calc.
Raw		 165.88
141.00		 29.55
26.00		 29.68
37.25		 30.00 195.11
 30  No Name #13927
 Calc.
Raw		 133.53
113.50		 45.83
40.33		 15.74
19.75		 0.00 195.10
 31  No Name #28938
 Calc.
Raw		 117.65
100.00		 31.07
27.34		 44.82
56.25		 0.00 193.54
 32  No Name #34082
 Calc.
Raw		 116.47
99.00		 19.32
17.00		 54.78
68.75		 0.00 190.57
 33  No Name #32249
 Calc.
Raw		 127.06
108.00		 25.38
22.33		 35.66
44.75		 0.00 188.10
 34  No Name #28348
 Calc.
Raw		 122.35
104.00		 31.43
27.66		 17.73
22.25		 0.00 171.51
 34  No Name #35010
 Calc.
Raw		 132.35
112.50		 22.35
19.67		 16.14
20.25		 0.00 170.84
 34  No Name #8013
 Calc.
Raw		 122.94
104.50		 31.07
27.34		 16.73
21.00		 0.00 170.74
 35  No Name #14724
 Calc.
Raw		 112.35
95.50		 20.83
18.33		 36.45
45.75		 0.00 169.63
 35  No Name #4909
 Calc.
Raw		 126.47
107.50		 32.19
28.33		 10.96
13.75		 0.00 169.62
 35  No Name #34080
 Calc.
Raw		 105.88
90.00		 20.83
18.33		 42.83
53.75		 0.00 169.54
 36  No Name #16610
 Calc.
Raw		 109.41
93.00		 22.73
20.00		 27.89
35.00		 0.00 160.03
 37  No Name #3422
 Calc.
Raw		 113.53
96.50		 26.51
23.33		 17.93
22.50		 2.00 155.97
 38  No Name #18918
 Calc.
Raw		 115.88
98.50		 24.63
21.67		 10.16
12.75		 0.00 150.67
 39  No Name #34931
 Calc.
Raw		 101.76
86.50		 23.10
20.33		 26.49
33.25		 5.00 146.35
 40  No Name #177
 Calc.
Raw		 85.88
73.00		 21.98
19.34		 21.91
27.50		 0.00 129.77
 41  No Name #22248
 Calc.
Raw		 79.41
67.50		 20.08
17.67		 17.73
22.25		 0.00 117.22
 42  No Name #35382
 Calc.
Raw		 68.82
58.50		 16.67
14.67		 11.35
14.25		 0.00 96.84