I think you're thinking of Pickwicks on one of those side streets down the side of the Grove library - Tumblers was round the back of the college on Tumbling Hill St - it had a pub type bit downstairs with a club night upstairs that opened once the bar had filled up a bit. Good music, loads of underage kids (like me and Mel) and neanderthal bouncers. Didn't know The Mannville had been Sutcliffe's pub of choice, it was a ropey Tetley's boozer with a piss artist landlord, cheap beer and a decent jukebox, and a mix of students and decrepit locals when I was there.... then it got flogged and turned into a fucking Scruffy Murphys 'Oirish' bar. Rios was a dive but had some good punk and metal bands on. The Cellar Bar under Queens Hall had a fair few smaller gigs on too and cheap beer being the college union bar.