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 = 8755 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Two of Scotland?s biggest clubbing brands have joined forces to create a new series of events across Edinburgh this autumn, paving the way for a new era of electronic music in the Scottish capital.
House & techno brand Musika and bass heavyweights Xplicit have teamed up to launch Nightvision, a series of specially curated events that will see over 50 world renowned artists from across the whole spectrum of electronic music perform across iconic venues in the city.
With a view to bring the cream of the crop from across the fields of house, techno, bass and electronica to the city, Nightvision?s genre-defying programme will run from mid-September through to New Year?s Eve and showcase the very best in established and breakthrough music talent.
Being the first of its kind in the Scottish capital, Nightvision?s series of events promises to draw in electronic music lovers from across Scotland, with each show completely unique and offering an unrivalled music experience like never before in the city.
Full details of the whole line-up will be revealed later on in July, with tickets also going on sale for all events then.
www.thisisourvision.com coming soon