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 III | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #30358 |
Calc. Raw |
198.80 165.00 |
48.23 36.34 |
96.78 80.33 |
0.00 | 343.81 | |
2 | No Name #10619 |
Calc. Raw |
194.58 161.50 |
44.24 33.33 |
95.18 79.00 |
0.00 | 334.00 | |
3 | No Name #11519 |
Calc. Raw |
187.35 155.50 |
45.13 34.00 |
100.00 83.00 |
0.00 | 332.48 | |
4 | No Name #34393 |
Calc. Raw |
200.00 166.00 |
46.46 35.00 |
69.48 57.67 |
0.00 | 315.94 | |
5 | No Name #10527 |
Calc. Raw |
171.08 142.00 |
48.23 36.34 |
95.18 79.00 |
0.00 | 314.49 | |
6 | No Name #381 |
Calc. Raw |
168.67 140.00 |
46.00 34.66 |
98.40 81.67 |
10.00 | 303.07 | |
7 | No Name #3473 |
Calc. Raw |
176.51 146.50 |
41.60 31.34 |
79.12 65.67 |
0.00 | 297.23 | |
8 | No Name #35519 |
Calc. Raw |
168.07 139.50 |
41.13 30.99 |
88.76 73.67 |
2.00 | 295.96 | |
8 | No Name #3260 |
Calc. Raw |
186.75 155.00 |
42.47 32.00 |
66.27 55.00 |
0.00 | 295.49 | |
8 | No Name #35792 |
Calc. Raw |
165.06 137.00 |
42.93 32.34 |
87.14 72.33 |
0.00 | 295.13 | |
9 | No Name #35758 |
Calc. Raw |
179.52 149.00 |
27.44 20.67 |
91.96 76.33 |
5.00 | 293.92 | |
10 | No Name #34810 |
Calc. Raw |
190.36 158.00 |
33.18 25.00 |
67.87 56.33 |
0.00 | 291.41 | |
11 | No Name #32441 |
Calc. Raw |
166.27 138.00 |
31.42 23.67 |
91.96 76.33 |
0.00 | 289.65 | |
11 | No Name #30049 |
Calc. Raw |
175.30 145.50 |
33.18 25.00 |
80.72 67.00 |
0.00 | 289.20 | |
12 | No Name #5736 |
Calc. Raw |
193.98 161.00 |
42.02 31.66 |
50.20 41.67 |
0.00 | 286.20 | |
12 | No Name #31043 |
Calc. Raw |
192.17 159.50 |
38.07 28.68 |
58.23 48.33 |
3.00 | 285.47 | |
13 | No Name #33084 |
Calc. Raw |
183.13 152.00 |
30.54 23.01 |
71.08 59.00 |
0.00 | 284.75 | |
14 | No Name #33516 |
Calc. Raw |
175.90 146.00 |
36.29 27.34 |
67.87 56.33 |
0.00 | 280.06 | |
14 | No Name #31579 |
Calc. Raw |
153.61 127.50 |
37.60 28.33 |
88.76 73.67 |
0.00 | 279.97 | |
14 | No Name #8496 |
Calc. Raw |
162.05 134.50 |
26.97 20.32 |
90.36 75.00 |
0.00 | 279.38 | |
15 | No Name #19945 |
Calc. Raw |
173.49 144.00 |
35.40 26.67 |
64.66 53.67 |
0.00 | 273.55 | |
15 | No Name #11172 |
Calc. Raw |
166.87 138.50 |
31.87 24.01 |
74.30 61.67 |
0.00 | 273.04 | |
16 | No Name #33393 |
Calc. Raw |
124.10 103.00 |
50.00 37.67 |
93.58 77.67 |
0.00 | 267.68 | |
17 | No Name #33640 |
Calc. Raw |
146.39 121.50 |
43.35 32.66 |
74.30 61.67 |
3.00 | 261.04 | |
17 | No Name #34812 |
Calc. Raw |
165.06 137.00 |
35.39 26.66 |
70.28 58.33 |
10.00 | 260.73 | |
18 | No Name #30951 |
Calc. Raw |
121.08 100.50 |
38.04 28.66 |
96.78 80.33 |
0.00 | 255.90 | |
19 | No Name #31161 |
Calc. Raw |
148.19 123.00 |
30.08 22.66 |
83.53 69.33 |
10.00 | 251.80 | |
20 | No Name #20135 |
Calc. Raw |
154.22 128.00 |
36.73 27.67 |
66.27 55.00 |
10.00 | 247.22 | |
21 | No Name #5404 |
Calc. Raw |
122.89 102.00 |
47.33 35.66 |
79.12 65.67 |
5.00 | 244.34 | |
21 | No Name #32530 |
Calc. Raw |
140.96 117.00 |
32.29 24.33 |
71.08 59.00 |
0.00 | 244.33 | |
22 | No Name #17068 |
Calc. Raw |
126.51 105.00 |
32.74 24.67 |
79.12 65.67 |
0.00 | 238.37 | |
23 | No Name #14231 |
Calc. Raw |
113.25 94.00 |
38.93 29.33 |
79.12 65.67 |
0.00 | 231.30 | |
24 | No Name #30883 |
Calc. Raw |
104.82 87.00 |
33.18 25.00 |
80.72 67.00 |
0.00 | 218.72 | |
25 | No Name #35545 |
Calc. Raw |
123.49 102.50 |
34.06 25.66 |
58.23 48.33 |
0.00 | 215.78 | |
25 | No Name #15074 |
Calc. Raw |
101.20 84.00 |
44.21 33.31 |
69.48 57.67 |
0.00 | 214.89 | |
26 | No Name #1412 |
Calc. Raw |
124.70 103.50 |
28.31 21.33 |
62.65 52.00 |
10.00 | 205.66 | |
27 | No Name #8871 |
Calc. Raw |
98.19 81.50 |
34.52 26.01 |
69.48 57.67 |
0.00 | 202.19 | |
28 | No Name #6905 |
Calc. Raw |
78.92 65.50 |
38.49 29.00 |
82.33 68.33 |
5.00 | 194.74 | |
28 | No Name #28292 |
Calc. Raw |
92.77 77.00 |
33.63 25.34 |
67.47 56.00 |
0.00 | 193.87 | |
29 | No Name #11606 |
Calc. Raw |
105.42 87.50 |
31.84 23.99 |
49.00 40.67 |
0.00 | 186.26 | |
30 | No Name #6379 |
Calc. Raw |
70.48 58.50 |
29.64 22.33 |
66.27 55.00 |
0.00 | 166.39 |