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 II | ||||||||
Rank | Member | Long Term |
Weight | Style | Spont | Penalty | Total | |
1 | No Name #346 |
Calc. Raw |
178.38 21.00 |
150.00 1220.00 |
36.76 32.34 |
73.80 76.75 |
0.00 | 288.94 |
2 | No Name #5815 |
Calc. Raw |
146.45 24.67 |
113.11 920.00 |
50.00 43.99 |
64.90 67.50 |
0.00 | 261.35 |
3 | No Name #30390 |
Calc. Raw |
187.09 37.00 |
137.09 1115.00 |
27.65 24.33 |
43.99 45.75 |
0.00 | 258.73 |
4 | No Name #10720 |
Calc. Raw |
174.14 33.33 |
129.10 1050.00 |
20.85 18.34 |
59.38 61.75 |
0.00 | 254.37 |
4 | No Name #31523 |
Calc. Raw |
126.09 17.34 |
102.66 835.00 |
34.47 30.33 |
93.51 97.25 |
0.00 | 254.07 |
5 | No Name #35548 |
Calc. Raw |
120.84 18.00 |
96.52 785.00 |
18.95 16.67 |
100.00 104.00 |
0.00 | 239.79 |
6 | No Name #13505 |
Calc. Raw |
114.40 22.33 |
84.22 685.00 |
23.88 21.01 |
79.57 82.75 |
0.00 | 217.85 |
7 | No Name #416 |
Calc. Raw |
111.82 16.33 |
89.75 730.00 |
23.12 20.34 |
83.65 87.00 |
3.00 | 215.59 |
8 | No Name #1141 |
Calc. Raw |
126.12 26.00 |
90.98 740.00 |
16.67 14.67 |
69.71 72.50 |
0.00 | 212.50 |
9 | No Name #36481 |
Calc. Raw |
130.01 19.33 |
103.89 845.00 |
26.15 23.01 |
52.16 54.25 |
0.00 | 208.32 |
10 | No Name #36482 |
Calc. Raw |
121.21 16.00 |
99.59 810.00 |
34.09 29.99 |
48.32 50.25 |
0.00 | 203.62 |
10 | No Name #7958 |
Calc. Raw |
157.23 24.00 |
124.80 1015.00 |
23.87 21.00 |
26.68 27.75 |
5.00 | 202.78 |
11 | No Name #32282 |
Calc. Raw |
92.77 16.33 |
70.70 575.00 |
15.91 14.00 |
93.03 96.75 |
0.00 | 201.71 |
12 | No Name #31096 |
Calc. Raw |
124.24 17.33 |
100.82 820.00 |
26.90 23.67 |
45.19 47.00 |
0.00 | 196.33 |
13 | No Name #3060 |
Calc. Raw |
126.62 20.00 |
99.59 810.00 |
16.67 14.67 |
49.76 51.75 |
0.00 | 193.05 |
13 | No Name #18527 |
Calc. Raw |
92.31 26.00 |
57.17 465.00 |
29.55 26.00 |
70.67 73.50 |
0.00 | 192.53 |
14 | No Name #6986 |
Calc. Raw |
107.76 18.33 |
82.99 675.00 |
23.48 20.66 |
43.03 44.75 |
0.00 | 174.27 |
15 | No Name #32054 |
Calc. Raw |
91.70 16.00 |
70.08 570.00 |
28.42 25.00 |
51.44 53.50 |
0.00 | 171.56 |
16 | No Name #18918 |
Calc. Raw |
62.98 15.67 |
41.80 340.00 |
14.78 13.00 |
86.06 89.50 |
0.00 | 163.82 |
17 | No Name #35471 |
Calc. Raw |
81.29 14.66 |
61.48 500.00 |
29.56 26.01 |
50.24 52.25 |
0.00 | 161.09 |
18 | No Name #10029 |
Calc. Raw |
70.96 20.67 |
43.03 350.00 |
24.24 21.33 |
62.50 65.00 |
0.00 | 157.70 |
19 | No Name #16088 |
Calc. Raw |
96.38 19.00 |
70.70 575.00 |
23.10 20.32 |
34.38 35.75 |
0.00 | 153.86 |
20 | No Name #34374 |
Calc. Raw |
88.31 16.67 |
65.78 535.00 |
28.42 25.00 |
38.70 40.25 |
3.00 | 152.43 |
21 | No Name #34387 |
Calc. Raw |
71.91 15.00 |
51.64 420.00 |
29.93 26.33 |
49.04 51.00 |
0.00 | 150.88 |
21 | No Name #1140 |
Calc. Raw |
79.33 23.67 |
47.34 385.00 |
22.35 19.66 |
49.04 51.00 |
0.00 | 150.72 |
22 | No Name #14989 |
Calc. Raw |
53.55 12.33 |
36.89 300.00 |
30.31 26.67 |
65.14 67.75 |
0.00 | 149.00 |
22 | No Name #30515 |
Calc. Raw |
54.29 18.34 |
29.51 240.00 |
28.04 24.67 |
66.35 69.00 |
0.00 | 148.68 |
23 | No Name #25818 |
Calc. Raw |
72.06 29.67 |
31.97 260.00 |
30.69 27.00 |
41.35 43.00 |
0.00 | 144.10 |
24 | No Name #37168 |
Calc. Raw |
71.21 22.67 |
40.57 330.00 |
24.64 21.68 |
49.28 51.25 |
3.00 | 142.13 |
25 | No Name #37097 |
Calc. Raw |
19.87 8.33 |
8.61 70.00 |
28.04 24.67 |
92.31 96.00 |
0.00 | 140.22 |
26 | No Name #29418 |
Calc. Raw |
44.48 22.00 |
14.75 120.00 |
12.14 10.68 |
81.73 85.00 |
0.00 | 138.35 |
27 | No Name #36216 |
Calc. Raw |
96.78 20.67 |
68.85 560.00 |
14.03 12.34 |
23.56 24.50 |
0.00 | 134.37 |
28 | No Name #31873 |
Calc. Raw |
52.27 13.66 |
33.81 275.00 |
14.40 12.67 |
63.22 65.75 |
0.00 | 129.89 |
29 | No Name #2661 |
Calc. Raw |
35.64 20.00 |
8.61 70.00 |
26.90 23.67 |
65.87 68.50 |
0.00 | 128.41 |
30 | No Name #3422 |
Calc. Raw |
39.81 24.00 |
7.38 60.00 |
26.14 23.00 |
55.29 57.50 |
0.00 | 121.24 |
31 | No Name #34690 |
Calc. Raw |
30.68 16.33 |
8.61 70.00 |
21.98 19.34 |
66.11 68.75 |
0.00 | 118.77 |
31 | No Name #33956 |
Calc. Raw |
35.47 15.33 |
14.75 120.00 |
21.22 18.67 |
66.59 69.25 |
5.00 | 118.28 |
32 | No Name #30867 |
Calc. Raw |
37.31 25.34 |
3.07 25.00 |
19.70 17.33 |
59.13 61.50 |
0.00 | 116.14 |
32 | No Name #30704 |
Calc. Raw |
35.39 18.00 |
11.07 90.00 |
24.63 21.67 |
56.01 58.25 |
0.00 | 116.03 |
32 | No Name #37167 |
Calc. Raw |
44.95 17.34 |
21.52 175.00 |
26.89 23.66 |
43.51 45.25 |
0.00 | 115.35 |
33 | No Name #33527 |
Calc. Raw |
39.99 13.67 |
21.52 175.00 |
12.12 10.66 |
62.26 64.75 |
0.00 | 114.37 |
34 | No Name #35971 |
Calc. Raw |
19.69 13.66 |
1.23 10.00 |
15.92 14.01 |
76.68 79.75 |
0.00 | 112.29 |
34 | No Name #35161 |
Calc. Raw |
25.85 13.67 |
7.38 60.00 |
21.98 19.34 |
63.70 66.25 |
0.00 | 111.53 |
35 | No Name #33345 |
Calc. Raw |
52.38 29.66 |
12.30 100.00 |
23.12 20.34 |
28.13 29.25 |
0.00 | 103.63 |
35 | No Name #2437 |
Calc. Raw |
24.77 18.33 |
0.00 0.00 |
14.40 12.67 |
64.42 67.00 |
0.00 | 103.59 |
36 | No Name #30595 |
Calc. Raw |
39.48 14.66 |
19.67 160.00 |
22.73 20.00 |
38.94 40.50 |
0.00 | 101.15 |
37 | No Name #36669 |
Calc. Raw |
47.20 19.00 |
21.52 175.00 |
20.85 18.34 |
40.63 42.25 |
10.00 | 98.68 |
37 | No Name #13318 |
Calc. Raw |
29.08 13.33 |
11.07 90.00 |
22.73 20.00 |
46.63 48.50 |
0.00 | 98.44 |
38 | No Name #21189 |
Calc. Raw |
50.35 16.33 |
28.28 230.00 |
13.28 11.68 |
33.41 34.75 |
0.00 | 97.04 |
38 | No Name #22186 |
Calc. Raw |
28.31 13.67 |
9.84 80.00 |
25.01 22.00 |
43.51 45.25 |
0.00 | 96.83 |
38 | No Name #17231 |
Calc. Raw |
36.17 22.67 |
5.53 45.00 |
15.54 13.67 |
44.47 46.25 |
0.00 | 96.18 |
39 | No Name #35698 |
Calc. Raw |
24.66 17.34 |
1.23 10.00 |
12.49 10.99 |
56.25 58.50 |
0.00 | 93.40 |
39 | No Name #34899 |
Calc. Raw |
36.95 22.34 |
6.76 55.00 |
23.88 21.01 |
32.21 33.50 |
0.00 | 93.04 |
40 | No Name #36225 |
Calc. Raw |
19.81 14.66 |
0.00 0.00 |
17.81 15.67 |
53.37 55.50 |
0.00 | 90.99 |
41 | No Name #21059 |
Calc. Raw |
22.19 12.33 |
5.53 45.00 |
23.87 21.00 |
42.31 44.00 |
0.00 | 88.37 |
42 | No Name #21030 |
Calc. Raw |
24.33 13.00 |
6.76 55.00 |
24.24 21.33 |
38.70 40.25 |
0.00 | 87.27 |
42 | No Name #2271 |
Calc. Raw |
49.54 13.00 |
31.97 260.00 |
15.53 13.66 |
22.12 23.00 |
0.00 | 87.19 |
43 | No Name #36640 |
Calc. Raw |
33.66 24.00 |
1.23 10.00 |
19.70 17.33 |
32.21 33.50 |
0.00 | 85.57 |
43 | No Name #31624 |
Calc. Raw |
28.19 12.67 |
11.07 90.00 |
24.63 21.67 |
32.45 33.75 |
0.00 | 85.27 |
43 | No Name #21803 |
Calc. Raw |
25.23 18.67 |
0.00 0.00 |
28.05 24.68 |
31.97 33.25 |
0.00 | 85.25 |
43 | No Name #22504 |
Calc. Raw |
35.84 13.33 |
17.83 145.00 |
18.20 16.01 |
33.89 35.25 |
3.00 | 84.93 |
44 | No Name #33816 |
Calc. Raw |
27.03 20.00 |
0.00 0.00 |
14.41 12.68 |
25.48 26.50 |
0.00 | 66.92 |
45 | No Name #30579 |
Calc. Raw |
22.73 15.00 |
2.46 20.00 |
12.88 11.33 |
27.88 29.00 |
10.00 | 53.49 |