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 1 The Great Parade Division II | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #1701 |
Calc. Raw |
193.15 178.66 |
41.48 39.00 |
100.00 86.75 |
0.00 | 334.63 | |
2 | No Name #28547 |
Calc. Raw |
187.03 173.00 |
50.00 47.01 |
72.62 63.00 |
0.00 | 309.65 | |
3 | No Name #30595 |
Calc. Raw |
200.00 185.00 |
35.10 33.00 |
35.73 31.00 |
0.00 | 270.83 | |
4 | No Name #5122 |
Calc. Raw |
140.90 130.33 |
35.81 33.67 |
86.46 75.00 |
0.00 | 263.17 | |
5 | No Name #29726 |
Calc. Raw |
171.18 158.34 |
47.86 45.00 |
33.14 28.75 |
0.00 | 252.18 | |
5 | No Name #33089 |
Calc. Raw |
160.37 148.34 |
42.18 39.66 |
48.99 42.50 |
0.00 | 251.54 | |
6 | No Name #32190 |
Calc. Raw |
183.43 169.67 |
31.20 29.33 |
34.01 29.50 |
0.00 | 248.64 | |
7 | No Name #26815 |
Calc. Raw |
148.82 137.66 |
37.23 35.00 |
61.10 53.00 |
0.00 | 247.15 | |
7 | No Name #10706 |
Calc. Raw |
179.10 165.67 |
38.28 35.99 |
29.11 25.25 |
0.00 | 246.49 | |
8 | No Name #32490 |
Calc. Raw |
151.72 140.34 |
40.78 38.34 |
43.52 37.75 |
0.00 | 236.02 | |
9 | No Name #18503 |
Calc. Raw |
164.34 152.01 |
36.15 33.99 |
34.01 29.50 |
0.00 | 234.50 | |
10 | No Name #467 |
Calc. Raw |
178.03 164.68 |
33.33 31.34 |
21.04 18.25 |
0.00 | 232.40 | |
11 | No Name #28695 |
Calc. Raw |
175.14 162.00 |
37.58 35.33 |
17.87 15.50 |
0.00 | 230.59 | |
12 | No Name #31458 |
Calc. Raw |
153.16 141.67 |
46.45 43.67 |
17.58 15.25 |
0.00 | 217.19 | |
12 | No Name #32289 |
Calc. Raw |
151.71 140.33 |
46.09 43.33 |
18.44 16.00 |
0.00 | 216.24 | |
13 | No Name #13338 |
Calc. Raw |
153.51 142.00 |
41.48 39.00 |
20.75 18.00 |
0.00 | 215.74 | |
14 | No Name #8192 |
Calc. Raw |
162.52 150.33 |
31.56 29.67 |
19.60 17.00 |
0.00 | 213.68 | |
15 | No Name #31604 |
Calc. Raw |
123.60 114.33 |
34.40 32.34 |
51.59 44.75 |
0.00 | 209.59 | |
15 | No Name #19826 |
Calc. Raw |
147.38 136.33 |
26.24 24.67 |
35.16 30.50 |
0.00 | 208.78 | |
16 | No Name #11901 |
Calc. Raw |
103.06 95.33 |
28.73 27.01 |
71.18 61.75 |
0.00 | 202.97 | |
17 | No Name #33757 |
Calc. Raw |
150.26 138.99 |
30.13 28.33 |
18.73 16.25 |
0.00 | 199.12 | |
18 | No Name #789 |
Calc. Raw |
65.95 61.00 |
39.35 37.00 |
92.80 80.50 |
0.00 | 198.10 | |
19 | No Name #7991 |
Calc. Raw |
120.71 111.66 |
29.77 27.99 |
46.40 40.25 |
0.00 | 196.88 | |
19 | No Name #33579 |
Calc. Raw |
102.70 95.00 |
30.86 29.01 |
63.11 54.75 |
0.00 | 196.67 | |
20 | No Name #22130 |
Calc. Raw |
109.90 101.66 |
39.35 37.00 |
43.80 38.00 |
0.00 | 193.05 | |
21 | No Name #11595 |
Calc. Raw |
120.37 111.34 |
19.51 18.34 |
44.96 39.00 |
0.00 | 184.84 | |
22 | No Name #14078 |
Calc. Raw |
124.68 115.33 |
32.25 30.32 |
23.92 20.75 |
0.00 | 180.85 | |
23 | No Name #3057 |
Calc. Raw |
112.42 103.99 |
34.39 32.33 |
31.99 27.75 |
0.00 | 178.80 | |
24 | No Name #21243 |
Calc. Raw |
152.80 141.34 |
34.04 32.00 |
21.90 19.00 |
33.00 | 175.74 | |
25 | No Name #10036 |
Calc. Raw |
102.35 94.67 |
40.79 38.35 |
23.92 20.75 |
0.00 | 167.06 | |
26 | No Name #34690 |
Calc. Raw |
118.21 109.34 |
30.48 28.66 |
21.33 18.50 |
4.00 | 166.02 | |
27 | No Name #32600 |
Calc. Raw |
86.49 80.00 |
22.69 21.33 |
51.01 44.25 |
0.00 | 160.19 | |
28 | No Name #25443 |
Calc. Raw |
80.72 74.67 |
35.46 33.34 |
42.94 37.25 |
0.00 | 159.12 | |
28 | No Name #26430 |
Calc. Raw |
94.42 87.34 |
34.75 32.67 |
29.39 25.50 |
0.00 | 158.56 | |
29 | No Name #6538 |
Calc. Raw |
87.57 81.00 |
19.13 17.99 |
49.28 42.75 |
0.00 | 155.98 | |
29 | No Name #34159 |
Calc. Raw |
109.55 101.33 |
25.16 23.66 |
22.19 19.25 |
1.00 | 155.90 | |
29 | No Name #34917 |
Calc. Raw |
90.45 83.67 |
27.65 26.00 |
37.46 32.50 |
0.00 | 155.56 | |
29 | No Name #8903 |
Calc. Raw |
112.43 104.00 |
25.88 24.33 |
16.71 14.50 |
0.00 | 155.02 | |
30 | No Name #5471 |
Calc. Raw |
107.03 99.00 |
15.24 14.33 |
27.38 23.75 |
0.00 | 149.65 | |
30 | No Name #34669 |
Calc. Raw |
78.19 72.33 |
35.81 33.67 |
35.45 30.75 |
0.00 | 149.45 | |
31 | No Name #35071 |
Calc. Raw |
86.85 80.34 |
36.88 34.67 |
18.16 15.75 |
0.00 | 141.89 | |
32 | No Name #34398 |
Calc. Raw |
83.98 77.68 |
26.59 25.00 |
28.53 24.75 |
0.00 | 139.10 | |
33 | No Name #20480 |
Calc. Raw |
73.87 68.33 |
29.78 28.00 |
15.56 13.50 |
0.00 | 119.21 | |
34 | No Name #31037 |
Calc. Raw |
58.02 53.67 |
20.55 19.32 |
31.41 27.25 |
0.00 | 109.98 | |
35 | No Name #11324 |
Calc. Raw |
76.76 71.00 |
15.95 15.00 |
12.10 10.50 |
0.00 | 104.81 | |
35 | No Name #34931 |
Calc. Raw |
59.11 54.68 |
30.84 29.00 |
14.70 12.75 |
0.00 | 104.65 | |
36 | No Name #1548 |
Calc. Raw |
49.36 45.66 |
21.27 20.00 |
19.88 17.25 |
0.00 | 90.51 | |
36 | No Name #34338 |
Calc. Raw |
54.78 50.67 |
18.79 17.67 |
16.43 14.25 |
0.00 | 90.00 | |
37 | No Name #35382 |
Calc. Raw |
43.98 40.68 |
18.78 17.66 |
19.02 16.50 |
0.00 | 81.78 | |
38 | No Name #33857 |
Calc. Raw |
16.94 15.67 |
20.21 19.00 |
24.50 21.25 |
0.00 | 61.65 |