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 4 Geometry Structure Division I
 Rank   Member    Long
Term		  Weight  Style  Spont  Penalty  Total
 1  No Name #9083
 Calc.
Raw		 200.00
35.67		 150.00
1270.00		 39.17
34.99		 100.00
109.67		 0.00 339.17
 2  No Name #1593
 Calc.
Raw		 182.68
39.67		 129.92
1100.00		 36.21
32.34		 80.54
88.33		 0.00 299.43
 3  No Name #31388
 Calc.
Raw		 152.04
33.67		 107.48
910.00		 41.79
37.33		 84.19
92.33		 0.00 278.02
 4  No Name #24142
 Calc.
Raw		 156.07
38.00		 106.89
905.00		 41.42
37.00		 75.68
83.00		 0.00 273.17
 5  No Name #29042
 Calc.
Raw		 151.89
24.67		 116.34
985.00		 22.76
20.33		 85.41
93.67		 10.00 250.06
 6  No Name #27874
 Calc.
Raw		 130.22
34.67		 86.22
730.00		 36.21
32.34		 77.20
84.67		 0.00 243.63
 6  No Name #27666
 Calc.
Raw		 147.51
25.33		 111.61
945.00		 36.20
32.33		 59.88
65.67		 0.00 243.59
 7  No Name #20906
 Calc.
Raw		 122.83
36.67		 77.36
655.00		 50.00
44.66		 69.60
76.33		 0.00 242.43
 8  No Name #14138
 Calc.
Raw		 135.53
31.33		 94.49
800.00		 30.60
27.33		 74.47
81.67		 0.00 240.60
 9  No Name #3260
 Calc.
Raw		 121.86
34.00		 79.13
670.00		 41.42
37.00		 72.03
79.00		 0.00 235.31
 9  No Name #28491
 Calc.
Raw		 132.87
20.00		 103.35
875.00		 37.33
33.34		 64.74
71.00		 0.00 234.94
 9  No Name #1436
 Calc.
Raw		 129.43
25.67		 94.49
800.00		 39.18
35.00		 65.95
72.33		 0.00 234.56
 10  No Name #33259
 Calc.
Raw		 114.66
29.67		 76.77
650.00		 31.72
28.33		 84.19
92.33		 0.00 230.57
 11  No Name #13791
 Calc.
Raw		 140.69
26.67		 103.94
880.00		 20.90
18.67		 65.95
72.33		 0.00 227.54
 12  No Name #5424
 Calc.
Raw		 124.74
23.67		 92.13
780.00		 35.09
31.34		 65.95
72.33		 10.00 215.78
 13  No Name #29489
 Calc.
Raw		 122.30
35.00		 78.54
665.00		 24.25
21.66		 63.53
69.67		 0.00 210.08
 14  No Name #8147
 Calc.
Raw		 121.95
34.67		 78.54
665.00		 34.33
30.66		 50.15
55.00		 0.00 206.43
 15  No Name #9831
 Calc.
Raw		 78.78
27.67		 45.47
385.00		 41.44
37.01		 75.68
83.00		 0.00 195.90
 16  No Name #31310
 Calc.
Raw		 89.98
33.33		 50.20
425.00		 28.72
25.65		 68.39
75.00		 0.00 187.09
 16  No Name #2791
 Calc.
Raw		 79.59
21.33		 52.56
445.00		 17.17
15.34		 90.27
99.00		 0.00 187.03
 17  No Name #35010
 Calc.
Raw		 80.53
26.33		 48.43
410.00		 30.61
27.34		 65.95
72.33		 0.00 177.09
 18  No Name #34320
 Calc.
Raw		 84.63
18.33		 60.24
510.00		 23.14
20.67		 67.17
73.67		 0.00 174.94
 18  No Name #30200
 Calc.
Raw		 102.63
17.33		 77.95
660.00		 26.49
23.66		 45.29
49.67		 0.00 174.41
 18  No Name #3161
 Calc.
Raw		 129.34
32.67		 87.40
740.00		 31.72
28.33		 82.98
91.00		 70.00 174.04
 19  No Name #15746
 Calc.
Raw		 81.13
28.67		 46.65
395.00		 29.10
25.99		 62.31
68.33		 0.00 172.54
 20  No Name #34512
 Calc.
