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 Tag 'em Division II | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #18227 |
Calc. Raw |
200.00 158.99 |
40.92 33.01 |
85.34 33.00 |
0.00 | 326.26 | |
2 | No Name #34754 |
Calc. Raw |
191.22 152.01 |
50.00 40.33 |
81.02 31.33 |
0.00 | 322.24 | |
3 | No Name #33894 |
Calc. Raw |
183.52 145.89 |
42.15 34.00 |
85.34 33.00 |
0.00 | 311.01 | |
4 | No Name #32490 |
Calc. Raw |
184.06 146.32 |
42.98 34.67 |
81.90 31.67 |
0.00 | 308.94 | |
5 | No Name #35851 |
Calc. Raw |
182.79 145.31 |
45.05 36.34 |
76.73 29.67 |
0.00 | 304.57 | |
6 | No Name #35071 |
Calc. Raw |
176.95 140.67 |
38.43 31.00 |
85.34 33.00 |
0.00 | 300.72 | |
7 | No Name #1436 |
Calc. Raw |
172.90 137.45 |
41.74 33.67 |
84.48 32.67 |
0.00 | 299.12 | |
8 | No Name #25320 |
Calc. Raw |
184.93 147.01 |
47.52 38.33 |
60.33 23.33 |
0.00 | 292.78 | |
9 | No Name #33986 |
Calc. Raw |
179.46 142.66 |
33.88 27.33 |
74.99 29.00 |
0.00 | 288.33 | |
10 | No Name #22311 |
Calc. Raw |
168.56 134.00 |
37.18 29.99 |
81.02 31.33 |
0.00 | 286.76 | |
11 | No Name #34983 |
Calc. Raw |
171.08 136.00 |
29.33 23.66 |
84.48 32.67 |
0.00 | 284.89 | |
11 | No Name #8020 |
Calc. Raw |
168.77 134.16 |
45.03 36.32 |
70.67 27.33 |
0.00 | 284.47 | |
12 | No Name #35546 |
Calc. Raw |
170.04 135.17 |
32.25 26.01 |
80.17 31.00 |
0.00 | 282.46 | |
12 | No Name #28072 |
Calc. Raw |
169.39 134.66 |
39.69 32.01 |
72.41 28.00 |
0.00 | 281.49 | |
13 | No Name #31337 |
Calc. Raw |
157.24 125.00 |
41.73 33.66 |
81.02 31.33 |
0.00 | 279.99 | |
14 | No Name #18112 |
Calc. Raw |
184.28 146.49 |
38.02 30.67 |
56.04 21.67 |
0.00 | 278.34 | |
15 | No Name #35548 |
Calc. Raw |
145.92 116.00 |
29.75 24.00 |
100.00 38.67 |
0.00 | 275.67 | |
15 | No Name #11901 |
Calc. Raw |
171.90 136.65 |
26.87 21.67 |
76.73 29.67 |
0.00 | 275.50 | |
16 | No Name #2747 |
Calc. Raw |
172.34 137.00 |
32.23 26.00 |
68.97 26.67 |
0.00 | 273.54 | |
16 | No Name #35493 |
Calc. Raw |
158.07 125.66 |
37.19 30.00 |
77.58 30.00 |
0.00 | 272.84 | |
17 | No Name #36938 |
Calc. Raw |
156.61 124.50 |
31.01 25.01 |
84.48 32.67 |
0.00 | 272.10 | |
17 | No Name #37146 |
Calc. Raw |
173.87 138.22 |
22.33 18.01 |
76.73 29.67 |
1.00 | 271.93 | |
18 | No Name #11548 |
Calc. Raw |
168.98 134.33 |
34.71 28.00 |
67.24 26.00 |
0.00 | 270.93 | |
19 | No Name #36467 |
Calc. Raw |
174.02 138.34 |
45.45 36.66 |
49.13 19.00 |
0.00 | 268.60 | |
20 | No Name #37100 |
Calc. Raw |
152.21 121.00 |
32.23 26.00 |
80.17 31.00 |
0.00 | 264.61 | |
20 | No Name #2271 |
Calc. Raw |
165.22 131.34 |
30.18 24.34 |
68.97 26.67 |
0.00 | 264.37 | |
21 | No Name #35687 |
Calc. Raw |
155.14 123.33 |
26.05 21.01 |
80.17 31.00 |
0.00 | 261.36 | |
22 | No Name #32144 |
Calc. Raw |
156.25 124.21 |
35.53 28.66 |
64.65 25.00 |
0.00 | 256.43 | |
22 | No Name #8192 |
Calc. Raw |
182.60 145.16 |
37.61 30.34 |
36.20 14.00 |
0.00 | 256.41 | |
23 | No Name #34601 |
Calc. Raw |
158.06 125.65 |
31.81 25.66 |
58.62 22.67 |
0.00 | 248.49 | |
23 | No Name #16088 |
Calc. Raw |
165.63 131.67 |
27.68 22.33 |
54.31 21.00 |
0.00 | 247.62 | |
24 | No Name #35907 |
Calc. Raw |
168.56 134.00 |
26.88 21.68 |
50.87 19.67 |
0.00 | 246.31 | |
25 | No Name #18929 |
Calc. Raw |
148.42 117.99 |
29.75 24.00 |
66.38 25.67 |
0.00 | 244.55 | |
25 | No Name #36641 |
Calc. Raw |
154.71 122.99 |
26.44 21.33 |
62.92 24.33 |
0.00 | 244.07 | |
26 | No Name #35662 |
Calc. Raw |
147.18 117.00 |
38.85 31.34 |
56.04 21.67 |
0.00 | 242.07 | |
27 | No Name #37039 |
Calc. Raw |
135.87 108.01 |
29.35 23.67 |
75.85 29.33 |
0.00 | 241.07 | |
28 | No Name #1386 |
Calc. Raw |
160.60 127.67 |
29.35 23.67 |
46.55 18.00 |
0.00 | 236.50 | |
29 | No Name #32184 |
Calc. Raw |
139.00 110.50 |
30.59 24.67 |
60.33 23.33 |
0.00 | 229.92 | |
30 | No Name #35502 |
Calc. Raw |
152.63 121.33 |
22.32 18.00 |
52.57 20.33 |
0.00 | 227.52 | |
31 | No Name #36211 |
Calc. Raw |
122.88 97.68 |
32.66 26.34 |
63.80 24.67 |
0.00 | 219.34 | |
32 | No Name #35507 |
Calc. Raw |
126.22 100.34 |
30.59 24.67 |
59.48 23.00 |
0.00 | 216.29 | |
33 | No Name #14485 |
Calc. Raw |
130.40 103.66 |
27.68 22.33 |
56.89 22.00 |
0.00 | 214.97 | |
34 | No Name #15407 |
Calc. Raw |
124.95 99.33 |
24.80 20.00 |
63.80 24.67 |
0.00 | 213.55 | |
35 | No Name #36051 |
Calc. Raw |
115.73 92.00 |
31.81 25.66 |
61.21 23.67 |
1.00 | 207.75 | |
36 | No Name #35327 |
Calc. Raw |
116.15 92.33 |
28.53 23.01 |
56.89 22.00 |
1.00 | 200.57 | |
37 | No Name #32289 |
Calc. Raw |
102.33 81.35 |
25.61 20.66 |
69.82 27.00 |
0.00 | 197.76 | |
37 | No Name #17346 |
Calc. Raw |
127.30 101.20 |
18.60 15.00 |
50.87 19.67 |
0.00 | 196.77 | |
38 | No Name #31230 |
Calc. Raw |
119.09 94.67 |
33.05 26.66 |
41.38 16.00 |
0.00 | 193.52 | |
39 | No Name #9565 |
Calc. Raw |
80.63 64.10 |
32.64 26.33 |
77.58 30.00 |
0.00 | 190.85 | |
39 | No Name #37156 |
Calc. Raw |
102.32 81.34 |
39.26 31.67 |
49.13 19.00 |
0.00 | 190.71 | |
40 | No Name #35212 |
Calc. Raw |
76.31 60.66 |
26.04 21.00 |
87.92 34.00 |
2.00 | 188.27 | |
41 | No Name #35889 |
Calc. Raw |
114.89 91.33 |
30.59 24.67 |
40.52 15.67 |
0.00 | 186.00 | |
42 | No Name #36643 |
Calc. Raw |
82.17 65.32 |
21.49 17.33 |
25.86 10.00 |
0.00 | 129.52 |