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 )
Problem 4 Out Of The Box Balsa Division I | ||||||||
Rank | Member | Long Term |
Weight | Style | Spont | Penalty | Total | |
1 | No Name #34768 |
Calc. Raw |
175.72 34.00 |
127.15 1085.00 |
50.00 46.00 |
66.85 61.50 |
5.00 | 287.57 |
2 | No Name #31486 |
Calc. Raw |
183.80 23.66 |
150.00 1280.00 |
40.58 37.33 |
52.45 48.25 |
30.00 | 246.83 |
3 | No Name #14138 |
Calc. Raw |
139.12 27.66 |
99.61 850.00 |
35.14 32.33 |
67.66 62.25 |
0.00 | 241.92 |
4 | No Name #11374 |
Calc. Raw |
113.46 22.00 |
82.03 700.00 |
38.77 35.67 |
80.98 74.50 |
2.00 | 231.21 |
5 | No Name #4645 |
Calc. Raw |
118.26 32.33 |
72.07 615.00 |
21.74 20.00 |
85.05 78.25 |
0.00 | 225.05 |
6 | No Name #1388 |
Calc. Raw |
134.93 22.67 |
102.54 875.00 |
40.22 37.00 |
44.02 40.50 |
5.00 | 214.17 |
7 | No Name #34903 |
Calc. Raw |
114.81 25.00 |
79.10 675.00 |
19.21 17.67 |
60.60 55.75 |
0.00 | 194.62 |
8 | No Name #2432 |
Calc. Raw |
134.05 25.34 |
97.85 835.00 |
31.16 28.67 |
25.27 23.25 |
0.00 | 190.48 |
9 | No Name #4639 |
Calc. Raw |
105.47 21.33 |
75.00 640.00 |
36.59 33.66 |
44.29 40.75 |
0.00 | 186.35 |
10 | No Name #36971 |
Calc. Raw |
96.46 27.33 |
57.42 490.00 |
40.22 37.00 |
35.60 32.75 |
0.00 | 172.28 |
11 | No Name #30339 |
Calc. Raw |
130.56 16.33 |
107.23 915.00 |
32.25 29.67 |
24.46 22.50 |
20.00 | 167.27 |
11 | No Name #37166 |
Calc. Raw |
104.49 35.00 |
54.49 465.00 |
30.79 28.33 |
31.25 28.75 |
0.00 | 166.53 |
12 | No Name #35273 |
Calc. Raw |
77.86 18.00 |
52.15 445.00 |
34.79 32.01 |
58.42 53.75 |
5.00 | 166.07 |
13 | No Name #35282 |
Calc. Raw |
46.56 17.00 |
22.27 190.00 |
14.13 13.00 |
100.00 92.00 |
0.00 | 160.69 |
13 | No Name #8147 |
Calc. Raw |
124.92 21.00 |
94.92 810.00 |
26.46 24.34 |
13.59 12.50 |
5.00 | 159.97 |
14 | No Name #20906 |
Calc. Raw |
90.71 21.66 |
59.77 510.00 |
40.58 37.33 |
27.45 25.25 |
0.00 | 158.74 |
14 | No Name #31388 |
Calc. Raw |
109.08 19.34 |
81.45 695.00 |
23.20 21.34 |
26.36 24.25 |
0.00 | 158.64 |
15 | No Name #34320 |
Calc. Raw |
96.03 23.33 |
62.70 535.00 |
25.72 23.66 |
35.87 33.00 |
0.00 | 157.62 |
16 | No Name #30242 |
Calc. Raw |
47.03 17.33 |
22.27 190.00 |
26.82 24.67 |
80.98 74.50 |
0.00 | 154.83 |
16 | No Name #31310 |
Calc. Raw |
64.24 16.67 |
40.43 345.00 |
30.43 28.00 |
60.33 55.50 |
1.00 | 154.00 |
17 | No Name #30200 |
Calc. Raw |
67.47 24.67 |
32.23 275.00 |
43.84 40.33 |
37.77 34.75 |
0.00 | 149.08 |
17 | No Name #32164 |
Calc. Raw |
61.83 18.67 |
35.16 300.00 |
28.62 26.33 |
57.88 53.25 |
0.00 | 148.33 |
18 | No Name #35789 |
Calc. Raw |
82.76 22.66 |
50.39 430.00 |
21.37 19.66 |
43.75 40.25 |
0.00 | 147.88 |
19 | No Name #35477 |
Calc. Raw |
78.44 18.00 |
52.73 450.00 |
22.11 20.34 |
45.65 42.00 |
0.00 | 146.20 |
20 | No Name #36495 |
Calc. Raw |
36.89 19.67 |
8.79 75.00 |
18.84 17.33 |
85.33 78.50 |
0.00 | 141.06 |
21 | No Name #36576 |
Calc. Raw |
47.25 16.67 |
23.44 200.00 |
34.41 31.66 |
53.80 49.50 |
0.00 | 135.46 |
21 | No Name #20039 |
Calc. Raw |
84.56 24.33 |
49.80 425.00 |
16.67 15.34 |
33.70 31.00 |
0.00 | 134.93 |
22 | No Name #15746 |
Calc. Raw |
34.55 14.34 |
14.06 120.00 |
22.83 21.00 |
75.54 69.50 |
0.00 | 132.92 |
23 | No Name #27311 |
Calc. Raw |
43.99 17.67 |
18.75 160.00 |
16.66 15.33 |
68.21 62.75 |
0.00 | 128.86 |
24 | No Name #37165 |
Calc. Raw |
62.88 19.00 |
35.74 305.00 |
23.92 22.01 |
45.65 42.00 |
5.00 | 127.45 |
25 | No Name #30823 |
Calc. Raw |
80.55 27.67 |
41.02 350.00 |
23.55 21.67 |
15.76 14.50 |
0.00 | 119.86 |
25 | No Name #1544 |
Calc. Raw |
44.20 22.33 |
12.30 105.00 |
23.90 21.99 |
51.09 47.00 |
0.00 | 119.19 |
26 | No Name #24450 |
Calc. Raw |
56.11 20.00 |
27.54 235.00 |
30.08 27.67 |
32.34 29.75 |
0.00 | 118.53 |
26 | No Name #32181 |
Calc. Raw |
67.53 17.33 |
42.77 365.00 |
38.41 35.34 |
22.55 20.75 |
10.00 | 118.49 |
27 | No Name #35570 |
Calc. Raw |
47.39 18.00 |
21.68 185.00 |
22.11 20.34 |
47.28 43.50 |
0.00 | 116.78 |
28 | No Name #36048 |
Calc. Raw |
38.31 26.00 |
1.17 10.00 |
23.18 21.33 |
52.72 48.50 |
0.00 | 114.21 |
29 | No Name #35604 |
Calc. Raw |
41.40 11.34 |
25.20 215.00 |
25.00 23.00 |
45.65 42.00 |
0.00 | 112.05 |
29 | No Name #3422 |
Calc. Raw |
50.37 30.34 |
7.03 60.00 |
25.73 23.67 |
35.05 32.25 |
0.00 | 111.15 |
30 | No Name #31899 |
Calc. Raw |
35.09 18.00 |
9.38 80.00 |
22.47 20.67 |
52.45 48.25 |
0.00 | 110.01 |
30 | No Name #36460 |
Calc. Raw |
47.39 18.00 |
21.68 185.00 |
27.90 25.67 |
34.51 31.75 |
0.00 | 109.80 |
31 | No Name #16925 |
Calc. Raw |
56.11 25.33 |
19.92 170.00 |
24.27 22.33 |
26.63 24.50 |
5.00 | 102.01 |
32 | No Name #37028 |
Calc. Raw |
41.14 15.67 |
18.75 160.00 |
27.53 25.33 |
32.07 29.50 |
0.00 | 100.74 |
33 | No Name #32898 |
Calc. Raw |
33.81 18.33 |
7.62 65.00 |
10.14 9.33 |
55.16 50.75 |
0.00 | 99.11 |
34 | No Name #8704 |
Calc. Raw |
25.93 17.33 |
1.17 10.00 |
28.26 26.00 |
42.93 39.50 |
0.00 | 97.12 |
35 | No Name #10655 |
Calc. Raw |
26.14 16.66 |
2.34 20.00 |
32.24 29.66 |
35.05 32.25 |
0.00 | 93.43 |
36 | No Name #2437 |
Calc. Raw |
21.90 15.33 |
0.00 0.00 |
15.95 14.67 |
53.80 49.50 |
0.00 | 91.65 |
36 | No Name #35727 |
Calc. Raw |
30.83 16.66 |
7.03 60.00 |
20.29 18.67 |
40.22 37.00 |
0.00 | 91.34 |
37 | No Name #30595 |
Calc. Raw |
50.51 21.00 |
20.51 175.00 |
24.64 22.67 |
13.86 12.75 |
0.00 | 89.01 |