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 2 Tech Transfer Division II | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #29726 |
Calc. Raw |
178.05 146.00 |
48.48 32.00 |
95.78 204.50 |
0.00 | 322.31 | |
2 | No Name #30595 |
Calc. Raw |
185.37 152.00 |
40.41 26.67 |
91.80 196.00 |
0.00 | 317.58 | |
3 | No Name #11901 |
Calc. Raw |
181.71 149.00 |
46.47 30.67 |
87.82 187.50 |
0.00 | 316.00 | |
4 | No Name #1386 |
Calc. Raw |
200.00 164.00 |
42.94 28.34 |
61.12 130.50 |
0.00 | 304.06 | |
5 | No Name #31523 |
Calc. Raw |
175.61 144.00 |
37.38 24.67 |
87.70 187.25 |
0.00 | 300.69 | |
6 | No Name #30853 |
Calc. Raw |
184.15 151.00 |
38.38 25.33 |
73.77 157.50 |
0.00 | 296.30 | |
7 | No Name #31702 |
Calc. Raw |
170.12 139.50 |
45.45 30.00 |
79.51 169.75 |
0.00 | 295.08 | |
8 | No Name #32066 |
Calc. Raw |
183.54 150.50 |
32.32 21.33 |
76.70 163.75 |
0.00 | 292.56 | |
8 | No Name #10036 |
Calc. Raw |
195.12 160.00 |
50.00 33.00 |
47.07 100.50 |
0.00 | 292.19 | |
9 | No Name #33422 |
Calc. Raw |
157.93 129.50 |
36.86 24.33 |
96.72 206.50 |
0.00 | 291.51 | |
10 | No Name #17182 |
Calc. Raw |
188.41 154.50 |
38.89 25.67 |
61.94 132.25 |
0.00 | 289.24 | |
11 | No Name #1375 |
Calc. Raw |
187.80 154.00 |
37.88 25.00 |
61.94 132.25 |
0.00 | 287.62 | |
11 | No Name #29467 |
Calc. Raw |
181.10 148.50 |
44.44 29.33 |
61.36 131.00 |
0.00 | 286.90 | |
12 | No Name #18227 |
Calc. Raw |
185.98 152.50 |
44.44 29.33 |
54.33 116.00 |
0.00 | 284.75 | |
13 | No Name #10414 |
Calc. Raw |
186.59 153.00 |
36.86 24.33 |
53.51 114.25 |
0.00 | 276.96 | |
13 | No Name #2344 |
Calc. Raw |
154.88 127.00 |
33.83 22.33 |
88.88 189.75 |
1.00 | 276.59 | |
13 | No Name #11324 |
Calc. Raw |
155.49 127.50 |
20.71 13.67 |
100.00 213.50 |
0.00 | 276.20 | |
14 | No Name #34422 |
Calc. Raw |
162.20 133.00 |
31.82 21.00 |
73.42 156.75 |
0.00 | 267.44 | |
14 | No Name #34983 |
Calc. Raw |
155.49 127.50 |
32.33 21.34 |
81.26 173.50 |
2.00 | 267.08 | |
15 | No Name #35139 |
Calc. Raw |
137.80 113.00 |
28.80 19.01 |
97.42 208.00 |
0.00 | 264.02 | |
15 | No Name #34760 |
Calc. Raw |
160.37 131.50 |
34.35 22.67 |
72.48 154.75 |
4.00 | 263.20 | |
16 | No Name #3249 |
Calc. Raw |
175.61 144.00 |
44.44 29.33 |
36.89 78.75 |
0.00 | 256.94 | |
16 | No Name #2269 |
Calc. Raw |
179.27 147.00 |
34.85 23.00 |
42.74 91.25 |
0.00 | 256.86 | |
17 | No Name #31161 |
Calc. Raw |
172.56 141.50 |
31.32 20.67 |
51.76 110.50 |
0.00 | 255.64 | |
17 | No Name #28695 |
Calc. Raw |
170.73 140.00 |
37.88 25.00 |
66.51 142.00 |
20.00 | 255.12 | |
17 | No Name #34175 |
Calc. Raw |
164.63 135.00 |
32.32 21.33 |
60.77 129.75 |
3.00 | 254.72 | |
18 | No Name #9361 |
Calc. Raw |
145.73 119.50 |
26.27 17.34 |
82.20 175.50 |
0.00 | 254.20 | |
19 | No Name #10680 |
Calc. Raw |
125.61 103.00 |
38.88 25.66 |
87.94 187.75 |
0.00 | 252.43 | |
20 | No Name #21101 |
Calc. Raw |
150.61 123.50 |
27.79 18.34 |
68.97 147.25 |
0.00 | 247.37 | |
21 | No Name #31230 |
Calc. Raw |
107.93 88.50 |
36.86 24.33 |
98.24 209.75 |
0.00 | 243.03 | |
21 | No Name #31873 |
Calc. Raw |
137.80 113.00 |
21.73 14.34 |
82.67 176.50 |
0.00 | 242.20 | |
22 | No Name #31912 |
Calc. Raw |
176.83 145.00 |
36.88 24.34 |
24.36 52.00 |
0.00 | 238.07 | |
23 | No Name #35907 |
Calc. Raw |
131.10 107.50 |
21.21 14.00 |
84.31 180.00 |
0.00 | 236.62 | |
24 | No Name #32908 |
Calc. Raw |
167.07 137.00 |
34.33 22.66 |
32.55 69.50 |
0.00 | 233.95 | |
25 | No Name #35647 |
Calc. Raw |
143.90 118.00 |
25.76 17.00 |
62.76 134.00 |
2.00 | 230.42 | |
26 | No Name #31604 |
Calc. Raw |
101.22 83.00 |
31.82 21.00 |
94.38 201.50 |
0.00 | 227.42 | |
27 | No Name #35658 |
Calc. Raw |
106.10 87.00 |
28.79 19.00 |
90.87 194.00 |
0.00 | 225.76 | |
28 | No Name #16559 |
Calc. Raw |
132.93 109.00 |
17.68 11.67 |
67.80 144.75 |
1.00 | 217.41 | |
29 | No Name #2437 |
Calc. Raw |
126.83 104.00 |
32.85 21.68 |
51.64 110.25 |
0.00 | 211.32 | |
30 | No Name #35576 |
Calc. Raw |
144.51 118.50 |
22.73 15.00 |
32.08 68.50 |
0.00 | 199.32 | |
30 | No Name #468 |
Calc. Raw |
130.49 107.00 |
41.92 27.67 |
26.93 57.50 |
1.00 | 198.34 | |
31 | No Name #33017 |
Calc. Raw |
143.90 118.00 |
22.23 14.67 |
30.33 64.75 |
0.00 | 196.46 | |
32 | No Name #30749 |
Calc. Raw |
101.22 83.00 |
34.35 22.67 |
83.61 178.50 |
25.00 | 194.18 | |
32 | No Name #34811 |
Calc. Raw |
114.63 94.00 |
38.89 25.67 |
40.40 86.25 |
0.00 | 193.92 | |
32 | No Name #23293 |
Calc. Raw |
87.20 71.50 |
31.82 21.00 |
74.59 159.25 |
0.00 | 193.61 | |
32 | No Name #13791 |
Calc. Raw |
146.34 120.00 |
43.94 29.00 |
28.22 60.25 |
25.00 | 193.50 | |
33 | No Name #10706 |
Calc. Raw |
120.12 98.50 |
32.83 21.67 |
38.76 82.75 |
0.00 | 191.71 | |
34 | No Name #20708 |
Calc. Raw |
73.17 60.00 |
26.26 17.33 |
86.53 184.75 |
0.00 | 185.96 | |
35 | No Name #11548 |
Calc. Raw |
107.93 88.50 |
39.89 26.33 |
33.14 70.75 |
0.00 | 180.96 | |
36 | No Name #25320 |
Calc. Raw |
89.63 73.50 |
38.88 25.66 |
49.41 105.50 |
0.00 | 177.92 | |
37 | No Name #32743 |
Calc. Raw |
55.49 45.50 |
17.68 11.67 |
97.54 208.25 |
1.00 | 169.71 | |
37 | No Name #22248 |
Calc. Raw |
119.51 98.00 |
18.20 12.01 |
33.14 70.75 |
2.00 | 168.85 | |
38 | No Name #789 |
Calc. Raw |
71.34 58.50 |
43.94 29.00 |
42.04 89.75 |
1.00 | 156.32 | |
39 | No Name #32199 |
Calc. Raw |
67.68 55.50 |
25.76 17.00 |
35.71 76.25 |
15.00 | 114.15 |