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 = 8542 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Glitterbox first sashayed in with the disco sticks in 2014. After being elevated to new heights at Space Ibiza in 2016 and a glamorous move to Hï Ibiza (the club formerly known as Space) in 2017, there was no doubt it would return in 2018.
The move to Hï Ibiza showed Glitterbox to be embracing change within Playa d'en Bossa's clubbing zone. As Glitterbox continues to take the world by storm, its weekly showdown gets even bigger and more flamboyant than ever.
On 1 June, one of Ibiza's most hedonistic parties will kick off the show and run every Friday until28 September. Only the most revered DJs will be bringing a musical selection loaded with house and disco gems, accompanied by flamboyant dance crews, state-of-the-art production and an electric vibe that simply cannot be replicated elsewhere. The only problem will be never wanting to leave.
The line-up is once again star-studded. The residents, rotating throughout the season, are Armand Van Helden, Basement Jaxx (DJ set), Cassius, Derrick Carter, Dimitri From Paris, Greg Wilson, Groove Armada (DJ set), Horse Meat Disco, Joey Negro, Kenny Dope, Nightmares on Wax, Roger Sanchez, Todd Tery and very special guests Masters At Work.
On the guest roll this year we have Glitterbox founder, Simon Dunmore, joined by a selection of DJs and producers who will be in the booth on numerous dates throughout the season. These include DJ Harvey, DJ Sneak, Eli Escobar, Honey Dijon, John Morales, Late Nite Tuff Guy, Melvo Bapitste, The 2 Bears and many, many more.