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 = 7808 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Canal Mills draws on its creative past rooted within the backbone of the industrial revolution to create a dynamic space that intertwines historic and modern day creativity whilst ultimately playing host to unique, bespoke events in Leeds.
Interweaving the lines of its own authentic history and the unbounded innovation of modern art, the venue offers up a revolutionary space unique of its type in Leeds. Canal Mills itself is an artefact that visually awakens the traditional processes of the textile mill from which its creative heredity stems, in a modern environment.
The venue will showcase a range of artistic pursuits from exhibitions, theatrical projects and film screenings, to live gigs and electronic dance events, all the while sustaining the unique aesthetic elements born from the heart of its heritage as a textile mill.
Canal Mills provides the City of Leeds with an opportunity to explore further into immersive arts and showcase creative contemporary events.