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 I
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 1  No Name #1887
 Calc.
Raw		 195.43
139.00		 41.54
36.00		 100.00
90.67		 0.00 336.97
 2  No Name #26191
 Calc.
Raw		 196.13
139.50		 43.85
38.00		 88.23
80.00		 0.00 328.21
 3  No Name #30965
 Calc.
Raw		 181.72
129.25		 43.85
38.00		 95.59
86.67		 0.00 321.16
 4  No Name #33883
 Calc.
Raw		 182.78
130.00		 41.54
36.00		 94.11
85.33		 0.00 318.43
 4  No Name #29007
 Calc.
Raw		 183.48
130.50		 46.16
40.00		 88.23
80.00		 0.00 317.87
 5  No Name #22614
 Calc.
Raw		 190.51
135.50		 35.39
30.67		 91.18
82.67		 0.00 317.08
 6  No Name #27796
 Calc.
Raw		 194.02
138.00		 41.54
36.00		 79.41
72.00		 0.00 314.97
 7  No Name #30361
 Calc.
Raw		 184.18
131.00		 41.92
36.33		 86.77
78.67		 0.00 312.87
 8  No Name #35664
 Calc.
Raw		 172.93
123.00		 40.78
35.34		 95.59
86.67		 0.00 309.30
 9  No Name #30572
 Calc.
Raw		 174.69
124.25		 40.39
35.00		 92.64
84.00		 0.00 307.72
 9  No Name #29891
 Calc.
Raw		 200.00
142.25		 44.24
38.34		 63.23
57.33		 0.00 307.47
 9  No Name #34513
 Calc.
Raw		 182.07
129.50		 41.54
36.00		 83.82
76.00		 0.00 307.43
 9  No Name #20434
 Calc.
Raw		 182.07
129.50		 39.61
34.33		 85.29
77.33		 0.00 306.97
 9  No Name #9692
 Calc.
Raw		 175.04
124.50		 43.47
37.67		 88.23
80.00		 0.00 306.74
 10  No Name #33665
 Calc.
Raw		 175.04
124.50		 43.84
37.99		 89.70
81.33		 2.00 306.58
 11  No Name #22575
 Calc.
Raw		 175.04
124.50		 42.71
37.01		 83.82
76.00		 0.00 301.57
 12  No Name #34813
 Calc.
Raw		 192.62
137.00		 50.00
43.33		 58.09
52.67		 1.00 299.71
 12  No Name #31535
 Calc.
Raw		 175.04
124.50		 38.46
33.33		 85.29
77.33		 0.00 298.79
 13  No Name #9831
 Calc.
Raw		 185.24
131.75		 38.08
33.00		 75.00
68.00		 0.00 298.32
 14  No Name #34302
 Calc.
Raw		 181.72
129.25		 35.77
31.00		 79.41
72.00		 0.00 296.90
 15  No Name #31733
 Calc.
Raw		 172.93
123.00		 40.00
34.66		 82.35
74.67		 0.00 295.28
 16  No Name #34653
 Calc.
Raw		 178.56
127.00		 45.78
39.67		 68.74
62.33		 0.00 293.08
 17  No Name #5574
 Calc.
Raw		 164.85
117.25		 40.01
34.67		 86.77
78.67		 0.00 291.63
 18  No Name #15731
 Calc.
Raw		 170.12
121.00		 35.39
30.67		 77.94
70.67		 0.00 283.45
 18  No Name #13391
 Calc.
Raw		 171.88
122.25		 37.70
32.67		 73.53
66.67		 0.00 283.11
 18  No Name #9971
 Calc.
Raw		 165.20
117.50		 36.56
31.68		 80.88
73.33		 0.00 282.64
 18  No Name #28372
 Calc.
Raw		 150.79
107.25		 36.15
31.33		 95.59
86.67		 0.00 282.53
 19  No Name #23238
 Calc.
Raw		 185.94
132.25		 32.70
28.34		 67.64
61.33		 4.00 282.28
 19  No Name #34897
 Calc.
