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 II | ||||||||
Rank | Member | Long Term |
Weight | Style | Spont | Penalty | Total | |
1 | No Name #9083 |
Calc. Raw |
198.98 48.00 |
150.00 865.00 |
49.09 36.00 |
99.27 136.00 |
0.00 | 347.34 |
2 | No Name #1140 |
Calc. Raw |
174.16 40.67 |
132.66 765.00 |
49.09 36.00 |
85.40 117.00 |
0.00 | 308.65 |
3 | No Name #346 |
Calc. Raw |
153.18 49.00 |
103.18 595.00 |
41.82 30.67 |
93.43 128.00 |
0.00 | 288.43 |
4 | No Name #31482 |
Calc. Raw |
137.76 48.33 |
88.44 510.00 |
50.00 36.67 |
84.12 115.25 |
0.00 | 271.88 |
5 | No Name #13505 |
Calc. Raw |
133.87 34.33 |
98.84 570.00 |
42.27 31.00 |
87.41 119.75 |
0.00 | 263.55 |
6 | No Name #416 |
Calc. Raw |
124.77 39.00 |
84.97 490.00 |
36.36 26.67 |
100.00 137.00 |
0.00 | 261.13 |
7 | No Name #30390 |
Calc. Raw |
119.25 20.00 |
98.84 570.00 |
39.99 29.33 |
90.69 124.25 |
0.00 | 249.93 |
8 | No Name #36450 |
Calc. Raw |
140.19 39.67 |
99.71 575.00 |
42.72 31.33 |
63.14 86.50 |
0.00 | 246.05 |
9 | No Name #3060 |
Calc. Raw |
141.72 32.67 |
108.38 625.00 |
39.99 29.33 |
58.39 80.00 |
0.00 | 240.10 |
10 | No Name #7160 |
Calc. Raw |
104.69 19.33 |
84.97 490.00 |
42.27 31.00 |
83.94 115.00 |
0.00 | 230.90 |
11 | No Name #34374 |
Calc. Raw |
90.31 36.67 |
52.89 305.00 |
46.36 34.00 |
86.86 119.00 |
0.00 | 223.53 |
12 | No Name #36693 |
Calc. Raw |
90.74 15.00 |
75.43 435.00 |
34.54 25.33 |
89.78 123.00 |
0.00 | 215.06 |
13 | No Name #28378 |
Calc. Raw |
94.29 19.33 |
74.57 430.00 |
30.45 22.33 |
86.86 119.00 |
0.00 | 211.60 |
14 | No Name #32054 |
Calc. Raw |
80.61 18.67 |
61.56 355.00 |
35.45 26.00 |
90.51 124.00 |
0.00 | 206.57 |
15 | No Name #13653 |
Calc. Raw |
93.61 45.00 |
47.69 275.00 |
27.27 20.00 |
80.11 109.75 |
0.00 | 200.99 |
16 | No Name #36576 |
Calc. Raw |
89.95 19.33 |
70.23 405.00 |
49.54 36.33 |
60.04 82.25 |
0.00 | 199.53 |
17 | No Name #37300 |
Calc. Raw |
90.15 18.67 |
71.10 410.00 |
36.36 26.67 |
70.26 96.25 |
0.00 | 196.77 |
18 | No Name #32282 |
Calc. Raw |
165.69 30.67 |
134.39 775.00 |
34.54 25.33 |
20.26 27.75 |
25.00 | 195.49 |
19 | No Name #36216 |
Calc. Raw |
128.69 25.00 |
103.18 595.00 |
39.54 29.00 |
22.45 30.75 |
0.00 | 190.68 |
20 | No Name #1388 |
Calc. Raw |
87.02 19.00 |
67.63 390.00 |
30.45 22.33 |
69.34 95.00 |
0.00 | 186.81 |
21 | No Name #34546 |
Calc. Raw |
68.18 33.67 |
33.82 195.00 |
33.64 24.67 |
81.20 111.25 |
0.00 | 183.02 |
22 | No Name #36485 |
Calc. Raw |
54.89 30.00 |
24.28 140.00 |
34.09 25.00 |
91.06 124.75 |
0.00 | 180.04 |
22 | No Name #26367 |
Calc. Raw |
48.29 30.33 |
17.34 100.00 |
36.36 26.67 |
95.07 130.25 |
0.00 | 179.72 |
23 | No Name #17346 |
Calc. Raw |
54.94 19.00 |
35.55 205.00 |
32.27 23.67 |
87.77 120.25 |
0.00 | 174.98 |
24 | No Name #16088 |
Calc. Raw |
42.80 19.00 |
23.41 135.00 |
38.63 28.33 |
89.60 122.75 |
0.00 | 171.03 |
24 | No Name #36144 |
Calc. Raw |
41.59 18.67 |
22.54 130.00 |
44.55 32.67 |
84.67 116.00 |
0.00 | 170.81 |
25 | No Name #19264 |
Calc. Raw |
49.01 29.33 |
19.08 110.00 |
23.63 17.33 |
96.72 132.50 |
0.00 | 169.36 |
26 | No Name #22944 |
Calc. Raw |
51.05 48.33 |
1.73 10.00 |
23.18 17.00 |
92.70 127.00 |
0.00 | 166.93 |
27 | No Name #34916 |
Calc. Raw |
97.34 14.67 |
82.37 475.00 |
40.46 29.67 |
26.28 36.00 |
0.00 | 164.08 |
28 | No Name #32946 |
Calc. Raw |
48.87 19.00 |
29.48 170.00 |
26.36 19.33 |
85.58 117.25 |
0.00 | 160.81 |
28 | No Name #10605 |
Calc. Raw |
32.92 18.67 |
13.87 80.00 |
36.81 27.00 |
90.33 123.75 |
0.00 | 160.06 |
29 | No Name #37464 |
Calc. Raw |
47.22 23.33 |
23.41 135.00 |
41.82 30.67 |
65.88 90.25 |
0.00 | 154.92 |
30 | No Name #36280 |
Calc. Raw |
52.47 29.33 |
22.54 130.00 |
41.36 30.33 |
59.85 82.00 |
0.00 | 153.68 |
30 | No Name #36181 |
Calc. Raw |
73.15 19.00 |
53.76 310.00 |
29.08 21.33 |
51.28 70.25 |
0.00 | 153.51 |
31 | No Name #2111 |
Calc. Raw |
31.19 18.67 |
12.14 70.00 |
28.63 21.00 |
92.34 126.50 |
0.00 | 152.16 |
31 | No Name #35471 |
Calc. Raw |
48.00 19.00 |
28.61 165.00 |
30.91 22.67 |
73.18 100.25 |
0.00 | 152.09 |
31 | No Name #3422 |
Calc. Raw |
50.38 38.33 |
11.27 65.00 |
27.72 20.33 |
73.91 101.25 |
0.00 | 152.01 |
31 | No Name #10706 |
Calc. Raw |
27.72 18.67 |
8.67 50.00 |
35.45 26.00 |
88.69 121.50 |
0.00 | 151.86 |
31 | No Name #37801 |
Calc. Raw |
30.66 19.00 |
11.27 65.00 |
36.36 26.67 |
84.49 115.75 |
0.00 | 151.51 |
31 | No Name #30515 |
Calc. Raw |
65.63 30.33 |
34.68 200.00 |
42.72 31.33 |
43.07 59.00 |
0.00 | 151.42 |
32 | No Name #30879 |
Calc. Raw |
43.75 40.33 |
2.60 15.00 |
20.00 14.67 |
68.98 94.50 |
0.00 | 132.73 |
32 | No Name #36701 |
Calc. Raw |
14.62 14.33 |
0.00 0.00 |
31.36 23.00 |
86.68 118.75 |
0.00 | 132.66 |
32 | No Name #31604 |
Calc. Raw |
53.02 19.67 |
32.95 190.00 |
26.82 19.67 |
52.19 71.50 |
0.00 | 132.03 |
33 | No Name #35273 |
Calc. Raw |
82.63 30.00 |
52.02 300.00 |
29.55 21.67 |
13.87 19.00 |
0.00 | 126.05 |
34 | No Name #13791 |
Calc. Raw |
49.65 14.67 |
34.68 200.00 |
31.81 23.33 |
41.24 56.50 |
0.00 | 122.70 |
34 | No Name #37316 |
Calc. Raw |
32.99 32.33 |
0.00 0.00 |
19.09 14.00 |
69.89 95.75 |
0.00 | 121.97 |
35 | No Name #37168 |
Calc. Raw |
52.34 19.00 |
32.95 190.00 |
38.63 28.33 |
27.01 37.00 |
0.00 | 117.98 |
35 | No Name #35698 |
Calc. Raw |
50.90 47.33 |
2.60 15.00 |
15.45 11.33 |
50.91 69.75 |
0.00 | 117.26 |
36 | No Name #29418 |
Calc. Raw |
46.47 26.00 |
19.94 115.00 |
33.17 24.33 |
25.18 34.50 |
0.00 | 104.82 |
37 | No Name #33956 |
Calc. Raw |
34.13 19.00 |
14.74 85.00 |
26.36 19.33 |
42.88 58.75 |
0.00 | 103.37 |
38 | No Name #22248 |
Calc. Raw |
35.94 32.67 |
2.60 15.00 |
30.00 22.00 |
31.93 43.75 |
0.00 | 97.87 |
39 | No Name #34935 |
Calc. Raw |
48.87 19.00 |
29.48 170.00 |
22.73 16.67 |
18.43 25.25 |
0.00 | 90.03 |
40 | No Name #7720 |
Calc. Raw |
35.52 18.67 |
16.47 95.00 |
30.00 22.00 |
18.25 25.00 |
0.00 | 83.77 |
41 | No Name #6688 |
Calc. Raw |
24.51 14.67 |
9.54 55.00 |
33.17 24.33 |
24.64 33.75 |
0.00 | 82.32 |
42 | No Name #37865 |
Calc. Raw |
29.26 28.67 |
0.00 0.00 |
20.00 14.67 |
26.82 36.75 |
0.00 | 76.08 |
43 | No Name #37449 |
Calc. Raw |
32.68 30.33 |
1.73 10.00 |
24.09 17.67 |
15.51 21.25 |
0.00 | 72.28 |
44 | No Name #1991 |
Calc. Raw |
32.38 28.33 |
3.47 20.00 |
20.45 15.00 |
18.07 24.75 |
0.00 | 70.90 |
45 | No Name #37276 |
Calc. Raw |
22.55 17.00 |
5.20 30.00 |
14.55 10.67 |
24.45 33.50 |
0.00 | 61.55 |
46 | No Name #34512 |
Calc. Raw |
15.31 15.00 |
0.00 0.00 |
29.55 21.67 |
14.78 20.25 |
0.00 | 59.64 |