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 = 9428 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Enter The Portal and be taken to another Dimension. A Surreal Journey of Illusion, mystery & Fun, Groovy House & Techno delivering an unrivalled Party atmosphere every time! Conceived by 2 Music & Party Lovers following years of ?Research? visiting the best Parties from Ibiza, Miami, Croatia to Serbia to the UK and throwing Large Events and DJing in Birmingham & beyond for the last 8+ Years.