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 Ancient Egypt Division I | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #12320 |
Calc. Raw |
197.97 146.63 |
33.48 26.34 |
92.96 105.67 |
0.00 | 324.41 | |
2 | No Name #15677 |
Calc. Raw |
180.76 133.88 |
34.32 27.00 |
100.00 113.67 |
0.00 | 315.08 | |
3 | No Name #28156 |
Calc. Raw |
185.84 137.64 |
50.00 39.34 |
76.54 87.00 |
0.00 | 312.38 | |
4 | No Name #33665 |
Calc. Raw |
190.05 140.76 |
50.00 39.34 |
63.63 72.33 |
0.00 | 303.68 | |
5 | No Name #30963 |
Calc. Raw |
194.44 144.01 |
28.81 22.67 |
78.89 89.67 |
0.00 | 302.14 | |
6 | No Name #31960 |
Calc. Raw |
200.00 148.13 |
41.93 32.99 |
57.77 65.67 |
0.00 | 299.70 | |
7 | No Name #9971 |
Calc. Raw |
183.97 136.26 |
39.40 31.00 |
69.50 79.00 |
0.00 | 292.87 | |
8 | No Name #4850 |
Calc. Raw |
175.20 129.76 |
32.61 25.66 |
82.41 93.67 |
0.00 | 290.22 | |
8 | No Name #12282 |
Calc. Raw |
187.35 138.76 |
28.39 22.34 |
78.89 89.67 |
5.00 | 289.63 | |
9 | No Name #28344 |
Calc. Raw |
190.39 141.01 |
32.19 25.33 |
64.81 73.67 |
0.00 | 287.39 | |
10 | No Name #11416 |
Calc. Raw |
190.89 141.38 |
30.08 23.67 |
64.81 73.67 |
0.00 | 285.78 | |
11 | No Name #11374 |
Calc. Raw |
173.50 128.50 |
26.70 21.01 |
83.58 95.00 |
0.00 | 283.78 | |
12 | No Name #2746 |
Calc. Raw |
174.68 129.38 |
28.37 22.32 |
77.71 88.33 |
0.00 | 280.76 | |
13 | No Name #28440 |
Calc. Raw |
192.74 142.75 |
25.42 20.00 |
85.92 97.67 |
25.00 | 279.08 | |
14 | No Name #9883 |
Calc. Raw |
184.97 137.00 |
24.14 18.99 |
68.33 77.67 |
0.00 | 277.44 | |
14 | No Name #30361 |
Calc. Raw |
171.47 127.00 |
28.80 22.66 |
76.54 87.00 |
0.00 | 276.81 | |
15 | No Name #4650 |
Calc. Raw |
180.42 133.63 |
24.58 19.34 |
68.33 77.67 |
0.00 | 273.33 | |
16 | No Name #28372 |
Calc. Raw |
172.82 128.00 |
30.07 23.66 |
67.15 76.33 |
0.00 | 270.04 | |
16 | No Name #28581 |
Calc. Raw |
167.76 124.25 |
31.35 24.67 |
70.67 80.33 |
0.00 | 269.78 | |
17 | No Name #31733 |
Calc. Raw |
192.06 142.25 |
33.05 26.00 |
48.39 55.00 |
5.00 | 268.50 | |
18 | No Name #15128 |
Calc. Raw |
165.57 122.63 |
28.81 22.67 |
67.15 76.33 |
0.00 | 261.53 | |
19 | No Name #1748 |
Calc. Raw |
165.57 122.63 |
26.69 21.00 |
63.63 72.33 |
0.00 | 255.89 | |
19 | No Name #5126 |
Calc. Raw |
170.30 126.13 |
23.73 18.67 |
65.98 75.00 |
5.00 | 255.01 | |
20 | No Name #30405 |
Calc. Raw |
162.36 120.25 |
28.81 22.67 |
61.29 69.67 |
0.00 | 252.46 | |
21 | No Name #12534 |
Calc. Raw |
178.07 131.89 |
20.32 15.99 |
56.59 64.33 |
5.00 | 249.98 | |
21 | No Name #34320 |
Calc. Raw |
165.91 122.88 |
20.34 16.00 |
68.33 77.67 |
5.00 | 249.58 | |
21 | No Name #3390 |
Calc. Raw |
166.08 123.01 |
26.27 20.67 |
57.77 65.67 |
1.00 | 249.12 | |
22 | No Name #15322 |
Calc. Raw |
172.50 127.76 |
19.48 15.33 |
61.29 69.67 |
5.00 | 248.27 | |
23 | No Name #10001 |
Calc. Raw |
159.67 118.26 |
13.99 11.01 |
69.50 79.00 |
0.00 | 243.16 | |
24 | No Name #20797 |
Calc. Raw |
147.17 109.00 |
25.41 19.99 |
64.81 73.67 |
0.00 | 237.39 | |
25 | No Name #1545 |
Calc. Raw |
153.59 113.76 |
17.36 13.66 |
63.63 72.33 |
0.00 | 234.58 | |
25 | No Name #2342 |
Calc. Raw |
158.33 117.27 |
21.17 16.66 |
54.25 61.67 |
0.00 | 233.75 | |
26 | No Name #6067 |
Calc. Raw |
146.84 108.76 |
22.46 17.67 |
62.46 71.00 |
0.00 | 231.76 | |
27 | No Name #17516 |
Calc. Raw |
145.66 107.88 |
27.11 21.33 |
57.77 65.67 |
0.00 | 230.54 | |
28 | No Name #35008 |
Calc. Raw |
162.69 120.50 |
9.30 7.32 |
62.46 71.00 |
5.00 | 229.45 | |
29 | No Name #33087 |
Calc. Raw |
133.67 99.00 |
23.72 18.66 |
74.19 84.33 |
5.00 | 226.58 | |
30 | No Name #34980 |
Calc. Raw |
143.12 106.00 |
24.16 19.01 |
54.25 61.67 |
0.00 | 221.53 | |
31 | No Name #34897 |
Calc. Raw |
145.49 107.76 |
11.87 9.34 |
64.81 73.67 |
5.00 | 217.17 | |
32 | No Name #232 |
Calc. Raw |
146.33 108.38 |
20.77 16.34 |
65.98 75.00 |
20.00 | 213.08 | |
33 | No Name #532 |
Calc. Raw |
158.32 117.26 |
34.75 27.34 |
55.42 63.00 |
40.00 | 208.49 | |
34 | No Name #26714 |
Calc. Raw |
140.93 104.38 |
13.98 11.00 |
76.54 87.00 |
25.00 | 206.45 | |
35 | No Name #11117 |
Calc. Raw |
135.87 100.63 |
13.13 10.33 |
61.29 69.67 |
5.00 | 205.29 | |
36 | No Name #9358 |
Calc. Raw |
128.44 95.13 |
12.28 9.66 |
68.33 77.67 |
5.00 | 204.05 | |
36 | No Name #34302 |
Calc. Raw |
132.32 98.00 |
32.61 25.66 |
63.63 72.33 |
25.00 | 203.56 | |
37 | No Name #31535 |
Calc. Raw |
150.54 111.50 |
9.74 7.66 |
50.73 57.67 |
30.00 | 181.01 | |
37 | No Name #35337 |
Calc. Raw |
101.60 75.25 |
12.29 9.67 |
66.86 76.00 |
0.00 | 180.75 |