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 III | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #1691 |
Calc. Raw |
173.23 144.00 |
44.59 33.00 |
84.11 90.00 |
0.00 | 301.93 | |
2 | No Name #36887 |
Calc. Raw |
171.13 142.25 |
40.99 30.33 |
83.88 89.75 |
0.00 | 296.00 | |
3 | No Name #37221 |
Calc. Raw |
185.86 154.50 |
40.54 30.00 |
55.84 59.75 |
0.00 | 282.24 | |
4 | No Name #32441 |
Calc. Raw |
138.95 115.50 |
34.69 25.67 |
100.00 107.00 |
0.00 | 273.64 | |
5 | No Name #27017 |
Calc. Raw |
200.00 166.25 |
48.20 35.67 |
13.32 14.25 |
0.00 | 261.52 | |
6 | No Name #26102 |
Calc. Raw |
150.08 124.75 |
30.64 22.67 |
76.64 82.00 |
0.00 | 257.36 | |
7 | No Name #1386 |
Calc. Raw |
152.78 127.00 |
38.74 28.67 |
56.54 60.50 |
0.00 | 248.06 | |
8 | No Name #35547 |
Calc. Raw |
158.20 131.50 |
43.69 32.33 |
26.17 28.00 |
0.00 | 228.06 | |
9 | No Name #4634 |
Calc. Raw |
125.11 104.00 |
37.84 28.00 |
56.07 60.00 |
0.00 | 219.02 | |
10 | No Name #35756 |
Calc. Raw |
167.22 139.00 |
33.34 24.67 |
11.92 12.75 |
0.00 | 212.48 | |
10 | No Name #5808 |
Calc. Raw |
121.80 101.25 |
28.82 21.33 |
61.45 65.75 |
0.00 | 212.07 | |
11 | No Name #1896 |
Calc. Raw |
157.89 131.25 |
37.39 27.67 |
13.32 14.25 |
0.00 | 208.60 | |
11 | No Name #3473 |
Calc. Raw |
141.95 118.00 |
38.28 28.33 |
33.18 35.50 |
5.00 | 208.41 | |
12 | No Name #17473 |
Calc. Raw |
104.96 87.25 |
22.53 16.67 |
77.34 82.75 |
0.00 | 204.83 | |
13 | No Name #23095 |
Calc. Raw |
151.58 126.00 |
36.49 27.00 |
15.42 16.50 |
0.00 | 203.49 | |
13 | No Name #2472 |
Calc. Raw |
132.03 109.75 |
32.88 24.33 |
37.85 40.50 |
0.00 | 202.76 | |
13 | No Name #25443 |
Calc. Raw |
129.02 107.25 |
43.24 32.00 |
30.37 32.50 |
0.00 | 202.63 | |
14 | No Name #37705 |
Calc. Raw |
143.46 119.25 |
30.18 22.33 |
28.50 30.50 |
0.00 | 202.14 | |
15 | No Name #31225 |
Calc. Raw |
134.14 111.50 |
50.00 37.00 |
13.08 14.00 |
0.00 | 197.22 | |
16 | No Name #31230 |
Calc. Raw |
145.26 120.75 |
40.09 29.67 |
10.28 11.00 |
0.00 | 195.63 | |
16 | No Name #381 |
Calc. Raw |
119.10 99.00 |
33.34 24.67 |
42.99 46.00 |
0.00 | 195.43 | |
17 | No Name #14577 |
Calc. Raw |
120.00 99.75 |
40.99 30.33 |
29.21 31.25 |
0.00 | 190.20 | |
18 | No Name #23774 |
Calc. Raw |
147.37 122.50 |
28.82 21.33 |
27.57 29.50 |
15.00 | 188.76 | |
19 | No Name #14670 |
Calc. Raw |
111.58 92.75 |
37.84 28.00 |
31.07 33.25 |
0.00 | 180.49 | |
20 | No Name #9744 |
Calc. Raw |
140.75 117.00 |
27.93 20.67 |
10.05 10.75 |
0.00 | 178.73 | |
21 | No Name #1965 |
Calc. Raw |
132.63 110.25 |
29.28 21.67 |
14.95 16.00 |
0.00 | 176.86 | |
21 | No Name #1790 |
Calc. Raw |
135.34 112.50 |
24.77 18.33 |
15.89 17.00 |
0.00 | 176.00 | |
22 | No Name #11780 |
Calc. Raw |
136.24 113.25 |
29.28 21.67 |
12.62 13.50 |
5.00 | 173.14 | |
22 | No Name #34351 |
Calc. Raw |
119.10 99.00 |
29.73 22.00 |
28.50 30.50 |
5.00 | 172.33 | |
23 | No Name #36134 |
Calc. Raw |
138.95 115.50 |
27.47 20.33 |
15.42 16.50 |
10.00 | 171.84 | |
23 | No Name #32435 |
Calc. Raw |
101.95 84.75 |
15.77 11.67 |
53.74 57.50 |
0.00 | 171.46 | |
24 | No Name #37405 |
Calc. Raw |
120.30 100.00 |
35.58 26.33 |
13.79 14.75 |
0.00 | 169.67 | |
24 | No Name #10146 |
Calc. Raw |
107.97 89.75 |
22.97 17.00 |
38.08 40.75 |
0.00 | 169.02 | |
25 | No Name #30595 |
Calc. Raw |
111.58 92.75 |
19.36 14.33 |
37.38 40.00 |
0.00 | 168.32 | |
26 | No Name #29473 |
Calc. Raw |
107.97 89.75 |
25.23 18.67 |
30.14 32.25 |
0.00 | 163.34 | |
26 | No Name #27946 |
Calc. Raw |
120.00 99.75 |
26.58 19.67 |
18.93 20.25 |
3.00 | 162.51 | |
27 | No Name #30883 |
Calc. Raw |
121.50 101.00 |
24.77 18.33 |
11.92 12.75 |
0.00 | 158.19 | |
28 | No Name #30329 |
Calc. Raw |
104.96 87.25 |
18.92 14.00 |
26.40 28.25 |
0.00 | 150.28 | |
29 | No Name #33852 |
Calc. Raw |
124.81 103.75 |
27.03 20.00 |
11.68 12.50 |
15.00 | 148.52 | |
30 | No Name #3244 |
Calc. Raw |
104.36 86.75 |
29.73 22.00 |
10.75 11.50 |
0.00 | 144.84 | |
31 | No Name #29857 |
Calc. Raw |
113.68 94.50 |
18.01 13.33 |
10.28 11.00 |
7.00 | 134.97 | |
31 | No Name #33986 |
Calc. Raw |
98.05 81.50 |
21.18 15.67 |
15.42 16.50 |
0.00 | 134.65 | |
32 | No Name #28695 |
Calc. Raw |
106.17 88.25 |
18.01 13.33 |
8.64 9.25 |
1.00 | 131.82 | |
33 | No Name #33422 |
Calc. Raw |
98.35 81.75 |
16.66 12.33 |
12.15 13.00 |
0.00 | 127.16 | |
34 | No Name #3962 |
Calc. Raw |
90.53 75.25 |
24.32 18.00 |
10.75 11.50 |
5.00 | 120.60 | |
34 | No Name #8871 |
Calc. Raw |
74.59 62.00 |
22.07 16.33 |
25.47 27.25 |
2.00 | 120.13 | |
35 | No Name #32530 |
Calc. Raw |
92.03 76.50 |
16.66 12.33 |
11.92 12.75 |
3.00 | 117.61 | |
36 | No Name #37429 |
Calc. Raw |
86.02 71.50 |
22.07 16.33 |
7.94 8.50 |
2.00 | 114.03 |