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 = 7832 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Kaluki was formed in a Manchester basement in 2006 as one of the final raves at the historic nightclub, Sankeys Soap.
Ever since, Kaluki has delivered parties with guests who are making waves right now – be it proven heavyweights or future stars of the electronic music scene, at venues across Manchester from the legendary Sankeys, to abandoned basements and currently at Victoria Warehouse.
The Kaluki Musik label is a natural progression from running events that showcase some of the finest electronic talents. With the same attention to detail and focus on quality that has made the parties a success story, Kaluki Musik releases four to the floor records constructed to make dancefloors move.
Now in it’s 7th year, Kaluki has lined up some of its most anticipated plans to date. 2013 will see even bigger marks made on the UK festival circuit and label showcases at some of the most respected clubs on the planet.