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 3 Ancient Egypt Division II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #27006
 Calc.
Raw		 200.00
165.50		 50.00
34.00		 88.55
105.67		 0.00 338.55
 2  No Name #16595
 Calc.
Raw		 192.15
159.00		 46.07
31.33		 98.32
117.33		 0.00 336.54
 3  No Name #3137
 Calc.
Raw		 190.63
157.75		 44.12
30.00		 91.62
109.33		 0.00 326.37
 4  No Name #2477
 Calc.
Raw		 191.24
158.25		 36.26
24.66		 97.21
116.00		 0.00 324.71
 5  No Name #14670
 Calc.
Raw		 187.01
154.75		 33.81
22.99		 99.58
118.83		 2.00 318.40
 6  No Name #16756
 Calc.
Raw		 183.38
151.75		 36.78
25.01		 95.53
114.00		 1.00 314.69
 7  No Name #31433
 Calc.
Raw		 177.95
147.25		 37.25
25.33		 91.76
109.50		 2.00 304.96
 8  No Name #28004
 Calc.
Raw		 186.39
154.24		 22.04
14.99		 95.26
113.67		 0.00 303.69
 9  No Name #10533
 Calc.
Raw		 177.64
147.00		 37.75
25.67		 85.48
102.00		 1.00 299.87
 9  No Name #15677
 Calc.
Raw		 188.52
156.00		 30.40
20.67		 85.20
101.67		 5.00 299.12
 10  No Name #14577
 Calc.
Raw		 164.95
136.50		 41.16
27.99		 91.62
109.33		 2.00 295.73
 11  No Name #1326
 Calc.
Raw		 179.76
148.75		 31.37
21.33		 96.37
115.00		 15.00 292.50
 12  No Name #2993
 Calc.
Raw		 161.93
134.00		 25.49
17.33		 100.00
119.33		 0.00 287.42
 12  No Name #31225
 Calc.
Raw		 181.27
150.00		 27.94
19.00		 77.94
93.00		 0.00 287.15
 13  No Name #16375
 Calc.
Raw		 190.33
157.50		 49.51
33.67		 48.60
58.00		 3.00 285.44
 13  No Name #17473
 Calc.
Raw		 172.81
143.00		 23.06
15.68		 88.83
106.00		 0.00 284.70
 14  No Name #1839
 Calc.
Raw		 164.05
135.75		 30.88
21.00		 89.11
106.33		 0.00 284.04
 15  No Name #20184
 Calc.
Raw		 185.80
153.75		 25.50
17.34		 72.63
86.67		 1.00 282.93
 16  No Name #2464
 Calc.
Raw		 170.69
141.25		 24.01
16.33		 85.75
102.33		 0.00 280.45
 17  No Name #1573
 Calc.
Raw		 171.00
141.50		 17.16
11.67		 94.97
113.33		 4.00 279.13
 18  No Name #4643
 Calc.
Raw		 169.49
140.25		 21.57
14.67		 86.88
103.67		 0.00 277.94
 18  No Name #18918
 Calc.
Raw		 162.24
134.25		 20.59
14.00		 96.93
115.67		 2.00 277.76
 19  No Name #13338
 Calc.
Raw		 176.74
146.25		 26.47
18.00		 73.47
87.67		 0.00 276.68
 20  No Name #6069
 Calc.
Raw		 153.78
127.25		 39.22
26.67		 75.42
90.00		 0.00 268.42
 21  No Name #22311
 Calc.
Raw		 153.78
127.25		 27.46
18.67		 87.01
103.83		 1.00 267.25
 22  No Name #13641
 Calc.
Raw		 171.60
142.00		 12.25
8.33		 81.01
96.67		 0.00 264.86
 23  No Name #1715
 Calc.
Raw		 154.38
127.75		 28.44
19.34		 82.96
99.00		 2.00 263.78
 23  No Name #33403
 Calc.
Raw		 154.98
128.25		 21.56
14.66		 87.15
104.00		 0.00 263.69
 24  No Name #20847
 Calc.
