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 = 9426 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
02:31 was initially founded to fill a gap in the market, as there was no after party event in the city that offered consistently good music on a weekly basis. Enjoying the best in house and UK bass music, the brand has rapidly grown into the key after hours event in Birmingham. Hannah Wants and Tom Shorterz built a name for themselves at these events and have since gone on to spearhead the bass music scene in the Midlands and beyond.