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 = 9427 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Elrow shines with the first sunlight. Achieving it's primary function of entertain and amuse, elrow fulfils these two objectives each and every time it's doors open, whether is at their spiritual home in Viladecans, it's summer residency at Space in Ibiza or the many different venues and festivals that have enjoyed it?s joyful exuberance and happiness that has become elrows signature. An experience where spectacle, music, color and happiness, essential elements of elrows DNA, get together to create that unique and involving experience that our clients get themselves into as soon as they cross the front door of any of our events, regardless of city, country, continent or time of the day! Thanks to all these components, elrow mutates, together with all it's public, into a great family that enjoys this experience up-close and personal, something only achieved thanks to an absolute connection between the show, the artists, performers and public alike. Fun and uninhibited entertainment make elrow a unique and unrepeatable experience.