This page is driven primarily by NSSA shoot data.
The initial list of shoots displayed are for Zone VI (AR, LA, MS, OK, TX). Click on "Quick Sorts" to filter the shoots displayed. The page is being updated so check back often.
If you would like to upload a PDF copy of your shoot program for addition please click
HERE
Shoot Num | Start/End Date | Days | Shoot Name PDF Program or Results linked if available. | Club Name | City, State |
Error of some sort: SELECT DISTINCT nssa.ShootID, nssa.*, (DATEDIFF(nssa.End_date,nssa.Start_date)+1) as NumOfDays , msshoots.*, sl.TABLECALL as TABLECALL
FROM msskeet_mymsskeet.nssashoots nssa
LEFT JOIN msskeet_myzonevi.zreg_shoots msshoots on msshoots.nssashootid=nssa.ShootID
LEFT JOIN msskeet_mymsskeet.shootlist sl ON msshoots.nssashootid=sl.SHOOTNUM
where nssa.State='TX' OR msshoots.ishoot=1
GROUP BY nssa.ShootID ORDER BY nssa.Start_date, nssa.State;