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 2008 May 31st
 Problem 2 DinoStories Division I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #36907
 Calc.
Raw		 195.80
140.00		 40.57
33.00		 100.00
93.67		 0.00 336.37
 2  No Name #4636
 Calc.
Raw		 188.81
135.00		 43.43
35.33		 85.76
80.33		 0.00 318.00
 3  No Name #34220
 Calc.
Raw		 193.01
138.00		 50.00
40.67		 68.68
64.33		 0.00 311.69
 4  No Name #36618
 Calc.
Raw		 172.73
123.50		 38.94
31.67		 94.30
88.33		 0.00 305.97
 5  No Name #37160
 Calc.
Raw		 200.00
143.00		 46.72
38.00		 54.45
51.00		 0.00 301.17
 6  No Name #33807
 Calc.
Raw		 193.01
138.00		 33.60
27.33		 70.11
65.67		 0.00 296.72
 7  No Name #33866
 Calc.
Raw		 185.31
132.50		 41.80
34.00		 67.26
63.00		 0.00 294.37
 8  No Name #15064
 Calc.
Raw		 165.03
118.00		 46.72
38.00		 81.49
76.33		 0.00 293.24
 9  No Name #31248
 Calc.
Raw		 183.22
131.00		 40.16
32.67		 68.68
64.33		 0.00 292.06
 10  No Name #36087
 Calc.
Raw		 159.44
114.00		 40.98
33.33		 87.19
81.67		 0.00 287.61
 11  No Name #37431
 Calc.
Raw		 160.84
115.00		 44.66
36.33		 78.65
73.67		 0.00 284.15
 12  No Name #37497
 Calc.
Raw		 197.20
141.00		 36.48
29.67		 48.76
45.67		 0.00 282.44
 13  No Name #37601
 Calc.
Raw		 169.23
121.00		 38.11
31.00		 74.38
69.67		 2.00 279.72
 14  No Name #26787
 Calc.
Raw		 174.83
125.00		 36.48
29.67		 67.26
63.00		 0.00 278.57
 15  No Name #15328
 Calc.
Raw		 172.73
123.50		 39.34
32.00		 64.41
60.33		 0.00 276.48
 15  No Name #36932
 Calc.
Raw		 160.84
115.00		 40.57
33.00		 74.38
69.67		 0.00 275.79
 16  No Name #34430
 Calc.
Raw		 165.03
118.00		 30.74
25.00		 78.65
73.67		 0.00 274.42
 16  No Name #37257
 Calc.
Raw		 159.44
114.00		 40.16
32.67		 74.38
69.67		 0.00 273.98
 17  No Name #13193
 Calc.
Raw		 174.13
124.50		 31.14
25.33		 66.19
62.00		 0.00 271.46
 18  No Name #20061
 Calc.
Raw		 166.43
119.00		 38.94
31.67		 65.84
61.67		 2.00 269.21
 19  No Name #8407
 Calc.
Raw		 157.34
112.50		 28.68
23.33		 75.80
71.00		 0.00 261.82
 20  No Name #34601
 Calc.
Raw		 181.12
129.50		 35.65
29.00		 43.42
40.67		 0.00 260.19
 20  No Name #37809
 Calc.
Raw		 161.54
115.50		 42.62
34.67		 62.99
59.00		 7.00 260.15
 21  No Name #28679
 Calc.
Raw		 146.85
105.00		 36.88
30.00		 74.38
69.67		 0.00 258.11
 21  No Name #23774
 Calc.
Raw		 158.04
113.00		 32.79
26.67		 67.26
63.00		 0.00 258.09
 22  No Name #36936
 Calc.
Raw		 148.25
106.00		 39.34
32.00		 67.26
63.00		 0.00 254.85
 23  No Name #37376
 Calc.
Raw		 149.65
107.00		 33.19
27.00		 75.08
70.33		 5.00 252.92
 23  No Name #34325
 Calc.
