Dance 88/89 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 = 9461 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

There are no upcoming events listed at the moment - check back later.

about Dance 88/89
Summer 2016, Sankeys Ibiza will take you back to the Summer of Love 88/89. Bring your Kickers, Converse, Bandanas, Dungarees & Smiley faces & scream Acieed!

  •  

Dance 88/89 News view all news

Discuss Dance 88/89