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 = 6170 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Carl’s Tuesday nights at Space are synonymous with world-class DJ talent, whether it’s established Ibiza names dropping in for one night only, resident DJs delivering premium tunes week in week out, or up and coming DJs that are breaking onto the scene. The cosmopolitan crowd continues to come from far and wide to party with Carl, with DJs and clubbers alike uniting each summer to celebrate the best that underground electronic music has to offer. What better way to move forward this year than under the ‘The Party Unites’ banner.