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 II | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #22311 |
Calc. Raw |
189.62 155.25 |
40.84 28.33 |
86.85 105.67 |
0.00 | 317.31 | |
1 | No Name #32462 |
Calc. Raw |
200.00 163.75 |
50.00 34.68 |
67.12 81.67 |
0.00 | 317.12 | |
2 | No Name #32284 |
Calc. Raw |
168.55 138.00 |
33.65 23.34 |
100.00 121.67 |
0.00 | 302.20 | |
3 | No Name #1375 |
Calc. Raw |
173.13 141.75 |
37.01 25.67 |
90.14 109.67 |
0.00 | 300.28 | |
4 | No Name #31225 |
Calc. Raw |
181.37 148.50 |
37.98 26.34 |
79.17 96.33 |
0.00 | 298.52 | |
5 | No Name #35850 |
Calc. Raw |
189.62 155.25 |
45.66 31.67 |
61.64 75.00 |
0.00 | 296.92 | |
6 | No Name #6688 |
Calc. Raw |
195.73 160.25 |
33.17 23.01 |
66.02 80.33 |
0.00 | 294.92 | |
6 | No Name #15677 |
Calc. Raw |
195.11 159.75 |
31.72 22.00 |
67.67 82.33 |
0.00 | 294.50 | |
7 | No Name #37000 |
Calc. Raw |
167.94 137.50 |
33.64 23.33 |
87.94 107.00 |
0.00 | 289.52 | |
8 | No Name #37089 |
Calc. Raw |
199.08 163.00 |
37.50 26.01 |
47.40 57.67 |
0.00 | 283.98 | |
9 | No Name #18418 |
Calc. Raw |
187.18 153.25 |
35.54 24.65 |
59.45 72.33 |
0.00 | 282.17 | |
10 | No Name #30604 |
Calc. Raw |
187.18 153.25 |
33.16 23.00 |
59.45 72.33 |
0.00 | 279.79 | |
11 | No Name #32785 |
Calc. Raw |
171.60 140.50 |
37.96 26.33 |
67.12 81.67 |
0.00 | 276.68 | |
12 | No Name #5465 |
Calc. Raw |
156.64 128.25 |
45.17 31.33 |
71.50 87.00 |
0.00 | 273.31 | |
13 | No Name #10378 |
Calc. Raw |
167.02 136.75 |
42.30 29.34 |
57.26 69.67 |
0.00 | 266.58 | |
14 | No Name #1790 |
Calc. Raw |
171.30 140.25 |
41.34 28.67 |
51.78 63.00 |
0.00 | 264.42 | |
15 | No Name #16375 |
Calc. Raw |
164.89 135.00 |
31.72 22.00 |
66.02 80.33 |
0.00 | 262.63 | |
16 | No Name #20184 |
Calc. Raw |
169.77 139.00 |
32.22 22.35 |
59.45 72.33 |
0.00 | 261.44 | |
17 | No Name #37164 |
Calc. Raw |
174.96 143.25 |
32.21 22.34 |
71.50 87.00 |
20.00 | 258.67 | |
17 | No Name #11781 |
Calc. Raw |
172.82 141.50 |
19.22 13.33 |
66.02 80.33 |
0.00 | 258.06 | |
18 | No Name #3253 |
Calc. Raw |
162.44 133.00 |
35.09 24.34 |
59.45 72.33 |
0.00 | 256.98 | |
19 | No Name #13927 |
Calc. Raw |
159.69 130.75 |
20.18 14.00 |
68.22 83.00 |
0.00 | 248.09 | |
20 | No Name #34380 |
Calc. Raw |
174.35 142.75 |
31.70 21.99 |
40.82 49.67 |
0.00 | 246.87 | |
20 | No Name #5511 |
Calc. Raw |
162.44 133.00 |
22.12 15.34 |
61.64 75.00 |
0.00 | 246.20 | |
20 | No Name #33346 |
Calc. Raw |
162.14 132.75 |
16.83 11.67 |
67.12 81.67 |
0.00 | 246.09 | |
21 | No Name #1493 |
Calc. Raw |
168.55 138.00 |
35.08 24.33 |
40.82 49.67 |
0.00 | 244.45 | |
22 | No Name #35317 |
Calc. Raw |
145.95 119.50 |
26.92 18.67 |
68.77 83.67 |
0.00 | 241.64 | |
22 | No Name #5570 |
Calc. Raw |
160.61 131.50 |
20.17 13.99 |
60.55 73.67 |
0.00 | 241.33 | |
23 | No Name #10680 |
Calc. Raw |
146.56 120.00 |
20.66 14.33 |
72.60 88.33 |
0.00 | 239.82 | |
24 | No Name #25991 |
Calc. Raw |
150.84 123.50 |
26.44 18.34 |
59.45 72.33 |
0.00 | 236.73 | |
25 | No Name #28057 |
Calc. Raw |
138.02 113.00 |
36.53 25.34 |
55.07 67.00 |
0.00 | 229.62 | |
25 | No Name #232 |
Calc. Raw |
144.73 118.50 |
33.16 23.00 |
50.96 62.00 |
0.00 | 228.85 | |
25 | No Name #34897 |
Calc. Raw |
160.31 131.25 |
22.12 15.34 |
46.30 56.33 |
0.00 | 228.73 | |
25 | No Name #34295 |
Calc. Raw |
144.73 118.50 |
28.84 20.00 |
55.07 67.00 |
0.00 | 228.64 | |
26 | No Name #18527 |
Calc. Raw |
150.23 123.00 |
23.08 16.01 |
55.07 67.00 |
0.00 | 228.38 | |
27 | No Name #16142 |
Calc. Raw |
139.85 114.50 |
30.28 21.00 |
56.16 68.33 |
0.00 | 226.29 | |
27 | No Name #25551 |
Calc. Raw |
145.04 118.75 |
28.34 19.66 |
52.87 64.33 |
0.00 | 226.25 | |
28 | No Name #1715 |
Calc. Raw |
151.15 123.75 |
12.96 8.99 |
60.55 73.67 |
0.00 | 224.66 | |
28 | No Name #28004 |
Calc. Raw |
146.56 120.00 |
35.57 24.67 |
51.78 63.00 |
10.00 | 223.91 | |
28 | No Name #35848 |
Calc. Raw |
146.87 120.25 |
28.34 19.66 |
48.49 59.00 |
0.00 | 223.70 | |
29 | No Name #34083 |
Calc. Raw |
137.40 112.50 |
25.00 17.34 |
59.73 72.67 |
0.00 | 222.13 | |
30 | No Name #36629 |
Calc. Raw |
142.29 116.50 |
13.45 9.33 |
63.84 77.67 |
0.00 | 219.58 | |
31 | No Name #11901 |
Calc. Raw |
132.52 108.50 |
25.48 17.67 |
60.55 73.67 |
0.00 | 218.55 | |
32 | No Name #26110 |
Calc. Raw |
154.20 126.25 |
13.45 9.33 |
49.58 60.33 |
0.00 | 217.23 | |
33 | No Name #28695 |
Calc. Raw |
139.24 114.00 |
20.67 14.34 |
53.97 65.67 |
0.00 | 213.88 | |
34 | No Name #32252 |
Calc. Raw |
136.18 111.50 |
20.67 14.34 |
57.26 69.67 |
5.00 | 209.11 | |
35 | No Name #28837 |
Calc. Raw |
145.65 119.25 |
19.71 13.67 |
43.29 52.67 |
3.00 | 205.65 | |
36 | No Name #13570 |
Calc. Raw |
128.85 105.50 |
9.60 6.66 |
59.45 72.33 |
0.00 | 197.90 | |
37 | No Name #36640 |
Calc. Raw |
116.95 95.75 |
25.95 18.00 |
53.97 65.67 |
0.00 | 196.87 | |
38 | No Name #36902 |
Calc. Raw |
129.47 106.00 |
21.63 15.00 |
43.29 52.67 |
0.00 | 194.39 | |
38 | No Name #3193 |
Calc. Raw |
135.57 111.00 |
17.78 12.33 |
40.82 49.67 |
0.00 | 194.17 | |
38 | No Name #35737 |
Calc. Raw |
116.34 95.25 |
20.18 14.00 |
57.26 69.67 |
0.00 | 193.78 | |
39 | No Name #25718 |
Calc. Raw |
122.44 100.25 |
12.98 9.00 |
57.26 69.67 |
0.00 | 192.68 | |
40 | No Name #3606 |
Calc. Raw |
131.30 107.50 |
19.22 13.33 |
38.63 47.00 |
0.00 | 189.15 | |
41 | No Name #34546 |
Calc. Raw |
112.37 92.00 |
18.25 12.66 |
57.26 69.67 |
0.00 | 187.88 | |
41 | No Name #2437 |
Calc. Raw |
118.47 97.00 |
14.89 10.33 |
53.97 65.67 |
0.00 | 187.33 | |
42 | No Name #35658 |
Calc. Raw |
129.16 105.75 |
16.83 11.67 |
40.54 49.33 |
0.00 | 186.53 | |
43 | No Name #497 |
Calc. Raw |
120.61 98.75 |
15.38 10.67 |
45.20 55.00 |
0.00 | 181.19 | |
44 | No Name #2464 |
Calc. Raw |
104.43 85.50 |
16.83 11.67 |
57.26 69.67 |
0.00 | 178.52 | |
45 | No Name #35883 |
Calc. Raw |
97.10 79.50 |
24.51 17.00 |
55.07 67.00 |
0.00 | 176.68 | |
46 | No Name #33010 |
Calc. Raw |
115.11 94.25 |
15.35 10.65 |
41.92 51.00 |
3.00 | 169.38 | |
47 | No Name #11548 |
Calc. Raw |
98.02 80.25 |
16.34 11.33 |
52.87 64.33 |
0.00 | 167.23 | |
47 | No Name #177 |
Calc. Raw |
125.80 103.00 |
15.86 11.00 |
24.93 30.33 |
0.00 | 166.59 | |
48 | No Name #820 |
Calc. Raw |
110.23 90.25 |
12.01 8.33 |
32.88 40.00 |
1.00 | 154.12 | |
49 | No Name #33846 |
Calc. Raw |
91.91 75.25 |
9.11 6.32 |
49.58 60.33 |
0.00 | 150.60 | |
50 | No Name #33747 |
Calc. Raw |
101.07 82.75 |
9.60 6.66 |
35.89 43.67 |
0.00 | 146.56 | |
No Name #36827 |
Calc. Raw |
0.00 0.00 |
0.00 0.00 |
0.00 0.00 |
0.00 | 0.00 |