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 II
 Rank   Member    Long
Term		  Weight  Style  Spont  Penalty  Total
 1  No Name #34398
 Calc.
Raw		 167.50
23.67		 130.15
1180.00		 33.03
25.33		 100.00
128.00		 0.00 300.53
 2  No Name #346
 Calc.
Raw		 200.00
33.67		 150.00
1360.00		 41.30
31.67		 29.16
37.33		 0.00 270.46
 3  No Name #13505
 Calc.
Raw		 197.09
31.00		 150.00
1360.00		 35.20
26.99		 33.34
42.67		 0.00 265.63
 4  No Name #1594
 Calc.
Raw		 144.38
33.33		 99.26
900.00		 43.02
32.99		 74.48
95.33		 0.00 261.88
 5  No Name #416
 Calc.
Raw		 136.85
22.00		 103.68
940.00		 33.02
25.32		 83.85
107.33		 0.00 253.72
 6  No Name #3260
 Calc.
Raw		 142.12
21.33		 109.19
990.00		 29.55
22.66		 72.40
92.67		 0.00 244.07
 7  No Name #30390
 Calc.
Raw		 150.35
28.33		 109.74
995.00		 29.13
22.34		 51.82
66.33		 0.00 231.30
 8  No Name #31096
 Calc.
Raw		 166.86
34.67		 118.57
1075.00		 35.65
27.34		 24.74
31.67		 0.00 227.25
 9  No Name #33857
 Calc.
Raw		 110.22
25.67		 75.55
685.00		 34.77
26.66		 59.38
76.00		 0.00 204.37
 9  No Name #30120
 Calc.
Raw		 113.32
39.00		 65.07
590.00		 34.77
26.66		 56.25
72.00		 0.00 204.34
 9  No Name #4909
 Calc.
Raw		 139.18
28.00		 99.82
905.00		 50.00
38.34		 15.10
19.33		 0.00 204.28
 10  No Name #32095
 Calc.
Raw		 124.78
44.00		 70.59
640.00		 48.25
37.00		 25.00
32.00		 0.00 198.03
 11  No Name #19264
 Calc.
Raw		 86.24
16.33		 62.87
570.00		 27.39
21.00		 80.21
102.67		 0.00 193.84
 12  No Name #14716
 Calc.
Raw		 101.70
26.67		 66.73
605.00		 36.93
28.32		 49.74
63.67		 0.00 188.37
 13  No Name #13791
 Calc.
Raw		 135.41
22.33		 102.02
925.00		 27.39
21.00		 23.96
30.67		 0.00 186.76
 14  No Name #17583
 Calc.
Raw		 113.89
34.00		 70.59
640.00		 45.64
35.00		 26.04
33.33		 0.00 185.57
 14  No Name #33403
 Calc.
Raw		 92.81
27.33		 57.90
525.00		 30.86
23.66		 61.20
78.33		 0.00 184.87
 15  No Name #2661
 Calc.
Raw		 106.31
32.00		 65.63
595.00		 38.68
29.66		 31.77
40.67		 0.00 176.76
 16  No Name #33631
 Calc.
Raw		 126.43
25.67		 90.44
820.00		 31.74
24.34		 15.37
19.67		 0.00 173.54
 17  No Name #32416
 Calc.
Raw		 100.69
35.67		 56.80
515.00		 45.21
34.67		 22.66
29.00		 0.00 168.56
 18  No Name #13640
 Calc.
Raw		 102.64
23.67		 70.59
640.00		 21.75
16.68		 38.80
49.67		 0.00 163.19
 19  No Name #32054
 Calc.
Raw		 99.16
24.33		 66.73
605.00		 30.43
23.33		 26.04
33.33		 0.00 155.63
 19  No Name #1701
 Calc.
Raw		 83.89
23.00		 54.04
490.00		 35.64
27.33		 35.16
45.00		 0.00 154.69
 20  No Name #1140
 Calc.
Raw		 102.22
31.00		 62.87
570.00		 28.26
21.67		 13.54
17.33		 0.00 144.02
 21  No Name #23240
 Calc.
