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 3 The Wonderful Muses Division II | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #31225 |
Calc. Raw |
200.00 155.25 |
40.47 28.33 |
100.00 175.50 |
0.00 | 340.47 | |
2 | No Name #29696 |
Calc. Raw |
189.37 147.00 |
48.10 33.67 |
83.62 146.75 |
0.00 | 321.09 | |
3 | No Name #22311 |
Calc. Raw |
191.95 149.00 |
49.04 34.33 |
76.35 134.00 |
4.00 | 313.34 | |
4 | No Name #37403 |
Calc. Raw |
175.20 136.00 |
49.53 34.67 |
81.77 143.50 |
0.00 | 306.50 | |
5 | No Name #35456 |
Calc. Raw |
186.15 144.50 |
45.71 32.00 |
73.36 128.75 |
0.00 | 305.22 | |
6 | No Name #1901 |
Calc. Raw |
168.76 131.00 |
43.81 30.67 |
89.46 157.00 |
0.00 | 302.03 | |
6 | No Name #29596 |
Calc. Raw |
173.27 134.50 |
50.00 35.00 |
77.92 136.75 |
0.00 | 301.19 | |
7 | No Name #9745 |
Calc. Raw |
189.69 147.25 |
39.53 27.67 |
68.23 119.75 |
0.00 | 297.45 | |
8 | No Name #26609 |
Calc. Raw |
177.13 137.50 |
27.61 19.33 |
88.89 156.00 |
0.00 | 293.63 | |
9 | No Name #36715 |
Calc. Raw |
183.25 142.25 |
50.00 35.00 |
58.97 103.50 |
0.00 | 292.22 | |
10 | No Name #34894 |
Calc. Raw |
177.78 138.00 |
34.29 24.00 |
78.35 137.50 |
0.00 | 290.42 | |
10 | No Name #36617 |
Calc. Raw |
184.22 143.00 |
37.14 26.00 |
68.80 120.75 |
0.00 | 290.16 | |
11 | No Name #21059 |
Calc. Raw |
192.27 149.25 |
29.04 20.33 |
67.38 118.25 |
0.00 | 288.69 | |
12 | No Name #30780 |
Calc. Raw |
184.86 143.50 |
48.57 34.00 |
53.13 93.25 |
0.00 | 286.56 | |
13 | No Name #3260 |
Calc. Raw |
172.95 134.25 |
33.33 23.33 |
77.78 136.50 |
0.00 | 284.06 | |
13 | No Name #22248 |
Calc. Raw |
178.10 138.25 |
32.39 22.67 |
75.36 132.25 |
2.00 | 283.85 | |
13 | No Name #13927 |
Calc. Raw |
180.03 139.75 |
31.90 22.33 |
71.51 125.50 |
0.00 | 283.44 | |
14 | No Name #35343 |
Calc. Raw |
179.07 139.00 |
24.29 17.00 |
79.20 139.00 |
0.00 | 282.56 | |
15 | No Name #11781 |
Calc. Raw |
163.29 126.75 |
34.76 24.33 |
80.34 141.00 |
0.00 | 278.39 | |
16 | No Name #2342 |
Calc. Raw |
176.81 137.25 |
40.47 28.33 |
59.69 104.75 |
0.00 | 276.97 | |
17 | No Name #28600 |
Calc. Raw |
177.46 137.75 |
41.90 29.33 |
55.98 98.25 |
0.00 | 275.34 | |
18 | No Name #37089 |
Calc. Raw |
186.15 144.50 |
35.24 24.67 |
52.71 92.50 |
0.00 | 274.10 | |
18 | No Name #35848 |
Calc. Raw |
165.86 128.75 |
42.39 29.67 |
65.67 115.25 |
0.00 | 273.92 | |
19 | No Name #30532 |
Calc. Raw |
163.61 127.00 |
36.19 25.33 |
71.65 125.75 |
0.00 | 271.45 | |
20 | No Name #33407 |
Calc. Raw |
175.20 136.00 |
42.86 30.00 |
49.29 86.50 |
0.00 | 267.35 | |
21 | No Name #11901 |
Calc. Raw |
168.44 130.75 |
25.71 18.00 |
70.66 124.00 |
0.00 | 264.81 | |
22 | No Name #37478 |
Calc. Raw |
169.08 131.25 |
41.43 29.00 |
51.57 90.50 |
0.00 | 262.08 | |
23 | No Name #34083 |
Calc. Raw |
163.61 127.00 |
43.33 30.33 |
53.28 93.50 |
0.00 | 260.22 | |
24 | No Name #12905 |
Calc. Raw |
165.22 128.25 |
32.86 23.00 |
61.11 107.25 |
0.00 | 259.19 | |
24 | No Name #33416 |
Calc. Raw |
154.27 119.75 |
28.10 19.67 |
76.64 134.50 |
0.00 | 259.01 | |
24 | No Name #36629 |
Calc. Raw |
165.22 128.25 |
26.67 18.67 |
66.52 116.75 |
0.00 | 258.41 | |
25 | No Name #29564 |
Calc. Raw |
169.40 131.50 |
13.81 9.67 |
74.50 130.75 |
0.00 | 257.71 | |
25 | No Name #30867 |
Calc. Raw |
176.81 137.25 |
27.14 19.00 |
67.81 119.00 |
15.00 | 256.76 | |
26 | No Name #15417 |
Calc. Raw |
159.42 123.75 |
34.29 24.00 |
67.38 118.25 |
10.00 | 251.09 | |
26 | No Name #34557 |
Calc. Raw |
173.27 134.50 |
33.33 23.33 |
44.02 77.25 |
0.00 | 250.62 | |
26 | No Name #32251 |
Calc. Raw |
172.95 134.25 |
28.57 20.00 |
48.72 85.50 |
0.00 | 250.24 | |
27 | No Name #30515 |
Calc. Raw |
160.71 124.75 |
41.43 29.00 |
48.72 85.50 |
1.00 | 249.86 | |
27 | No Name #232 |
Calc. Raw |
155.56 120.75 |
44.76 31.33 |
49.15 86.25 |
0.00 | 249.47 | |
28 | No Name #35511 |
Calc. Raw |
156.52 121.50 |
20.47 14.33 |
70.23 123.25 |
0.00 | 247.22 | |
29 | No Name #3421 |
Calc. Raw |
153.62 119.25 |
33.33 23.33 |
58.69 103.00 |
0.00 | 245.64 | |
29 | No Name #30469 |
Calc. Raw |
143.32 111.25 |
30.96 21.67 |
70.80 124.25 |
0.00 | 245.08 | |
30 | No Name #36548 |
Calc. Raw |
149.11 115.75 |
26.19 18.33 |
69.23 121.50 |
0.00 | 244.53 | |
31 | No Name #11548 |
Calc. Raw |
156.84 121.75 |
42.39 29.67 |
43.16 75.75 |
0.00 | 242.39 | |
31 | No Name #30126 |
Calc. Raw |
138.49 107.50 |
36.19 25.33 |
72.65 127.50 |
5.00 | 242.33 | |
32 | No Name #34916 |
Calc. Raw |
166.18 129.00 |
29.04 20.33 |
44.59 78.25 |
0.00 | 239.81 | |
32 | No Name #20480 |
Calc. Raw |
151.05 117.25 |
23.81 16.67 |
64.81 113.75 |
0.00 | 239.67 | |
33 | No Name #36211 |
Calc. Raw |
154.59 120.00 |
31.43 22.00 |
52.28 91.75 |
0.00 | 238.30 | |
33 | No Name #37368 |
Calc. Raw |
153.95 119.50 |
25.71 18.00 |
58.26 102.25 |
0.00 | 237.92 | |
34 | No Name #37730 |
Calc. Raw |
152.66 118.50 |
13.33 9.33 |
63.68 111.75 |
0.00 | 229.67 | |
35 | No Name #33979 |
Calc. Raw |
136.55 106.00 |
14.29 10.00 |
77.49 136.00 |
0.00 | 228.33 | |
36 | No Name #10595 |
Calc. Raw |
145.25 112.75 |
16.67 11.67 |
64.96 114.00 |
0.00 | 226.88 | |
37 | No Name #28239 |
Calc. Raw |
111.76 86.75 |
34.76 24.33 |
79.34 139.25 |
0.00 | 225.86 | |
37 | No Name #35883 |
Calc. Raw |
144.93 112.50 |
22.86 16.00 |
57.69 101.25 |
0.00 | 225.48 | |
38 | No Name #36756 |
Calc. Raw |
145.89 113.25 |
30.00 21.00 |
43.73 76.75 |
0.00 | 219.62 | |
39 | No Name #19185 |
Calc. Raw |
145.25 112.75 |
15.24 10.67 |
53.56 94.00 |
0.00 | 214.05 | |
39 | No Name #37856 |
Calc. Raw |
151.37 117.50 |
27.14 19.00 |
36.75 64.50 |
2.00 | 213.26 | |
40 | No Name #19568 |
Calc. Raw |
131.40 102.00 |
12.86 9.00 |
56.84 99.75 |
2.00 | 199.10 |