Raw		 172.58
122.75		 36.15
31.33		 83.46
75.67		 10.00 282.19
 20  No Name #26255
 Calc.
Raw		 181.02
128.75		 34.62
30.00		 63.23
57.33		 0.00 278.87
 21  No Name #28844
 Calc.
Raw		 163.44
116.25		 35.77
31.00		 77.94
70.67		 0.00 277.15
 22  No Name #1358
 Calc.
Raw		 155.01
110.25		 35.00
30.33		 83.82
76.00		 0.00 273.83
 23  No Name #35277
 Calc.
Raw		 170.47
121.25		 35.77
31.00		 66.17
60.00		 0.00 272.41
 24  No Name #14485
 Calc.
Raw		 175.04
124.50		 34.23
29.66		 61.76
56.00		 0.00 271.03
 24  No Name #33866
 Calc.
Raw		 158.17
112.50		 39.22
33.99		 73.53
66.67		 0.00 270.92
 25  No Name #34430
 Calc.
Raw		 149.74
106.50		 31.55
27.34		 86.77
78.67		 0.00 268.06
 25  No Name #26974
 Calc.
Raw		 156.41
111.25		 31.54
27.33		 79.77
72.33		 0.00 267.72
 26  No Name #35125
 Calc.
Raw		 169.07
120.25		 33.48
29.01		 63.23
57.33		 0.00 265.78
 26  No Name #10944
 Calc.
Raw		 166.96
118.75		 31.92
27.66		 67.64
61.33		 1.00 265.52
 27  No Name #22186
 Calc.
Raw		 165.20
117.50		 35.77
31.00		 63.60
57.67		 0.00 264.57
 28  No Name #4087
 Calc.
Raw		 156.77
111.50		 32.32
28.01		 73.53
66.67		 0.00 262.62
 29  No Name #9732
 Calc.
Raw		 158.52
112.75		 28.08
24.33		 77.94
70.67		 4.00 260.54
 30  No Name #16862
 Calc.
Raw		 153.25
109.00		 35.38
30.66		 70.59
64.00		 0.00 259.22
 31  No Name #35808
 Calc.
Raw		 163.09
116.00		 37.70
32.67		 55.88
50.67		 0.00 256.67
 31  No Name #33843
 Calc.
Raw		 144.11
102.50		 30.78
26.67		 80.88
73.33		 0.00 255.77
 32  No Name #16873
 Calc.
Raw		 140.25
99.75		 31.55
27.34		 82.35
74.67		 0.00 254.15
 33  No Name #30595
 Calc.
Raw		 147.98
105.25		 31.53
27.32		 73.53
66.67		 0.00 253.04
 34  No Name #14988
 Calc.
Raw		 146.57
104.25		 33.84
29.33		 64.71
58.67		 0.00 245.12
 35  No Name #31871
 Calc.
Raw		 142.36
101.25		 31.53
27.32		 69.12
62.67		 0.00 243.01
 36  No Name #35458
 Calc.
Raw		 149.74
106.50		 36.15
31.33		 70.59
64.00		 15.00 241.48
 36  No Name #14205
 Calc.
Raw		 138.84
98.75		 34.24
29.67		 67.64
61.33		 0.00 240.72
 37  No Name #36194
 Calc.
Raw		 127.94
91.00		 33.86
29.34		 79.41
72.00		 2.00 239.21
 38  No Name #29049
 Calc.
Raw		 143.76
102.25		 35.38
30.66		 67.64
61.33		 15.00 231.78
 38  No Name #3390
 Calc.
Raw		 143.41
102.00		 32.31
28.00		 60.30
54.67		 5.00 231.02
 39  No Name #34370
 Calc.
Raw		 140.95
100.25		 27.31
23.67		 57.35
52.00		 1.00 224.61
 40  No Name #8704
 Calc.
Raw		 123.73
88.00		 27.69
24.00		 59.56
54.00		 0.00 210.98
 41  No Name #35382
 Calc.
Raw		 103.69
73.75		 25.39
22.00		 49.27
44.67		 1.00 177.35