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 II
 Rank   Member    Long
Term		  Weight  Style  Spont  Penalty  Total
 1  No Name #346
 Calc.
Raw		 189.08
34.33		 143.51
995.00		 39.42
32.33		 82.80
78.25		 0.00 311.30
 2  No Name #4640
 Calc.
Raw		 170.96
31.00		 129.81
900.00		 39.83
32.67		 86.51
81.75		 0.00 297.30
 3  No Name #13505
 Calc.
Raw		 143.78
29.00		 105.29
730.00		 38.20
31.33		 88.36
83.50		 0.00 270.34
 4  No Name #5815
 Calc.
Raw		 195.13
34.00		 150.00
1040.00		 45.11
37.00		 25.13
23.75		 0.00 265.37
 5  No Name #18527
 Calc.
Raw		 144.92
33.66		 100.24
695.00		 30.88
25.33		 85.98
81.25		 0.00 261.78
 6  No Name #35471
 Calc.
Raw		 148.35
22.66		 118.27
820.00		 28.03
22.99		 84.13
79.50		 0.00 260.51
 7  No Name #30655
 Calc.
Raw		 129.87
26.67		 94.47
655.00		 37.39
30.67		 85.71
81.00		 0.00 252.97
 8  No Name #1140
 Calc.
Raw		 123.50
36.00		 75.72
525.00		 42.67
35.00		 83.86
79.25		 0.00 250.03
 9  No Name #28541
 Calc.
Raw		 89.29
34.67		 43.27
300.00		 50.00
41.01		 100.00
94.50		 0.00 239.29
 10  No Name #31096
 Calc.
Raw		 160.60
27.00		 124.76
865.00		 38.20
31.33		 37.57
35.50		 0.00 236.37
 11  No Name #10167
 Calc.
Raw		 142.89
28.33		 105.29
730.00		 32.52
26.67		 59.26
56.00		 0.00 234.67
 11  No Name #34511
 Calc.
Raw		 121.69
18.33		 97.36
675.00		 27.63
22.66		 84.92
80.25		 0.00 234.24
 12  No Name #9831
 Calc.
Raw		 113.28
31.01		 72.12
500.00		 35.76
29.33		 83.86
79.25		 0.00 232.90
 13  No Name #32054
 Calc.
Raw		 133.88
21.00		 106.01
735.00		 30.48
25.00		 65.87
62.25		 0.00 230.23
 14  No Name #6986
 Calc.
Raw		 97.51
30.00		 57.69
400.00		 37.80
31.00		 89.68
84.75		 0.00 224.99
 15  No Name #22311
 Calc.
Raw		 102.45
31.00		 61.30
425.00		 35.76
29.33		 85.71
81.00		 0.00 223.92
 15  No Name #15407
 Calc.
Raw		 97.38
25.01		 64.18
445.00		 41.04
33.66		 85.19
80.50		 0.00 223.61
 16  No Name #416
 Calc.
Raw		 98.31
12.67		 81.49
565.00		 32.52
26.67		 87.04
82.25		 0.00 217.87
 17  No Name #32926
 Calc.
Raw		 97.49
24.00		 65.63
455.00		 30.88
25.33		 82.54
78.00		 0.00 210.91
 17  No Name #22504
 Calc.
Raw		 94.89
19.33		 69.23
480.00		 32.11
26.34		 83.33
78.75		 0.00 210.33
 18  No Name #25818
 Calc.
Raw		 79.69
17.66		 56.25
390.00		 32.10
26.33		 80.42
76.00		 0.00 192.21
 19  No Name #33379
 Calc.
Raw		 120.78
26.34		 85.82
595.00		 29.27
24.01		 35.45
33.50		 0.00 185.50
 20  No Name #31230
 Calc.
Raw		 72.72
25.99		 38.22
265.00		 28.86
23.67		 82.80
78.25		 0.00 184.38
 21  No Name #14421
 Calc.
Raw		 64.51
16.00		 43.27
300.00		 20.73
17.00		 87.57
82.75		 0.00 172.81
 22  No Name #34809
 Calc.
Raw		 109.34
25.33		 75.72
525.00		 39.01
32.00		 20.63
19.50		 0.00 168.98
 22  No Name #20708
 Calc.
Raw		 57.04
22.33		 27.40
190.00		 30.88
25.33		 85.45
80.75		 5.00 168.37
 23  No Name #17346
 Calc.
