SELECT artists.* , MIN(iEventDate) as firstEventDate, EventName as firstEventName, ListingInstance.iListingInstance as firstEventILID FROM artists INNER JOIN artistListing ON artists.artistID = artistListing.artistID INNER JOIN Listings ON Listings.ListingID = artistListing.ListingID INNER JOIN ListingInstance ON ListingInstance.iListingID = Listings.ListingID INNER JOIN ListingPromotionBrand ON ListingPromotionBrand.listingID = Listings.ListingID
WHERE 1=1 AND Listings.active=1 and iEventDate >= CURDATE() AND promotionBrandID = 5887 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Basement Bar Dark but not dank, the plush basement bar is a dandyish den open for special one off events. Also available to hire!
Ground Floor Cafe Bar Open from 4pm serving scrumptious burgers, interesting beers, cocktails, whatever you want. The most delightful cafe in town by day and home to the most delectable bar sessions by night.
Upstairs Music Hall Everything you could want and more... A massive mirror ball, velvet curtains, domed ceiling, smoking terrace, tiered seating and parrots on the wall. Singing, dancing, cavorting, jigging.