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 3 Ancient Egypt Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #31225
 Calc.
Raw		 200.00
149.50		 49.49
32.00		 77.49
81.75		 0.00 326.98
 2  No Name #6688
 Calc.
Raw		 160.87
120.25		 41.77
27.01		 100.00
105.50		 0.00 302.64
 3  No Name #22311
 Calc.
Raw		 186.62
139.50		 44.85
29.00		 59.72
63.00		 0.00 291.19
 4  No Name #34158
 Calc.
Raw		 150.84
112.75		 50.00
32.33		 76.54
80.75		 0.00 277.38
 5  No Name #34365
 Calc.
Raw		 168.56
126.00		 46.41
30.01		 61.85
65.25		 1.00 275.82
 6  No Name #33415
 Calc.
Raw		 165.55
123.75		 39.70
25.67		 68.96
72.75		 0.00 274.21
 7  No Name #32435
 Calc.
Raw		 143.81
107.50		 37.12
24.00		 85.31
90.00		 0.00 266.24
 8  No Name #30358
 Calc.
Raw		 176.92
132.25		 44.85
29.00		 41.23
43.50		 0.00 263.00
 8  No Name #9103
 Calc.
Raw		 135.45
101.25		 39.17
25.33		 87.44
92.25		 0.00 262.06
 9  No Name #4186
 Calc.
Raw		 164.55
123.00		 43.81
28.33		 53.08
56.00		 0.00 261.44
 10  No Name #8451
 Calc.
Raw		 170.57
127.50		 50.00
32.33		 35.78
37.75		 0.00 256.35
 11  No Name #2450
 Calc.
Raw		 151.17
113.00		 41.76
27.00		 58.06
61.25		 0.00 250.99
 12  No Name #28508
 Calc.
Raw		 159.20
119.00		 46.92
30.34		 42.42
44.75		 0.00 248.54
 13  No Name #27297
 Calc.
Raw		 153.51
114.75		 41.25
26.67		 50.95
53.75		 0.00 245.71
 14  No Name #9744
 Calc.
Raw		 169.57
126.75		 47.42
30.66		 27.25
28.75		 0.00 244.24
 15  No Name #18242
 Calc.
Raw		 181.61
135.75		 45.36
29.33		 15.88
16.75		 0.00 242.85
 16  No Name #20483
 Calc.
Raw		 143.48
107.25		 35.59
23.01		 57.58
60.75		 0.00 236.65
 17  No Name #3962
 Calc.
Raw		 130.77
97.75		 39.19
25.34		 65.17
68.75		 0.00 235.13
 18  No Name #4679
 Calc.
Raw		 142.14
106.25		 31.97
20.67		 59.00
62.25		 0.00 233.11
 19  No Name #34802
 Calc.
Raw		 150.17
112.25		 44.34
28.67		 45.02
47.50		 10.00 229.53
 19  No Name #14577
 Calc.
Raw		 150.50
112.50		 43.30
28.00		 35.31
37.25		 0.00 229.11
 20  No Name #7743
 Calc.
Raw		 134.78
100.75		 26.29
17.00		 65.17
68.75		 0.00 226.24
 21  No Name #14670
 Calc.
Raw		 149.16
111.50		 30.93
20.00		 45.02
47.50		 0.00 225.11
 22  No Name #28781
 Calc.
Raw		 121.40
90.75		 32.99
21.33		 78.67
83.00		 10.00 223.06
 22  No Name #1386
 Calc.
Raw		 158.86
118.75		 28.87
18.67		 35.07
37.00		 0.00 222.80
 23  No Name #35492
 Calc.
Raw		 138.80
103.75		 27.85
18.01		 52.84
55.75		 0.00 219.49
 23  No Name #1991
 Calc.
Raw		 141.14
105.50		 32.99
21.33		 44.55
47.00		 0.00 218.68
 24  No Name #31361
 Calc.
Raw		 149.83
112.00		 34.52
22.32		 27.96
29.50		 0.00 212.31
 25  No Name #10527
 Calc.
Raw		 145.82
109.00		 38.66
25.00		 24.88
26.25		 0.00 209.36
 26  No Name #19404
 Calc.
Raw		 139.46
104.25		 28.35
18.33		 39.10
41.25		 0.00 206.91
 26  No Name #15515
 Calc.
Raw		 138.80
103.75		 30.93
20.00		 36.97
39.00		 0.00 206.70
 26  No Name #23095
 Calc.
Raw		 130.10
97.25		 49.49
32.00		 26.54
28.00		 0.00 206.13
 27  No Name #32431
 Calc.
Raw		 115.72
86.50		 30.93
20.00		 59.24
62.50		 5.00 200.89
 28  No Name #30883
 Calc.
Raw		 136.12
101.75		 24.25
15.68		 36.49
38.50		 0.00 196.86
 29  No Name #32530
 Calc.
Raw		 130.10
97.25		 35.57
23.00		 19.67
20.75		 0.00 185.34
 29  No Name #26818
 Calc.
Raw		 109.70
82.00		 40.72
26.33		 44.08
46.50		 10.00 184.50
 30  No Name #33198
 Calc.
Raw		 129.10
96.50		 38.68
25.01		 31.99
33.75		 20.00 179.77
 30  No Name #30889
 Calc.
Raw		 125.08
93.50		 23.20
15.00		 30.57
32.25		 0.00 178.85
 31  No Name #3133
 Calc.
Raw		 119.06
89.00		 39.68
25.66		 30.81
32.50		 15.00 174.55
 31  No Name #11117
 Calc.
Raw		 118.39
88.50		 20.62
13.33		 35.31
37.25		 0.00 174.32
 32  No Name #35475
 Calc.
Raw		 123.75
92.50		 25.78
16.67		 23.70
25.00		 0.00 173.23
 33  No Name #185
 Calc.
Raw		 120.07
89.75		 23.18
14.99		 23.70
25.00		 0.00 166.95
 34  No Name #31161
 Calc.
Raw		 119.13
89.05		 23.21
15.01		 23.22
24.50		 0.00 165.56
 35  No Name #33010
 Calc.
Raw		 112.71
84.25		 20.63
13.34		 31.04
32.75		 0.00 164.38
 36  No Name #35734
 Calc.
Raw		 124.08
92.75		 22.67
14.66		 32.23
34.00		 20.00 158.98