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 2 The Large And Small Of It Division II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #28547
 Calc.
Raw		 183.85
148.00		 41.40
36.99		 100.00
107.33		 0.00 325.25
 1  No Name #322
 Calc.
Raw		 200.00
161.00		 50.00
44.67		 74.84
80.33		 0.00 324.84
 2  No Name #9745
 Calc.
Raw		 186.96
150.50		 44.03
39.34		 87.58
94.00		 0.00 318.57
 3  No Name #32490
 Calc.
Raw		 195.03
157.00		 45.89
41.00		 75.16
80.67		 0.00 316.08
 4  No Name #18227
 Calc.
Raw		 181.99
146.50		 39.56
35.34		 86.65
93.00		 0.00 308.20
 5  No Name #36480
 Calc.
Raw		 179.50
144.50		 38.43
34.33		 84.48
90.67		 0.00 302.41
 6  No Name #22311
 Calc.
Raw		 154.04
124.00		 41.03
36.66		 100.00
107.33		 0.00 295.07
 6  No Name #6538
 Calc.
Raw		 188.82
152.00		 41.78
37.33		 63.66
68.33		 0.00 294.26
 7  No Name #33591
 Calc.
Raw		 162.11
130.50		 35.82
32.00		 91.31
98.00		 0.00 289.24
 8  No Name #32663
 Calc.
Raw		 183.85
148.00		 30.97
27.67		 69.88
75.00		 0.00 284.70
 9  No Name #1386
 Calc.
Raw		 175.16
141.00		 39.56
35.34		 63.66
68.33		 0.00 278.38
 10  No Name #32289
 Calc.
Raw		 175.16
141.00		 32.09
28.67		 67.39
72.33		 0.00 274.64
 11  No Name #12320
 Calc.
Raw		 148.45
119.50		 31.34
28.00		 92.86
99.67		 0.00 272.65
 12  No Name #31230
 Calc.
Raw		 156.52
126.00		 38.06
34.00		 75.47
81.00		 0.00 270.05
 13  No Name #28348
 Calc.
Raw		 152.17
122.50		 26.85
23.99		 87.27
93.67		 0.00 266.29
 13  No Name #17625
 Calc.
Raw		 165.84
133.50		 36.56
32.66		 63.66
68.33		 0.00 266.06
 13  No Name #34175
 Calc.
Raw		 147.20
118.50		 34.32
30.66		 84.48
90.67		 0.00 266.00
 14  No Name #17182
 Calc.
Raw		 150.31
121.00		 28.35
25.33		 76.09
81.67		 0.00 254.75
 14  No Name #31374
 Calc.
Raw		 163.35
131.50		 29.85
26.67		 61.49
66.00		 0.00 254.69
 14  No Name #35493
 Calc.
Raw		 152.80
123.00		 31.34
28.00		 70.50
75.67		 0.00 254.64
 15  No Name #37161
 Calc.
Raw		 154.66
124.50		 29.10
26.00		 68.32
73.33		 0.00 252.08
 15  No Name #33946
 Calc.
Raw		 167.70
135.00		 33.21
29.67		 50.62
54.33		 0.00 251.53
 15  No Name #1715
 Calc.
Raw		 132.30
106.50		 29.47
26.33		 89.75
96.33		 0.00 251.52
 16  No Name #33790
 Calc.
Raw		 154.04
124.00		 30.22
27.00		 66.78
71.67		 0.00 251.04
 17  No Name #32323
 Calc.
Raw		 135.40
109.00		 33.21
29.67		 80.43
86.33		 0.00 249.04
 18  No Name #2271
 Calc.
Raw		 129.19
104.00		 32.46
29.00		 77.96
83.67		 0.00 239.61
 19  No Name #34281
 Calc.
Raw		 144.10
116.00		 34.70
31.00		 59.00
63.33		 0.00 237.80
 19  No Name #2464
 Calc.
Raw		 139.75
112.50		 26.11
23.33		 71.43
76.67		 0.00 237.29
 19  No Name #5816
 Calc.
Raw		 147.83
119.00		 33.58
30.00		 55.59
59.67		 0.00 237.00
 20  No Name #11901
 Calc.
Raw		 127.33
102.50		 33.20
29.66		 65.84
70.67		 0.00 226.37
 20  No Name #16375
 Calc.
Raw		 127.95
103.00		 30.60
27.34		 67.71
72.67		 0.00 226.26
 21  No Name #37039
 Calc.
Raw		 137.27
110.50		 25.76
23.01		 54.35
58.33		 0.00 217.38
 21  No Name #31161
 Calc.
Raw		 113.66
91.50		 26.86
24.00		 76.40
82.00		 0.00 216.92
 22  No Name #28378
 Calc.
Raw		 135.40
109.00		 26.49
23.67		 54.35
58.33		 0.00 216.24
 23  No Name #35548
 Calc.
Raw		 124.22
100.00		 25.37
22.67		 57.46
61.67		 0.00 207.05
 24  No Name #29564
 Calc.
Raw		 127.33
102.50		 24.99
22.33		 50.62
54.33		 0.00 202.94
 24  No Name #31164
 Calc.
Raw		 120.50
97.00		 25.36
22.66		 56.53
60.67		 0.00 202.39
 25  No Name #15824
 Calc.
Raw		 122.36
98.50		 22.39
20.00		 57.77
62.00		 1.00 201.52
 25  No Name #16372
 Calc.
Raw		 118.01
95.00		 27.61
24.67		 55.59
59.67		 0.00 201.21
 26  No Name #1722
 Calc.
Raw		 122.36
98.50		 23.88
21.33		 53.73
57.67		 0.00 199.97
 27  No Name #36211
 Calc.
Raw		 115.53
93.00		 30.59
27.33		 51.87
55.67		 0.00 197.99
 28  No Name #1140
 Calc.
Raw		 93.17
75.00		 20.52
18.33		 80.75
86.67		 0.00 194.44
 28  No Name #8704
 Calc.
Raw		 104.97
84.50		 22.76
20.33		 66.46
71.33		 0.00 194.19
 29  No Name #36496
 Calc.
Raw		 107.45
86.50		 28.73
25.67		 48.76
52.33		 0.00 184.94
 30  No Name #32252
 Calc.
Raw		 86.96
70.00		 30.97
27.67		 67.08
72.00		 2.00 183.01
 31  No Name #20480
 Calc.
Raw		 80.75
65.00		 23.51
21.00		 56.53
60.67		 0.00 160.79
 32  No Name #35698
 Calc.
Raw		 77.02
62.00		 20.52
18.33		 56.21
60.33		 0.00 153.75
 33  No Name #34082
 Calc.
Raw		 90.68
73.00		 21.27
19.00		 55.90
60.00		 20.00 147.85
 34  No Name #33846
 Calc.
Raw		 95.65
77.00		 17.54
15.67		 31.37
33.67		 0.00 144.56
 35  No Name #2437
 Calc.
Raw		 44.72
36.00		 16.79
15.00		 50.62
54.33		 0.00 112.13