I went to the New Union Pub on two occasions, mainly because I enjoy a bit of singing on the odd occasion. Don't bother. The DJ and bar seems to cater to a regular, closed group of students. Frankly, they were very enjoyable, but the bar wasn't. A real pity.
Do watch your bags here. Gay or straight, you will get various leeches. And, depending on the bar person, the price of your drink may vary. Maybe I was just too sober for this pub.