Raw		 168.88
139.75		 23.06
15.68		 71.79
85.67		 1.00 262.73
 25  No Name #32144
 Calc.
Raw		 166.47
137.75		 20.59
14.00		 75.14
89.67		 3.00 259.20
 25  No Name #32684
 Calc.
Raw		 168.58
139.50		 37.74
25.66		 52.79
63.00		 0.00 259.11
 26  No Name #11901
 Calc.
Raw		 145.92
120.75		 28.43
19.33		 83.52
99.67		 0.00 257.87
 26  No Name #5471
 Calc.
Raw		 152.87
126.50		 13.74
9.34		 90.78
108.33		 0.00 257.39
 27  No Name #10167
 Calc.
Raw		 159.52
132.00		 23.06
15.68		 83.80
100.00		 10.00 256.38
 27  No Name #15407
 Calc.
Raw		 142.60
118.00		 29.41
20.00		 84.92
101.33		 1.00 255.93
 28  No Name #32766
 Calc.
Raw		 141.09
116.75		 19.12
13.00		 97.49
116.33		 3.00 254.70
 29  No Name #30670
 Calc.
Raw		 151.66
125.50		 19.12
13.00		 82.40
98.33		 0.00 253.18
 29  No Name #3505
 Calc.
Raw		 155.89
129.00		 19.60
13.33		 76.82
91.67		 0.00 252.31
 30  No Name #10720
 Calc.
Raw		 164.95
136.50		 23.03
15.66		 66.20
79.00		 2.00 252.18
 31  No Name #30424
 Calc.
Raw		 125.68
104.00		 29.41
20.00		 95.81
114.33		 0.00 250.90
 32  No Name #32136
 Calc.
Raw		 135.05
111.75		 33.84
23.01		 95.95
114.50		 17.00 247.84
 33  No Name #1386
 Calc.
Raw		 126.59
104.75		 20.10
13.67		 89.94
107.33		 0.00 236.63
 34  No Name #32450
 Calc.
Raw		 154.08
127.50		 19.62
13.34		 90.23
107.67		 30.00 233.93
 35  No Name #23612
 Calc.
Raw		 121.75
100.75		 16.18
11.00		 95.81
114.33		 3.00 230.74
 36  No Name #35058
 Calc.
Raw		 126.59
104.75		 23.51
15.99		 78.50
93.67		 2.00 226.60
 36  No Name #34263
 Calc.
Raw		 133.53
110.50		 17.66
12.01		 76.26
91.00		 1.00 226.45
 37  No Name #2628
 Calc.
Raw		 150.76
124.75		 12.26
8.34		 61.45
73.33		 0.00 224.47
 38  No Name #22248
 Calc.
Raw		 129.61
107.25		 12.75
8.67		 79.33
94.67		 0.00 221.69
 39  No Name #33345
 Calc.
Raw		 114.50
94.75		 16.66
11.33		 86.59
103.33		 0.00 217.75
 40  No Name #3117
 Calc.
Raw		 146.53
121.25		 13.72
9.33		 53.91
64.33		 0.00 214.16
 41  No Name #34604
 Calc.
Raw		 124.77
103.25		 11.76
8.00		 72.91
87.00		 0.00 209.44
 42  No Name #8903
 Calc.
Raw		 110.57
91.50		 12.25
8.33		 97.21
116.00		 15.00 205.03
 43  No Name #33187
 Calc.
Raw		 93.66
77.50		 16.68
11.34		 90.60
108.11		 10.00 190.94
 44  No Name #497
 Calc.
Raw		 110.57
91.50		 13.24
9.00		 65.64
78.33		 0.00 189.45
 45  No Name #29084
 Calc.
Raw		 127.49
105.50		 12.75
8.67		 46.37
55.33		 0.00 186.61
 46  No Name #16610
 Calc.
Raw		 112.39
93.00		 17.65
12.00		 57.82
69.00		 20.00 167.86