Warning: ini_set(): A session is active. You cannot change the session module's ini settings at this time in /home/outfitterpros/outfitterpros.net/config.php on line 61
Black Bear Hunting Guides & Outfitters in Colorado, Montana, Maine, Alaska & Canada
 
Outfitter Pros

Black Bear Hunts

Book 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 9

SQL:
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