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 The Large And Small Of It Division III | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #8496 |
Calc. Raw |
175.29 149.00 |
36.24 29.00 |
95.14 112.50 |
0.00 | 306.67 | |
2 | No Name #22311 |
Calc. Raw |
151.18 128.50 |
37.90 30.33 |
97.46 115.25 |
15.00 | 271.54 | |
3 | No Name #30949 |
Calc. Raw |
200.00 170.00 |
50.00 40.01 |
19.45 23.00 |
0.00 | 269.45 | |
4 | No Name #27017 |
Calc. Raw |
196.47 167.00 |
46.24 37.00 |
23.04 27.25 |
0.00 | 265.75 | |
5 | No Name #3887 |
Calc. Raw |
190.59 162.00 |
44.58 35.67 |
23.04 27.25 |
1.00 | 257.21 | |
6 | No Name #10619 |
Calc. Raw |
120.00 102.00 |
35.42 28.34 |
100.00 118.25 |
0.00 | 255.42 | |
7 | No Name #34393 |
Calc. Raw |
179.41 152.50 |
37.07 29.66 |
36.15 42.75 |
0.00 | 252.63 | |
8 | No Name #37162 |
Calc. Raw |
171.18 145.50 |
39.15 31.33 |
26.00 30.75 |
0.00 | 236.33 | |
9 | No Name #31230 |
Calc. Raw |
148.82 126.50 |
40.83 32.67 |
43.55 51.50 |
0.00 | 233.20 | |
10 | No Name #35550 |
Calc. Raw |
170.59 145.00 |
39.15 31.33 |
20.08 23.75 |
0.00 | 229.82 | |
11 | No Name #35519 |
Calc. Raw |
147.65 125.50 |
41.24 33.00 |
38.90 46.00 |
0.00 | 227.79 | |
12 | No Name #1149 |
Calc. Raw |
140.59 119.50 |
44.99 36.00 |
41.01 48.50 |
0.00 | 226.59 | |
13 | No Name #30595 |
Calc. Raw |
138.82 118.00 |
41.65 33.33 |
43.34 51.25 |
0.00 | 223.81 | |
14 | No Name #5736 |
Calc. Raw |
174.71 148.50 |
40.41 32.34 |
23.47 27.75 |
17.00 | 221.59 | |
15 | No Name #31437 |
Calc. Raw |
157.06 133.50 |
32.49 26.00 |
30.66 36.25 |
0.00 | 220.21 | |
16 | No Name #22063 |
Calc. Raw |
160.59 136.50 |
40.40 32.33 |
31.50 37.25 |
16.00 | 216.49 | |
17 | No Name #32939 |
Calc. Raw |
145.29 123.50 |
28.73 22.99 |
38.05 45.00 |
0.00 | 212.07 | |
18 | No Name #33422 |
Calc. Raw |
154.71 131.50 |
34.59 27.68 |
20.08 23.75 |
2.00 | 207.38 | |
19 | No Name #4307 |
Calc. Raw |
130.59 111.00 |
42.08 33.67 |
31.92 37.75 |
0.00 | 204.59 | |
20 | No Name #35180 |
Calc. Raw |
137.06 116.50 |
33.74 27.00 |
27.06 32.00 |
0.00 | 197.86 | |
21 | No Name #15074 |
Calc. Raw |
122.35 104.00 |
37.07 29.66 |
34.46 40.75 |
0.00 | 193.88 | |
21 | No Name #14186 |
Calc. Raw |
119.41 101.50 |
34.58 27.67 |
38.90 46.00 |
0.00 | 192.89 | |
22 | No Name #36451 |
Calc. Raw |
135.29 115.00 |
36.65 29.33 |
20.51 24.25 |
0.00 | 192.45 | |
22 | No Name #7743 |
Calc. Raw |
131.18 111.50 |
33.33 26.67 |
27.27 32.25 |
0.00 | 191.78 | |
23 | No Name #24436 |
Calc. Raw |
131.76 112.00 |
34.99 28.00 |
24.10 28.50 |
0.00 | 190.85 | |
24 | No Name #28239 |
Calc. Raw |
114.12 97.00 |
32.08 25.67 |
39.96 47.25 |
0.00 | 186.16 | |
25 | No Name #19512 |
Calc. Raw |
120.59 102.50 |
34.17 27.34 |
27.48 32.50 |
0.00 | 182.24 | |
26 | No Name #31161 |
Calc. Raw |
120.59 102.50 |
28.74 23.00 |
30.66 36.25 |
2.00 | 177.99 | |
27 | No Name #2215 |
Calc. Raw |
104.12 88.50 |
35.82 28.66 |
35.10 41.50 |
0.00 | 175.04 | |
28 | No Name #34802 |
Calc. Raw |
131.76 112.00 |
32.49 26.00 |
20.93 24.75 |
15.00 | 170.18 | |
29 | No Name #35824 |
Calc. Raw |
108.24 92.00 |
30.00 24.01 |
29.18 34.50 |
0.00 | 167.42 | |
30 | No Name #15515 |
Calc. Raw |
111.18 94.50 |
20.83 16.67 |
33.62 39.75 |
0.00 | 165.63 | |
31 | No Name #36979 |
Calc. Raw |
117.06 99.50 |
27.49 22.00 |
20.08 23.75 |
0.00 | 164.63 | |
32 | No Name #7246 |
Calc. Raw |
111.18 94.50 |
31.24 25.00 |
23.04 27.25 |
2.00 | 163.46 | |
33 | No Name #21290 |
Calc. Raw |
115.29 98.00 |
29.99 24.00 |
16.70 19.75 |
0.00 | 161.98 | |
34 | No Name #34519 |
Calc. Raw |
90.59 77.00 |
31.24 25.00 |
38.90 46.00 |
0.00 | 160.73 | |
34 | No Name #33415 |
Calc. Raw |
94.12 80.00 |
39.17 31.34 |
27.27 32.25 |
0.00 | 160.56 | |
34 | No Name #8871 |
Calc. Raw |
113.53 96.50 |
22.07 17.66 |
24.31 28.75 |
0.00 | 159.91 | |
35 | No Name #1412 |
Calc. Raw |
116.47 99.00 |
23.32 18.66 |
17.34 20.50 |
0.00 | 157.13 | |
36 | No Name #31108 |
Calc. Raw |
105.88 90.00 |
28.33 22.67 |
21.35 25.25 |
0.00 | 155.56 | |
37 | No Name #30551 |
Calc. Raw |
92.94 79.00 |
30.40 24.33 |
29.81 35.25 |
0.00 | 153.15 | |
38 | No Name #8149 |
Calc. Raw |
80.59 68.50 |
34.99 28.00 |
12.68 15.00 |
0.00 | 128.26 | |
39 | No Name #32640 |
Calc. Raw |
42.94 36.50 |
17.92 14.34 |
17.97 21.25 |
0.00 | 78.83 | |
40 | No Name #16610 |
Calc. Raw |
31.18 26.50 |
22.07 17.66 |
23.26 27.50 |
0.00 | 76.51 |