Visiting a legendary pub in Sneinton, indoor opening in Hockley and an encounter with a farting hound.