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 = 7806 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Housed in a bricked railway arch underneath Manchester's Oxford Road Station, Gorilla arrived in late 2012 as the latest addition to Trof's quirky family of bars and clubs in the city. After taking over the space that was once the much loved Green Room theatre and bar on Whitworth Street West, Gorilla stood up, beat its chest, and quickly set about making the space work anew - turning the main railway arch into a cool, two storey, glass fronted bar, kitchen and gin parlour, and creating a 600 capacity gig/club/comedy venue in what was once the Green Room's theatre space.