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 3 Around The World In 8 Minutes Division I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #19400
 Calc.
Raw		 200.00
149.25		 46.68
37.34		 67.24
65.67		 0.00 313.92
 2  No Name #36848
 Calc.
Raw		 200.00
149.25		 43.75
35.00		 56.31
55.00		 0.00 300.06
 3  No Name #5494
 Calc.
Raw		 192.96
144.00		 43.32
34.66		 59.05
57.67		 0.00 295.33
 4  No Name #36233
 Calc.
Raw		 198.32
148.00		 48.75
39.00		 46.76
45.67		 0.00 293.83
 5  No Name #603
 Calc.
Raw		 183.25
136.75		 33.76
27.01		 75.43
73.67		 0.00 292.44
 6  No Name #9692
 Calc.
Raw		 193.30
144.25		 39.17
31.34		 54.95
53.67		 0.00 287.42
 6  No Name #34220
 Calc.
Raw		 178.22
133.00		 47.91
38.33		 61.77
60.33		 1.00 286.90
 7  No Name #2770
 Calc.
Raw		 187.60
140.00		 45.84
36.67		 49.48
48.33		 0.00 282.92
 7  No Name #6428
 Calc.
Raw		 186.60
139.25		 39.17
31.34		 56.31
55.00		 0.00 282.08
 8  No Name #1839
 Calc.
Raw		 157.12
117.25		 24.57
19.66		 100.00
97.67		 0.00 281.69
 8  No Name #36902
 Calc.
Raw		 177.89
132.75		 44.18
35.34		 59.05
57.67		 0.00 281.12
 9  No Name #36027
 Calc.
Raw		 181.24
135.25		 39.17
31.34		 61.09
59.67		 3.00 278.50
 10  No Name #25994
 Calc.
Raw		 184.25
137.50		 40.84
32.67		 50.85
49.67		 0.00 275.94
 10  No Name #36489
 Calc.
Raw		 178.89
133.50		 50.00
40.00		 46.76
45.67		 0.00 275.65
 11  No Name #6771
 Calc.
Raw		 184.25
137.50		 42.07
33.66		 48.12
47.00		 0.00 274.44
 11  No Name #36769
 Calc.
Raw		 156.11
116.50		 36.67
29.34		 80.88
79.00		 0.00 273.66
 12  No Name #1178
 Calc.
Raw		 173.53
129.50		 42.50
34.00		 54.95
53.67		 0.00 270.98
 13  No Name #33665
 Calc.
Raw		 182.91
136.50		 42.91
34.33		 44.03
43.00		 0.00 269.85
 13  No Name #31960
 Calc.
Raw		 178.22
133.00		 37.08
29.66		 53.58
52.33		 0.00 268.88
 14  No Name #33883
 Calc.
Raw		 177.55
132.50		 42.91
34.33		 50.85
49.67		 5.00 266.31
 15  No Name #34691
 Calc.
Raw		 174.87
130.50		 35.00
28.00		 54.95
53.67		 0.00 264.82
 16  No Name #729
 Calc.
Raw		 181.91
135.75		 33.75
27.00		 48.12
47.00		 0.00 263.78
 16  No Name #26609
 Calc.
Raw		 172.86
129.00		 35.00
28.00		 54.95
53.67		 0.00 262.81
 17  No Name #30532
 Calc.
Raw		 181.24
135.25		 31.25
25.00		 49.48
48.33		 0.00 261.97
 17  No Name #31453
 Calc.
Raw		 184.25
137.50		 34.60
27.68		 42.66
41.67		 0.00 261.51
 17  No Name #5931
 Calc.
Raw		 170.52
127.25		 44.18
35.34		 46.76
45.67		 0.00 261.46
 17  No Name #35277
 Calc.
Raw		 172.86
129.00		 42.93
34.34		 45.39
44.33		 0.00 261.18
 17  No Name #34601
 Calc.
Raw		 164.82
123.00		 35.83
28.66		 60.41
59.00		 0.00 261.06
 18  No Name #28156
 Calc.
Raw		 161.81
120.75		 32.08
25.66		 65.86
64.33		 0.00 259.75
 18  No Name #2432
 Calc.
Raw		 179.23
133.75		 35.00
28.00		 45.39
44.33		 0.00 259.62
 18  No Name #36446
 Calc.
Raw		 168.84
126.00		 33.75
27.00		 56.31
55.00		 0.00 258.90
 19  No Name #37163
 Calc.
Raw		 172.19
128.50		 38.76
31.01		 47.10
46.00		 0.00 258.05
 20  No Name #11781
 Calc.
Raw		 168.51
125.75		 32.91
26.33		 54.95
53.67		 0.00 256.37
 20  No Name #17174
 Calc.
