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 = 6688 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Since the Ibiza Rocks Hotel opened in May 2008 it has become THE destination hotel for a new generation of music lovers.
Born in the backroom of Ibiza's most legendary club night, Manumission, Ibiza Rocks has powered through six years of existence to now boast live music events, a hotel and a fashion label as part of the brand. Even better? It shows no sign of stopping. In 2008 the Ibiza Rocks Hotel opened its doors for the first time and along the hot weather, cool accommodation and the biggest acts on the planet playing poolside on a weekly basis.
Every Wednesday throughout the summer, Ibiza Rocks and the hotel’s courtyard will be packed to the rafters with some of the best party animals in Ibiza. The stage is the center of the action and is packed with the latest high-tech sound and visual system, making this one of the most electrifying parties in Ibiza.