Raw		 86.73
17.33		 63.19
535.00		 14.17
12.66		 67.78
74.33		 0.00 168.68
 21  No Name #35200
 Calc.
Raw		 57.72
19.33		 34.25
290.00		 26.12
23.33		 80.54
88.33		 0.00 164.38
 22  No Name #1388
 Calc.
Raw		 104.98
26.00		 71.46
605.00		 25.75
23.00		 41.94
46.00		 10.00 162.67
 23  No Name #34680
 Calc.
Raw		 62.28
38.33		 19.49
165.00		 34.71
31.00		 64.13
70.33		 0.00 161.12
 24  No Name #30823
 Calc.
Raw		 57.35
26.67		 26.57
225.00		 20.15
18.00		 80.54
88.33		 0.00 158.04
 25  No Name #4137
 Calc.
Raw		 64.35
26.67		 33.07
280.00		 20.90
18.67		 70.82
77.67		 0.00 156.07
 26  No Name #11248
 Calc.
Raw		 70.28
25.67		 39.57
335.00		 22.02
19.67		 62.31
68.33		 0.00 154.61
 27  No Name #28745
 Calc.
Raw		 58.49
23.00		 31.30
265.00		 34.71
31.00		 57.45
63.00		 0.00 150.65
 28  No Name #24450
 Calc.
Raw		 60.56
24.33		 31.89
270.00		 28.74
25.67		 59.88
65.67		 0.00 149.18
 29  No Name #1544
 Calc.
Raw		 67.84
16.33		 46.65
395.00		 19.40
17.33		 58.66
64.33		 0.00 145.90
 29  No Name #34242
 Calc.
Raw		 50.71
27.00		 20.08
170.00		 21.27
19.00		 73.25
80.33		 0.00 145.23
 30  No Name #5128
 Calc.
Raw		 51.46
25.33		 22.44
190.00		 18.66
16.67		 74.47
81.67		 0.00 144.59
 30  No Name #33085
 Calc.
Raw		 51.44
27.67		 20.08
170.00		 30.61
27.34		 67.17
73.67		 5.00 144.22
 31  No Name #34284
 Calc.
Raw		 59.16
20.67		 34.25
290.00		 25.00
22.33		 74.47
81.67		 20.00 138.63
 32  No Name #3422
 Calc.
Raw		 51.30
24.00		 23.62
200.00		 23.89
21.34		 62.31
68.33		 0.00 137.50
 33  No Name #22905
 Calc.
Raw		 56.14
22.00		 30.12
255.00		 23.51
21.00		 53.80
59.00		 0.00 133.45
 34  No Name #16420
 Calc.
Raw		 28.84
25.00		 1.77
15.00		 20.91
18.68		 81.76
89.67		 0.00 131.51
 34  No Name #34897
 Calc.
Raw		 62.57
30.33		 27.76
235.00		 17.53
15.66		 61.09
67.00		 10.00 131.19
 34  No Name #17227
 Calc.
Raw		 48.89
27.67		 17.72
150.00		 27.99
25.00		 53.80
59.00		 0.00 130.68
 35  No Name #31535
 Calc.
Raw		 33.72
20.67		 10.63
90.00		 25.38
22.67		 70.82
77.67		 0.00 129.92
 36  No Name #35162
 Calc.
Raw		 37.40
17.00		 17.72
150.00		 20.90
18.67		 68.39
75.00		 0.00 126.69
 37  No Name #34199
 Calc.
Raw		 33.75
31.33		 0.00
0.00		 25.38
22.67		 63.53
69.67		 0.00 122.66
 38  No Name #35089
 Calc.
Raw		 49.28
25.67		 20.08
170.00		 21.26
18.99		 58.66
64.33		 10.00 119.20
 39  No Name #2437
 Calc.
Raw		 30.34
21.67		 6.50
55.00		 18.28
16.33		 62.31
68.33		 0.00 110.93
 39  No Name #10605
 Calc.
Raw		 34.90
20.00		 12.40
105.00		 15.29
13.66		 80.54
88.33		 20.00 110.73
 40  No Name #35125
 Calc.
Raw		 46.06
28.00		 14.76
125.00		 23.50
20.99		 57.45
63.00		 20.00 107.01
 41  No Name #35277
 Calc.
Raw		 25.27
19.33		 4.13
35.00		 11.93
10.66		 55.62
61.00		 0.00 92.82