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 III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #18255
 Calc.
Raw		 200.00
159.33		 28.98
24.34		 79.53
68.00		 0.00 308.51
 2  No Name #33488
 Calc.
Raw		 166.11
132.33		 37.70
31.67		 100.00
85.50		 0.00 303.81
 3  No Name #9744
 Calc.
Raw		 176.15
140.33		 41.29
34.68		 74.27
63.50		 0.00 291.71
 4  No Name #27017
 Calc.
Raw		 187.03
149.00		 50.00
42.00		 29.24
25.00		 0.00 266.27
 5  No Name #35550
 Calc.
Raw		 167.36
133.33		 26.60
22.34		 71.05
60.75		 0.00 265.01
 6  No Name #26200
 Calc.
Raw		 165.68
131.99		 40.88
34.34		 56.43
48.25		 0.00 262.99
 7  No Name #9116
 Calc.
Raw		 182.01
145.00		 33.73
28.33		 44.15
37.75		 0.00 259.89
 8  No Name #291
 Calc.
Raw		 169.05
134.67		 32.15
27.01		 54.68
46.75		 0.00 255.88
 9  No Name #24553
 Calc.
Raw		 140.20
111.69		 41.27
34.67		 66.37
56.75		 0.00 247.84
 9  No Name #31230
 Calc.
Raw		 166.86
132.93		 38.50
32.34		 42.40
36.25		 0.00 247.76
 10  No Name #32441
 Calc.
Raw		 147.29
117.34		 38.11
32.01		 59.65
51.00		 0.00 245.05
 11  No Name #3887
 Calc.
Raw		 159.00
126.67		 32.94
27.67		 46.49
39.75		 0.00 238.43
 12  No Name #33516
 Calc.
Raw		 149.34
118.97		 30.95
26.00		 54.68
46.75		 0.00 234.97
 13  No Name #35901
 Calc.
Raw		 163.60
130.33		 19.85
16.67		 49.71
42.50		 0.00 233.16
 14  No Name #4307
 Calc.
Raw		 150.63
120.00		 35.32
29.67		 40.64
34.75		 0.00 226.59
 15  No Name #5730
 Calc.
Raw		 142.28
113.35		 25.81
21.68		 57.02
48.75		 0.00 225.11
 15  No Name #1149
 Calc.
Raw		 129.69
103.32		 40.08
33.67		 54.68
46.75		 0.00 224.45
 16  No Name #2215
 Calc.
Raw		 139.74
111.32		 25.80
21.67		 57.31
49.00		 0.00 222.85
 16  No Name #35621
 Calc.
Raw		 116.74
93.00		 30.15
25.33		 75.15
64.25		 0.00 222.04
 17  No Name #35824
 Calc.
Raw		 115.06
91.66		 23.40
19.66		 83.04
71.00		 0.00 221.50
 18  No Name #1412
 Calc.
Raw		 124.67
99.32		 21.42
17.99		 73.10
62.50		 0.00 219.19
 19  No Name #27336
 Calc.
Raw		 97.91
78.00		 30.15
25.33		 84.80
72.50		 0.00 212.86
 20  No Name #35509
 Calc.
Raw		 130.53
103.99		 34.92
29.33		 42.40
36.25		 0.00 207.85
 20  No Name #31161
 Calc.
Raw		 125.91
100.31		 18.64
15.66		 62.87
53.75		 0.00 207.42
 21  No Name #35880
 Calc.
Raw		 124.71
99.35		 36.12
30.34		 38.60
33.00		 0.00 199.43
 22  No Name #35430
 Calc.
Raw		 100.03
79.69		 16.65
13.99		 75.15
64.25		 0.00 191.83
 23  No Name #33323
 Calc.
Raw		 99.15
78.99		 29.37
24.67		 59.65
51.00		 0.00 188.17
 24  No Name #33986
 Calc.
Raw		 102.10
81.34		 38.50
32.34		 43.57
37.25		 0.00 184.17
 25  No Name #3047
 Calc.
Raw		 134.71
107.32		 23.42
19.67		 24.85
21.25		 0.00 182.98
 25  No Name #11392
 Calc.
Raw		 123.43
98.33		 14.29
12.00		 44.74
38.25		 0.00 182.46
 26  No Name #29482
 Calc.
Raw		 133.87
106.65		 24.21
20.34		 20.76
17.75		 0.00 178.84
 27  No Name #7975
 Calc.
Raw		 97.92
78.01		 26.20
22.01		 48.25
41.25		 0.00 172.37
 28  No Name #8888
 Calc.
Raw		 106.30
84.68		 22.21
18.66		 42.11
36.00		 0.00 170.62
 29  No Name #1386
 Calc.
Raw		 78.24
62.33		 29.76
25.00		 55.56
47.50		 0.00 163.56
 29  No Name #30595
 Calc.
Raw		 108.37
86.33		 24.61
20.67		 30.41
26.00		 0.00 163.39
 30  No Name #16610
 Calc.
Raw		 111.73
89.01		 26.58
22.33		 18.42
15.75		 0.00 156.73
 31  No Name #24436
 Calc.
Raw		 46.87
37.34		 19.05
16.00		 83.92
71.75		 0.00 149.84
 32  No Name #11753
 Calc.
Raw		 81.99
65.32		 17.86
15.00		 21.05
18.00		 0.00 120.90
 33  No Name #36007
 Calc.
Raw		 46.46
37.01		 28.57
24.00		 32.16
27.50		 0.00 107.19
 34  No Name #35428
 Calc.
Raw		 89.12
71.00		 15.88
13.34		 22.22
19.00		 30.00 97.22
 35  No Name #5144
 Calc.
Raw		 26.77
21.33		 15.08
12.67		 41.81
35.75		 0.00 83.66