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 4 Geometry Structure Division I
 Rank   Member    Long
Term		  Weight  Style  Spont  Penalty  Total
 1  No Name #34631
 Calc.
Raw		 187.71
28.66		 150.00
880.00		 37.60
32.34		 97.57
106.67		 10.00 312.88
 2  No Name #27666
 Calc.
Raw		 172.55
33.33		 128.69
755.00		 37.58
32.33		 86.59
94.67		 0.00 296.72
 3  No Name #11374
 Calc.
Raw		 154.76
25.00		 121.87
715.00		 36.82
31.67		 90.25
98.67		 0.00 281.83
 4  No Name #8147
 Calc.
Raw		 184.12
35.00		 138.07
810.00		 38.36
33.00		 86.59
94.67		 40.00 269.07
 4  No Name #32112
 Calc.
Raw		 137.52
30.67		 97.16
570.00		 36.03
30.99		 100.00
109.33		 5.00 268.55
 5  No Name #14614
 Calc.
Raw		 147.91
35.33		 101.42
595.00		 44.94
38.66		 73.17
80.00		 0.00 266.02
 6  No Name #31388
 Calc.
Raw		 150.54
25.67		 116.76
685.00		 38.75
33.33		 75.62
82.67		 0.00 264.91
 6  No Name #30339
 Calc.
Raw		 132.91
33.00		 89.49
525.00		 42.22
36.32		 89.02
97.33		 0.00 264.15
 7  No Name #1388
 Calc.
Raw		 147.25
29.00		 109.09
640.00		 27.52
23.67		 75.62
82.67		 0.00 250.39
 8  No Name #35477
 Calc.
Raw		 163.33
25.67		 129.55
760.00		 36.43
31.34		 73.17
80.00		 25.00 247.93
 9  No Name #1567
 Calc.
Raw		 151.96
29.34		 113.35
665.00		 29.46
25.34		 60.98
66.67		 0.00 242.40
 10  No Name #33017
 Calc.
Raw		 124.74
31.33		 83.52
490.00		 36.04
31.00		 79.27
86.67		 0.00 240.05
 11  No Name #3260
 Calc.
Raw		 146.47
31.00		 105.68
620.00		 32.17
27.67		 57.32
62.67		 0.00 235.96
 12  No Name #31960
 Calc.
Raw		 111.46
29.00		 73.30
430.00		 36.42
31.33		 91.47
100.00		 10.00 229.35
 13  No Name #30823
 Calc.
Raw		 111.81
15.67		 91.19
535.00		 32.55
28.00		 96.34
105.33		 20.00 220.70
 14  No Name #31310
 Calc.
Raw		 99.64
32.33		 57.10
335.00		 34.88
30.00		 80.49
88.00		 0.00 215.01
 15  No Name #5000
 Calc.
Raw		 92.75
18.67		 68.18
400.00		 24.41
21.00		 78.05
85.33		 0.00 195.21
 16  No Name #34511
 Calc.
Raw		 70.50
16.66		 48.58
285.00		 20.93
18.00		 97.57
106.67		 0.00 189.00
 17  No Name #34320
 Calc.
Raw		 91.10
20.01		 64.77
380.00		 27.12
23.33		 68.30
74.67		 0.00 186.52
 17  No Name #30200
 Calc.
Raw		 81.65
29.67		 42.61
250.00		 42.23
36.33		 62.20
68.00		 0.00 186.08
 17  No Name #15746
 Calc.
Raw		 99.50
17.33		 76.70
450.00		 17.05
14.67		 69.51
76.00		 0.00 186.06
 17  No Name #34889
 Calc.
Raw		 77.84
19.00		 52.84
310.00		 37.20
32.00		 70.73
77.33		 0.00 185.77
 18  No Name #28745
 Calc.
Raw		 82.57
20.00		 56.25
330.00		 23.25
20.00		 74.39
81.33		 0.00 180.21
 19  No Name #30595
 Calc.
Raw		 90.67
31.34		 49.43
290.00		 31.77
27.33		 56.10
61.33		 0.00 178.54
 20  No Name #35273
 Calc.
Raw		 60.18
25.01		 27.27
160.00		 24.80
21.33		 80.49
88.00		 0.00 165.47
 21  No Name #14138
 Calc.
Raw		 175.94
32.67		 132.95
780.00		 42.23
36.33		 91.47
100.00		 150.00 159.64
 22  No Name #28072
 Calc.
Raw		 72.61
27.33		 36.65
215.00		 26.74
23.00		 59.75
65.33		 2.00 157.10
 23  No Name #35747
 Calc.
Raw		 30.49
17.34		 7.67
45.00		 27.13
23.34		 86.59
94.67		 0.00 144.21
 24  No Name #24450
 Calc.
Raw		 41.72
21.34		 13.64
80.00		 33.71
29.00		 57.32
62.67		 0.00 132.75
 25  No Name #18112
 Calc.
Raw		 30.94
18.33		 6.82
40.00		 23.25
20.00		 76.83
84.00		 0.00 131.02
 26  No Name #35121
 Calc.
Raw		 43.51
24.00		 11.93
70.00		 33.33
28.67		 45.12
49.33		 0.00 121.96
 27  No Name #32088
 Calc.
Raw		 28.51
21.67		 0.00
0.00		 29.45
25.33		 68.30
74.67		 10.00 116.26
 28  No Name #31148
 Calc.
Raw		 27.72
12.00		 11.93
70.00		 13.95
12.00		 56.10
61.33		 0.00 97.77
 29  No Name #18669
 Calc.
Raw		 16.22
12.33		 0.00
0.00		 12.79
11.00		 64.64
70.67		 0.00 93.65
 30  No Name #34487
 Calc.
Raw		 28.84
19.33		 3.41
20.00		 24.81
21.34		 82.93
90.67		 50.00 86.58
 31  No Name #20906
 Calc.
Raw		 113.92
38.00		 63.92
375.00		 50.00
43.01		 76.83
84.00		 160.00 80.75
 31  No Name #32141
 Calc.
Raw		 45.92
20.00		 19.60
115.00		 20.54
17.67		 63.41
69.33		 50.00 79.87
 32  No Name #35139
 Calc.
Raw		 17.47
11.33		 2.56
15.00		 22.47
19.33		 48.78
53.33		 10.00 78.72
 33  No Name #34808
 Calc.
Raw		 21.67
9.34		 9.38
55.00		 10.86
9.34		 53.35
58.33		 25.00 60.88