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 = 9269 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Pier Jam, set at the Iconic seaside venue of Blackpool North Pier, is all about quality electronic music with the outside atmosphere and sea views creating a special kind of vibe. With 4 stages including 2 outdoor, no other event delivers such a summer soaked day time party, backed by a soundtrack designed for real house music fans. Imagine dancing all day, whilst watching the sun go down over the sea; a clubbing memory that is hard to beat.