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 3 Around The World In 8 Minutes Division III | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #31225 |
Calc. Raw |
192.49 141.00 |
50.00 39.99 |
89.06 97.67 |
0.00 | 331.55 | |
2 | No Name #4186 |
Calc. Raw |
200.00 146.50 |
46.67 37.33 |
76.89 84.33 |
0.00 | 323.56 | |
3 | No Name #4634 |
Calc. Raw |
185.32 135.75 |
43.35 34.67 |
85.41 93.67 |
0.00 | 314.08 | |
4 | No Name #8451 |
Calc. Raw |
162.12 118.75 |
43.35 34.67 |
100.00 109.67 |
0.00 | 305.47 | |
4 | No Name #31230 |
Calc. Raw |
172.70 126.50 |
46.67 37.33 |
85.41 93.67 |
0.00 | 304.78 | |
5 | No Name #19512 |
Calc. Raw |
172.35 126.25 |
46.26 37.00 |
85.41 93.67 |
0.00 | 304.02 | |
6 | No Name #34158 |
Calc. Raw |
155.63 114.00 |
47.92 38.33 |
95.13 104.33 |
0.00 | 298.68 | |
7 | No Name #35547 |
Calc. Raw |
170.31 124.75 |
48.76 39.00 |
76.89 84.33 |
0.00 | 295.96 | |
8 | No Name #14577 |
Calc. Raw |
176.45 129.25 |
47.92 38.33 |
70.51 77.33 |
0.00 | 294.88 | |
9 | No Name #35495 |
Calc. Raw |
159.39 116.75 |
46.27 37.01 |
80.54 88.33 |
0.00 | 286.20 | |
10 | No Name #1691 |
Calc. Raw |
169.62 124.25 |
45.85 36.67 |
69.60 76.33 |
0.00 | 285.07 | |
11 | No Name #27297 |
Calc. Raw |
150.51 110.25 |
44.60 35.67 |
90.57 99.33 |
5.00 | 280.68 | |
12 | No Name #32441 |
Calc. Raw |
163.82 120.00 |
38.35 30.67 |
74.47 81.67 |
0.00 | 276.64 | |
13 | No Name #30709 |
Calc. Raw |
152.90 112.00 |
40.42 32.33 |
70.82 77.67 |
0.00 | 264.14 | |
13 | No Name #36574 |
Calc. Raw |
161.77 118.50 |
37.51 30.00 |
64.74 71.00 |
0.00 | 264.02 | |
13 | No Name #15467 |
Calc. Raw |
134.81 98.75 |
44.16 35.32 |
84.19 92.33 |
0.00 | 263.16 | |
14 | No Name #3506 |
Calc. Raw |
149.83 109.75 |
35.00 27.99 |
74.47 81.67 |
0.00 | 259.30 | |
14 | No Name #3381 |
Calc. Raw |
153.58 112.50 |
40.85 32.67 |
64.74 71.00 |
0.00 | 259.17 | |
15 | No Name #34293 |
Calc. Raw |
146.42 107.25 |
27.52 22.01 |
82.98 91.00 |
0.00 | 256.92 | |
15 | No Name #1386 |
Calc. Raw |
144.03 105.50 |
43.77 35.01 |
68.39 75.00 |
0.00 | 256.19 | |
16 | No Name #14670 |
Calc. Raw |
136.52 100.00 |
30.42 24.33 |
85.41 93.67 |
0.00 | 252.35 | |
17 | No Name #31212 |
Calc. Raw |
140.96 103.25 |
27.92 22.33 |
78.12 85.67 |
0.00 | 247.00 | |
17 | No Name #35756 |
Calc. Raw |
134.81 98.75 |
35.85 28.67 |
75.68 83.00 |
0.00 | 246.34 | |
18 | No Name #23095 |
Calc. Raw |
131.06 96.00 |
40.44 32.34 |
74.47 81.67 |
0.00 | 245.97 | |
19 | No Name #36828 |
Calc. Raw |
147.78 108.25 |
32.52 26.01 |
63.53 69.67 |
0.00 | 243.83 | |
19 | No Name #30883 |
Calc. Raw |
126.62 92.75 |
37.51 30.00 |
79.33 87.00 |
0.00 | 243.46 | |
20 | No Name #3473 |
Calc. Raw |
137.54 100.75 |
32.93 26.34 |
72.03 79.00 |
0.00 | 242.50 | |
21 | No Name #9744 |
Calc. Raw |
131.40 96.25 |
39.18 31.34 |
70.82 77.67 |
0.00 | 241.40 | |
22 | No Name #8888 |
Calc. Raw |
141.98 104.00 |
21.67 17.33 |
75.68 83.00 |
0.00 | 239.33 | |
23 | No Name #1790 |
Calc. Raw |
141.98 104.00 |
30.42 24.33 |
79.33 87.00 |
15.00 | 236.73 | |
23 | No Name #5169 |
Calc. Raw |
124.23 91.00 |
27.09 21.67 |
85.41 93.67 |
0.00 | 236.73 | |
24 | No Name #197 |
Calc. Raw |
139.59 102.25 |
30.43 24.34 |
64.74 71.00 |
0.00 | 234.76 | |
24 | No Name #2472 |
Calc. Raw |
122.18 89.50 |
29.99 23.99 |
81.76 89.67 |
0.00 | 233.93 | |
25 | No Name #34505 |
Calc. Raw |
146.76 107.50 |
20.43 16.34 |
64.74 71.00 |
0.00 | 231.93 | |
25 | No Name #34802 |
Calc. Raw |
116.38 85.25 |
40.01 32.00 |
75.38 82.67 |
0.00 | 231.77 | |
26 | No Name #33819 |
Calc. Raw |
131.06 96.00 |
27.93 22.34 |
67.17 73.67 |
0.00 | 226.16 | |
27 | No Name #33358 |
Calc. Raw |
125.94 92.25 |
26.26 21.00 |
72.03 79.00 |
0.00 | 224.23 | |
27 | No Name #36112 |
Calc. Raw |
143.69 105.25 |
31.67 25.33 |
58.06 63.67 |
10.00 | 223.42 | |
28 | No Name #33345 |
Calc. Raw |
119.11 87.25 |
23.34 18.67 |
78.12 85.67 |
0.00 | 220.57 | |
29 | No Name #31161 |
Calc. Raw |
120.48 88.25 |
31.26 25.00 |
65.95 72.33 |
0.00 | 217.69 | |
29 | No Name #29618 |
Calc. Raw |
126.62 92.75 |
35.00 27.99 |
65.95 72.33 |
10.00 | 217.57 | |
29 | No Name #34897 |
Calc. Raw |
126.28 92.50 |
29.18 23.34 |
62.31 68.33 |
1.00 | 216.77 | |
30 | No Name #35871 |
Calc. Raw |
117.75 86.25 |
30.42 24.33 |
63.53 69.67 |
0.00 | 211.70 | |
31 | No Name #23774 |
Calc. Raw |
110.24 80.75 |
22.92 18.33 |
75.68 83.00 |
0.00 | 208.84 | |
32 | No Name #32640 |
Calc. Raw |
122.87 90.00 |
21.26 17.00 |
63.53 69.67 |
0.00 | 207.66 | |
33 | No Name #34990 |
Calc. Raw |
129.01 94.50 |
24.17 19.33 |
67.17 73.67 |
20.00 | 200.35 | |
34 | No Name #33010 |
Calc. Raw |
111.95 82.00 |
13.75 11.00 |
73.25 80.33 |
0.00 | 198.95 | |
35 | No Name #11781 |
Calc. Raw |
118.43 86.75 |
33.76 27.00 |
40.73 44.67 |
0.00 | 192.92 | |
36 | No Name #13857 |
Calc. Raw |
106.83 78.25 |
32.51 26.00 |
62.31 68.33 |
10.00 | 191.65 | |
37 | No Name #35115 |
Calc. Raw |
102.39 75.00 |
27.09 21.67 |
57.45 63.00 |
0.00 | 186.93 | |
38 | No Name #16610 |
Calc. Raw |
97.61 71.50 |
26.26 21.00 |
68.39 75.00 |
30.00 | 162.26 |