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 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 |