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 III | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #18255 |
Calc. Raw |
200.00 159.33 |
28.98 24.34 |
79.53 68.00 |
0.00 | 308.51 | |
2 | No Name #33488 |
Calc. Raw |
166.11 132.33 |
37.70 31.67 |
100.00 85.50 |
0.00 | 303.81 | |
3 | No Name #9744 |
Calc. Raw |
176.15 140.33 |
41.29 34.68 |
74.27 63.50 |
0.00 | 291.71 | |
4 | No Name #27017 |
Calc. Raw |
187.03 149.00 |
50.00 42.00 |
29.24 25.00 |
0.00 | 266.27 | |
5 | No Name #35550 |
Calc. Raw |
167.36 133.33 |
26.60 22.34 |
71.05 60.75 |
0.00 | 265.01 | |
6 | No Name #26200 |
Calc. Raw |
165.68 131.99 |
40.88 34.34 |
56.43 48.25 |
0.00 | 262.99 | |
7 | No Name #9116 |
Calc. Raw |
182.01 145.00 |
33.73 28.33 |
44.15 37.75 |
0.00 | 259.89 | |
8 | No Name #291 |
Calc. Raw |
169.05 134.67 |
32.15 27.01 |
54.68 46.75 |
0.00 | 255.88 | |
9 | No Name #24553 |
Calc. Raw |
140.20 111.69 |
41.27 34.67 |
66.37 56.75 |
0.00 | 247.84 | |
9 | No Name #31230 |
Calc. Raw |
166.86 132.93 |
38.50 32.34 |
42.40 36.25 |
0.00 | 247.76 | |
10 | No Name #32441 |
Calc. Raw |
147.29 117.34 |
38.11 32.01 |
59.65 51.00 |
0.00 | 245.05 | |
11 | No Name #3887 |
Calc. Raw |
159.00 126.67 |
32.94 27.67 |
46.49 39.75 |
0.00 | 238.43 | |
12 | No Name #33516 |
Calc. Raw |
149.34 118.97 |
30.95 26.00 |
54.68 46.75 |
0.00 | 234.97 | |
13 | No Name #35901 |
Calc. Raw |
163.60 130.33 |
19.85 16.67 |
49.71 42.50 |
0.00 | 233.16 | |
14 | No Name #4307 |
Calc. Raw |
150.63 120.00 |
35.32 29.67 |
40.64 34.75 |
0.00 | 226.59 | |
15 | No Name #5730 |
Calc. Raw |
142.28 113.35 |
25.81 21.68 |
57.02 48.75 |
0.00 | 225.11 | |
15 | No Name #1149 |
Calc. Raw |
129.69 103.32 |
40.08 33.67 |
54.68 46.75 |
0.00 | 224.45 | |
16 | No Name #2215 |
Calc. Raw |
139.74 111.32 |
25.80 21.67 |
57.31 49.00 |
0.00 | 222.85 | |
16 | No Name #35621 |
Calc. Raw |
116.74 93.00 |
30.15 25.33 |
75.15 64.25 |
0.00 | 222.04 | |
17 | No Name #35824 |
Calc. Raw |
115.06 91.66 |
23.40 19.66 |
83.04 71.00 |
0.00 | 221.50 | |
18 | No Name #1412 |
Calc. Raw |
124.67 99.32 |
21.42 17.99 |
73.10 62.50 |
0.00 | 219.19 | |
19 | No Name #27336 |
Calc. Raw |
97.91 78.00 |
30.15 25.33 |
84.80 72.50 |
0.00 | 212.86 | |
20 | No Name #35509 |
Calc. Raw |
130.53 103.99 |
34.92 29.33 |
42.40 36.25 |
0.00 | 207.85 | |
20 | No Name #31161 |
Calc. Raw |
125.91 100.31 |
18.64 15.66 |
62.87 53.75 |
0.00 | 207.42 | |
21 | No Name #35880 |
Calc. Raw |
124.71 99.35 |
36.12 30.34 |
38.60 33.00 |
0.00 | 199.43 | |
22 | No Name #35430 |
Calc. Raw |
100.03 79.69 |
16.65 13.99 |
75.15 64.25 |
0.00 | 191.83 | |
23 | No Name #33323 |
Calc. Raw |
99.15 78.99 |
29.37 24.67 |
59.65 51.00 |
0.00 | 188.17 | |
24 | No Name #33986 |
Calc. Raw |
102.10 81.34 |
38.50 32.34 |
43.57 37.25 |
0.00 | 184.17 | |
25 | No Name #3047 |
Calc. Raw |
134.71 107.32 |
23.42 19.67 |
24.85 21.25 |
0.00 | 182.98 | |
25 | No Name #11392 |
Calc. Raw |
123.43 98.33 |
14.29 12.00 |
44.74 38.25 |
0.00 | 182.46 | |
26 | No Name #29482 |
Calc. Raw |
133.87 106.65 |
24.21 20.34 |
20.76 17.75 |
0.00 | 178.84 | |
27 | No Name #7975 |
Calc. Raw |
97.92 78.01 |
26.20 22.01 |
48.25 41.25 |
0.00 | 172.37 | |
28 | No Name #8888 |
Calc. Raw |
106.30 84.68 |
22.21 18.66 |
42.11 36.00 |
0.00 | 170.62 | |
29 | No Name #1386 |
Calc. Raw |
78.24 62.33 |
29.76 25.00 |
55.56 47.50 |
0.00 | 163.56 | |
29 | No Name #30595 |
Calc. Raw |
108.37 86.33 |
24.61 20.67 |
30.41 26.00 |
0.00 | 163.39 | |
30 | No Name #16610 |
Calc. Raw |
111.73 89.01 |
26.58 22.33 |
18.42 15.75 |
0.00 | 156.73 | |
31 | No Name #24436 |
Calc. Raw |
46.87 37.34 |
19.05 16.00 |
83.92 71.75 |
0.00 | 149.84 | |
32 | No Name #11753 |
Calc. Raw |
81.99 65.32 |
17.86 15.00 |
21.05 18.00 |
0.00 | 120.90 | |
33 | No Name #36007 |
Calc. Raw |
46.46 37.01 |
28.57 24.00 |
32.16 27.50 |
0.00 | 107.19 | |
34 | No Name #35428 |
Calc. Raw |
89.12 71.00 |
15.88 13.34 |
22.22 19.00 |
30.00 | 97.22 | |
35 | No Name #5144 |
Calc. Raw |
26.77 21.33 |
15.08 12.67 |
41.81 35.75 |
0.00 | 83.66 |