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 I | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #33665 |
Calc. Raw |
183.97 132.00 |
42.21 30.67 |
100.00 141.25 |
0.00 | 326.18 | |
2 | No Name #36233 |
Calc. Raw |
182.58 131.00 |
40.37 29.33 |
96.99 137.00 |
0.00 | 319.94 | |
3 | No Name #16925 |
Calc. Raw |
173.52 124.50 |
33.48 24.33 |
99.47 140.50 |
0.00 | 306.47 | |
4 | No Name #31535 |
Calc. Raw |
174.22 125.00 |
44.04 32.00 |
76.64 108.25 |
0.00 | 294.90 | |
5 | No Name #22423 |
Calc. Raw |
174.22 125.00 |
43.57 31.66 |
72.57 102.50 |
0.00 | 290.36 | |
6 | No Name #15064 |
Calc. Raw |
167.94 120.50 |
40.39 29.35 |
80.00 113.00 |
0.00 | 288.33 | |
7 | No Name #34601 |
Calc. Raw |
190.24 136.50 |
37.61 27.33 |
57.70 81.50 |
1.00 | 284.55 | |
8 | No Name #34325 |
Calc. Raw |
154.01 110.50 |
35.34 25.68 |
82.12 116.00 |
0.00 | 271.47 | |
8 | No Name #34123 |
Calc. Raw |
175.61 126.00 |
37.16 27.00 |
58.23 82.25 |
0.00 | 271.00 | |
9 | No Name #33866 |
Calc. Raw |
162.37 116.50 |
38.08 27.67 |
69.38 98.00 |
0.00 | 269.83 | |
10 | No Name #34320 |
Calc. Raw |
165.85 119.00 |
30.28 22.00 |
67.43 95.25 |
0.00 | 263.56 | |
10 | No Name #4636 |
Calc. Raw |
162.37 116.50 |
44.49 32.33 |
56.11 79.25 |
0.00 | 262.97 | |
11 | No Name #33744 |
Calc. Raw |
173.52 124.50 |
37.16 27.00 |
51.68 73.00 |
0.00 | 262.36 | |
12 | No Name #31032 |
Calc. Raw |
158.19 113.50 |
30.75 22.34 |
69.20 97.75 |
0.00 | 258.14 | |
12 | No Name #1009 |
Calc. Raw |
200.00 143.50 |
39.46 28.67 |
18.23 25.75 |
0.00 | 257.69 | |
13 | No Name #45 |
Calc. Raw |
176.31 126.50 |
43.57 31.66 |
35.93 50.75 |
0.00 | 255.81 | |
14 | No Name #31733 |
Calc. Raw |
139.37 100.00 |
27.51 19.99 |
94.34 133.25 |
10.00 | 251.22 | |
14 | No Name #36998 |
Calc. Raw |
159.58 114.50 |
29.37 21.34 |
62.12 87.75 |
0.00 | 251.07 | |
14 | No Name #33278 |
Calc. Raw |
158.89 114.00 |
24.30 17.66 |
77.52 109.50 |
10.00 | 250.71 | |
15 | No Name #36839 |
Calc. Raw |
159.58 114.50 |
35.78 26.00 |
52.57 74.25 |
0.00 | 247.93 | |
15 | No Name #14205 |
Calc. Raw |
140.77 101.00 |
34.86 25.33 |
72.04 101.75 |
0.00 | 247.67 | |
16 | No Name #37159 |
Calc. Raw |
186.06 133.50 |
38.99 28.33 |
16.64 23.50 |
0.00 | 241.69 | |
16 | No Name #33807 |
Calc. Raw |
164.46 118.00 |
41.74 30.33 |
34.87 49.25 |
0.00 | 241.07 | |
17 | No Name #26604 |
Calc. Raw |
174.22 125.00 |
50.00 36.33 |
11.50 16.25 |
0.00 | 235.72 | |
18 | No Name #28204 |
Calc. Raw |
158.19 113.50 |
38.54 28.00 |
35.93 50.75 |
0.00 | 232.66 | |
19 | No Name #2345 |
Calc. Raw |
154.01 110.50 |
37.61 27.33 |
37.17 52.50 |
0.00 | 228.79 | |
19 | No Name #5574 |
Calc. Raw |
158.89 114.00 |
41.27 29.99 |
27.79 39.25 |
0.00 | 227.95 | |
20 | No Name #12534 |
Calc. Raw |
168.64 121.00 |
30.73 22.33 |
26.02 36.75 |
0.00 | 225.39 | |
21 | No Name #36439 |
Calc. Raw |
164.46 118.00 |
37.16 27.00 |
22.48 31.75 |
0.00 | 224.10 | |
21 | No Name #15731 |
Calc. Raw |
172.13 123.50 |
33.03 24.00 |
18.41 26.00 |
0.00 | 223.57 | |
21 | No Name #11416 |
Calc. Raw |
158.19 113.50 |
39.91 29.00 |
25.31 35.75 |
0.00 | 223.41 | |
22 | No Name #3193 |
Calc. Raw |
160.28 115.00 |
43.12 31.33 |
17.17 24.25 |
0.00 | 220.57 | |
23 | No Name #12646 |
Calc. Raw |
140.77 101.00 |
36.24 26.33 |
39.12 55.25 |
1.00 | 215.13 | |
23 | No Name #37160 |
Calc. Raw |
135.19 97.00 |
37.61 27.33 |
41.77 59.00 |
0.00 | 214.57 | |
24 | No Name #8061 |
Calc. Raw |
165.16 118.50 |
38.99 28.33 |
7.61 10.75 |
0.00 | 211.76 | |
25 | No Name #15746 |
Calc. Raw |
126.13 90.50 |
32.11 23.33 |
49.38 69.75 |
0.00 | 207.62 | |
25 | No Name #37028 |
Calc. Raw |
139.37 100.00 |
33.03 24.00 |
35.04 49.50 |
0.00 | 207.44 | |
25 | No Name #28679 |
Calc. Raw |
141.46 101.50 |
41.29 30.00 |
24.25 34.25 |
0.00 | 207.00 | |
26 | No Name #14186 |
Calc. Raw |
150.52 108.00 |
33.03 24.00 |
19.65 27.75 |
0.00 | 203.20 | |
27 | No Name #36445 |
Calc. Raw |
118.47 85.00 |
30.29 22.01 |
53.10 75.00 |
0.00 | 201.86 | |
27 | No Name #4984 |
Calc. Raw |
158.19 113.50 |
24.32 17.67 |
18.94 26.75 |
0.00 | 201.45 | |
28 | No Name #35162 |
Calc. Raw |
134.49 96.50 |
33.48 24.33 |
24.07 34.00 |
0.00 | 192.04 | |
29 | No Name #3390 |
Calc. Raw |
133.10 95.50 |
23.85 17.33 |
28.67 40.50 |
0.00 | 185.62 | |
29 | No Name #32181 |
Calc. Raw |
124.74 89.50 |
25.70 18.67 |
34.69 49.00 |
0.00 | 185.13 | |
30 | No Name #33846 |
Calc. Raw |
107.32 77.00 |
21.57 15.67 |
44.78 63.25 |
0.00 | 173.67 | |
31 | No Name #36534 |
Calc. Raw |
129.62 93.00 |
24.32 17.67 |
14.87 21.00 |
0.00 | 168.81 | |
32 | No Name #30823 |
Calc. Raw |
109.41 78.50 |
32.11 23.33 |
23.01 32.50 |
0.00 | 164.53 |