Raw		 98.33
24.67		 65.63
595.00		 19.14
14.68		 25.26
32.33		 0.00 142.73
 22  No Name #33292
 Calc.
Raw		 47.53
26.00		 17.65
160.00		 29.99
23.00		 62.76
80.33		 0.00 140.28
 23  No Name #30579
 Calc.
Raw		 71.79
27.33		 38.60
350.00		 26.96
20.67		 39.59
50.67		 0.00 138.34
 23  No Name #30861
 Calc.
Raw		 98.39
18.67		 71.69
650.00		 13.91
10.67		 25.78
33.00		 0.00 138.08
 24  No Name #34374
 Calc.
Raw		 97.33
21.00		 68.38
620.00		 34.32
26.32		 15.10
19.33		 10.00 136.75
 25  No Name #15407
 Calc.
Raw		 83.42
23.67		 52.94
480.00		 27.80
21.32		 18.49
23.67		 0.00 129.71
 26  No Name #32242
 Calc.
Raw		 63.39
25.67		 32.54
295.00		 34.78
26.67		 29.43
37.67		 0.00 127.60
 27  No Name #10789
 Calc.
Raw		 52.93
26.00		 22.61
205.00		 23.92
18.34		 42.97
55.00		 0.00 119.82
 27  No Name #22311
 Calc.
Raw		 65.53
24.33		 35.85
325.00		 29.99
23.00		 23.44
30.00		 0.00 118.96
 28  No Name #32206
 Calc.
Raw		 27.22
25.00		 0.00
0.00		 35.20
26.99		 51.30
65.67		 0.00 113.72
 29  No Name #34159
 Calc.
Raw		 47.05
26.67		 16.54
150.00		 27.39
21.00		 29.95
38.33		 0.00 104.39
 30  No Name #28003
 Calc.
Raw		 56.29
24.67		 27.02
245.00		 26.51
20.33		 20.57
26.33		 0.00 103.37
 31  No Name #26110
 Calc.
Raw		 28.18
23.67		 2.21
20.00		 32.59
24.99		 41.15
52.67		 0.00 101.92
 32  No Name #31228
 Calc.
Raw		 36.40
32.33		 1.10
10.00		 36.53
28.01		 26.30
33.67		 0.00 99.23
 33  No Name #3057
 Calc.
Raw		 54.08
17.67		 31.99
290.00		 28.25
21.66		 14.32
18.33		 0.00 96.65
 34  No Name #3422
 Calc.
Raw		 53.71
17.33		 31.99
290.00		 27.82
21.33		 14.06
18.00		 2.00 93.59
 35  No Name #3117
 Calc.
Raw		 40.64
21.33		 15.99
145.00		 26.10
20.01		 25.26
32.33		 0.00 92.00
 36  No Name #11548
 Calc.
Raw		 28.78
25.33		 1.10
10.00		 30.44
23.34		 30.47
39.00		 0.00 89.69
 37  No Name #34922
 Calc.
Raw		 57.60
25.33		 27.57
250.00		 23.04
17.67		 7.29
9.33		 0.00 87.93
 37  No Name #715
 Calc.
Raw		 48.29
15.67		 28.68
260.00		 21.30
16.33		 18.23
23.33		 0.00 87.82
 38  No Name #11428
 Calc.
Raw		 32.23
21.33		 8.27
75.00		 38.68
29.66		 15.63
20.00		 0.00 86.54
 38  No Name #29564
 Calc.
Raw		 40.12
31.33		 5.51
50.00		 21.31
16.34		 24.74
31.67		 0.00 86.17
 39  No Name #19877
 Calc.
Raw		 34.04
21.33		 9.93
90.00		 28.69
22.00		 14.32
18.33		 0.00 77.05
 40  No Name #2437
 Calc.
Raw		 15.97
14.67		 0.00
0.00		 22.17
17.00		 34.38
44.00		 0.00 72.52
 41  No Name #8903
 Calc.
Raw		 17.40
12.67		 3.31
30.00		 17.83
13.67		 27.87
35.67		 0.00 63.10
 42  No Name #11324
 Calc.
Raw		 13.91
11.67		 1.10
10.00		 13.47
10.33		 54.16
69.33		 20.00 61.54