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 5 The Jungle Bloke Division II | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #28541 |
Calc. Raw |
200.00 155.75 |
47.26 28.99 |
80.57 77.75 |
5.00 | 322.83 | |
2 | No Name #22311 |
Calc. Raw |
192.94 150.25 |
48.91 30.00 |
77.20 74.50 |
0.00 | 319.05 | |
3 | No Name #25808 |
Calc. Raw |
170.14 132.50 |
41.85 25.67 |
100.00 96.50 |
0.00 | 311.99 | |
4 | No Name #1573 |
Calc. Raw |
197.43 153.75 |
47.82 29.33 |
58.03 56.00 |
0.00 | 303.28 | |
5 | No Name #1839 |
Calc. Raw |
189.73 147.75 |
36.96 22.67 |
73.32 70.75 |
0.00 | 300.01 | |
6 | No Name #2477 |
Calc. Raw |
200.00 155.75 |
48.37 29.67 |
49.62 47.88 |
0.00 | 297.99 | |
7 | No Name #31230 |
Calc. Raw |
189.73 147.75 |
42.39 26.00 |
67.62 65.25 |
5.00 | 294.74 | |
8 | No Name #2269 |
Calc. Raw |
195.18 152.00 |
46.19 28.33 |
50.65 48.88 |
0.00 | 292.02 | |
9 | No Name #18929 |
Calc. Raw |
158.59 123.50 |
42.92 26.33 |
80.83 78.00 |
0.00 | 282.34 | |
9 | No Name #10680 |
Calc. Raw |
169.50 132.00 |
50.00 30.67 |
62.44 60.25 |
0.00 | 281.94 | |
10 | No Name #12320 |
Calc. Raw |
169.50 132.00 |
36.94 22.66 |
78.76 76.00 |
5.00 | 280.20 | |
11 | No Name #30604 |
Calc. Raw |
169.82 132.25 |
42.39 26.00 |
70.73 68.25 |
5.00 | 277.94 | |
12 | No Name #1722 |
Calc. Raw |
146.07 113.75 |
36.40 22.33 |
97.41 94.00 |
5.00 | 274.88 | |
13 | No Name #18931 |
Calc. Raw |
166.29 129.50 |
42.92 26.33 |
63.21 61.00 |
0.00 | 272.42 | |
13 | No Name #3137 |
Calc. Raw |
166.61 129.75 |
40.76 25.00 |
64.64 62.38 |
0.00 | 272.01 | |
14 | No Name #20022 |
Calc. Raw |
178.49 139.00 |
42.39 26.00 |
49.22 47.50 |
0.00 | 270.10 | |
14 | No Name #31433 |
Calc. Raw |
181.38 141.25 |
43.48 26.67 |
49.48 47.75 |
5.00 | 269.34 | |
15 | No Name #36206 |
Calc. Raw |
170.47 132.75 |
41.29 25.33 |
55.70 53.75 |
0.00 | 267.46 | |
16 | No Name #35004 |
Calc. Raw |
171.11 133.25 |
37.50 23.00 |
57.13 55.13 |
0.00 | 265.74 | |
17 | No Name #32095 |
Calc. Raw |
186.20 145.00 |
45.11 27.67 |
32.38 31.25 |
0.00 | 263.69 | |
17 | No Name #2119 |
Calc. Raw |
183.31 142.75 |
38.07 23.35 |
41.71 40.25 |
0.00 | 263.09 | |
18 | No Name #16375 |
Calc. Raw |
172.39 134.25 |
41.85 25.67 |
53.11 51.25 |
5.00 | 262.35 | |
18 | No Name #3505 |
Calc. Raw |
188.12 146.50 |
43.46 26.66 |
29.93 28.88 |
0.00 | 261.51 | |
19 | No Name #34249 |
Calc. Raw |
178.81 139.25 |
34.79 21.34 |
47.67 46.00 |
0.00 | 261.27 | |
20 | No Name #7934 |
Calc. Raw |
183.63 143.00 |
47.82 29.33 |
33.68 32.50 |
5.00 | 260.13 | |
21 | No Name #9385 |
Calc. Raw |
161.48 125.75 |
40.76 25.00 |
56.22 54.25 |
0.00 | 258.46 | |
21 | No Name #14724 |
Calc. Raw |
165.33 128.75 |
41.29 25.33 |
51.81 50.00 |
0.00 | 258.43 | |
22 | No Name #10102 |
Calc. Raw |
179.78 140.00 |
48.37 29.67 |
29.27 28.25 |
0.00 | 257.42 | |
22 | No Name #32743 |
Calc. Raw |
152.17 118.50 |
33.14 20.33 |
71.24 68.75 |
0.00 | 256.55 | |
23 | No Name #34080 |
Calc. Raw |
156.02 121.50 |
42.92 26.33 |
62.44 60.25 |
5.00 | 256.38 | |
24 | No Name #34649 |
Calc. Raw |
182.66 142.25 |
45.11 27.67 |
35.49 34.25 |
8.00 | 255.26 | |
25 | No Name #13158 |
Calc. Raw |
162.12 126.25 |
44.55 27.33 |
52.07 50.25 |
5.00 | 253.74 | |
26 | No Name #2785 |
Calc. Raw |
192.30 149.75 |
35.87 22.00 |
29.53 28.50 |
5.00 | 252.70 | |
26 | No Name #35737 |
Calc. Raw |
149.92 116.75 |
45.65 28.00 |
56.48 54.50 |
0.00 | 252.05 | |
27 | No Name #11901 |
Calc. Raw |
179.45 139.75 |
38.03 23.33 |
31.48 30.38 |
0.00 | 248.96 | |
28 | No Name #1790 |
Calc. Raw |
153.45 119.50 |
41.29 25.33 |
57.51 55.50 |
5.00 | 247.25 | |
29 | No Name #35750 |
Calc. Raw |
163.40 127.25 |
36.96 22.67 |
49.74 48.00 |
5.00 | 245.10 | |
30 | No Name #19568 |
Calc. Raw |
170.14 132.50 |
45.11 27.67 |
32.90 31.75 |
5.00 | 243.15 | |
31 | No Name #10236 |
Calc. Raw |
151.85 118.25 |
38.03 23.33 |
56.22 54.25 |
5.00 | 241.10 | |
31 | No Name #27471 |
Calc. Raw |
167.90 130.75 |
45.11 27.67 |
32.90 31.75 |
5.00 | 240.91 | |
32 | No Name #27797 |
Calc. Raw |
168.86 131.50 |
38.59 23.67 |
36.53 35.25 |
5.00 | 238.98 | |
33 | No Name #5557 |
Calc. Raw |
139.65 108.75 |
37.48 22.99 |
58.29 56.25 |
0.00 | 235.42 | |
33 | No Name #35487 |
Calc. Raw |
158.91 123.75 |
40.22 24.67 |
41.07 39.63 |
5.00 | 235.20 | |
33 | No Name #32117 |
Calc. Raw |
153.13 119.25 |
44.02 27.00 |
42.49 41.00 |
5.00 | 234.64 | |
34 | No Name #32346 |
Calc. Raw |
148.96 116.00 |
38.05 23.34 |
47.41 45.75 |
0.00 | 234.42 | |
34 | No Name #8653 |
Calc. Raw |
163.08 127.00 |
33.68 20.66 |
44.69 43.13 |
8.00 | 233.45 | |
35 | No Name #21290 |
Calc. Raw |
149.28 116.25 |
40.22 24.67 |
47.80 46.13 |
5.00 | 232.30 | |
36 | No Name #13133 |
Calc. Raw |
153.77 119.75 |
33.14 20.33 |
48.45 46.75 |
5.00 | 230.36 | |
37 | No Name #34082 |
Calc. Raw |
146.71 114.25 |
36.40 22.33 |
49.74 48.00 |
5.00 | 227.85 | |
37 | No Name #8401 |
Calc. Raw |
150.88 117.50 |
34.24 21.00 |
42.23 40.75 |
0.00 | 227.35 | |
38 | No Name #34759 |
Calc. Raw |
160.19 124.75 |
36.40 22.33 |
33.68 32.50 |
5.00 | 225.27 | |
39 | No Name #16610 |
Calc. Raw |
127.13 99.00 |
32.61 20.00 |
66.06 63.75 |
5.00 | 220.80 | |
39 | No Name #35511 |
Calc. Raw |
134.19 104.50 |
32.07 19.67 |
53.63 51.75 |
0.00 | 219.89 | |
40 | No Name #3422 |
Calc. Raw |
151.85 118.25 |
39.13 24.00 |
41.19 39.75 |
20.00 | 212.17 | |
40 | No Name #17066 |
Calc. Raw |
138.04 107.50 |
31.53 19.34 |
42.36 40.88 |
0.00 | 211.93 | |
41 | No Name #17855 |
Calc. Raw |
148.64 115.75 |
34.24 21.00 |
41.97 40.50 |
15.00 | 209.85 | |
42 | No Name #18527 |
Calc. Raw |
137.40 107.00 |
37.48 22.99 |
33.94 32.75 |
0.00 | 208.82 | |
43 | No Name #31338 |
Calc. Raw |
129.37 100.75 |
34.24 21.00 |
43.01 41.50 |
0.00 | 206.62 | |
44 | No Name #33946 |
Calc. Raw |
141.57 110.25 |
31.51 19.33 |
32.38 31.25 |
0.00 | 205.46 | |
45 | No Name #35337 |
Calc. Raw |
139.97 109.00 |
30.97 19.00 |
46.63 45.00 |
15.00 | 202.57 | |
46 | No Name #33010 |
Calc. Raw |
124.88 97.25 |
35.33 21.67 |
33.94 32.75 |
5.00 | 189.15 | |
47 | No Name #5482 |
Calc. Raw |
135.15 105.25 |
32.07 19.67 |
18.65 18.00 |
5.00 | 180.87 |