Black Bear HuntsBook a Black Bear Hunting Trip with Professional, Pre-Screened Big Game Hunting Guides and Outfitters
Black Bear Hunting - From Maine up to New Brunswick, across all of Canada to British Columbia, Alaska and several Rocky Mountain states, we've compiled a great selection of Black Bear hunts, 12 in total. Black bear hunts from reputable big game hunting guides and outfitters to bag that big bruin for the wall mount or rug for the floor. Guided and self-guided bow and gun black bear hunts.
Top 10 Black Bear 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 = 76
AND oh.hunt_weapon = 1
AND oh.enabled = 1
AND of.enabled = 1
GROUP BY st.id
ORDER BY 2 DESC
LIMIT 10 |