Ibiza Rocks group

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

next 1 Ibiza Rocks Events view all
Promised Land at Proud Embankment

Promised Land

  • Proud Embankment London
  • Saturday 30th November
  • Escape reality with your chosen family at the all new super club Proud Embankment
    view events
    about Ibiza Rocks
    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.

    •  

    Ibiza Rocks News view all news

    Discuss Ibiza Rocks