Raw		 58.83
19.33		 33.17
230.00		 25.20
20.67		 81.48
77.00		 0.00 165.51
 24  No Name #30758
 Calc.
Raw		 101.20
37.67		 51.20
355.00		 45.93
37.67		 16.14
15.25		 0.00 163.27
 25  No Name #8020
 Calc.
Raw		 48.39
22.33		 18.75
130.00		 30.08
24.67		 83.07
78.50		 0.00 161.54
 26  No Name #30595
 Calc.
Raw		 42.73
21.33		 14.42
100.00		 28.86
23.67		 87.30
82.50		 0.00 158.89
 27  No Name #31421
 Calc.
Raw		 40.04
17.67		 16.59
115.00		 26.01
21.33		 84.92
80.25		 0.00 150.97
 27  No Name #34922
 Calc.
Raw		 45.26
14.00		 26.68
185.00		 23.17
19.00		 82.54
78.00		 0.00 150.97
 28  No Name #32283
 Calc.
Raw		 153.57
23.33		 122.60
850.00		 26.01
21.33		 19.05
18.00		 50.00 148.63
 28  No Name #16088
 Calc.
Raw		 61.84
18.34		 37.50
260.00		 28.04
23.00		 57.94
54.75		 0.00 147.82
 29  No Name #2661
 Calc.
Raw		 86.60
26.67		 51.20
355.00		 39.01
32.00		 21.96
20.75		 0.00 147.57
 30  No Name #17068
 Calc.
Raw		 98.39
20.34		 71.39
495.00		 27.64
22.67		 20.11
19.00		 0.00 146.14
 30  No Name #2465
 Calc.
Raw		 43.91
17.33		 20.91
145.00		 19.91
16.33		 82.28
77.75		 0.00 146.10
 30  No Name #33631
 Calc.
Raw		 73.29
10.67		 59.13
410.00		 14.63
12.00		 57.94
54.75		 0.00 145.86
 31  No Name #33259
 Calc.
Raw		 92.29
19.00		 67.07
465.00		 30.48
25.00		 17.46
16.50		 0.00 140.23
 32  No Name #29564
 Calc.
Raw		 72.97
34.33		 27.40
190.00		 29.26
24.00		 32.28
30.50		 0.00 134.51
 33  No Name #34374
 Calc.
Raw		 83.31
17.67		 59.86
415.00		 24.80
20.34		 21.43
20.25		 0.00 129.54
 34  No Name #34371
 Calc.
Raw		 78.81
17.00		 56.25
390.00		 19.51
16.00		 19.58
18.50		 0.00 117.90
 35  No Name #31161
 Calc.
Raw		 75.06
12.00		 59.13
410.00		 20.32
16.67		 18.78
17.75		 0.00 114.16
 36  No Name #35548
 Calc.
Raw		 64.01
14.00		 45.43
315.00		 24.40
20.01		 17.46
16.50		 0.00 105.87
 37  No Name #34338
 Calc.
Raw		 34.35
10.67		 20.19
140.00		 19.91
16.33		 85.19
80.50		 35.00 104.45
 38  No Name #33345
 Calc.
Raw		 48.45
24.00		 16.59
115.00		 30.08
24.67		 17.46
16.50		 0.00 95.99
 39  No Name #31624
 Calc.
Raw		 49.14
18.01		 25.24
175.00		 23.57
19.33		 21.96
20.75		 0.00 94.67
 40  No Name #35125
 Calc.
Raw		 24.38
9.67		 11.54
80.00		 20.73
17.00		 20.63
19.50		 0.00 65.74
 41  No Name #16610
 Calc.
Raw		 27.23
14.00		 8.65
60.00		 15.45
12.67		 21.69
20.50		 0.00 64.37
 42  No Name #13318
 Calc.
Raw		 47.41
18.33		 23.08
160.00		 29.26
24.00		 81.48
77.00		 100.00 58.15
 43  No Name #34080
 Calc.
Raw		 21.20
10.00		 7.93
55.00		 13.81
11.33		 20.90
19.75		 0.00 55.91
 44  No Name #11324
 Calc.
Raw		 17.05
6.33		 8.65
60.00		 13.41
11.00		 18.52
17.50		 0.00 48.98
 45  No Name #11548
 Calc.
Raw		 45.76
16.00		 24.52
170.00		 22.35
18.33		 58.99
55.75		 140.00 0.00