Chapter 12 Series 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 = 9478 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 Chapter 12 Series
March 26th we celebrate our 12th birthday with the biggest show in our history! Welcoming the worlds best DJs in house and techno across 6 unique stages for 12 hours of music. Combining unique industrial spaces, from the Arena to the Warehouse, and the Blackbox to the Roof Terrace, we set host to an event of epic proportions, uniting thousands of music fans for a 12 hour marathon. Teamed up with the city?s best brands we aim to showcase a huge pool of international DJ talent and some of our favourite DJs of the last decade, creating a mixed musical theatre of genres, this is shaping up to be one of our biggest shows to date.
An Interview with Rebekah
4th Oct 2018
In a crowded techno field, few have risen above the rest like Rebekah. Over the past several years, the Birmingham-born artist has taken the world by storm.
7 days to go! Ticket update.....
9th Nov 2016
With all Super Early Birds, Early Birds & First Release gone, there are now under 50% of Second Release tickets left! Don't be a last minute Larry.....
Discuss Chapter 12 Series