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 III | ||||||||
Rank | Member | Long Term |
Weight | Style | Spont | Penalty | Total | |
1 | No Name #2660 |
Calc. Raw |
190.52 37.00 |
150.00 980.00 |
38.49 35.67 |
77.95 137.00 |
10.00 | 296.96 |
2 | No Name #7158 |
Calc. Raw |
166.07 43.33 |
118.62 775.00 |
48.55 45.00 |
79.37 139.50 |
0.00 | 293.99 |
3 | No Name #2130 |
Calc. Raw |
167.86 38.67 |
125.51 820.00 |
42.80 39.67 |
78.81 138.50 |
0.00 | 289.47 |
4 | No Name #32995 |
Calc. Raw |
160.59 38.33 |
118.62 775.00 |
41.00 38.00 |
75.11 132.00 |
0.00 | 276.70 |
5 | No Name #11102 |
Calc. Raw |
158.64 39.34 |
115.56 755.00 |
38.84 36.00 |
76.39 134.25 |
0.00 | 273.87 |
6 | No Name #20368 |
Calc. Raw |
149.49 45.66 |
99.49 650.00 |
49.28 45.67 |
70.55 124.00 |
0.00 | 269.32 |
7 | No Name #17473 |
Calc. Raw |
139.27 36.33 |
99.49 650.00 |
41.37 38.34 |
87.20 153.25 |
0.00 | 267.84 |
8 | No Name #34398 |
Calc. Raw |
157.32 35.34 |
118.62 775.00 |
44.24 41.00 |
59.60 104.75 |
0.00 | 261.16 |
9 | No Name #3637 |
Calc. Raw |
188.80 40.33 |
144.64 945.00 |
39.20 36.33 |
27.88 49.00 |
0.00 | 255.88 |
10 | No Name #2680 |
Calc. Raw |
124.90 26.00 |
96.43 630.00 |
30.58 28.34 |
97.87 172.00 |
0.00 | 253.35 |
11 | No Name #5109 |
Calc. Raw |
172.60 43.00 |
125.51 820.00 |
48.91 45.33 |
21.48 37.75 |
0.00 | 242.99 |
12 | No Name #19945 |
Calc. Raw |
116.31 29.34 |
84.18 550.00 |
41.72 38.67 |
80.94 142.25 |
0.00 | 238.97 |
13 | No Name #26200 |
Calc. Raw |
127.09 42.67 |
80.36 525.00 |
46.04 42.67 |
63.73 112.00 |
0.00 | 236.86 |
14 | No Name #22063 |
Calc. Raw |
142.86 41.00 |
97.96 640.00 |
47.12 43.67 |
44.95 79.00 |
0.00 | 234.93 |
15 | No Name #24409 |
Calc. Raw |
107.78 31.33 |
73.47 480.00 |
43.52 40.33 |
79.94 140.50 |
0.00 | 231.24 |
16 | No Name #32374 |
Calc. Raw |
106.91 33.33 |
70.41 460.00 |
42.44 39.33 |
68.28 120.00 |
0.00 | 217.63 |
16 | No Name #34619 |
Calc. Raw |
97.96 43.33 |
50.51 330.00 |
50.00 46.34 |
68.85 121.00 |
0.00 | 216.81 |
17 | No Name #34281 |
Calc. Raw |
71.54 36.67 |
31.38 205.00 |
44.61 41.34 |
100.00 175.75 |
0.00 | 216.15 |
18 | No Name #32435 |
Calc. Raw |
118.79 33.00 |
82.65 540.00 |
35.25 32.67 |
53.63 94.25 |
0.00 | 207.67 |
19 | No Name #31161 |
Calc. Raw |
98.56 32.00 |
63.52 415.00 |
34.18 31.68 |
68.85 121.00 |
0.00 | 201.59 |
20 | No Name #1269 |
Calc. Raw |
132.32 37.67 |
91.07 595.00 |
42.44 39.33 |
23.04 40.50 |
0.00 | 197.80 |
21 | No Name #19633 |
Calc. Raw |
91.57 34.00 |
54.34 355.00 |
38.12 35.33 |
66.86 117.50 |
0.00 | 196.55 |
21 | No Name #3887 |
Calc. Raw |
114.90 34.34 |
77.30 505.00 |
42.80 39.67 |
38.69 68.00 |
0.00 | 196.39 |
22 | No Name #17250 |
Calc. Raw |
52.76 37.00 |
12.24 80.00 |
42.45 39.34 |
98.29 172.75 |
0.00 | 193.50 |
23 | No Name #34807 |
Calc. Raw |
89.33 32.66 |
53.57 350.00 |
42.08 39.00 |
59.89 105.25 |
0.00 | 191.30 |
24 | No Name #32441 |
Calc. Raw |
91.69 39.00 |
48.98 320.00 |
42.08 39.00 |
55.90 98.25 |
0.00 | 189.67 |
24 | No Name #13641 |
Calc. Raw |
96.39 37.00 |
55.87 365.00 |
35.25 32.67 |
57.89 101.75 |
0.00 | 189.53 |
25 | No Name #26319 |
Calc. Raw |
81.53 28.33 |
50.51 330.00 |
38.49 35.67 |
66.86 117.50 |
0.00 | 186.88 |
26 | No Name #14588 |
Calc. Raw |
124.76 35.66 |
85.71 560.00 |
38.49 35.67 |
22.62 39.75 |
0.00 | 185.87 |
26 | No Name #3069 |
Calc. Raw |
117.71 39.00 |
75.00 490.00 |
44.59 41.33 |
23.47 41.25 |
0.00 | 185.77 |
27 | No Name #21439 |
Calc. Raw |
81.51 36.00 |
42.09 275.00 |
40.29 37.34 |
58.61 103.00 |
0.00 | 180.41 |
27 | No Name #33343 |
Calc. Raw |
116.72 36.00 |
77.30 505.00 |
41.37 38.34 |
21.91 38.50 |
0.00 | 180.00 |
28 | No Name #30049 |
Calc. Raw |
111.61 38.33 |
69.64 455.00 |
43.17 40.01 |
20.34 35.75 |
0.00 | 175.12 |
28 | No Name #34806 |
Calc. Raw |
87.20 37.00 |
46.68 305.00 |
41.72 38.67 |
60.60 106.50 |
15.00 | 174.52 |
29 | No Name #32497 |
Calc. Raw |
100.83 39.66 |
57.40 375.00 |
47.83 44.33 |
21.91 38.50 |
0.00 | 170.57 |
30 | No Name #15515 |
Calc. Raw |
94.99 34.33 |
57.40 375.00 |
42.80 39.67 |
28.17 49.50 |
0.00 | 165.96 |
31 | No Name #35739 |
Calc. Raw |
97.43 38.66 |
55.10 360.00 |
43.16 40.00 |
21.05 37.00 |
0.00 | 161.64 |
32 | No Name #3473 |
Calc. Raw |
103.70 29.00 |
71.94 470.00 |
33.82 31.34 |
22.05 38.75 |
0.00 | 159.57 |
33 | No Name #17068 |
Calc. Raw |
103.96 31.34 |
69.64 455.00 |
34.53 32.00 |
19.77 34.75 |
0.00 | 158.26 |
34 | No Name #31228 |
Calc. Raw |
80.14 40.34 |
35.97 235.00 |
42.08 39.00 |
29.30 51.50 |
0.00 | 151.52 |
35 | No Name #32868 |
Calc. Raw |
81.34 39.33 |
38.27 250.00 |
40.65 37.67 |
25.18 44.25 |
0.00 | 147.17 |
36 | No Name #2149 |
Calc. Raw |
177.67 41.34 |
132.40 865.00 |
46.76 43.34 |
21.48 37.75 |
100.00 | 145.91 |
37 | No Name #786 |
Calc. Raw |
85.21 38.67 |
42.86 280.00 |
41.72 38.67 |
14.51 25.50 |
0.00 | 141.44 |
38 | No Name #2039 |
Calc. Raw |
65.46 28.33 |
34.44 225.00 |
34.89 32.34 |
21.62 38.00 |
0.00 | 121.97 |
39 | No Name #17622 |
Calc. Raw |
66.42 32.00 |
31.38 205.00 |
29.86 27.67 |
22.33 39.25 |
0.00 | 118.61 |
40 | No Name #33116 |
Calc. Raw |
43.35 27.00 |
13.78 90.00 |
35.97 33.34 |
24.18 42.50 |
0.00 | 103.50 |
40 | No Name #30579 |
Calc. Raw |
46.19 31.00 |
12.24 80.00 |
37.05 34.34 |
19.63 34.50 |
0.00 | 102.87 |
No Name #35342 |
Calc. Raw |
0.00 0.00 |
0.00 0.00 |
0.00 0.00 |
0.00 0.00 |
0.00 | 0.00 |