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 4 Tee Structure Division III
 Rank   Member    Long
Term		  Weight  Style  Spont  Penalty  Total
 1  No Name #2149
 Calc.
Raw		 192.12
41.00		 150.00
1190.00		 33.19
26.33		 90.20
135.75		 5.00 310.51
 2  No Name #37774
 Calc.
Raw		 136.53
43.33		 92.02
730.00		 34.03
27.00		 99.67
150.00		 0.00 270.23
 3  No Name #37802
 Calc.
Raw		 128.38
47.67		 79.41
630.00		 31.93
25.33		 93.02
140.00		 0.00 253.33
 4  No Name #3887
 Calc.
Raw		 111.26
46.33		 63.66
505.00		 44.96
35.67		 93.85
141.25		 0.00 250.07
 5  No Name #6905
 Calc.
Raw		 108.90
33.00		 75.00
595.00		 42.85
34.00		 91.20
137.25		 0.00 242.95
 5  No Name #2130
 Calc.
Raw		 107.84
43.00		 63.66
505.00		 49.57
39.33		 90.53
136.25		 5.00 242.94
 6  No Name #11102
 Calc.
Raw		 115.96
46.00		 68.70
545.00		 38.66
30.67		 87.21
131.25		 0.00 241.83
 7  No Name #18029
 Calc.
Raw		 103.99
42.33		 60.50
480.00		 38.23
30.33		 97.67
147.00		 0.00 239.89
 8  No Name #3260
 Calc.
Raw		 88.33
32.00		 55.46
440.00		 47.05
37.33		 95.51
143.75		 0.00 230.89
 9  No Name #37630
 Calc.
Raw		 99.28
46.33		 51.68
410.00		 27.31
21.67		 97.34
146.50		 0.00 223.93
 9  No Name #3637
 Calc.
Raw		 84.91
44.00		 39.71
315.00		 43.70
34.67		 94.35
142.00		 0.00 222.96
 10  No Name #34606
 Calc.
Raw		 78.43
45.67		 31.51
250.00		 50.00
39.67		 90.20
135.75		 0.00 218.63
 10  No Name #3694
 Calc.
Raw		 87.44
40.33		 46.01
365.00		 42.01
33.33		 88.87
133.75		 0.00 218.32
 11  No Name #15515
 Calc.
Raw		 95.70
37.33		 57.35
455.00		 24.36
19.33		 97.01
146.00		 0.00 217.07
 11  No Name #32868
 Calc.
Raw		 92.64
30.67		 61.13
485.00		 31.09
24.67		 92.36
139.00		 0.00 216.09
 12  No Name #32995
 Calc.
Raw		 73.95
48.67		 23.95
190.00		 38.23
30.33		 94.68
142.50		 0.00 206.86
 12  No Name #37857
 Calc.
Raw		 81.28
34.33		 46.01
365.00		 36.55
29.00		 88.21
132.75		 0.00 206.04
 13  No Name #32969
 Calc.
Raw		 70.65
39.33		 30.25
240.00		 44.11
35.00		 88.21
132.75		 0.00 202.97
 13  No Name #26200
 Calc.
Raw		 78.32
29.00		 48.53
385.00		 36.97
29.33		 87.21
131.25		 0.00 202.50
 14  No Name #35739
 Calc.
Raw		 70.43
25.00		 44.75
355.00		 43.27
34.33		 88.21
132.75		 0.00 201.91
 15  No Name #32374
 Calc.
Raw		 68.66
38.00		 29.62
235.00		 37.81
30.00		 93.85
141.25		 0.00 200.32
 16  No Name #33422
 Calc.
Raw		 72.44
38.00		 33.40
265.00		 29.41
23.33		 93.85
141.25		 0.00 195.70
 17  No Name #34690
 Calc.
Raw		 69.53
33.33		 35.29
280.00		 31.51
25.00		 90.70
136.50		 0.00 191.74
 18  No Name #30951
 Calc.
Raw		 55.21
20.00		 34.66
275.00		 44.11
35.00		 89.70
135.00		 0.00 189.02
 19  No Name #36282
 Calc.
Raw		 53.31
39.00		 13.24
105.00		 41.59
33.00		 92.69
139.50		 0.00 187.59
 20  No Name #2660
 Calc.
