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 4 Tee Structure Division I | ||||||||
Rank | Member | Long Term |
Weight | Style | Spont | Penalty | Total | |
1 | No Name #37787 |
Calc. Raw |
200.00 48.00 |
150.00 730.00 |
34.80 29.00 |
85.25 96.33 |
0.00 | 320.05 |
2 | No Name #4639 |
Calc. Raw |
153.51 30.00 |
122.26 595.00 |
38.00 31.67 |
100.00 113.00 |
0.00 | 291.51 |
3 | No Name #14138 |
Calc. Raw |
158.52 44.67 |
111.99 545.00 |
37.59 31.33 |
56.64 64.00 |
0.00 | 252.75 |
4 | No Name #8147 |
Calc. Raw |
170.14 19.33 |
150.00 730.00 |
34.40 28.67 |
40.71 46.00 |
0.00 | 245.25 |
5 | No Name #37166 |
Calc. Raw |
126.88 36.00 |
89.38 435.00 |
39.60 33.00 |
67.85 76.67 |
0.00 | 234.33 |
6 | No Name #34412 |
Calc. Raw |
146.43 38.00 |
106.85 520.00 |
26.78 22.32 |
59.88 67.67 |
5.00 | 228.09 |
7 | No Name #30823 |
Calc. Raw |
153.99 15.67 |
137.67 670.00 |
14.40 12.00 |
53.10 60.00 |
0.00 | 221.49 |
8 | No Name #28072 |
Calc. Raw |
91.15 28.33 |
61.64 300.00 |
38.79 32.33 |
77.58 87.67 |
0.00 | 207.52 |
8 | No Name #2432 |
Calc. Raw |
123.95 46.00 |
76.03 370.00 |
43.59 36.33 |
39.23 44.33 |
0.00 | 206.77 |
9 | No Name #31388 |
Calc. Raw |
113.76 28.33 |
84.25 410.00 |
39.60 33.00 |
64.89 73.33 |
20.00 | 198.25 |
10 | No Name #36467 |
Calc. Raw |
123.22 43.33 |
78.08 380.00 |
34.40 28.67 |
36.58 41.33 |
0.00 | 194.20 |
11 | No Name #36864 |
Calc. Raw |
88.63 19.00 |
68.84 335.00 |
30.00 25.00 |
72.27 81.67 |
0.00 | 190.90 |
12 | No Name #37309 |
Calc. Raw |
95.11 41.00 |
52.40 255.00 |
35.60 29.67 |
56.04 63.33 |
0.00 | 186.75 |
13 | No Name #34123 |
Calc. Raw |
66.64 38.33 |
26.71 130.00 |
36.39 30.33 |
81.71 92.33 |
0.00 | 184.74 |
14 | No Name #1388 |
Calc. Raw |
113.45 31.00 |
81.16 395.00 |
37.59 31.33 |
28.91 32.67 |
0.00 | 179.95 |
15 | No Name #36158 |
Calc. Raw |
69.09 41.67 |
25.68 125.00 |
31.20 26.00 |
78.47 88.67 |
0.00 | 178.76 |
16 | No Name #34231 |
Calc. Raw |
84.87 19.33 |
64.73 315.00 |
20.40 17.00 |
78.47 88.67 |
6.00 | 177.74 |
16 | No Name #30339 |
Calc. Raw |
51.31 19.67 |
30.82 150.00 |
44.00 36.67 |
81.71 92.33 |
0.00 | 177.02 |
17 | No Name #34814 |
Calc. Raw |
65.00 19.00 |
45.21 220.00 |
50.00 41.67 |
57.23 64.67 |
0.00 | 172.23 |
18 | No Name #34897 |
Calc. Raw |
52.31 42.33 |
8.22 40.00 |
36.80 30.67 |
78.17 88.33 |
0.00 | 167.28 |
19 | No Name #36576 |
Calc. Raw |
41.37 19.00 |
21.58 105.00 |
39.60 33.00 |
79.05 89.33 |
0.00 | 160.02 |
20 | No Name #35490 |
Calc. Raw |
58.83 19.00 |
39.04 190.00 |
32.00 26.67 |
66.66 75.33 |
0.00 | 157.49 |
20 | No Name #15746 |
Calc. Raw |
55.75 19.00 |
35.96 175.00 |
21.99 18.33 |
78.76 89.00 |
0.00 | 156.50 |
21 | No Name #603 |
Calc. Raw |
79.05 19.67 |
58.56 285.00 |
33.60 28.00 |
39.53 44.67 |
0.00 | 152.18 |
21 | No Name #34521 |
Calc. Raw |
54.54 29.67 |
23.63 115.00 |
32.40 27.00 |
64.31 72.67 |
0.00 | 151.25 |
22 | No Name #36616 |
Calc. Raw |
33.83 18.67 |
14.38 70.00 |
39.60 33.00 |
69.32 78.33 |
0.00 | 142.75 |
23 | No Name #1244 |
Calc. Raw |
60.94 46.67 |
12.33 60.00 |
25.59 21.33 |
55.16 62.33 |
0.00 | 141.69 |
23 | No Name #35727 |
Calc. Raw |
60.10 36.00 |
22.60 110.00 |
35.19 29.33 |
45.73 51.67 |
0.00 | 141.02 |
24 | No Name #37595 |
Calc. Raw |
67.38 42.00 |
23.63 115.00 |
13.20 11.00 |
56.64 64.00 |
0.00 | 137.22 |
25 | No Name #1544 |
Calc. Raw |
42.05 18.67 |
22.60 110.00 |
36.80 30.67 |
57.23 64.67 |
0.00 | 136.08 |
26 | No Name #36693 |
Calc. Raw |
53.29 14.67 |
38.01 185.00 |
26.79 22.33 |
54.27 61.33 |
0.00 | 134.35 |
27 | No Name #3422 |
Calc. Raw |
67.74 43.33 |
22.60 110.00 |
40.40 33.67 |
21.53 24.33 |
0.00 | 129.67 |
27 | No Name #12646 |
Calc. Raw |
65.93 35.67 |
28.77 140.00 |
32.40 27.00 |
31.27 35.33 |
0.00 | 129.60 |
28 | No Name #24052 |
Calc. Raw |
26.26 16.33 |
9.25 45.00 |
23.19 19.33 |
77.88 88.00 |
0.00 | 127.33 |
29 | No Name #31655 |
Calc. Raw |
38.28 19.00 |
18.49 90.00 |
18.39 15.33 |
63.72 72.00 |
0.00 | 120.39 |
30 | No Name #35602 |
Calc. Raw |
41.37 19.00 |
21.58 105.00 |
18.00 15.00 |
58.12 65.67 |
0.00 | 117.49 |
30 | No Name #31535 |
Calc. Raw |
48.53 17.00 |
30.82 150.00 |
23.19 19.33 |
45.42 51.33 |
0.00 | 117.14 |
30 | No Name #30904 |
Calc. Raw |
29.31 14.33 |
14.38 70.00 |
34.80 29.00 |
52.50 59.33 |
0.00 | 116.61 |
31 | No Name #18898 |
Calc. Raw |
55.72 17.00 |
38.01 185.00 |
18.39 15.33 |
40.42 45.67 |
0.00 | 114.53 |
31 | No Name #2900 |
Calc. Raw |
44.05 14.67 |
28.77 140.00 |
25.59 21.33 |
43.96 49.67 |
0.00 | 113.60 |
32 | No Name #11374 |
Calc. Raw |
43.36 38.67 |
3.08 15.00 |
40.40 33.67 |
28.91 32.67 |
0.00 | 112.67 |
32 | No Name #21688 |
Calc. Raw |
41.62 37.00 |
3.08 15.00 |
17.19 14.33 |
53.69 60.67 |
0.00 | 112.50 |
33 | No Name #32197 |
Calc. Raw |
25.93 17.00 |
8.22 40.00 |
34.40 28.67 |
44.84 50.67 |
0.00 | 105.17 |
34 | No Name #35846 |
Calc. Raw |
22.88 20.00 |
2.05 10.00 |
24.80 20.67 |
53.98 61.00 |
0.00 | 101.66 |
35 | No Name #34298 |
Calc. Raw |
60.52 41.33 |
17.47 85.00 |
31.59 26.33 |
7.08 8.00 |
0.00 | 99.19 |
35 | No Name #1829 |
Calc. Raw |
20.42 14.67 |
5.14 25.00 |
19.20 16.00 |
58.70 66.33 |
0.00 | 98.32 |
36 | No Name #33953 |
Calc. Raw |
63.29 19.33 |
43.15 210.00 |
24.39 20.33 |
30.09 34.00 |
20.00 | 97.77 |
37 | No Name #35604 |
Calc. Raw |
51.64 19.00 |
31.85 155.00 |
17.19 14.33 |
27.73 31.33 |
0.00 | 96.56 |
38 | No Name #33375 |
Calc. Raw |
21.14 18.33 |
2.05 10.00 |
23.60 19.67 |
49.85 56.33 |
0.00 | 94.59 |
39 | No Name #30889 |
Calc. Raw |
19.39 14.67 |
4.11 20.00 |
36.00 30.00 |
37.46 42.33 |
0.00 | 92.85 |
39 | No Name #35314 |
Calc. Raw |
22.45 12.67 |
9.25 45.00 |
15.60 13.00 |
54.58 61.67 |
0.00 | 92.63 |
40 | No Name #37359 |
Calc. Raw |
19.45 18.67 |
0.00 0.00 |
32.00 26.67 |
41.59 47.00 |
5.00 | 88.04 |
41 | No Name #33381 |
Calc. Raw |
44.09 42.33 |
0.00 0.00 |
14.40 12.00 |
17.11 19.33 |
0.00 | 75.60 |
42 | No Name #29062 |
Calc. Raw |
32.47 19.33 |
12.33 60.00 |
23.19 19.33 |
6.19 7.00 |
0.00 | 61.85 |
43 | No Name #32181 |
Calc. Raw |
40.34 19.00 |
20.55 100.00 |
31.59 26.33 |
37.76 42.67 |
65.00 | 44.69 |