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 = 9711 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Over the past few years Motion, the west countries leading underground music mecca has achieved immeasurable recognition not only for its larger than life parties week in and week out but for its undeniable commitment to bass-driven underground music establishing itself as a valuable asset to Bristol?s flourishing music scene. Set in a network of warehouses, Motion?s thriving culture continues to celebrate and showcase some of the most influential and incredible artists from around the world. rnrnUnlike any other club in the South West, Motion has provided a multi-dimensional musical platform for diverse promoters and production teams, who have worked together to create some of the most innovative and exciting events in the UK. Its ability to produce a series of sold out events consistently throughout the years has helped shape an exhilarating fan base from all corners of the dance music map.