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 1 Odyssey Road Rally Division I | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #20906 |
Calc. Raw |
200.00 160.98 |
50.00 46.33 |
84.62 137.50 |
0.00 | 334.62 | |
2 | No Name #32957 |
Calc. Raw |
192.20 154.70 |
42.45 39.33 |
84.31 137.00 |
0.00 | 318.96 | |
3 | No Name #28072 |
Calc. Raw |
173.54 139.68 |
30.94 28.67 |
97.38 158.25 |
0.00 | 301.86 | |
4 | No Name #28819 |
Calc. Raw |
186.77 150.33 |
31.30 29.00 |
81.54 132.50 |
0.00 | 299.61 | |
5 | No Name #387 |
Calc. Raw |
153.62 123.65 |
32.38 30.00 |
100.00 162.50 |
0.00 | 286.00 | |
6 | No Name #34320 |
Calc. Raw |
159.86 128.67 |
35.26 32.67 |
83.69 136.00 |
0.00 | 278.81 | |
6 | No Name #9108 |
Calc. Raw |
151.56 121.99 |
42.09 39.00 |
84.77 137.75 |
0.00 | 278.42 | |
7 | No Name #35789 |
Calc. Raw |
156.96 126.34 |
30.57 28.33 |
84.15 136.75 |
0.00 | 271.68 | |
7 | No Name #34835 |
Calc. Raw |
162.34 130.67 |
37.77 35.00 |
71.23 115.75 |
0.00 | 271.34 | |
8 | No Name #6162 |
Calc. Raw |
168.13 135.33 |
28.42 26.33 |
70.62 114.75 |
0.00 | 267.17 | |
9 | No Name #29453 |
Calc. Raw |
168.57 135.68 |
31.30 29.00 |
61.85 100.50 |
0.00 | 261.72 | |
9 | No Name #16465 |
Calc. Raw |
130.87 105.34 |
33.46 31.00 |
97.38 158.25 |
0.00 | 261.71 | |
10 | No Name #35477 |
Calc. Raw |
145.35 116.99 |
31.65 29.33 |
82.77 134.50 |
2.00 | 257.77 | |
10 | No Name #37176 |
Calc. Raw |
128.36 103.32 |
32.38 30.00 |
96.92 157.50 |
0.00 | 257.66 | |
11 | No Name #5637 |
Calc. Raw |
150.33 121.00 |
36.34 33.67 |
66.00 107.25 |
0.00 | 252.67 | |
11 | No Name #34814 |
Calc. Raw |
143.26 115.31 |
33.81 31.33 |
74.92 121.75 |
0.00 | 251.99 | |
12 | No Name #33665 |
Calc. Raw |
150.74 121.33 |
38.13 35.33 |
60.31 98.00 |
0.00 | 249.18 | |
13 | No Name #35446 |
Calc. Raw |
153.22 123.33 |
22.31 20.67 |
71.69 116.50 |
0.00 | 247.22 | |
14 | No Name #34298 |
Calc. Raw |
132.10 106.33 |
29.14 27.00 |
84.77 137.75 |
0.00 | 246.01 | |
14 | No Name #37850 |
Calc. Raw |
142.04 114.33 |
34.53 32.00 |
68.77 111.75 |
0.00 | 245.34 | |
15 | No Name #4999 |
Calc. Raw |
161.52 130.01 |
25.90 24.00 |
56.46 91.75 |
0.00 | 243.88 | |
15 | No Name #34889 |
Calc. Raw |
151.99 122.34 |
32.02 29.67 |
59.38 96.50 |
0.00 | 243.39 | |
16 | No Name #32908 |
Calc. Raw |
135.00 108.66 |
36.69 34.00 |
70.92 115.25 |
0.00 | 242.61 | |
16 | No Name #715 |
Calc. Raw |
132.51 106.66 |
16.91 15.67 |
92.92 151.00 |
0.00 | 242.34 | |
17 | No Name #8582 |
Calc. Raw |
139.15 112.00 |
28.06 26.00 |
72.00 117.00 |
0.00 | 239.21 | |
18 | No Name #34310 |
Calc. Raw |
115.53 92.99 |
23.74 22.00 |
96.00 156.00 |
0.00 | 235.27 | |
19 | No Name #3895 |
Calc. Raw |
122.79 98.83 |
16.91 15.67 |
93.69 152.25 |
0.00 | 233.39 | |
20 | No Name #36671 |
Calc. Raw |
106.83 85.99 |
27.34 25.33 |
97.08 157.75 |
0.00 | 231.25 | |
21 | No Name #37815 |
Calc. Raw |
122.57 98.66 |
22.66 21.00 |
83.54 135.75 |
0.00 | 228.77 | |
21 | No Name #37354 |
Calc. Raw |
145.77 117.33 |
19.43 18.00 |
62.77 102.00 |
0.00 | 227.97 | |
22 | No Name #30618 |
Calc. Raw |
133.36 107.34 |
19.07 17.67 |
71.85 116.75 |
0.00 | 224.28 | |
22 | No Name #1386 |
Calc. Raw |
124.65 100.33 |
27.70 25.67 |
71.85 116.75 |
0.00 | 224.20 | |
23 | No Name #16597 |
Calc. Raw |
135.01 108.67 |
20.52 19.01 |
65.08 105.75 |
0.00 | 220.61 | |
24 | No Name #36300 |
Calc. Raw |
106.01 85.33 |
29.49 27.33 |
83.85 136.25 |
0.00 | 219.35 | |
25 | No Name #37234 |
Calc. Raw |
119.68 96.33 |
29.86 27.67 |
95.69 155.50 |
30.00 | 215.23 | |
26 | No Name #35035 |
Calc. Raw |
123.82 99.66 |
25.18 23.33 |
64.62 105.00 |
0.00 | 213.62 | |
26 | No Name #37612 |
Calc. Raw |
125.08 100.68 |
23.74 22.00 |
67.08 109.00 |
3.00 | 212.90 | |
27 | No Name #34242 |
Calc. Raw |
118.86 95.67 |
20.15 18.67 |
72.62 118.00 |
0.00 | 211.63 | |
28 | No Name #37715 |
Calc. Raw |
113.05 90.99 |
25.18 23.33 |
71.69 116.50 |
0.00 | 209.92 | |
29 | No Name #9599 |
Calc. Raw |
126.31 101.67 |
25.55 23.67 |
56.62 92.00 |
0.00 | 208.48 | |
30 | No Name #35727 |
Calc. Raw |
124.24 100.00 |
17.62 16.33 |
64.77 105.25 |
0.00 | 206.63 | |
31 | No Name #20733 |
Calc. Raw |
121.73 97.98 |
17.62 16.33 |
66.00 107.25 |
0.00 | 205.35 | |
31 | No Name #30823 |
Calc. Raw |
122.98 98.99 |
17.99 16.67 |
63.69 103.50 |
0.00 | 204.66 | |
32 | No Name #36769 |
Calc. Raw |
82.83 66.67 |
33.81 31.33 |
84.31 137.00 |
1.00 | 199.95 | |
32 | No Name #31535 |
Calc. Raw |
117.18 94.32 |
31.65 29.33 |
50.46 82.00 |
0.00 | 199.29 | |
33 | No Name #5128 |
Calc. Raw |
94.41 75.99 |
19.07 17.67 |
84.00 136.50 |
0.00 | 197.48 | |
34 | No Name #13857 |
Calc. Raw |
91.08 73.31 |
29.49 27.33 |
71.54 116.25 |
2.00 | 190.11 | |
34 | No Name #11451 |
Calc. Raw |
121.31 97.64 |
28.42 26.33 |
39.54 64.25 |
0.00 | 189.27 | |
35 | No Name #21099 |
Calc. Raw |
108.93 87.68 |
14.39 13.33 |
64.46 104.75 |
0.00 | 187.78 | |
36 | No Name #36158 |
Calc. Raw |
121.33 97.66 |
21.94 20.33 |
36.46 59.25 |
0.00 | 179.73 | |
37 | No Name #36616 |
Calc. Raw |
128.81 103.68 |
21.23 19.67 |
21.85 35.50 |
0.00 | 171.89 | |
38 | No Name #32600 |
Calc. Raw |
73.72 59.34 |
26.62 24.67 |
67.23 109.25 |
0.00 | 167.57 | |
39 | No Name #37851 |
Calc. Raw |
83.66 67.34 |
35.26 32.67 |
42.77 69.50 |
0.00 | 161.69 | |
40 | No Name #19400 |
Calc. Raw |
78.06 62.83 |
33.81 31.33 |
46.62 75.75 |
0.00 | 158.49 | |
40 | No Name #34796 |
Calc. Raw |
113.87 91.65 |
36.34 33.67 |
7.69 12.50 |
0.00 | 157.90 | |
41 | No Name #37378 |
Calc. Raw |
72.89 58.67 |
8.28 7.67 |
68.92 112.00 |
0.00 | 150.09 | |
41 | No Name #34080 |
Calc. Raw |
39.74 31.99 |
28.42 26.33 |
81.85 133.00 |
0.00 | 150.01 |