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 1 Odyssey Road Rally Division II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #33956
 Calc.
Raw		 177.59
142.67		 39.67
32.00		 98.43
42.00		 0.00 315.69
 2  No Name #36233
 Calc.
Raw		 200.00
160.67		 41.74
33.67		 48.44
20.67		 0.00 290.18
 3  No Name #37198
 Calc.
Raw		 155.19
124.67		 30.99
25.00		 100.00
42.67		 0.00 286.18
 4  No Name #2464
 Calc.
Raw		 143.16
115.01		 38.43
31.00		 96.86
41.33		 0.00 278.45
 5  No Name #789
 Calc.
Raw		 181.34
145.68		 30.99
25.00		 49.99
21.33		 0.00 262.32
 6  No Name #35548
 Calc.
Raw		 184.65
148.34		 31.40
25.33		 42.18
18.00		 0.00 258.23
 7  No Name #34754
 Calc.
Raw		 169.94
136.52		 46.28
37.33		 35.15
15.00		 0.00 251.37
 7  No Name #820
 Calc.
Raw		 180.48
144.99		 42.56
34.33		 27.35
11.67		 0.00 250.39
 8  No Name #1375
 Calc.
Raw		 125.33
100.68		 38.02
30.67		 88.28
37.67		 2.00 249.63
 9  No Name #37306
 Calc.
Raw		 126.98
102.01		 26.44
21.33		 94.52
40.33		 0.00 247.94
 10  No Name #29469
 Calc.
Raw		 161.83
130.01		 49.18
39.67		 33.58
14.33		 0.00 244.59
 11  No Name #17625
 Calc.
Raw		 169.08
135.83		 32.23
26.00		 42.18
18.00		 0.00 243.49
 12  No Name #1386
 Calc.
Raw		 154.35
124.00		 41.32
33.33		 48.44
20.67		 3.00 241.11
 12  No Name #17473
 Calc.
Raw		 170.13
136.67		 43.80
35.33		 26.55
11.33		 0.00 240.48
 13  No Name #14485
 Calc.
Raw		 168.88
135.67		 36.78
29.67		 34.38
14.67		 0.00 240.04
 13  No Name #25443
 Calc.
Raw		 166.79
133.99		 35.54
28.67		 37.50
16.00		 0.00 239.83
 13  No Name #30680
 Calc.
Raw		 171.37
137.67		 30.59
24.67		 37.50
16.00		 0.00 239.46
 14  No Name #36468
 Calc.
Raw		 166.81
134.01		 50.00
40.33		 21.09
9.00		 0.00 237.90
 15  No Name #36145
 Calc.
Raw		 149.15
119.82		 37.60
30.33		 44.53
19.00		 0.00 231.28
 15  No Name #30603
 Calc.
Raw		 167.22
134.34		 26.44
21.33		 37.50
16.00		 0.00 231.16
 16  No Name #22841
 Calc.
Raw		 158.09
127.00		 40.50
32.67		 29.69
12.67		 0.00 228.28
 17  No Name #35493
 Calc.
Raw		 158.49
127.32		 37.19
30.00		 30.47
13.00		 0.00 226.15
 17  No Name #37097
 Calc.
Raw		 174.89
140.50		 21.49
17.33		 29.69
12.67		 0.00 226.07
 18  No Name #36617
 Calc.
Raw		 99.99
80.33		 26.04
21.00		 97.66
41.67		 2.00 221.69
 19  No Name #35714
 Calc.
Raw		 155.59
124.99		 42.15
34.00		 21.87
9.33		 0.00 219.61
 20  No Name #11901
 Calc.
Raw		 160.55
128.98		 36.36
29.33		 23.44
10.00		 2.00 218.35
 20  No Name #35507
 Calc.
Raw		 157.25
126.33		 31.40
25.33		 28.90
12.33		 0.00 217.55
 21  No Name #11548
 Calc.
Raw		 152.27
122.33		 35.95
29.00		 28.12
12.00		 0.00 216.34
 22  No Name #35154
 Calc.
Raw		 135.26
108.66		 35.95
29.00		 44.53
19.00		 1.00 214.74
 23  No Name #37318
 Calc.
