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 II | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #29584 |
Calc. Raw |
200.00 136.75 |
50.00 32.67 |
82.74 102.33 |
0.00 | 332.74 | |
2 | No Name #16756 |
Calc. Raw |
190.86 130.50 |
29.08 19.00 |
95.68 118.33 |
0.00 | 315.62 | |
3 | No Name #31225 |
Calc. Raw |
182.82 125.00 |
46.43 30.34 |
80.59 99.67 |
0.00 | 309.84 | |
3 | No Name #18918 |
Calc. Raw |
193.05 132.00 |
34.70 22.67 |
81.13 100.33 |
0.00 | 308.88 | |
4 | No Name #32785 |
Calc. Raw |
178.43 122.00 |
43.36 28.33 |
81.67 101.00 |
0.00 | 303.46 | |
4 | No Name #27729 |
Calc. Raw |
192.69 131.75 |
29.08 19.00 |
81.67 101.00 |
0.00 | 303.44 | |
5 | No Name #24701 |
Calc. Raw |
180.26 123.25 |
16.33 10.67 |
100.00 123.67 |
0.00 | 296.59 | |
6 | No Name #25964 |
Calc. Raw |
178.43 122.00 |
36.73 24.00 |
79.51 98.33 |
0.00 | 294.67 | |
6 | No Name #15677 |
Calc. Raw |
198.17 135.50 |
33.16 21.67 |
62.80 77.67 |
0.00 | 294.13 | |
7 | No Name #10378 |
Calc. Raw |
172.58 118.00 |
46.43 30.34 |
68.73 85.00 |
0.00 | 287.74 | |
8 | No Name #28057 |
Calc. Raw |
179.89 123.00 |
34.18 22.33 |
70.89 87.67 |
0.00 | 284.96 | |
8 | No Name #35890 |
Calc. Raw |
175.14 119.75 |
31.11 20.33 |
78.43 97.00 |
0.00 | 284.68 | |
9 | No Name #5471 |
Calc. Raw |
169.29 115.75 |
30.12 19.68 |
78.43 97.00 |
1.00 | 276.84 | |
10 | No Name #24942 |
Calc. Raw |
164.90 112.75 |
37.74 24.66 |
73.04 90.33 |
0.00 | 275.68 | |
11 | No Name #32302 |
Calc. Raw |
161.24 110.25 |
26.00 16.99 |
84.90 105.00 |
0.00 | 272.14 | |
12 | No Name #35456 |
Calc. Raw |
170.02 116.25 |
26.02 17.00 |
74.12 91.67 |
0.00 | 270.16 | |
12 | No Name #34894 |
Calc. Raw |
169.29 115.75 |
19.90 13.00 |
80.59 99.67 |
0.00 | 269.78 | |
12 | No Name #6653 |
Calc. Raw |
194.15 132.75 |
33.16 21.67 |
42.05 52.00 |
0.00 | 269.36 | |
12 | No Name #13927 |
Calc. Raw |
174.41 119.25 |
21.92 14.32 |
87.87 108.67 |
15.00 | 269.20 | |
13 | No Name #36009 |
Calc. Raw |
165.63 113.25 |
16.82 10.99 |
86.52 107.00 |
0.00 | 268.97 | |
14 | No Name #1140 |
Calc. Raw |
166.00 113.50 |
21.93 14.33 |
79.51 98.33 |
0.00 | 267.44 | |
15 | No Name #34083 |
Calc. Raw |
180.99 123.75 |
22.96 15.00 |
61.19 75.67 |
0.00 | 265.14 | |
16 | No Name #13608 |
Calc. Raw |
158.32 108.25 |
24.49 16.00 |
80.59 99.67 |
0.00 | 263.40 | |
16 | No Name #4185 |
Calc. Raw |
159.41 109.00 |
23.98 15.67 |
79.51 98.33 |
0.00 | 262.90 | |
16 | No Name #16142 |
Calc. Raw |
167.82 114.75 |
22.97 15.01 |
71.97 89.00 |
0.00 | 262.76 | |
17 | No Name #11901 |
Calc. Raw |
165.63 113.25 |
21.93 14.33 |
73.58 91.00 |
0.00 | 261.14 | |
18 | No Name #5511 |
Calc. Raw |
172.21 117.75 |
25.51 16.67 |
62.26 77.00 |
0.00 | 259.98 | |
19 | No Name #32600 |
Calc. Raw |
159.41 109.00 |
19.90 13.00 |
78.43 97.00 |
0.00 | 257.74 | |
19 | No Name #35308 |
Calc. Raw |
167.82 114.75 |
33.69 22.01 |
55.25 68.33 |
0.00 | 256.76 | |
20 | No Name #34803 |
Calc. Raw |
160.51 109.75 |
24.99 16.33 |
68.73 85.00 |
0.00 | 254.23 | |
20 | No Name #2465 |
Calc. Raw |
165.27 113.00 |
24.49 16.00 |
64.42 79.67 |
0.00 | 254.18 | |
20 | No Name #32570 |
Calc. Raw |
136.01 93.00 |
41.83 27.33 |
76.28 94.33 |
0.00 | 254.12 | |
20 | No Name #35115 |
Calc. Raw |
167.46 114.50 |
20.40 13.33 |
65.50 81.00 |
0.00 | 253.36 | |
21 | No Name #30746 |
Calc. Raw |
158.68 108.50 |
20.92 13.67 |
71.97 89.00 |
0.00 | 251.57 | |
22 | No Name #5582 |
Calc. Raw |
153.93 105.25 |
13.27 8.67 |
82.74 102.33 |
0.00 | 249.94 | |
22 | No Name #15407 |
Calc. Raw |
162.34 111.00 |
24.49 16.00 |
62.26 77.00 |
0.00 | 249.09 | |
23 | No Name #34295 |
Calc. Raw |
159.41 109.00 |
18.37 12.00 |
75.74 93.67 |
5.00 | 248.52 | |
24 | No Name #18415 |
Calc. Raw |
163.44 111.75 |
20.40 13.33 |
62.26 77.00 |
0.00 | 246.10 | |
24 | No Name #6986 |
Calc. Raw |
163.44 111.75 |
12.26 8.01 |
69.81 86.33 |
0.00 | 245.51 | |
25 | No Name #14989 |
Calc. Raw |
149.18 102.00 |
17.36 11.34 |
77.89 96.33 |
0.00 | 244.43 | |
26 | No Name #33986 |
Calc. Raw |
155.39 106.25 |
26.02 17.00 |
66.57 82.33 |
5.00 | 242.98 | |
26 | No Name #21290 |
Calc. Raw |
140.77 96.25 |
18.89 12.34 |
83.29 103.00 |
0.00 | 242.95 | |
26 | No Name #1701 |
Calc. Raw |
146.98 100.50 |
24.49 16.00 |
70.89 87.67 |
0.00 | 242.36 | |
26 | No Name #27409 |
Calc. Raw |
162.71 111.25 |
20.42 13.34 |
59.03 73.00 |
0.00 | 242.16 | |
27 | No Name #3117 |
Calc. Raw |
139.31 95.25 |
21.93 14.33 |
77.36 95.67 |
0.00 | 238.60 | |
27 | No Name #35867 |
Calc. Raw |
141.13 96.50 |
25.50 16.66 |
71.70 88.67 |
0.00 | 238.33 | |
27 | No Name #33591 |
Calc. Raw |
179.16 122.50 |
31.63 20.67 |
56.87 70.33 |
30.00 | 237.66 | |
28 | No Name #35511 |
Calc. Raw |
145.89 99.75 |
18.37 12.00 |
70.89 87.67 |
0.00 | 235.15 | |
28 | No Name #1548 |
Calc. Raw |
162.71 111.25 |
18.87 12.33 |
53.10 65.67 |
0.00 | 234.68 | |
29 | No Name #33946 |
Calc. Raw |
160.15 109.50 |
17.86 11.67 |
55.25 68.33 |
1.00 | 232.26 | |
30 | No Name #34080 |
Calc. Raw |
150.27 102.75 |
18.89 12.34 |
60.65 75.00 |
0.00 | 229.81 | |
31 | No Name #35317 |
Calc. Raw |
138.94 95.00 |
20.92 13.67 |
62.26 77.00 |
0.00 | 222.12 | |
32 | No Name #33846 |
Calc. Raw |
141.50 96.75 |
15.81 10.33 |
63.34 78.33 |
1.00 | 219.65 | |
32 | No Name #20005 |
Calc. Raw |
133.09 91.00 |
13.27 8.67 |
74.12 91.67 |
1.00 | 219.48 | |
32 | No Name #33735 |
Calc. Raw |
141.13 96.50 |
14.28 9.33 |
63.34 78.33 |
0.00 | 218.75 | |
33 | No Name #22248 |
Calc. Raw |
131.99 90.25 |
16.33 10.67 |
67.66 83.67 |
0.00 | 215.98 | |
34 | No Name #35382 |
Calc. Raw |
126.51 86.50 |
14.28 9.33 |
71.42 88.33 |
0.00 | 212.21 | |
35 | No Name #35769 |
Calc. Raw |
131.99 90.25 |
8.16 5.33 |
67.11 83.00 |
0.00 | 207.26 | |
36 | No Name #7228 |
Calc. Raw |
130.90 89.50 |
9.69 6.33 |
65.50 81.00 |
1.00 | 205.09 | |
37 | No Name #12905 |
Calc. Raw |
133.82 91.50 |
12.75 8.33 |
53.10 65.67 |
0.00 | 199.67 | |
38 | No Name #497 |
Calc. Raw |
125.41 85.75 |
11.23 7.34 |
43.40 53.67 |
0.00 | 180.04 | |
39 | No Name #35883 |
Calc. Raw |
116.64 79.75 |
11.72 7.66 |
62.26 77.00 |
70.00 | 120.62 |