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 I | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #31310 |
Calc. Raw |
200.00 154.25 |
29.90 21.33 |
69.23 60.00 |
0.00 | 299.13 | |
1 | No Name #1887 |
Calc. Raw |
188.01 145.00 |
45.79 32.67 |
64.99 56.33 |
0.00 | 298.79 | |
2 | No Name #27729 |
Calc. Raw |
182.50 140.75 |
49.52 35.33 |
57.31 49.67 |
0.00 | 289.33 | |
3 | No Name #4645 |
Calc. Raw |
175.36 135.25 |
50.00 35.67 |
56.54 49.00 |
0.00 | 281.90 | |
4 | No Name #33665 |
Calc. Raw |
173.42 133.75 |
38.79 27.67 |
68.07 59.00 |
0.00 | 280.28 | |
5 | No Name #19400 |
Calc. Raw |
167.26 129.00 |
40.65 29.00 |
64.23 55.67 |
0.00 | 272.14 | |
6 | No Name #2118 |
Calc. Raw |
140.03 108.00 |
29.89 21.32 |
100.00 86.67 |
0.00 | 269.92 | |
7 | No Name #15517 |
Calc. Raw |
141.65 109.25 |
40.65 29.00 |
86.54 75.00 |
0.00 | 268.84 | |
7 | No Name #31535 |
Calc. Raw |
180.55 139.25 |
35.04 25.00 |
52.69 45.67 |
0.00 | 268.28 | |
8 | No Name #30389 |
Calc. Raw |
162.72 125.50 |
30.38 21.67 |
75.38 65.33 |
5.00 | 263.48 | |
8 | No Name #32908 |
Calc. Raw |
155.59 120.00 |
45.32 32.33 |
62.31 54.00 |
0.00 | 263.22 | |
8 | No Name #750 |
Calc. Raw |
146.52 113.00 |
42.51 30.33 |
73.84 64.00 |
0.00 | 262.87 | |
9 | No Name #7529 |
Calc. Raw |
177.31 136.75 |
25.23 18.00 |
55.38 48.00 |
0.00 | 257.92 | |
10 | No Name #5574 |
Calc. Raw |
157.54 121.50 |
47.67 34.01 |
48.08 41.67 |
0.00 | 253.29 | |
10 | No Name #2768 |
Calc. Raw |
131.93 101.75 |
41.13 29.34 |
79.99 69.33 |
0.00 | 253.05 | |
11 | No Name #6379 |
Calc. Raw |
164.34 126.75 |
30.38 21.67 |
55.00 47.67 |
0.00 | 249.72 | |
12 | No Name #33320 |
Calc. Raw |
140.03 108.00 |
28.02 19.99 |
80.39 69.67 |
0.00 | 248.44 | |
13 | No Name #31305 |
Calc. Raw |
143.92 111.00 |
29.91 21.34 |
72.31 62.67 |
0.00 | 246.14 | |
13 | No Name #1375 |
Calc. Raw |
137.44 106.00 |
42.07 30.01 |
70.76 61.33 |
5.00 | 245.27 | |
14 | No Name #10566 |
Calc. Raw |
132.58 102.25 |
33.63 23.99 |
76.53 66.33 |
0.00 | 242.74 | |
14 | No Name #33795 |
Calc. Raw |
143.60 110.75 |
39.26 28.01 |
59.22 51.33 |
0.00 | 242.08 | |
14 | No Name #20522 |
Calc. Raw |
146.52 113.00 |
34.10 24.33 |
61.15 53.00 |
0.00 | 241.77 | |
15 | No Name #34298 |
Calc. Raw |
133.55 103.00 |
27.10 19.33 |
75.00 65.00 |
0.00 | 235.65 | |
15 | No Name #32349 |
Calc. Raw |
145.87 112.50 |
34.10 24.33 |
55.38 48.00 |
0.00 | 235.35 | |
15 | No Name #13391 |
Calc. Raw |
146.84 113.25 |
30.84 22.00 |
57.31 49.67 |
0.00 | 234.99 | |
16 | No Name #9926 |
Calc. Raw |
136.14 105.00 |
31.30 22.33 |
63.84 55.33 |
0.00 | 231.28 | |
17 | No Name #28057 |
Calc. Raw |
144.89 111.75 |
35.04 25.00 |
49.99 43.33 |
0.00 | 229.92 | |
18 | No Name #1164 |
Calc. Raw |
159.16 122.75 |
26.63 19.00 |
43.07 37.33 |
0.00 | 228.86 | |
18 | No Name #34674 |
Calc. Raw |
145.87 112.50 |
37.38 26.67 |
75.38 65.33 |
30.00 | 228.63 | |
18 | No Name #1785 |
Calc. Raw |
140.03 108.00 |
29.44 21.00 |
58.84 51.00 |
0.00 | 228.31 | |
18 | No Name #35033 |
Calc. Raw |
140.36 108.25 |
25.23 18.00 |
62.31 54.00 |
0.00 | 227.90 | |
19 | No Name #25354 |
Calc. Raw |
128.36 99.00 |
37.37 26.66 |
57.31 49.67 |
0.00 | 223.04 | |
19 | No Name #30686 |
Calc. Raw |
134.52 103.75 |
38.79 27.67 |
48.84 42.33 |
0.00 | 222.15 | |
20 | No Name #13004 |
Calc. Raw |
135.82 104.75 |
33.18 23.67 |
64.23 55.67 |
15.00 | 218.23 | |
20 | No Name #30361 |
Calc. Raw |
117.02 90.25 |
29.90 21.33 |
70.38 61.00 |
0.00 | 217.30 | |
21 | No Name #24442 |
Calc. Raw |
117.99 91.00 |
29.44 21.00 |
64.23 55.67 |
0.00 | 211.66 | |
21 | No Name #2271 |
Calc. Raw |
123.82 95.50 |
31.78 22.67 |
60.77 52.67 |
5.00 | 211.37 | |
22 | No Name #8239 |
Calc. Raw |
115.07 88.75 |
26.17 18.67 |
68.85 59.67 |
0.00 | 210.09 | |
22 | No Name #32346 |
Calc. Raw |
130.96 101.00 |
26.63 19.00 |
52.30 45.33 |
0.00 | 209.89 | |
23 | No Name #33395 |
Calc. Raw |
125.77 97.00 |
28.05 20.01 |
48.84 42.33 |
0.00 | 202.66 | |
24 | No Name #4087 |
Calc. Raw |
105.02 81.00 |
31.30 22.33 |
61.53 53.33 |
0.00 | 197.85 | |
25 | No Name #21969 |
Calc. Raw |
113.13 87.25 |
28.02 19.99 |
55.00 47.67 |
0.00 | 196.15 | |
26 | No Name #33295 |
Calc. Raw |
122.20 94.25 |
21.49 15.33 |
52.69 45.67 |
3.00 | 193.38 | |
27 | No Name #2437 |
Calc. Raw |
106.32 82.00 |
22.90 16.34 |
58.07 50.33 |
0.00 | 187.29 | |
27 | No Name #25437 |
Calc. Raw |
114.75 88.50 |
25.23 18.00 |
46.93 40.67 |
0.00 | 186.91 | |
28 | No Name #34912 |
Calc. Raw |
113.78 87.75 |
24.77 17.67 |
56.54 49.00 |
10.00 | 185.09 | |
29 | No Name #33843 |
Calc. Raw |
110.86 85.50 |
19.61 13.99 |
50.39 43.67 |
0.00 | 180.86 | |
30 | No Name #33381 |
Calc. Raw |
98.87 76.25 |
22.43 16.00 |
53.07 46.00 |
0.00 | 174.37 | |
31 | No Name #35382 |
Calc. Raw |
102.11 78.75 |
15.90 11.34 |
53.07 46.00 |
2.00 | 169.08 | |
32 | No Name #32918 |
Calc. Raw |
103.08 79.50 |
19.62 14.00 |
49.23 42.67 |
5.00 | 166.93 | |
33 | No Name #14544 |
Calc. Raw |
89.47 69.00 |
21.97 15.67 |
53.46 46.33 |
0.00 | 164.90 |