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 = 7726 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
On Saturdays, Ushuaïa presents their new night Ants. Starting from mid-afternoon, the Playa d'en Bossa hotspot will turn into a cool underground house anthill!
After a consistent run of sell out events during their 2013 and 2014 programming and a succession of roadblock events across the world, the colony are once again preparing to descend on Ibiza for a third season of domination on the White Isle. A hugely respected entity amongst both new blood and true veterans of the scene, ANTS have built a solid reputation based on a colony of relentlessly taste making high profile bookings, as well as their all-star resident cast.