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 Eccentrics! Division I | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #34691 |
Calc. Raw |
200.00 167.25 |
41.78 37.33 |
100.00 112.67 |
0.00 | 341.78 | |
2 | No Name #29007 |
Calc. Raw |
181.46 151.75 |
50.00 44.67 |
96.74 109.00 |
0.00 | 328.20 | |
3 | No Name #2784 |
Calc. Raw |
186.25 155.75 |
41.41 37.00 |
90.24 101.67 |
0.00 | 317.90 | |
4 | No Name #35672 |
Calc. Raw |
173.39 145.00 |
44.02 39.33 |
95.86 108.00 |
0.00 | 313.27 | |
4 | No Name #34835 |
Calc. Raw |
177.88 148.75 |
38.43 34.33 |
96.15 108.33 |
0.00 | 312.46 | |
5 | No Name #2770 |
Calc. Raw |
171.90 143.75 |
46.64 41.67 |
91.71 103.33 |
0.00 | 310.25 | |
6 | No Name #30361 |
Calc. Raw |
168.31 140.75 |
44.77 40.00 |
95.86 108.00 |
0.00 | 308.94 | |
7 | No Name #36092 |
Calc. Raw |
173.99 145.50 |
44.02 39.33 |
90.82 102.33 |
1.00 | 307.83 | |
7 | No Name #37160 |
Calc. Raw |
172.80 144.50 |
49.62 44.33 |
95.26 107.33 |
10.00 | 307.68 | |
8 | No Name #14491 |
Calc. Raw |
165.62 138.50 |
40.66 36.33 |
97.34 109.67 |
0.00 | 303.62 | |
8 | No Name #36302 |
Calc. Raw |
170.10 142.25 |
37.31 33.33 |
97.63 110.00 |
2.00 | 303.04 | |
9 | No Name #28109 |
Calc. Raw |
163.53 136.75 |
39.18 35.00 |
99.70 112.33 |
0.00 | 302.41 | |
10 | No Name #1944 |
Calc. Raw |
172.50 144.25 |
37.31 33.33 |
90.53 102.00 |
0.00 | 300.34 | |
10 | No Name #35454 |
Calc. Raw |
173.39 145.00 |
35.82 32.00 |
90.82 102.33 |
0.00 | 300.03 | |
11 | No Name #36087 |
Calc. Raw |
162.33 135.75 |
38.81 34.67 |
96.74 109.00 |
0.00 | 297.88 | |
12 | No Name #37858 |
Calc. Raw |
159.34 133.25 |
42.16 37.67 |
93.19 105.00 |
0.00 | 294.69 | |
12 | No Name #32258 |
Calc. Raw |
164.72 137.75 |
38.06 34.00 |
94.97 107.00 |
4.00 | 293.75 | |
13 | No Name #6428 |
Calc. Raw |
158.15 132.25 |
40.30 36.00 |
92.60 104.33 |
0.00 | 291.05 | |
13 | No Name #37702 |
Calc. Raw |
159.04 133.00 |
40.30 36.00 |
91.12 102.67 |
0.00 | 290.46 | |
14 | No Name #34905 |
Calc. Raw |
154.26 129.00 |
38.06 34.00 |
96.45 108.67 |
0.00 | 288.77 | |
14 | No Name #237 |
Calc. Raw |
154.26 129.00 |
42.90 38.33 |
90.82 102.33 |
0.00 | 287.98 | |
15 | No Name #37490 |
Calc. Raw |
156.35 130.75 |
38.43 34.33 |
92.60 104.33 |
0.00 | 287.38 | |
15 | No Name #5418 |
Calc. Raw |
155.16 129.75 |
37.31 33.33 |
94.08 106.00 |
0.00 | 286.55 | |
16 | No Name #34380 |
Calc. Raw |
151.27 126.50 |
35.82 32.00 |
98.81 111.33 |
0.00 | 285.90 | |
16 | No Name #33282 |
Calc. Raw |
165.62 138.50 |
35.82 32.00 |
84.02 94.67 |
0.00 | 285.46 | |
16 | No Name #37176 |
Calc. Raw |
148.58 124.25 |
40.30 36.00 |
96.15 108.33 |
0.00 | 285.03 | |
17 | No Name #7130 |
Calc. Raw |
152.17 127.25 |
31.34 28.00 |
99.70 112.33 |
2.00 | 281.21 | |
17 | No Name #37821 |
Calc. Raw |
151.57 126.75 |
36.57 32.67 |
92.60 104.33 |
0.00 | 280.74 | |
18 | No Name #35727 |
Calc. Raw |
153.66 128.50 |
32.09 28.67 |
93.49 105.33 |
0.00 | 279.24 | |
18 | No Name #32233 |
Calc. Raw |
156.95 131.25 |
28.73 25.67 |
92.90 104.67 |
0.00 | 278.58 | |
18 | No Name #34123 |
Calc. Raw |
146.19 122.25 |
32.83 29.33 |
99.41 112.00 |
0.00 | 278.43 | |
19 | No Name #28372 |
Calc. Raw |
144.99 121.25 |
36.57 32.67 |
95.56 107.67 |
0.00 | 277.12 | |
19 | No Name #37365 |
Calc. Raw |
141.41 118.25 |
38.06 34.00 |
97.63 110.00 |
0.00 | 277.10 | |
20 | No Name #36839 |
Calc. Raw |
145.59 121.75 |
37.69 33.67 |
92.30 104.00 |
0.00 | 275.58 | |
20 | No Name #11374 |
Calc. Raw |
149.18 124.75 |
32.09 28.67 |
94.08 106.00 |
0.00 | 275.35 | |
21 | No Name #2746 |
Calc. Raw |
144.99 121.25 |
38.06 34.00 |
90.24 101.67 |
0.00 | 273.29 | |
21 | No Name #36693 |
Calc. Raw |
147.09 123.00 |
31.71 28.33 |
93.79 105.67 |
0.00 | 272.59 | |
22 | No Name #13857 |
Calc. Raw |
144.39 120.75 |
35.45 31.67 |
92.01 103.67 |
0.00 | 271.85 | |
22 | No Name #16874 |
Calc. Raw |
141.70 118.50 |
35.45 31.67 |
93.79 105.67 |
0.00 | 270.94 | |
23 | No Name #37102 |
Calc. Raw |
139.61 116.75 |
37.69 33.67 |
92.01 103.67 |
0.00 | 269.31 | |
23 | No Name #27653 |
Calc. Raw |
138.12 115.50 |
40.30 36.00 |
90.82 102.33 |
0.00 | 269.24 | |
23 | No Name #18836 |
Calc. Raw |
140.81 117.75 |
35.82 32.00 |
92.01 103.67 |
0.00 | 268.64 | |
24 | No Name #6161 |
Calc. Raw |
141.11 118.00 |
36.19 32.33 |
90.53 102.00 |
0.00 | 267.83 | |
24 | No Name #37859 |
Calc. Raw |
147.98 123.75 |
45.52 40.67 |
73.37 82.67 |
0.00 | 266.87 | |
25 | No Name #27409 |
Calc. Raw |
132.74 111.00 |
35.82 32.00 |
97.92 110.33 |
0.00 | 266.48 | |
25 | No Name #31210 |
Calc. Raw |
138.12 115.50 |
33.21 29.67 |
94.37 106.33 |
0.00 | 265.70 | |
26 | No Name #33291 |
Calc. Raw |
154.56 129.25 |
36.94 33.00 |
81.95 92.33 |
10.00 | 263.45 | |
26 | No Name #30749 |
Calc. Raw |
139.61 116.75 |
30.59 27.33 |
92.90 104.67 |
0.00 | 263.10 | |
26 | No Name #4984 |
Calc. Raw |
142.30 119.00 |
37.31 33.33 |
83.14 93.67 |
0.00 | 262.75 | |
27 | No Name #34242 |
Calc. Raw |
139.91 117.00 |
28.35 25.33 |
93.19 105.00 |
0.00 | 261.45 | |
28 | No Name #35925 |
Calc. Raw |
135.72 113.50 |
31.71 28.33 |
91.12 102.67 |
0.00 | 258.55 | |
28 | No Name #9090 |
Calc. Raw |
136.02 113.75 |
35.82 32.00 |
86.39 97.33 |
0.00 | 258.23 | |
29 | No Name #36478 |
Calc. Raw |
128.85 107.75 |
34.70 31.00 |
92.90 104.67 |
0.00 | 256.45 | |
30 | No Name #3606 |
Calc. Raw |
134.53 112.50 |
32.83 29.33 |
87.87 99.00 |
0.00 | 255.23 | |
31 | No Name #6603 |
Calc. Raw |
141.11 118.00 |
26.11 23.33 |
91.42 103.00 |
5.00 | 253.64 | |
32 | No Name #35714 |
Calc. Raw |
139.31 116.50 |
39.18 35.00 |
73.07 82.33 |
0.00 | 251.56 | |
33 | No Name #34430 |
Calc. Raw |
134.23 112.25 |
29.85 26.67 |
86.39 97.33 |
0.00 | 250.47 | |
34 | No Name #30598 |
Calc. Raw |
141.70 118.50 |
33.95 30.33 |
83.72 94.33 |
15.00 | 244.37 | |
35 | No Name #25437 |
Calc. Raw |
111.51 93.25 |
22.02 19.67 |
98.52 111.00 |
0.00 | 232.05 | |
36 | No Name #37234 |
Calc. Raw |
119.58 100.00 |
27.98 25.00 |
82.54 93.00 |
0.00 | 230.10 | |
37 | No Name #19400 |
Calc. Raw |
136.32 114.00 |
32.83 29.33 |
49.11 55.33 |
0.00 | 218.26 | |
38 | No Name #17220 |
Calc. Raw |
112.71 94.25 |
24.99 22.33 |
63.61 71.67 |
20.00 | 181.31 |