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 2006 May 24th
 Problem 1 The Great Parade Division I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #9108
 Calc.
Raw		 200.00
151.99		 50.00
31.34		 54.15
55.50		 0.00 304.15
 2  No Name #5462
 Calc.
Raw		 137.71
104.65		 40.43
25.34		 83.90
86.00		 0.00 262.04
 3  No Name #1436
 Calc.
Raw		 171.95
130.67		 32.45
20.34		 40.73
41.75		 0.00 245.13
 4  No Name #2271
 Calc.
Raw		 135.10
102.67		 23.39
14.66		 84.63
86.75		 0.00 243.12
 4  No Name #32735
 Calc.
Raw		 139.48
106.00		 35.11
22.01		 68.29
70.00		 0.00 242.88
 5  No Name #29543
 Calc.
Raw		 128.07
97.33		 42.55
26.67		 66.83
68.50		 0.00 237.45
 6  No Name #16465
 Calc.
Raw		 129.39
98.33		 22.89
14.35		 83.66
85.75		 0.00 235.94
 7  No Name #1010
 Calc.
Raw		 136.39
103.65		 32.43
20.33		 62.68
64.25		 0.00 231.50
 8  No Name #17473
 Calc.
Raw		 164.04
124.66		 47.34
29.67		 18.29
18.75		 0.00 229.67
 9  No Name #33957
 Calc.
Raw		 110.53
84.00		 25.53
16.00		 91.46
93.75		 0.00 227.52
 10  No Name #28072
 Calc.
Raw		 87.69
66.64		 35.64
22.34		 100.00
102.50		 1.00 222.33
 11  No Name #4645
 Calc.
Raw		 111.84
84.99		 40.95
25.67		 67.56
69.25		 0.00 220.35
 12  No Name #1164
 Calc.
Raw		 130.73
99.35		 38.82
24.33		 45.61
46.75		 0.00 215.16
 13  No Name #22144
 Calc.
Raw		 129.84
98.67		 44.67
28.00		 37.07
38.00		 0.00 211.58
 14  No Name #45
 Calc.
Raw		 132.04
100.34		 36.17
22.67		 37.32
38.25		 1.00 204.53
 15  No Name #35587
 Calc.
Raw		 105.70
80.33		 31.92
20.01		 64.15
65.75		 0.00 201.77
 16  No Name #32163
 Calc.
Raw		 113.61
86.34		 36.69
23.00		 44.39
45.50		 0.00 194.69
 17  No Name #35277
 Calc.
Raw		 95.61
72.66		 14.89
9.33		 82.44
84.50		 0.00 192.94
 18  No Name #25057
 Calc.
Raw		 126.34
96.01		 40.41
25.33		 22.20
22.75		 0.00 188.95
 18  No Name #31535
 Calc.
Raw		 109.23
83.01		 41.48
26.00		 42.93
44.00		 5.00 188.64
 19  No Name #14032
 Calc.
Raw		 117.11
89.00		 29.24
18.33		 41.22
42.25		 0.00 187.57
 19  No Name #32425
 Calc.
Raw		 127.67
97.02		 43.08
27.00		 16.10
16.50		 0.00 186.85
 20  No Name #33282
 Calc.
Raw		 103.95
79.00		 30.31
19.00		 52.20
53.50		 0.00 186.46
 21  No Name #569
 Calc.
Raw		 99.57
75.67		 22.35
14.01		 60.49
62.00		 0.00 182.41
 22  No Name #30841
 Calc.
Raw		 118.43
90.00		 34.05
21.34		 26.59
27.25		 0.00 179.07
 23  No Name #13391
 Calc.
Raw		 118.86
90.33		 29.24
18.33		 29.76
30.50		 0.00 177.86
 23  No Name #34804
 Calc.
Raw		 114.94
87.35		 42.55
26.67		 19.76
20.25		 0.00 177.25
 24  No Name #33665
 Calc.
Raw		 116.23
88.33		 41.48
26.00		 17.56
18.00		 0.00 175.27
 25  No Name #15746
 Calc.
Raw		 79.40
60.34		 26.60
16.67		 67.80
69.50		 0.00 173.80
 26  No Name #5728
 Calc.
