Self-Guided Cheap Hunting Trips for Whitetail DeerBook a D-I-Y Cheap Hunting Trip with Pre-Screened Hunting Guides and Outfitters
Cheap Self-Guided Whitetail Deer Hunting - We offer a great selection of Cheap Semi and Self-Guided Whitetail Deer hunts, 6 in total. Cheap (price relative to guided hunts) Whitetail Deer hunts from reputable whitetail deer guides and outfitters in Texas, Illinois, Kansas, Oklahoma, Ontario Canada, and more.... Semi and self-guided bow and gun Whitetail Deer hunts at very reasonable prices for the hunter that doesn't need or want a guide - just access to great whitetail properties.
Top Self-Guided Whitetail Deer Hunts (Gun)
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 'of ON oh.outfitterid = of.id
JOIN states AS st ON st.id = ' at line 9SQL: SELECT
st.state_name AS 'Location',
COUNT(DISTINCT(oh.outfitterid)) AS '#_of_Outfitters',
COUNT(*) AS '#_of_Hunts',
ROUND((AVG(oh.hunt_minprice) + AVG(oh.hunt_maxprice)) / 2) AS 'Average_Cost',
oh.hunt_state AS 'state_id'
FROM species sp
JOIN outfitters_hunts as oh ON sp.id = oh.hunt_species
JOIN outfitters as of ON oh.outfitterid = of.id
JOIN states AS st ON st.id = oh.hunt_state
WHERE sp.id = 96
AND oh.hunt_weapon = 1
AND oh.enabled = 1
AND of.enabled = 1
GROUP BY st.id
ORDER BY 2 DESC
LIMIT 10 |