Raw		 59.63
20.00		 39.08
310.00		 32.77
26.00		 88.37
133.00		 0.00 180.77
 20  No Name #33292
 Calc.
Raw		 59.05
20.67		 37.82
300.00		 26.47
21.00		 94.35
142.00		 0.00 179.87
 21  No Name #2701
 Calc.
Raw		 62.02
22.33		 39.08
310.00		 28.14
22.33		 88.04
132.50		 0.00 178.20
 22  No Name #17250
 Calc.
Raw		 51.77
20.33		 30.88
245.00		 29.83
23.67		 94.68
142.50		 0.00 176.28
 23  No Name #19945
 Calc.
Raw		 40.79
28.67		 11.34
90.00		 35.71
28.33		 95.02
143.00		 0.00 171.52
 24  No Name #17068
 Calc.
Raw		 60.94
20.67		 39.71
315.00		 20.58
16.33		 88.70
133.50		 0.00 170.22
 25  No Name #8871
 Calc.
Raw		 46.15
21.00		 24.58
195.00		 25.21
20.00		 97.01
146.00		 0.00 168.37
 25  No Name #3069
 Calc.
Raw		 44.67
33.67		 10.08
80.00		 34.03
27.00		 89.37
134.50		 0.00 168.07
 26  No Name #37863
 Calc.
Raw		 44.16
19.67		 23.95
190.00		 24.79
19.67		 98.34
148.00		 0.00 167.29
 27  No Name #2039
 Calc.
Raw		 37.33
21.00		 15.76
125.00		 33.19
26.33		 94.68
142.50		 0.00 165.20
 28  No Name #33992
 Calc.
Raw		 46.87
29.67		 16.39
130.00		 25.21
20.00		 91.20
137.25		 0.00 163.28
 28  No Name #20819
 Calc.
Raw		 44.41
42.00		 1.26
10.00		 23.10
18.33		 95.51
143.75		 0.00 163.02
 29  No Name #5736
 Calc.
Raw		 31.55
19.67		 11.34
90.00		 38.23
30.33		 90.37
136.00		 0.00 160.15
 30  No Name #35415
 Calc.
Raw		 43.23
23.67		 18.91
150.00		 20.58
16.33		 94.35
142.00		 0.00 158.16
 30  No Name #34922
 Calc.
Raw		 42.34
28.33		 13.24
105.00		 23.10
18.33		 92.19
138.75		 0.00 157.63
 31  No Name #29698
 Calc.
Raw		 47.30
35.00		 11.34
90.00		 19.32
15.33		 88.87
133.75		 0.00 155.49
 32  No Name #34351
 Calc.
Raw		 41.59
15.33		 25.84
205.00		 16.39
13.00		 96.51
145.25		 0.00 154.49
 32  No Name #37326
 Calc.
Raw		 34.54
17.67		 16.39
130.00		 27.73
22.00		 91.53
137.75		 0.00 153.80
 33  No Name #786
 Calc.
Raw		 30.36
28.33		 1.26
10.00		 26.88
21.33		 90.37
136.00		 0.00 147.61
 34  No Name #26319
 Calc.
Raw		 33.73
19.33		 13.87
110.00		 20.58
16.33		 89.04
134.00		 0.00 143.35
 35  No Name #1412
 Calc.
Raw		 24.62
19.67		 4.41
35.00		 15.97
12.67		 100.00
150.50		 0.00 140.59
 35  No Name #24409
 Calc.
Raw		 33.45
19.67		 13.24
105.00		 35.29
28.00		 71.43
107.50		 0.00 140.17
 36  No Name #33819
 Calc.
Raw		 24.38
20.67		 3.15
25.00		 22.69
18.00		 88.70
133.50		 0.00 135.77
 37  No Name #20499
 Calc.
Raw		 24.57
15.33		 8.82
70.00		 22.27
17.67		 85.71
129.00		 0.00 132.55
 38  No Name #31077
 Calc.
Raw		 29.34
15.67		 13.24
105.00		 17.23
13.67		 74.09
111.50		 0.00 120.66
 38  No Name #36490
 Calc.
Raw		 17.01
15.33		 1.26
10.00		 12.60
10.00		 90.70
136.50		 0.00 120.31
   No Name #3148
 Calc.
Raw		 0.00
0.00		 0.00
0.00		 0.00
0.00		 0.00
0.00		 0.00 0.00