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 III | ||||||||
Rank | Member | Long Term |
Style | Spont | Penalty | Total | ||
1 | No Name #20868 |
Calc. Raw |
157.96 139.00 |
39.28 29.33 |
100.00 584.50 |
0.00 | 297.24 | |
2 | No Name #35901 |
Calc. Raw |
164.41 144.67 |
41.96 31.33 |
79.08 462.25 |
0.00 | 285.45 | |
3 | No Name #7975 |
Calc. Raw |
151.53 133.34 |
31.25 23.33 |
99.83 583.50 |
0.00 | 282.61 | |
3 | No Name #37674 |
Calc. Raw |
139.02 122.33 |
43.76 32.67 |
99.79 583.25 |
0.00 | 282.57 | |
3 | No Name #37802 |
Calc. Raw |
184.86 162.67 |
39.74 29.67 |
57.87 338.25 |
0.00 | 282.47 | |
4 | No Name #1149 |
Calc. Raw |
154.17 135.66 |
49.56 37.00 |
66.30 387.50 |
0.00 | 270.03 | |
5 | No Name #5736 |
Calc. Raw |
200.00 175.99 |
46.44 34.67 |
22.58 132.00 |
0.00 | 269.02 | |
6 | No Name #19512 |
Calc. Raw |
152.67 134.34 |
27.69 20.67 |
79.34 463.75 |
0.00 | 259.70 | |
6 | No Name #36232 |
Calc. Raw |
184.86 162.67 |
48.66 36.33 |
26.01 152.00 |
0.00 | 259.53 | |
7 | No Name #33986 |
Calc. Raw |
134.84 118.65 |
36.16 27.00 |
85.97 502.50 |
0.00 | 256.97 | |
8 | No Name #33894 |
Calc. Raw |
106.82 94.00 |
38.40 28.67 |
99.62 582.25 |
0.00 | 244.84 | |
8 | No Name #32490 |
Calc. Raw |
175.00 153.99 |
49.12 36.67 |
19.85 116.00 |
0.00 | 243.97 | |
9 | No Name #10102 |
Calc. Raw |
161.76 142.34 |
47.78 35.67 |
33.28 194.50 |
0.00 | 242.82 | |
10 | No Name #9103 |
Calc. Raw |
157.96 139.00 |
48.66 36.33 |
31.18 182.25 |
0.00 | 237.80 | |
11 | No Name #30663 |
Calc. Raw |
146.21 128.66 |
39.28 29.33 |
43.97 257.00 |
0.00 | 229.46 | |
12 | No Name #22311 |
Calc. Raw |
159.85 140.66 |
39.28 29.33 |
25.96 151.75 |
0.00 | 225.09 | |
13 | No Name #36451 |
Calc. Raw |
126.14 111.00 |
39.28 29.33 |
48.76 285.00 |
0.00 | 214.18 | |
14 | No Name #35911 |
Calc. Raw |
148.11 130.33 |
31.70 23.67 |
31.74 185.50 |
0.00 | 211.55 | |
15 | No Name #33488 |
Calc. Raw |
149.27 131.35 |
37.50 28.00 |
29.17 170.50 |
6.00 | 209.94 | |
16 | No Name #4637 |
Calc. Raw |
143.56 126.33 |
39.28 29.33 |
25.96 151.75 |
0.00 | 208.80 | |
17 | No Name #18255 |
Calc. Raw |
150.38 132.33 |
50.00 37.33 |
5.99 35.00 |
0.00 | 206.37 | |
18 | No Name #17068 |
Calc. Raw |
142.43 125.33 |
38.40 28.67 |
21.90 128.00 |
0.00 | 202.73 | |
19 | No Name #31161 |
Calc. Raw |
78.80 69.34 |
33.93 25.33 |
87.77 513.00 |
2.00 | 198.50 | |
20 | No Name #32441 |
Calc. Raw |
103.41 91.00 |
37.50 28.00 |
52.52 307.00 |
0.00 | 193.43 | |
20 | No Name #29018 |
Calc. Raw |
131.05 115.32 |
36.16 27.00 |
25.75 150.50 |
0.00 | 192.96 | |
21 | No Name #33292 |
Calc. Raw |
149.25 131.33 |
25.01 18.67 |
16.89 98.75 |
0.00 | 191.15 | |
22 | No Name #17622 |
Calc. Raw |
125.77 110.67 |
35.27 26.33 |
26.90 157.25 |
0.00 | 187.94 | |
23 | No Name #37852 |
Calc. Raw |
139.02 122.33 |
38.40 28.67 |
9.41 55.00 |
0.00 | 186.83 | |
23 | No Name #34802 |
Calc. Raw |
145.10 127.68 |
29.02 21.67 |
12.40 72.50 |
0.00 | 186.52 | |
23 | No Name #10146 |
Calc. Raw |
123.47 108.65 |
36.16 27.00 |
26.43 154.50 |
0.00 | 186.06 | |
24 | No Name #14186 |
Calc. Raw |
126.92 111.68 |
25.45 19.00 |
23.14 135.25 |
0.00 | 175.51 | |
25 | No Name #4307 |
Calc. Raw |
113.63 99.99 |
43.30 32.33 |
16.00 93.50 |
0.00 | 172.93 | |
26 | No Name #1412 |
Calc. Raw |
132.59 116.67 |
22.77 17.00 |
12.49 73.00 |
0.00 | 167.85 | |
27 | No Name #8451 |
Calc. Raw |
117.45 103.35 |
35.72 26.67 |
19.42 113.50 |
8.00 | 164.59 | |
28 | No Name #32144 |
Calc. Raw |
119.32 105.00 |
25.01 18.67 |
25.83 151.00 |
20.00 | 150.16 | |
29 | No Name #3148 |
Calc. Raw |
94.31 82.99 |
23.21 17.33 |
21.64 126.50 |
6.00 | 133.16 | |
30 | No Name #11105 |
Calc. Raw |
79.95 70.35 |
37.50 28.00 |
8.04 47.00 |
0.00 | 125.49 | |
31 | No Name #30595 |
Calc. Raw |
89.41 78.68 |
24.55 18.33 |
10.31 60.25 |
12.00 | 112.27 | |
32 | No Name #19633 |
Calc. Raw |
59.09 52.00 |
32.15 24.00 |
18.43 107.75 |
2.00 | 107.67 | |
33 | No Name #36469 |
Calc. Raw |
46.21 40.66 |
39.74 29.67 |
5.22 30.50 |
0.00 | 91.17 | |
34 | No Name #7940 |
Calc. Raw |
72.36 63.67 |
15.18 11.33 |
8.68 50.75 |
7.00 | 89.22 | |
35 | No Name #36540 |
Calc. Raw |
50.00 44.00 |
10.72 8.00 |
4.28 25.00 |
3.00 | 62.00 |