Zoo Project 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 = 6846 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0 next 4 Zoo Project Events
about Zoo Project
The Zoo Project is Ibiza's premier outdoor underground electronic music event, housed in an old abandoned Zoo among the picturesque hills of Benimussa, it's an event whose main focus is to provide an unforgettable experience for like-minded people - people who choose love, unity and quality underground electronic music as their staple diet.
To truly understand what The Zoo Project is all about, you must experience it firsthand. It's a place where you can lose yourself and find yourself all over again amongst a sea of kindred revelers, set to an unforgettable soundtrack. With its vast open air space you can find whatever you need at The Zoo Project, whether it's the energetic non-stop vibes of 'The Seal Pit', the rejuvenating vibes of the sunshine soaked 'Pool Area', the tranquility of the flower-filled gardens or simply the amicable company of other like-minded and warmhearted Zoo Project party animals.
Zoo will never forget that it is YOU, the people who attend the Zoo, that make the Zoo!
Love music, Love family, Love Zoo.
Discuss Zoo Project