Raw		 131.15
99.67		 32.43
20.33		 4.88
5.00		 0.00 168.46
 26  No Name #34242
 Calc.
Raw		 104.85
79.68		 16.48
10.33		 46.34
47.50		 0.00 167.67
 27  No Name #35727
 Calc.
Raw		 100.02
76.01		 22.34
14.00		 47.32
48.50		 3.00 166.68
 28  No Name #23365
 Calc.
Raw		 93.85
71.32		 44.13
27.66		 26.34
27.00		 0.00 164.32
 28  No Name #35570
 Calc.
Raw		 120.61
91.66		 26.07
16.34		 17.56
18.00		 0.00 164.24
 28  No Name #34320
 Calc.
Raw		 111.39
84.65		 23.40
14.67		 28.54
29.25		 0.00 163.33
 29  No Name #20522
 Calc.
Raw		 98.70
75.01		 44.14
27.67		 16.59
17.00		 0.00 159.43
 29  No Name #30598
 Calc.
Raw		 121.93
92.66		 28.72
18.00		 8.05
8.25		 0.00 158.70
 29  No Name #33246
 Calc.
Raw		 120.61
91.66		 21.28
13.34		 16.59
17.00		 0.00 158.48
 30  No Name #24450
 Calc.
Raw		 111.42
84.67		 30.86
19.34		 15.85
16.25		 0.00 158.13
 30  No Name #20797
 Calc.
Raw		 129.82
98.66		 20.21
12.67		 8.05
8.25		 0.00 158.08
 31  No Name #24819
 Calc.
Raw		 89.93
68.34		 26.58
16.66		 39.76
40.75		 5.00 151.27
 31  No Name #21969
 Calc.
Raw		 104.85
79.68		 30.84
19.33		 15.37
15.75		 0.00 151.06
 32  No Name #30889
 Calc.
Raw		 84.62
64.31		 26.08
16.35		 38.05
39.00		 0.00 148.75
 32  No Name #2481
 Calc.
Raw		 83.35
63.34		 36.17
22.67		 28.29
29.00		 0.00 147.81
 33  No Name #35602
 Calc.
Raw		 116.22
88.32		 14.36
9.00		 21.22
21.75		 6.00 145.80
 34  No Name #9358
 Calc.
Raw		 106.15
80.67		 21.27
13.33		 14.88
15.25		 0.00 142.30
 34  No Name #2770
 Calc.
Raw		 106.11
80.64		 24.47
15.34		 10.73
11.00		 0.00 141.31
 35  No Name #3390
 Calc.
Raw		 68.43
52.00		 30.86
19.34		 38.05
39.00		 0.00 137.34
 35  No Name #35138
 Calc.
Raw		 88.16
67.00		 29.26
18.34		 19.27
19.75		 0.00 136.69
 36  No Name #35146
 Calc.
Raw		 85.10
64.67		 34.57
21.67		 15.61
16.00		 0.00 135.28
 37  No Name #22905
 Calc.
Raw		 91.24
69.34		 21.27
13.33		 20.98
21.50		 0.00 133.49
 38  No Name #25354
 Calc.
Raw		 84.68
64.35		 20.21
12.67		 26.83
27.50		 0.00 131.72
 39  No Name #25085
 Calc.
Raw		 73.70
56.01		 26.60
16.67		 28.54
29.25		 0.00 128.84
 40  No Name #3422
 Calc.
Raw		 83.31
63.31		 26.58
16.66		 17.07
17.50		 5.00 121.96
 41  No Name #12534
 Calc.
Raw		 75.89
57.67		 21.83
13.68		 19.51
20.00		 0.00 117.23
 42  No Name #19826
 Calc.
Raw		 85.52
64.99		 21.81
13.67		 6.83
7.00		 0.00 114.16
 43  No Name #23774
 Calc.
Raw		 67.56
51.34		 30.84
19.33		 19.27
19.75		 5.00 112.67
 44  No Name #1859
 Calc.
Raw		 77.20
58.67		 16.48
10.33		 13.66
14.00		 0.00 107.34
 45  No Name #34760
 Calc.
Raw		 55.27
42.00		 27.66
17.34		 17.32
17.75		 0.00 100.25