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 I | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #34094 |
Calc. Raw |
200.00 160.50 |
46.79 34.00 |
92.73 97.67 |
0.00 | 339.52 | |
2 | No Name #532 |
Calc. Raw |
191.28 153.50 |
48.17 35.00 |
78.49 82.67 |
0.00 | 317.94 | |
3 | No Name #18112 |
Calc. Raw |
188.16 151.00 |
37.63 27.34 |
82.28 86.67 |
0.00 | 308.07 | |
4 | No Name #35403 |
Calc. Raw |
179.44 144.00 |
33.03 24.00 |
89.88 94.67 |
0.00 | 302.35 | |
5 | No Name #17473 |
Calc. Raw |
176.95 142.00 |
33.04 24.01 |
91.14 96.00 |
0.00 | 301.13 | |
6 | No Name #10061 |
Calc. Raw |
170.09 136.50 |
40.83 29.67 |
88.61 93.33 |
0.00 | 299.53 | |
7 | No Name #3260 |
Calc. Raw |
177.57 142.50 |
50.00 36.33 |
69.62 73.33 |
0.00 | 297.19 | |
7 | No Name #34123 |
Calc. Raw |
171.34 137.50 |
42.21 30.67 |
83.55 88.00 |
0.00 | 297.10 | |
8 | No Name #5128 |
Calc. Raw |
170.72 137.00 |
33.03 24.00 |
83.86 88.33 |
0.00 | 287.61 | |
9 | No Name #26347 |
Calc. Raw |
177.57 142.50 |
42.21 30.67 |
63.30 66.67 |
0.00 | 283.08 | |
10 | No Name #18449 |
Calc. Raw |
164.49 132.00 |
33.03 24.00 |
81.01 85.33 |
0.00 | 278.53 | |
11 | No Name #35803 |
Calc. Raw |
173.21 139.00 |
31.65 23.00 |
72.15 76.00 |
0.00 | 277.01 | |
12 | No Name #34504 |
Calc. Raw |
160.12 128.50 |
30.28 22.00 |
82.28 86.67 |
0.00 | 272.68 | |
13 | No Name #30179 |
Calc. Raw |
171.96 138.00 |
36.71 26.67 |
62.02 65.33 |
0.00 | 270.69 | |
14 | No Name #27122 |
Calc. Raw |
165.11 132.50 |
24.77 18.00 |
79.75 84.00 |
0.00 | 269.63 | |
15 | No Name #30361 |
Calc. Raw |
165.11 132.50 |
28.90 21.00 |
73.42 77.33 |
0.00 | 267.43 | |
16 | No Name #34829 |
Calc. Raw |
166.36 133.50 |
25.23 18.33 |
73.42 77.33 |
0.00 | 265.01 | |
17 | No Name #35282 |
Calc. Raw |
165.11 132.50 |
29.34 21.32 |
68.36 72.00 |
0.00 | 262.81 | |
18 | No Name #36008 |
Calc. Raw |
171.96 138.00 |
29.37 21.34 |
58.23 61.33 |
0.00 | 259.56 | |
19 | No Name #1500 |
Calc. Raw |
142.68 114.50 |
31.20 22.67 |
83.55 88.00 |
0.00 | 257.43 | |
20 | No Name #34320 |
Calc. Raw |
148.91 119.50 |
35.33 25.67 |
70.89 74.67 |
0.00 | 255.13 | |
20 | No Name #2272 |
Calc. Raw |
163.24 131.00 |
30.73 22.33 |
60.76 64.00 |
0.00 | 254.73 | |
21 | No Name #31305 |
Calc. Raw |
151.40 121.50 |
34.41 25.00 |
67.09 70.67 |
0.00 | 252.90 | |
22 | No Name #35667 |
Calc. Raw |
171.34 137.50 |
31.65 23.00 |
48.11 50.67 |
1.00 | 250.10 | |
22 | No Name #35666 |
Calc. Raw |
156.39 125.50 |
28.45 20.67 |
64.56 68.00 |
0.00 | 249.40 | |
23 | No Name #12534 |
Calc. Raw |
157.63 126.50 |
23.40 17.00 |
67.09 70.67 |
0.00 | 248.12 | |
24 | No Name #9971 |
Calc. Raw |
150.16 120.50 |
27.98 20.33 |
68.36 72.00 |
0.00 | 246.50 | |
24 | No Name #34399 |
Calc. Raw |
152.02 122.00 |
33.48 24.33 |
60.76 64.00 |
0.00 | 246.26 | |
24 | No Name #2746 |
Calc. Raw |
123.36 99.00 |
38.08 27.67 |
84.81 89.33 |
0.00 | 246.25 | |
25 | No Name #715 |
Calc. Raw |
146.42 117.50 |
22.96 16.68 |
75.95 80.00 |
0.00 | 245.33 | |
26 | No Name #1011 |
Calc. Raw |
163.24 131.00 |
27.07 19.67 |
51.90 54.67 |
0.00 | 242.21 | |
27 | No Name #45 |
Calc. Raw |
157.63 126.50 |
27.07 19.67 |
51.90 54.67 |
0.00 | 236.60 | |
28 | No Name #35502 |
Calc. Raw |
141.43 113.50 |
23.41 17.01 |
68.99 72.67 |
0.00 | 233.83 | |
29 | No Name #1859 |
Calc. Raw |
129.60 104.00 |
33.48 24.33 |
67.09 70.67 |
0.00 | 230.17 | |
30 | No Name #35834 |
Calc. Raw |
130.22 104.50 |
34.87 25.34 |
56.96 60.00 |
0.00 | 222.05 | |
31 | No Name #35869 |
Calc. Raw |
165.11 132.50 |
31.65 23.00 |
18.99 20.00 |
0.00 | 215.75 | |
32 | No Name #14485 |
Calc. Raw |
94.08 75.50 |
37.63 27.34 |
81.01 85.33 |
0.00 | 212.72 | |
33 | No Name #35342 |
Calc. Raw |
69.78 56.00 |
40.83 29.67 |
100.00 105.33 |
0.00 | 210.61 | |
34 | No Name #35727 |
Calc. Raw |
104.67 84.00 |
32.58 23.67 |
69.62 73.33 |
0.00 | 206.87 | |
35 | No Name #15559 |
Calc. Raw |
113.40 91.00 |
29.37 21.34 |
56.96 60.00 |
0.00 | 199.73 | |
35 | No Name #33497 |
Calc. Raw |
123.36 99.00 |
23.85 17.33 |
53.17 56.00 |
1.00 | 199.38 | |
36 | No Name #33665 |
Calc. Raw |
74.77 60.00 |
45.42 33.00 |
82.28 86.67 |
6.00 | 196.47 | |
37 | No Name #31733 |
Calc. Raw |
114.64 92.00 |
23.86 17.34 |
55.70 58.67 |
0.00 | 194.20 | |
38 | No Name #31871 |
Calc. Raw |
81.62 65.50 |
17.44 12.67 |
92.40 97.33 |
0.00 | 191.46 | |
39 | No Name #28638 |
Calc. Raw |
100.93 81.00 |
21.57 15.67 |
56.96 60.00 |
0.00 | 179.46 | |
40 | No Name #24450 |
Calc. Raw |
94.70 76.00 |
21.11 15.34 |
59.50 62.67 |
6.00 | 169.31 | |
41 | No Name #35396 |
Calc. Raw |
86.60 69.50 |
29.36 21.33 |
49.37 52.00 |
0.00 | 165.33 | |
42 | No Name #8704 |
Calc. Raw |
67.29 54.00 |
24.77 18.00 |
67.09 70.67 |
15.00 | 144.15 | |
43 | No Name #35198 |
Calc. Raw |
79.13 63.50 |
8.71 6.33 |
53.17 56.00 |
0.00 | 141.01 |