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 2005 May 21st
 Problem 5 The Jungle Bloke Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #12306
 Calc.
Raw		 200.00
140.50		 50.00
43.66		 79.40
61.67		 0.00 329.40
 2  No Name #31225
 Calc.
Raw		 185.41
130.25		 46.19
40.33		 91.41
71.00		 0.00 323.01
 3  No Name #7548
 Calc.
Raw		 180.07
126.50		 44.66
39.00		 79.40
61.67		 0.00 304.13
 3  No Name #10619
 Calc.
Raw		 181.14
127.25		 41.23
36.00		 81.11
63.00		 0.00 303.48
 3  No Name #25285
 Calc.
Raw		 180.43
126.75		 46.95
41.00		 75.96
59.00		 0.00 303.34
 4  No Name #30832
 Calc.
Raw		 176.16
123.75		 41.22
35.99		 82.82
64.33		 0.00 300.20
 5  No Name #1965
 Calc.
Raw		 169.40
119.00		 47.72
41.67		 77.67
60.33		 0.00 294.79
 6  No Name #15467
 Calc.
Raw		 172.95
121.50		 46.58
40.67		 74.25
57.67		 0.00 293.78
 6  No Name #3746
 Calc.
Raw		 153.74
108.00		 39.33
34.34		 100.00
77.67		 0.00 293.07
 7  No Name #32441
 Calc.
Raw		 151.60
106.50		 43.90
38.33		 96.56
75.00		 0.00 292.06
 7  No Name #11519
 Calc.
Raw		 172.24
121.00		 46.97
41.01		 72.52
56.33		 0.00 291.73
 7  No Name #34250
 Calc.
Raw		 170.82
120.00		 39.70
34.67		 81.11
63.00		 0.00 291.63
 8  No Name #10527
 Calc.
Raw		 171.89
120.75		 45.42
39.66		 65.66
51.00		 0.00 282.97
 9  No Name #33516
 Calc.
Raw		 166.19
116.75		 44.27
38.66		 70.81
55.00		 0.00 281.27
 10  No Name #7975
 Calc.
Raw		 163.70
115.00		 43.14
37.67		 72.52
56.33		 0.00 279.36
 11  No Name #32076
 Calc.
Raw		 172.95
121.50		 32.82
28.66		 72.52
56.33		 0.00 278.29
 11  No Name #35288
 Calc.
Raw		 153.74
108.00		 34.36
30.00		 89.70
69.67		 0.00 277.80
 11  No Name #22172
 Calc.
Raw		 150.53
105.75		 38.94
34.00		 87.97
68.33		 0.00 277.44
 12  No Name #22311
 Calc.
Raw		 164.06
115.25		 43.14
37.67		 67.37
52.33		 0.00 274.57
 12  No Name #32431
 Calc.
Raw		 154.80
108.75		 31.69
27.67		 87.97
68.33		 0.00 274.46
 13  No Name #19633
 Calc.
Raw		 160.85
113.00		 36.66
32.01		 74.25
57.67		 0.00 271.76
 14  No Name #20528
 Calc.
Raw		 145.55
102.25		 37.04
32.34		 84.55
65.67		 0.00 267.14
 15  No Name #30326
 Calc.
Raw		 155.52
109.25		 37.40
32.66		 69.10
53.67		 0.00 262.02
 16  No Name #11908
 Calc.
Raw		 141.28
99.25		 39.32
34.33		 77.67
60.33		 0.00 258.27
 17  No Name #31133
 Calc.
Raw		 142.70
100.25		 35.11
30.66		 79.40
61.67		 0.00 257.21
 18  No Name #8422
 Calc.
Raw		 130.60
91.75		 38.93
33.99		 86.26
67.00		 0.00 255.79
 19  No Name #3823
 Calc.
Raw		 137.72
96.75		 35.51
31.01		 81.11
63.00		 0.00 254.34
 20  No Name #25052
 Calc.
Raw		 141.64
99.50		 36.66
32.01		 72.52
56.33		 0.00 250.82
 21  No Name #21434
 Calc.
Raw		 130.25
91.50		 48.10
42.00		 70.81
55.00		 0.00 249.16
 22  No Name #32435
 Calc.
Raw		 148.75
104.50		 30.15
26.33		 74.25
57.67		 5.00 248.15
 23  No Name #12264
 Calc.
Raw		 125.62
88.25		 39.30
34.32		 82.82
64.33		 2.00 245.74
 24  No Name #33896
 Calc.
Raw		 132.74
93.25		 38.17
33.33		 73.39
57.00		 0.00 244.30
 25  No Name #34301
 Calc.
Raw		 138.43
97.25		 30.92
27.00		 70.81
55.00		 0.00 240.16
 25  No Name #18242
 Calc.
Raw		 143.77
101.00		 33.98
29.67		 62.22
48.33		 0.00 239.97
 26  No Name #16962
 Calc.
Raw		 132.03
92.75		 35.89
31.34		 70.81
55.00		 0.00 238.73
 27  No Name #5144
 Calc.
Raw		 109.25
76.75		 38.56
33.67		 84.11
65.33		 0.00 231.92
 27  No Name #30426
 Calc.
Raw		 122.42
86.00		 37.80
33.01		 70.81
55.00		 0.00 231.03
 28  No Name #19848
 Calc.
Raw		 119.57
84.00		 32.46
28.34		 74.25
57.67		 0.00 226.28
 29  No Name #1412
 Calc.
Raw		 124.20
87.25		 26.33
22.99		 72.52
56.33		 0.00 223.05
 29  No Name #8149
 Calc.
Raw		 128.11
90.00		 27.49
24.00		 67.37
52.33		 0.00 222.97
 29  No Name #30883
 Calc.
Raw		 105.69
74.25		 38.93
33.99		 82.82
64.33		 5.00 222.44
 30  No Name #30640
 Calc.
Raw		 120.28
84.50		 31.69
27.67		 67.37
52.33		 0.00 219.34
 30  No Name #4307
 Calc.
Raw		 116.73
82.00		 38.17
33.33		 63.95
49.67		 0.00 218.85
 31  No Name #16610
 Calc.
Raw		 114.95
80.75		 31.69
27.67		 65.66
51.00		 0.00 212.30
 32  No Name #32969
 Calc.
Raw		 117.79
82.75		 26.72
23.33		 58.36
45.33		 0.00 202.87
 33  No Name #32348
 Calc.
Raw		 91.46
64.25		 32.08
28.01		 75.96
59.00		 0.00 199.50
 34  No Name #1988
 Calc.
Raw		 98.58
69.25		 33.21
29.00		 65.66
51.00		 0.00 197.45