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 I | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #18449 |
Calc. Raw |
200.00 176.34 |
37.71 31.67 |
86.42 70.00 |
0.00 | 324.13 | |
2 | No Name #33557 |
Calc. Raw |
182.98 161.33 |
46.83 39.33 |
91.67 74.25 |
0.00 | 321.48 | |
3 | No Name #34928 |
Calc. Raw |
187.15 165.01 |
32.56 27.34 |
95.68 77.50 |
1.00 | 314.39 | |
3 | No Name #16465 |
Calc. Raw |
192.42 169.66 |
48.82 41.00 |
72.53 58.75 |
0.00 | 313.77 | |
4 | No Name #16873 |
Calc. Raw |
192.81 170.00 |
32.95 27.67 |
86.73 70.25 |
0.00 | 312.49 | |
4 | No Name #5002 |
Calc. Raw |
198.09 174.66 |
40.89 34.34 |
72.53 58.75 |
0.00 | 311.51 | |
5 | No Name #16868 |
Calc. Raw |
170.89 150.67 |
42.87 36.00 |
94.14 76.25 |
0.00 | 307.90 | |
6 | No Name #33368 |
Calc. Raw |
188.27 166.00 |
26.60 22.34 |
90.74 73.50 |
0.00 | 305.61 | |
7 | No Name #28072 |
Calc. Raw |
188.66 166.34 |
29.38 24.67 |
81.79 66.25 |
0.00 | 299.83 | |
8 | No Name #34325 |
Calc. Raw |
182.98 161.33 |
42.47 35.67 |
70.37 57.00 |
0.00 | 295.82 | |
9 | No Name #32122 |
Calc. Raw |
153.49 135.33 |
33.35 28.01 |
93.21 75.50 |
0.00 | 280.05 | |
10 | No Name #1436 |
Calc. Raw |
139.13 122.67 |
36.52 30.67 |
94.44 76.50 |
0.00 | 270.09 | |
11 | No Name #27796 |
Calc. Raw |
142.53 125.67 |
31.36 26.34 |
94.44 76.50 |
0.00 | 268.33 | |
11 | No Name #32521 |
Calc. Raw |
151.60 133.67 |
32.15 27.00 |
83.64 67.75 |
0.00 | 267.39 | |
11 | No Name #20906 |
Calc. Raw |
140.25 123.66 |
46.84 39.34 |
80.25 65.00 |
0.00 | 267.34 | |
12 | No Name #6424 |
Calc. Raw |
187.89 165.66 |
23.80 19.99 |
52.16 42.25 |
0.00 | 263.85 | |
13 | No Name #31531 |
Calc. Raw |
134.97 119.00 |
34.52 28.99 |
90.74 73.50 |
0.00 | 260.23 | |
14 | No Name #32061 |
Calc. Raw |
120.21 105.99 |
38.09 31.99 |
93.83 76.00 |
0.00 | 252.13 | |
14 | No Name #8174 |
Calc. Raw |
144.80 127.67 |
32.15 27.00 |
74.69 60.50 |
0.00 | 251.64 | |
15 | No Name #26787 |
Calc. Raw |
127.41 112.34 |
35.72 30.00 |
82.72 67.00 |
0.00 | 245.85 | |
16 | No Name #1567 |
Calc. Raw |
148.95 131.33 |
50.00 41.99 |
48.77 39.50 |
3.00 | 244.72 | |
17 | No Name #24450 |
Calc. Raw |
142.52 125.66 |
32.95 27.67 |
61.73 50.00 |
0.00 | 237.20 | |
18 | No Name #28577 |
Calc. Raw |
88.84 78.33 |
48.43 40.67 |
91.98 74.50 |
0.00 | 229.25 | |
19 | No Name #5735 |
Calc. Raw |
108.12 95.33 |
35.33 29.67 |
79.32 64.25 |
0.00 | 222.77 | |
20 | No Name #33705 |
Calc. Raw |
111.91 98.67 |
42.47 35.67 |
54.94 44.50 |
0.00 | 209.32 | |
21 | No Name #237 |
Calc. Raw |
108.89 96.01 |
17.06 14.33 |
82.10 66.50 |
5.00 | 203.05 | |
22 | No Name #35008 |
Calc. Raw |
105.48 93.00 |
18.66 15.67 |
79.32 64.25 |
2.00 | 201.46 | |
23 | No Name #5469 |
Calc. Raw |
74.87 66.01 |
24.60 20.66 |
100.00 81.00 |
0.00 | 199.47 | |
23 | No Name #34320 |
Calc. Raw |
135.34 119.33 |
19.05 16.00 |
47.22 38.25 |
3.00 | 198.61 | |
24 | No Name #34917 |
Calc. Raw |
100.57 88.67 |
17.06 14.33 |
80.56 65.25 |
0.00 | 198.19 | |
25 | No Name #35125 |
Calc. Raw |
117.58 103.67 |
14.68 12.33 |
63.27 51.25 |
0.00 | 195.53 | |
26 | No Name #34242 |
Calc. Raw |
94.51 83.33 |
19.45 16.33 |
80.25 65.00 |
0.00 | 194.21 | |
27 | No Name #28204 |
Calc. Raw |
105.86 93.34 |
37.31 31.33 |
50.00 40.50 |
0.00 | 193.17 | |
28 | No Name #14485 |
Calc. Raw |
104.34 92.00 |
36.13 30.34 |
46.91 38.00 |
0.00 | 187.38 | |
29 | No Name #5821 |
Calc. Raw |
108.13 95.34 |
19.85 16.67 |
54.94 44.50 |
0.00 | 182.92 | |
29 | No Name #33039 |
Calc. Raw |
97.55 86.01 |
37.70 31.66 |
48.77 39.50 |
2.00 | 182.02 | |
30 | No Name #30749 |
Calc. Raw |
64.65 57.00 |
23.83 20.01 |
85.80 69.50 |
0.00 | 174.28 | |
31 | No Name #27122 |
Calc. Raw |
85.05 74.99 |
16.27 13.66 |
76.85 62.25 |
5.00 | 173.17 | |
32 | No Name #33087 |
Calc. Raw |
73.72 65.00 |
18.25 15.33 |
84.57 68.50 |
10.00 | 166.54 | |
33 | No Name #9971 |
Calc. Raw |
118.33 104.33 |
33.34 28.00 |
13.58 11.00 |
0.00 | 165.25 | |
34 | No Name #22144 |
Calc. Raw |
66.92 59.00 |
29.77 25.00 |
66.05 53.50 |
2.00 | 160.74 | |
35 | No Name #34284 |
Calc. Raw |
63.50 55.99 |
37.32 31.34 |
52.78 42.75 |
1.00 | 152.60 | |
36 | No Name #2925 |
Calc. Raw |
26.85 23.67 |
39.70 33.34 |
84.57 68.50 |
0.00 | 151.12 | |
37 | No Name #33278 |
Calc. Raw |
90.36 79.67 |
26.99 22.67 |
30.56 24.75 |
0.00 | 147.91 | |
38 | No Name #5470 |
Calc. Raw |
100.18 88.33 |
10.73 9.01 |
30.56 24.75 |
0.00 | 141.47 | |
39 | No Name #35277 |
Calc. Raw |
96.02 84.66 |
19.46 16.34 |
21.60 17.50 |
0.00 | 137.08 | |
40 | No Name #31036 |
Calc. Raw |
79.39 70.00 |
20.64 17.33 |
31.48 25.50 |
1.00 | 130.51 | |
41 | No Name #35357 |
Calc. Raw |
41.59 36.67 |
16.27 13.66 |
73.15 59.25 |
3.00 | 128.01 | |
42 | No Name #33979 |
Calc. Raw |
25.71 22.67 |
16.67 14.00 |
77.47 62.75 |
0.00 | 119.85 | |
43 | No Name #12905 |
Calc. Raw |
22.30 19.66 |
21.43 18.00 |
53.70 43.50 |
0.00 | 97.43 | |
44 | No Name #32847 |
Calc. Raw |
19.28 17.00 |
12.71 10.67 |
56.17 45.50 |
0.00 | 88.16 |