Cheap Self-Guided Elk Hunting - We offer a great selection of Cheap Self-Guided & Drop Camp Elk hunts, 12 in total. Cheap (price relative to guided hunts) Elk hunts from reputable elk hunting guides and outfitters in Colorado, New Mexico, Idaho, Wyoming, Montana, Canada, and more.... Self-guided bow and gun elk hunts, some with no lodging, and some drop camps with tent lodging, at very reasonable prices for the hunter that doesn't need or want a guide - just access to great elk properties. Many of these hunts also allow the hunter to take a mule deer and/or black bear.
Top Self-Guided & Drop Camp Elk 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 = 95
AND oh.hunt_weapon = 1
AND oh.enabled = 1
AND of.enabled = 1
GROUP BY st.id
ORDER BY 2 DESC
LIMIT 10 |