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 2 DinoStories Division II | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #34754 |
Calc. Raw |
200.00 174.50 |
43.76 32.67 |
52.90 54.75 |
0.00 | 296.66 | |
2 | No Name #30949 |
Calc. Raw |
189.11 165.00 |
38.84 29.00 |
50.97 52.75 |
0.00 | 278.92 | |
3 | No Name #35548 |
Calc. Raw |
142.69 124.50 |
26.35 19.67 |
100.00 103.50 |
0.00 | 269.04 | |
4 | No Name #36480 |
Calc. Raw |
193.12 168.50 |
50.00 37.33 |
22.71 23.50 |
0.00 | 265.83 | |
4 | No Name #2344 |
Calc. Raw |
175.36 153.00 |
39.28 29.33 |
50.97 52.75 |
0.00 | 265.61 | |
5 | No Name #31230 |
Calc. Raw |
173.07 151.00 |
33.49 25.00 |
51.93 53.75 |
0.00 | 258.49 | |
6 | No Name #322 |
Calc. Raw |
165.62 144.50 |
38.84 29.00 |
50.00 51.75 |
0.00 | 254.46 | |
7 | No Name #2477 |
Calc. Raw |
178.80 156.00 |
41.96 31.33 |
21.74 22.50 |
1.00 | 241.50 | |
7 | No Name #37853 |
Calc. Raw |
133.52 116.50 |
36.62 27.34 |
70.53 73.00 |
0.00 | 240.67 | |
8 | No Name #30595 |
Calc. Raw |
147.85 129.00 |
36.16 27.00 |
52.17 54.00 |
0.00 | 236.18 | |
9 | No Name #14989 |
Calc. Raw |
146.70 128.00 |
28.57 21.33 |
55.56 57.50 |
0.00 | 230.83 | |
9 | No Name #33344 |
Calc. Raw |
132.95 116.00 |
26.79 20.00 |
70.77 73.25 |
0.00 | 230.51 | |
10 | No Name #14032 |
Calc. Raw |
154.73 135.00 |
24.11 18.00 |
50.72 52.50 |
0.00 | 229.56 | |
11 | No Name #13372 |
Calc. Raw |
139.26 121.50 |
34.82 26.00 |
51.93 53.75 |
0.00 | 226.01 | |
12 | No Name #26110 |
Calc. Raw |
129.51 113.00 |
33.04 24.67 |
62.32 64.50 |
0.00 | 224.87 | |
13 | No Name #35750 |
Calc. Raw |
127.22 111.00 |
26.79 20.00 |
69.57 72.00 |
0.00 | 223.58 | |
14 | No Name #36120 |
Calc. Raw |
143.84 125.50 |
29.02 21.67 |
48.31 50.00 |
0.00 | 221.17 | |
15 | No Name #1009 |
Calc. Raw |
137.54 120.00 |
30.36 22.67 |
51.93 53.75 |
0.00 | 219.83 | |
16 | No Name #29596 |
Calc. Raw |
123.78 108.00 |
41.52 31.00 |
50.48 52.25 |
0.00 | 215.78 | |
17 | No Name #28072 |
Calc. Raw |
147.85 129.00 |
24.11 18.00 |
41.55 43.00 |
0.00 | 213.51 | |
18 | No Name #32284 |
Calc. Raw |
154.15 134.50 |
35.27 26.33 |
21.74 22.50 |
0.00 | 211.16 | |
19 | No Name #5482 |
Calc. Raw |
110.60 96.50 |
25.01 18.67 |
64.73 67.00 |
0.00 | 200.34 | |
20 | No Name #11905 |
Calc. Raw |
120.34 105.00 |
23.67 17.67 |
51.45 53.25 |
0.00 | 195.46 | |
20 | No Name #6538 |
Calc. Raw |
146.13 127.50 |
29.02 21.67 |
20.29 21.00 |
0.00 | 195.44 | |
21 | No Name #28212 |
Calc. Raw |
132.95 116.00 |
34.38 25.67 |
25.36 26.25 |
0.00 | 192.69 | |
21 | No Name #28547 |
Calc. Raw |
139.26 121.50 |
30.81 23.00 |
22.46 23.25 |
0.00 | 192.53 | |
22 | No Name #10414 |
Calc. Raw |
142.69 124.50 |
23.67 17.67 |
22.95 23.75 |
0.00 | 189.31 | |
23 | No Name #7069 |
Calc. Raw |
114.61 100.00 |
23.67 17.67 |
49.52 51.25 |
0.00 | 187.80 | |
24 | No Name #34601 |
Calc. Raw |
148.42 129.50 |
20.09 15.00 |
17.39 18.00 |
0.00 | 185.90 | |
24 | No Name #4391 |
Calc. Raw |
134.67 117.50 |
29.47 22.00 |
21.74 22.50 |
0.00 | 185.88 | |
24 | No Name #33956 |
Calc. Raw |
140.40 122.50 |
26.79 20.00 |
18.12 18.75 |
0.00 | 185.31 | |
25 | No Name #10680 |
Calc. Raw |
151.86 132.50 |
32.59 24.33 |
0.00 0.00 |
0.00 | 184.45 | |
26 | No Name #21303 |
Calc. Raw |
134.10 117.00 |
29.02 21.67 |
19.32 20.00 |
0.00 | 182.44 | |
26 | No Name #28057 |
Calc. Raw |
130.66 114.00 |
31.25 23.33 |
19.57 20.25 |
0.00 | 181.48 | |
27 | No Name #33010 |
Calc. Raw |
108.31 94.50 |
19.19 14.33 |
53.14 55.00 |
0.00 | 180.64 | |
27 | No Name #10102 |
Calc. Raw |
126.65 110.50 |
31.70 23.67 |
21.74 22.50 |
0.00 | 180.09 | |
28 | No Name #33099 |
Calc. Raw |
135.24 118.00 |
25.45 19.00 |
17.39 18.00 |
0.00 | 178.08 | |
28 | No Name #15417 |
Calc. Raw |
134.67 117.50 |
24.11 18.00 |
19.08 19.75 |
0.00 | 177.86 | |
28 | No Name #35380 |
Calc. Raw |
132.38 115.50 |
28.57 21.33 |
16.18 16.75 |
0.00 | 177.13 | |
29 | No Name #17182 |
Calc. Raw |
142.12 124.00 |
19.19 14.33 |
15.46 16.00 |
0.00 | 176.77 | |
30 | No Name #32462 |
Calc. Raw |
144.99 126.50 |
29.02 21.67 |
1.69 1.75 |
0.00 | 175.70 | |
31 | No Name #11901 |
Calc. Raw |
128.37 112.00 |
25.45 19.00 |
20.05 20.75 |
0.00 | 173.87 | |
32 | No Name #36216 |
Calc. Raw |
123.78 108.00 |
24.11 18.00 |
21.98 22.75 |
0.00 | 169.87 | |
33 | No Name #15407 |
Calc. Raw |
104.30 91.00 |
9.82 7.33 |
51.69 53.50 |
0.00 | 165.81 | |
34 | No Name #16142 |
Calc. Raw |
123.78 108.00 |
20.09 15.00 |
20.53 21.25 |
0.00 | 164.40 | |
35 | No Name #36980 |
Calc. Raw |
108.31 94.50 |
25.01 18.67 |
20.77 21.50 |
0.00 | 154.09 | |
36 | No Name #3422 |
Calc. Raw |
71.63 62.50 |
20.53 15.33 |
60.87 63.00 |
0.00 | 153.03 | |
36 | No Name #27133 |
Calc. Raw |
113.47 99.00 |
21.87 16.33 |
16.91 17.50 |
0.00 | 152.25 | |
37 | No Name #33292 |
Calc. Raw |
121.49 106.00 |
22.77 17.00 |
7.49 7.75 |
0.00 | 151.75 | |
38 | No Name #36225 |
Calc. Raw |
103.15 90.00 |
24.55 18.33 |
22.46 23.25 |
0.00 | 150.16 | |
39 | No Name #37848 |
Calc. Raw |
73.93 64.50 |
23.21 17.33 |
50.24 52.00 |
0.00 | 147.38 | |
40 | No Name #37369 |
Calc. Raw |
104.30 91.00 |
18.31 13.67 |
21.26 22.00 |
0.00 | 143.87 | |
41 | No Name #36148 |
Calc. Raw |
97.42 85.00 |
28.57 21.33 |
21.50 22.25 |
10.00 | 137.49 | |
42 | No Name #36629 |
Calc. Raw |
68.19 59.50 |
14.29 10.67 |
51.45 53.25 |
0.00 | 133.93 | |
43 | No Name #34298 |
Calc. Raw |
92.26 80.50 |
19.64 14.66 |
19.81 20.50 |
0.00 | 131.71 | |
44 | No Name #19877 |
Calc. Raw |
93.98 82.00 |
15.18 11.33 |
16.91 17.50 |
0.00 | 126.07 | |
45 | No Name #36617 |
Calc. Raw |
79.66 69.50 |
15.63 11.67 |
17.87 18.50 |
0.00 | 113.16 | |
46 | No Name #1722 |
Calc. Raw |
68.77 60.00 |
22.33 16.67 |
21.50 22.25 |
2.00 | 110.60 | |
47 | No Name #18919 |
Calc. Raw |
73.35 64.00 |
16.51 12.33 |
22.46 23.25 |
5.00 | 107.32 |