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 The Large And Small Of It Division II | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #28547 |
Calc. Raw |
183.85 148.00 |
41.40 36.99 |
100.00 107.33 |
0.00 | 325.25 | |
1 | No Name #322 |
Calc. Raw |
200.00 161.00 |
50.00 44.67 |
74.84 80.33 |
0.00 | 324.84 | |
2 | No Name #9745 |
Calc. Raw |
186.96 150.50 |
44.03 39.34 |
87.58 94.00 |
0.00 | 318.57 | |
3 | No Name #32490 |
Calc. Raw |
195.03 157.00 |
45.89 41.00 |
75.16 80.67 |
0.00 | 316.08 | |
4 | No Name #18227 |
Calc. Raw |
181.99 146.50 |
39.56 35.34 |
86.65 93.00 |
0.00 | 308.20 | |
5 | No Name #36480 |
Calc. Raw |
179.50 144.50 |
38.43 34.33 |
84.48 90.67 |
0.00 | 302.41 | |
6 | No Name #22311 |
Calc. Raw |
154.04 124.00 |
41.03 36.66 |
100.00 107.33 |
0.00 | 295.07 | |
6 | No Name #6538 |
Calc. Raw |
188.82 152.00 |
41.78 37.33 |
63.66 68.33 |
0.00 | 294.26 | |
7 | No Name #33591 |
Calc. Raw |
162.11 130.50 |
35.82 32.00 |
91.31 98.00 |
0.00 | 289.24 | |
8 | No Name #32663 |
Calc. Raw |
183.85 148.00 |
30.97 27.67 |
69.88 75.00 |
0.00 | 284.70 | |
9 | No Name #1386 |
Calc. Raw |
175.16 141.00 |
39.56 35.34 |
63.66 68.33 |
0.00 | 278.38 | |
10 | No Name #32289 |
Calc. Raw |
175.16 141.00 |
32.09 28.67 |
67.39 72.33 |
0.00 | 274.64 | |
11 | No Name #12320 |
Calc. Raw |
148.45 119.50 |
31.34 28.00 |
92.86 99.67 |
0.00 | 272.65 | |
12 | No Name #31230 |
Calc. Raw |
156.52 126.00 |
38.06 34.00 |
75.47 81.00 |
0.00 | 270.05 | |
13 | No Name #28348 |
Calc. Raw |
152.17 122.50 |
26.85 23.99 |
87.27 93.67 |
0.00 | 266.29 | |
13 | No Name #17625 |
Calc. Raw |
165.84 133.50 |
36.56 32.66 |
63.66 68.33 |
0.00 | 266.06 | |
13 | No Name #34175 |
Calc. Raw |
147.20 118.50 |
34.32 30.66 |
84.48 90.67 |
0.00 | 266.00 | |
14 | No Name #17182 |
Calc. Raw |
150.31 121.00 |
28.35 25.33 |
76.09 81.67 |
0.00 | 254.75 | |
14 | No Name #31374 |
Calc. Raw |
163.35 131.50 |
29.85 26.67 |
61.49 66.00 |
0.00 | 254.69 | |
14 | No Name #35493 |
Calc. Raw |
152.80 123.00 |
31.34 28.00 |
70.50 75.67 |
0.00 | 254.64 | |
15 | No Name #37161 |
Calc. Raw |
154.66 124.50 |
29.10 26.00 |
68.32 73.33 |
0.00 | 252.08 | |
15 | No Name #33946 |
Calc. Raw |
167.70 135.00 |
33.21 29.67 |
50.62 54.33 |
0.00 | 251.53 | |
15 | No Name #1715 |
Calc. Raw |
132.30 106.50 |
29.47 26.33 |
89.75 96.33 |
0.00 | 251.52 | |
16 | No Name #33790 |
Calc. Raw |
154.04 124.00 |
30.22 27.00 |
66.78 71.67 |
0.00 | 251.04 | |
17 | No Name #32323 |
Calc. Raw |
135.40 109.00 |
33.21 29.67 |
80.43 86.33 |
0.00 | 249.04 | |
18 | No Name #2271 |
Calc. Raw |
129.19 104.00 |
32.46 29.00 |
77.96 83.67 |
0.00 | 239.61 | |
19 | No Name #34281 |
Calc. Raw |
144.10 116.00 |
34.70 31.00 |
59.00 63.33 |
0.00 | 237.80 | |
19 | No Name #2464 |
Calc. Raw |
139.75 112.50 |
26.11 23.33 |
71.43 76.67 |
0.00 | 237.29 | |
19 | No Name #5816 |
Calc. Raw |
147.83 119.00 |
33.58 30.00 |
55.59 59.67 |
0.00 | 237.00 | |
20 | No Name #11901 |
Calc. Raw |
127.33 102.50 |
33.20 29.66 |
65.84 70.67 |
0.00 | 226.37 | |
20 | No Name #16375 |
Calc. Raw |
127.95 103.00 |
30.60 27.34 |
67.71 72.67 |
0.00 | 226.26 | |
21 | No Name #37039 |
Calc. Raw |
137.27 110.50 |
25.76 23.01 |
54.35 58.33 |
0.00 | 217.38 | |
21 | No Name #31161 |
Calc. Raw |
113.66 91.50 |
26.86 24.00 |
76.40 82.00 |
0.00 | 216.92 | |
22 | No Name #28378 |
Calc. Raw |
135.40 109.00 |
26.49 23.67 |
54.35 58.33 |
0.00 | 216.24 | |
23 | No Name #35548 |
Calc. Raw |
124.22 100.00 |
25.37 22.67 |
57.46 61.67 |
0.00 | 207.05 | |
24 | No Name #29564 |
Calc. Raw |
127.33 102.50 |
24.99 22.33 |
50.62 54.33 |
0.00 | 202.94 | |
24 | No Name #31164 |
Calc. Raw |
120.50 97.00 |
25.36 22.66 |
56.53 60.67 |
0.00 | 202.39 | |
25 | No Name #15824 |
Calc. Raw |
122.36 98.50 |
22.39 20.00 |
57.77 62.00 |
1.00 | 201.52 | |
25 | No Name #16372 |
Calc. Raw |
118.01 95.00 |
27.61 24.67 |
55.59 59.67 |
0.00 | 201.21 | |
26 | No Name #1722 |
Calc. Raw |
122.36 98.50 |
23.88 21.33 |
53.73 57.67 |
0.00 | 199.97 | |
27 | No Name #36211 |
Calc. Raw |
115.53 93.00 |
30.59 27.33 |
51.87 55.67 |
0.00 | 197.99 | |
28 | No Name #1140 |
Calc. Raw |
93.17 75.00 |
20.52 18.33 |
80.75 86.67 |
0.00 | 194.44 | |
28 | No Name #8704 |
Calc. Raw |
104.97 84.50 |
22.76 20.33 |
66.46 71.33 |
0.00 | 194.19 | |
29 | No Name #36496 |
Calc. Raw |
107.45 86.50 |
28.73 25.67 |
48.76 52.33 |
0.00 | 184.94 | |
30 | No Name #32252 |
Calc. Raw |
86.96 70.00 |
30.97 27.67 |
67.08 72.00 |
2.00 | 183.01 | |
31 | No Name #20480 |
Calc. Raw |
80.75 65.00 |
23.51 21.00 |
56.53 60.67 |
0.00 | 160.79 | |
32 | No Name #35698 |
Calc. Raw |
77.02 62.00 |
20.52 18.33 |
56.21 60.33 |
0.00 | 153.75 | |
33 | No Name #34082 |
Calc. Raw |
90.68 73.00 |
21.27 19.00 |
55.90 60.00 |
20.00 | 147.85 | |
34 | No Name #33846 |
Calc. Raw |
95.65 77.00 |
17.54 15.67 |
31.37 33.67 |
0.00 | 144.56 | |
35 | No Name #2437 |
Calc. Raw |
44.72 36.00 |
16.79 15.00 |
50.62 54.33 |
0.00 | 112.13 |