Raw		 146.46
117.66		 33.47
27.00		 28.90
12.33		 0.00 208.83
 24  No Name #34698
 Calc.
Raw		 137.34
110.33		 36.36
29.33		 32.04
13.67		 0.00 205.74
 25  No Name #35896
 Calc.
Raw		 149.37
120.00		 35.12
28.33		 17.18
7.33		 0.00 201.67
 25  No Name #37039
 Calc.
Raw		 158.29
127.16		 28.92
23.33		 16.40
7.00		 2.00 201.61
 26  No Name #35542
 Calc.
Raw		 112.85
90.66		 28.51
23.00		 57.82
24.67		 0.00 199.18
 26  No Name #35212
 Calc.
Raw		 123.66
99.34		 23.56
19.00		 51.56
22.00		 0.00 198.78
 27  No Name #33986
 Calc.
Raw		 142.15
114.20		 30.99
25.00		 28.90
12.33		 5.00 197.04
 28  No Name #34983
 Calc.
Raw		 98.34
79.00		 25.20
20.33		 71.88
30.67		 0.00 195.42
 29  No Name #1722
 Calc.
Raw		 146.03
117.31		 23.56
19.00		 24.21
10.33		 0.00 193.80
 29  No Name #20480
 Calc.
Raw		 137.35
110.34		 34.71
28.00		 21.09
9.00		 0.00 193.15
 30  No Name #37388
 Calc.
Raw		 102.06
81.99		 22.73
18.33		 67.19
28.67		 0.00 191.98
 31  No Name #31293
 Calc.
Raw		 146.05
117.33		 15.71
12.67		 28.90
12.33		 0.00 190.66
 31  No Name #36148
 Calc.
Raw		 123.66
99.34		 37.19
30.00		 29.69
12.67		 0.00 190.54
 32  No Name #19264
 Calc.
Raw		 133.62
107.34		 10.33
8.33		 49.21
21.00		 5.00 188.16
 32  No Name #5993
 Calc.
Raw		 127.79
102.66		 28.92
23.33		 31.24
13.33		 0.00 187.95
 32  No Name #36541
 Calc.
Raw		 136.94
110.01		 33.88
27.33		 21.09
9.00		 4.00 187.91
 33  No Name #2395
 Calc.
Raw		 135.28
108.68		 33.06
26.67		 17.98
7.67		 0.00 186.32
 34  No Name #35471
 Calc.
Raw		 131.11
105.33		 30.99
25.00		 22.66
9.67		 0.00 184.76
 35  No Name #13568
 Calc.
Raw		 133.39
107.16		 20.67
16.67		 28.12
12.00		 0.00 182.18
 35  No Name #16088
 Calc.
Raw		 119.49
95.99		 33.06
26.67		 28.90
12.33		 0.00 181.45
 36  No Name #26609
 Calc.
Raw		 132.36
106.33		 27.27
22.00		 20.32
8.67		 0.00 179.95
 36  No Name #36971
 Calc.
Raw		 125.71
100.99		 17.77
14.33		 35.93
15.33		 0.00 179.41
 37  No Name #17135
 Calc.
Raw		 102.92
82.68		 28.92
23.33		 46.10
19.67		 0.00 177.94
 38  No Name #37094
 Calc.
Raw		 119.08
95.66		 24.80
20.00		 35.15
15.00		 6.00 173.03
 39  No Name #36643
 Calc.
Raw		 127.19
102.18		 28.51
23.00		 19.52
8.33		 4.00 171.22
 40  No Name #4085
 Calc.
Raw		 119.92
96.34		 21.08
17.00		 25.78
11.00		 5.00 161.78
 40  No Name #37478
 Calc.
Raw		 110.15
88.49		 27.68
22.33		 23.44
10.00		 0.00 161.27
 41  No Name #37206
 Calc.
Raw		 96.68
77.67		 12.81
10.33		 27.35
11.67		 0.00 136.84
 42  No Name #37176
 Calc.
Raw		 47.30
38.00		 19.01
15.33		 37.50
16.00		 0.00 103.81
 43  No Name #37316
 Calc.
Raw		 53.94
43.33		 16.12
13.00		 26.55
11.33		 0.00 96.61