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 III | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #22311 |
Calc. Raw |
191.32 152.11 |
50.00 43.99 |
90.65 121.25 |
0.00 | 331.97 | |
2 | No Name #18255 |
Calc. Raw |
173.36 137.83 |
46.99 41.34 |
96.82 129.50 |
0.00 | 317.17 | |
3 | No Name #36232 |
Calc. Raw |
193.70 154.00 |
46.60 41.00 |
65.05 87.00 |
0.00 | 305.35 | |
4 | No Name #31161 |
Calc. Raw |
186.15 148.00 |
15.16 13.34 |
100.00 133.75 |
0.00 | 301.31 | |
5 | No Name #5736 |
Calc. Raw |
195.18 155.18 |
43.58 38.34 |
60.37 80.75 |
0.00 | 299.13 | |
6 | No Name #7246 |
Calc. Raw |
173.35 137.82 |
31.44 27.66 |
91.59 122.50 |
0.00 | 296.38 | |
7 | No Name #33516 |
Calc. Raw |
189.91 150.99 |
40.53 35.66 |
63.18 84.50 |
0.00 | 293.62 | |
8 | No Name #30595 |
Calc. Raw |
182.58 145.16 |
29.94 26.34 |
80.00 107.00 |
0.00 | 292.52 | |
8 | No Name #32441 |
Calc. Raw |
174.82 138.99 |
42.44 37.34 |
75.14 100.50 |
0.00 | 292.40 | |
9 | No Name #32223 |
Calc. Raw |
171.06 136.00 |
21.97 19.33 |
97.38 130.25 |
0.00 | 290.41 | |
10 | No Name #3887 |
Calc. Raw |
193.70 154.00 |
49.64 43.67 |
42.24 56.50 |
0.00 | 285.58 | |
11 | No Name #3381 |
Calc. Raw |
164.35 130.67 |
15.91 14.00 |
99.63 133.25 |
0.00 | 279.89 | |
12 | No Name #9125 |
Calc. Raw |
185.94 147.83 |
30.68 26.99 |
59.07 79.00 |
0.00 | 275.69 | |
13 | No Name #31579 |
Calc. Raw |
166.01 131.99 |
29.93 26.33 |
78.50 105.00 |
0.00 | 274.44 | |
13 | No Name #26200 |
Calc. Raw |
139.20 110.67 |
42.82 37.67 |
92.34 123.50 |
0.00 | 274.36 | |
14 | No Name #33757 |
Calc. Raw |
189.91 150.99 |
30.31 26.67 |
50.84 68.00 |
0.00 | 271.06 | |
14 | No Name #31230 |
Calc. Raw |
185.88 147.78 |
44.33 39.00 |
40.19 53.75 |
0.00 | 270.40 | |
15 | No Name #36469 |
Calc. Raw |
200.00 159.01 |
36.37 32.00 |
33.27 44.50 |
0.00 | 269.64 | |
16 | No Name #1149 |
Calc. Raw |
174.00 138.34 |
46.60 41.00 |
46.92 62.75 |
0.00 | 267.52 | |
17 | No Name #31043 |
Calc. Raw |
183.22 145.67 |
27.28 24.00 |
55.70 74.50 |
0.00 | 266.20 | |
17 | No Name #30951 |
Calc. Raw |
178.18 141.66 |
31.06 27.33 |
56.07 75.00 |
0.00 | 265.31 | |
18 | No Name #35621 |
Calc. Raw |
177.35 141.00 |
42.43 37.33 |
42.80 57.25 |
0.00 | 262.58 | |
19 | No Name #33488 |
Calc. Raw |
139.63 111.01 |
26.14 23.00 |
90.84 121.50 |
0.00 | 256.61 | |
20 | No Name #1412 |
Calc. Raw |
152.19 121.00 |
23.88 21.01 |
78.88 105.50 |
0.00 | 254.95 | |
20 | No Name #33422 |
Calc. Raw |
160.58 127.67 |
15.54 13.67 |
77.94 104.25 |
0.00 | 254.06 | |
21 | No Name #20868 |
Calc. Raw |
179.45 142.67 |
28.40 24.99 |
45.42 60.75 |
0.00 | 253.27 | |
21 | No Name #10146 |
Calc. Raw |
132.07 105.00 |
26.53 23.34 |
93.83 125.50 |
0.00 | 252.43 | |
22 | No Name #34393 |
Calc. Raw |
167.07 132.83 |
23.87 21.00 |
59.63 79.75 |
0.00 | 250.57 | |
23 | No Name #35758 |
Calc. Raw |
178.62 142.01 |
21.98 19.34 |
48.41 64.75 |
2.00 | 247.01 | |
24 | No Name #36865 |
Calc. Raw |
141.50 112.50 |
15.54 13.67 |
84.11 112.50 |
0.00 | 241.15 | |
25 | No Name #17068 |
Calc. Raw |
170.00 135.16 |
30.68 26.99 |
36.45 48.75 |
0.00 | 237.13 | |
26 | No Name #4637 |
Calc. Raw |
169.79 134.99 |
21.22 18.67 |
38.32 51.25 |
0.00 | 229.33 | |
27 | No Name #32530 |
Calc. Raw |
165.18 131.33 |
20.07 17.66 |
41.50 55.50 |
0.00 | 226.75 | |
28 | No Name #37109 |
Calc. Raw |
97.26 77.33 |
23.12 20.34 |
96.64 129.25 |
0.00 | 217.02 | |
29 | No Name #31734 |
Calc. Raw |
113.20 90.00 |
12.89 11.34 |
84.11 112.50 |
0.00 | 210.20 | |
30 | No Name #36823 |
Calc. Raw |
157.64 125.33 |
25.38 22.33 |
25.23 33.75 |
0.00 | 208.25 | |
31 | No Name #5420 |
Calc. Raw |
157.21 124.99 |
26.53 23.34 |
22.06 29.50 |
0.00 | 205.80 | |
32 | No Name #25049 |
Calc. Raw |
154.57 122.89 |
19.32 17.00 |
29.91 40.00 |
0.00 | 203.80 | |
33 | No Name #37158 |
Calc. Raw |
89.53 71.18 |
26.90 23.67 |
46.92 62.75 |
0.00 | 163.35 | |
34 | No Name #33292 |
Calc. Raw |
78.85 62.69 |
27.65 24.33 |
53.08 71.00 |
0.00 | 159.58 |