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 5 Ibiza Rocks Events view all
Bongo's Bingo at Ibiza Rocks Hotel

Bongo's Bingo

  • Ibiza Rocks Hotel Sant Antoni De Portm
  • Wednesday 18th September
  • Mixing classic favourite Bingo with an extravagant Pool party Bongo’s Bingo will be bringing the best in Old-Skool with special guests
    DJ EZ Eluzive Pool Party at Ibiza Rocks Hotel

    DJ EZ Eluzive Pool Party

    • Ibiza Rocks Hotel Sant Antoni De Portm
    • Thursday 19th September
    • This summer legendary party starter DJ EZ is bringing the heat to Ibiza Rocks for an epic 8 week Eluzive Pool Party residency.
      Amnesia presents Do Not Sleep Pool Party at Ibiza Rocks Hotel

      Amnesia presents Do Not Sleep Pool Party

      • Ibiza Rocks Hotel Sant Antoni De Portm
      • Friday 20th September
      • For 2019, Amnesia & Do Not Sleep are joining forces with Ibiza Rocks at the Home of the Pool Party for 4 epic Fridays of the best in House and Techno.
        Superfoxx Pool Party at Ibiza Rocks Hotel

        Superfoxx Pool Party

        • Ibiza Rocks Hotel Sant Antoni De Portm
        • Sunday 22nd September
        • This summer the female-fronted Superfoxx lands at Ibiza Rocks Hotel for 3 Sunday sessions, filled with everything music, fitness and wellbeing
          FLOAT YOUR BOAT MONDAY SUNSET with any day Ibiza Rocks at Palapa

          FLOAT YOUR BOAT MONDAY SUNSET with any day Ibiza Rocks

          • Palapa Sant Antoni De Portm
          • Monday 23rd September
          • An incredible 3 hour boat party with open bar and club combo package that includes any Ibiza Rocks pool party plus O Beach.
            view all 10 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

            Ibiza Rocks Artists view all artists

            • Craig David

              Next Playing At:
              Craig David's TS5 Pool Closing Party (24th September)

              Craig David Craig David
            • Sonny Fodera

              Next Playing At:
              Cuckoo Land Pool Closing Party (27th September)

              Sonny Fodera Sonny Fodera
            • Yungen

              Next Playing At:
              Craig David's TS5 Pool Closing Party (24th September)

              Yungen Yungen
            • Huxley

              Next Playing At:
              Cuckoo Land Pool Closing Party (27th September)

              Huxley Huxley
            • Shola Ama

              Next Playing At:
              Shola Ama Upclose and Personal (5th October)

              Shola Ama Shola Ama
            • Todd Edwards

              Next Playing At:
              DJ EZ Eluzive Pool Party (19th September)

              Todd Edwards Todd Edwards

            Discuss Ibiza Rocks