Raw		 170.18
127.00		 42.07
33.66		 44.03
43.00		 0.00 256.28
 20  No Name #31659
 Calc.
Raw		 172.53
128.75		 41.66
33.33		 42.66
41.67		 1.00 255.85
 21  No Name #36050
 Calc.
Raw		 167.84
125.25		 37.06
29.65		 49.48
48.33		 0.00 254.38
 21  No Name #37102
 Calc.
Raw		 175.88
131.25		 31.66
25.33		 46.76
45.67		 0.00 254.30
 22  No Name #31210
 Calc.
Raw		 168.17
125.50		 35.83
28.66		 46.76
45.67		 0.00 250.76
 23  No Name #4087
 Calc.
Raw		 167.17
124.75		 35.83
28.66		 46.76
45.67		 0.00 249.76
 23  No Name #30595
 Calc.
Raw		 173.87
129.75		 29.59
23.67		 45.39
44.33		 0.00 248.85
 24  No Name #21059
 Calc.
Raw		 148.41
110.75		 33.75
27.00		 65.86
64.33		 0.00 248.02
 24  No Name #23371
 Calc.
Raw		 173.20
129.25		 34.17
27.34		 39.93
39.00		 0.00 247.30
 25  No Name #739
 Calc.
Raw		 172.19
128.50		 32.08
25.66		 42.66
41.67		 0.00 246.93
 25  No Name #18527
 Calc.
Raw		 161.14
120.25		 30.82
24.66		 54.95
53.67		 0.00 246.91
 26  No Name #237
 Calc.
Raw		 166.50
124.25		 31.25
25.00		 48.12
47.00		 0.00 245.87
 27  No Name #33824
 Calc.
Raw		 163.82
122.25		 30.82
24.66		 48.12
47.00		 0.00 242.76
 27  No Name #27653
 Calc.
Raw		 152.09
113.50		 35.41
28.33		 54.95
53.67		 0.00 242.45
 28  No Name #35737
 Calc.
Raw		 160.47
119.75		 38.33
30.66		 42.66
41.67		 0.00 241.46
 28  No Name #32772
 Calc.
Raw		 157.79
117.75		 32.08
25.66		 50.85
49.67		 0.00 240.72
 29  No Name #35714
 Calc.
Raw		 161.81
120.75		 32.50
26.00		 42.66
41.67		 0.00 236.97
 30  No Name #2771
 Calc.
Raw		 160.47
119.75		 32.91
26.33		 41.29
40.33		 0.00 234.67
 30  No Name #36827
 Calc.
Raw		 163.15
121.75		 22.91
18.33		 48.12
47.00		 0.00 234.18
 31  No Name #33246
 Calc.
Raw		 161.47
120.50		 32.50
26.00		 38.57
37.67		 0.00 232.54
 32  No Name #3390
 Calc.
Raw		 154.44
115.25		 28.76
23.01		 48.12
47.00		 0.00 231.32
 32  No Name #5128
 Calc.
Raw		 145.73
108.75		 29.16
23.33		 56.31
55.00		 0.00 231.20
 32  No Name #35327
 Calc.
Raw		 156.11
116.50		 29.59
23.67		 45.39
44.33		 0.00 231.09
 33  No Name #4538
 Calc.
Raw		 150.42
112.25		 30.84
24.67		 46.76
45.67		 0.00 228.02
 33  No Name #33381
 Calc.
Raw		 146.73
109.50		 32.50
26.00		 48.46
47.33		 0.00 227.69
 33  No Name #35511
 Calc.
Raw		 143.05
106.75		 29.59
23.67		 54.95
53.67		 0.00 227.59
 33  No Name #13631
 Calc.
Raw		 145.73
108.75		 38.75
31.00		 42.66
41.67		 0.00 227.14
 34  No Name #30867
 Calc.
Raw		 151.76
113.25		 31.66
25.33		 44.03
43.00		 3.00 224.45
 35  No Name #18035
 Calc.
Raw		 146.06
109.00		 34.16
27.33		 41.29
40.33		 0.00 221.51
 36  No Name #34370
 Calc.
Raw		 135.01
100.75		 24.59
19.67		 53.58
52.33		 0.00 213.18
 37  No Name #8704
 Calc.
Raw		 128.98
96.25		 25.41
20.33		 54.95
53.67		 0.00 209.34
 37  No Name #6161
 Calc.
Raw		 138.69
103.50		 27.51
22.01		 42.66
41.67		 0.00 208.86
 38  No Name #36534
 Calc.
Raw		 147.40
110.00		 26.66
21.33		 35.83
35.00		 3.00 206.89
   No Name #35869
 Calc.
Raw		 0.00
0.00		 0.00
0.00		 0.00
0.00		 0.00 0.00