Raw		 145.45
104.00		 39.75
32.33		 67.26
63.00		 0.00 252.46
 24  No Name #5128
 Calc.
Raw		 171.33
122.50		 22.54
18.33		 57.30
53.67		 0.00 251.17
 25  No Name #34371
 Calc.
Raw		 153.85
110.00		 33.19
27.00		 62.99
59.00		 0.00 250.03
 25  No Name #13318
 Calc.
Raw		 151.75
108.50		 33.19
27.00		 64.41
60.33		 0.00 249.35
 26  No Name #28581
 Calc.
Raw		 158.74
113.50		 32.79
26.67		 57.30
53.67		 0.00 248.83
 27  No Name #35666
 Calc.
Raw		 142.66
102.00		 34.42
28.00		 71.53
67.00		 1.00 247.61
 28  No Name #2600
 Calc.
Raw		 148.25
106.00		 35.25
28.67		 62.99
59.00		 0.00 246.49
 29  No Name #7424
 Calc.
Raw		 144.06
103.00		 34.02
27.67		 70.11
65.67		 5.00 243.19
 30  No Name #35604
 Calc.
Raw		 124.48
89.00		 33.19
27.00		 84.34
79.00		 0.00 242.01
 31  No Name #6379
 Calc.
Raw		 126.57
90.50		 42.21
34.33		 70.11
65.67		 0.00 238.89
 32  No Name #37367
 Calc.
Raw		 125.17
89.50		 31.56
25.67		 79.72
74.67		 7.00 229.45
 33  No Name #35417
 Calc.
Raw		 148.25
106.00		 27.05
22.00		 54.45
51.00		 4.00 225.75
 34  No Name #35577
 Calc.
Raw		 131.47
94.00		 26.22
21.33		 61.57
57.67		 0.00 219.26
 34  No Name #33953
 Calc.
Raw		 123.08
88.00		 32.37
26.33		 64.05
60.00		 1.00 218.50
 35  No Name #31733
 Calc.
Raw		 144.06
103.00		 36.48
29.67		 37.72
35.33		 0.00 218.26
 36  No Name #34567
 Calc.
Raw		 132.87
95.00		 28.68
23.33		 49.46
46.33		 0.00 211.01
 37  No Name #3606
 Calc.
Raw		 107.69
77.00		 35.25
28.67		 66.54
62.33		 0.00 209.48
 38  No Name #35927
 Calc.
Raw		 125.87
90.00		 23.36
19.00		 57.30
53.67		 1.00 205.53
 39  No Name #36534
 Calc.
Raw		 102.10
73.00		 34.02
27.67		 65.84
61.67		 0.00 201.96
 40  No Name #14205
 Calc.
Raw		 122.38
87.50		 24.99
20.33		 50.89
47.67		 0.00 198.26
 41  No Name #34795
 Calc.
Raw		 85.31
61.00		 36.48
29.67		 84.34
79.00		 11.00 195.13
 41  No Name #30867
 Calc.
Raw		 113.99
81.50		 31.96
26.00		 53.03
49.67		 4.00 194.98
 41  No Name #35727
 Calc.
Raw		 96.50
69.00		 24.99
20.33		 72.95
68.33		 0.00 194.44
 42  No Name #1725
 Calc.
Raw		 98.60
70.50		 24.99
20.33		 68.68
64.33		 0.00 192.27
 43  No Name #29420
 Calc.
Raw		 90.21
64.50		 26.22
21.33		 68.68
64.33		 1.00 184.11
 44  No Name #37222
 Calc.
Raw		 100.00
71.50		 17.62
14.33		 64.41
60.33		 0.00 182.03
 45  No Name #36668
 Calc.
Raw		 90.91
65.00		 23.36
19.00		 66.91
62.67		 2.00 179.18
 46  No Name #37378
 Calc.
Raw		 97.90
70.00		 16.40
13.34		 42.70
40.00		 0.00 157.00