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 = 7838 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
The team behind the reputable Mint brand are back for a second year of Mint Festival at Lotherton Hall, Leeds on Saturday 21st September. The Mint Club and Mint Warehouse are home to some of the UK's finest parties including system., Louche, Teknicolor and Blacklight. Following the overwhelming success of last year's event, Mint Festival in 2013 will be bigger and now boasts 7 covered arenas and an increased capacity of over 10,000. The all-day festival will again feature first-class lineups across the electronic music spectrum, curated by leading club nights system., Louche, Teknicolor, Blacklight, Bitch, Distrikt, Jungle Jam, Detonate, Goodgreef, Digital Society, Bigger Than Barry and Set One Twenty.