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 |
200.00 32.66 |
150.00 1380.00 |
42.70 41.00 |
53.59 31.75 |
2.00 | 294.29 |
2 | No Name #34689 |
Calc. Raw |
186.66 37.33 |
133.15 1225.00 |
44.08 42.33 |
54.01 32.00 |
0.00 | 284.75 |
2 | No Name #32674 |
Calc. Raw |
192.92 34.34 |
141.85 1305.00 |
50.00 48.01 |
41.35 24.50 |
0.00 | 284.27 |
3 | No Name #22063 |
Calc. Raw |
138.71 32.66 |
94.02 865.00 |
44.78 43.00 |
100.00 59.25 |
0.00 | 283.49 |
4 | No Name #11606 |
Calc. Raw |
158.06 35.66 |
108.70 1000.00 |
45.47 43.66 |
60.76 36.00 |
0.00 | 264.29 |
4 | No Name #7158 |
Calc. Raw |
161.01 29.66 |
117.39 1080.00 |
42.35 40.66 |
60.76 36.00 |
0.00 | 264.12 |
5 | No Name #26200 |
Calc. Raw |
153.01 28.33 |
111.41 1025.00 |
45.13 43.33 |
63.29 37.50 |
0.00 | 261.43 |
5 | No Name #1965 |
Calc. Raw |
175.83 32.33 |
128.26 1180.00 |
44.09 42.34 |
41.35 24.50 |
0.00 | 261.27 |
6 | No Name #1595 |
Calc. Raw |
161.12 28.67 |
118.48 1090.00 |
41.65 39.99 |
57.38 34.00 |
0.00 | 260.15 |
7 | No Name #32995 |
Calc. Raw |
155.62 38.33 |
103.80 955.00 |
39.58 38.00 |
49.79 29.50 |
0.00 | 244.99 |
8 | No Name #32441 |
Calc. Raw |
129.95 39.33 |
79.35 730.00 |
50.00 48.01 |
62.87 37.25 |
0.00 | 242.82 |
9 | No Name #3637 |
Calc. Raw |
132.99 17.66 |
103.80 955.00 |
37.15 35.67 |
67.93 40.25 |
0.00 | 238.07 |
10 | No Name #24409 |
Calc. Raw |
143.41 35.33 |
95.65 880.00 |
36.10 34.66 |
55.27 32.75 |
0.00 | 234.78 |
11 | No Name #30704 |
Calc. Raw |
138.53 34.67 |
91.85 845.00 |
36.79 35.33 |
53.59 31.75 |
0.00 | 228.91 |
12 | No Name #5109 |
Calc. Raw |
124.35 29.33 |
84.24 775.00 |
42.35 40.66 |
60.34 35.75 |
0.00 | 227.04 |
13 | No Name #2680 |
Calc. Raw |
143.49 28.33 |
102.72 945.00 |
22.56 21.66 |
59.92 35.50 |
0.00 | 225.97 |
14 | No Name #12145 |
Calc. Raw |
139.77 32.00 |
95.65 880.00 |
40.26 38.66 |
43.04 25.50 |
0.00 | 223.07 |
15 | No Name #1149 |
Calc. Raw |
126.07 21.66 |
93.48 860.00 |
39.92 38.33 |
54.85 32.50 |
0.00 | 220.84 |
16 | No Name #11102 |
Calc. Raw |
130.70 21.00 |
98.37 905.00 |
38.53 37.00 |
54.85 32.50 |
10.00 | 214.08 |
17 | No Name #381 |
Calc. Raw |
112.73 26.33 |
76.63 705.00 |
39.58 38.00 |
56.12 33.25 |
0.00 | 208.43 |
17 | No Name #31232 |
Calc. Raw |
125.93 35.66 |
79.35 730.00 |
40.26 38.66 |
42.19 25.00 |
0.00 | 208.38 |
18 | No Name #33992 |
Calc. Raw |
121.92 32.00 |
79.35 730.00 |
27.08 26.00 |
57.38 34.00 |
0.00 | 206.38 |
19 | No Name #22311 |
Calc. Raw |
102.11 29.67 |
63.59 585.00 |
37.49 36.00 |
62.87 37.25 |
0.00 | 202.47 |
20 | No Name #28603 |
Calc. Raw |
106.97 34.66 |
63.04 580.00 |
35.42 34.01 |
56.96 33.75 |
0.00 | 199.35 |
21 | No Name #19063 |
Calc. Raw |
103.79 20.33 |
74.46 685.00 |
36.10 34.66 |
56.96 33.75 |
0.00 | 196.85 |
22 | No Name #6656 |
Calc. Raw |
103.97 33.00 |
61.96 570.00 |
39.23 37.67 |
45.99 27.25 |
0.00 | 189.19 |
22 | No Name #33422 |
Calc. Raw |
97.70 19.66 |
69.57 640.00 |
38.87 37.32 |
62.45 37.00 |
10.00 | 189.02 |
23 | No Name #786 |
Calc. Raw |
88.33 20.34 |
60.33 555.00 |
38.19 36.67 |
57.38 34.00 |
2.00 | 181.90 |
23 | No Name #23464 |
Calc. Raw |
88.08 20.66 |
59.78 550.00 |
27.42 26.33 |
66.24 39.25 |
0.00 | 181.74 |
24 | No Name #12897 |
Calc. Raw |
104.38 30.66 |
64.67 595.00 |
32.62 31.32 |
38.82 23.00 |
0.00 | 175.82 |
25 | No Name #26319 |
Calc. Raw |
46.93 21.66 |
21.20 195.00 |
32.97 31.66 |
90.30 53.50 |
0.00 | 170.20 |
26 | No Name #19945 |
Calc. Raw |
99.40 31.00 |
59.78 550.00 |
30.21 29.01 |
37.13 22.00 |
0.00 | 166.74 |
27 | No Name #3069 |
Calc. Raw |
71.17 25.33 |
39.67 365.00 |
37.84 36.33 |
54.01 32.00 |
0.00 | 163.02 |
28 | No Name #32969 |
Calc. Raw |
52.51 21.33 |
26.63 245.00 |
33.32 31.99 |
74.26 44.00 |
0.00 | 160.09 |
29 | No Name #13984 |
Calc. Raw |
71.25 33.00 |
32.07 295.00 |
47.56 45.67 |
37.97 22.50 |
0.00 | 156.78 |
30 | No Name #30941 |
Calc. Raw |
44.87 35.00 |
5.98 55.00 |
46.18 44.34 |
55.70 33.00 |
0.00 | 146.75 |
31 | No Name #13641 |
Calc. Raw |
49.18 31.33 |
13.59 125.00 |
35.06 33.66 |
57.38 34.00 |
0.00 | 141.62 |
32 | No Name #14991 |
Calc. Raw |
37.70 33.34 |
1.09 10.00 |
31.94 30.67 |
56.96 33.75 |
0.00 | 126.60 |
33 | No Name #33752 |
Calc. Raw |
29.59 22.67 |
4.35 40.00 |
25.34 24.33 |
58.65 34.75 |
0.00 | 113.58 |
34 | No Name #35285 |
Calc. Raw |
47.90 17.66 |
26.09 240.00 |
26.04 25.00 |
38.40 22.75 |
0.00 | 112.34 |
35 | No Name #32435 |
Calc. Raw |
22.87 16.00 |
4.89 45.00 |
24.65 23.67 |
54.01 32.00 |
0.00 | 101.53 |