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 = 9669 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Area Club, Sheffield's newest 2000 capacity Super club, set in the old cinema complex at the former Embrace / Kingdom site has recently undergone a complete overhaul and been de branded and stripped back to basics, kitted out with a high tech lighting systems dominated by custom built DJ booth on the main dance floor L.E.D screens and tunnelled ceilings, packed to the rafters with hand built OPUS sound systems and an array of special FX including CO2 cannons & pyrotechnics. The main arena boasts 10 meter ceiling heights and scale but manages to retain an intimate feel across the many rooms and two arenas / areas.