Below are results for CHESTER ABBOTT OCEAN SPRINGS , MS for shoots shot from 2010-11-01 to 2011-10-31.

REDFISH OPEN 2ND - Mississippi Point Shoot # 1

Event: DBL 19 Competitors
Shooter Name City, State Score Award Class Award PTS Score PTS Total PTS

REDFISH OPEN 2ND - Mississippi Point Shoot # 1

Event: 12 39 Competitors
Shooter Name City, State Score Award Class Award PTS Score PTS Total PTS

REDFISH OPEN 2ND - Mississippi Point Shoot # 1

Event: 20 40 Competitors
Shooter Name City, State Score Award Class Award PTS Score PTS Total PTS

REDFISH OPEN 2ND - Mississippi Point Shoot # 1

Event: 28 38 Competitors
Shooter Name City, State Score Award Class Award PTS Score PTS Total PTS
CHESTER ABBOTTVANCLEAVE, MS97X100B2B1297109

REDFISH OPEN 2ND - Mississippi Point Shoot # 1

Event: 410 36 Competitors
Shooter Name City, State Score Award Class Award PTS Score PTS Total PTS
CHESTER ABBOTTVANCLEAVE, MS91X100B3B9 9
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV134887 LEFT JOIN ske' at line 1: SELECT MV134887.FNAME, MV134887.LNAME, MV134887.CITY, MV134887.STATE, MV134887.CLASSHOA, MV134887.AWARD1HOA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV134887 LEFT JOIN skeet_awards ON MV134887.AWARD1HOA = skeet_awards.award_id_pk WHERE NSSANUM='167695' and MV134887.AWARD1HOA > 0