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 = 1509 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Belladrum - homegrown heaven In the Highlands (you'll feel great and you'll smile a lot).
The craic's amazing, the people friendly, families love it, the setting is stunning, the music blows you away and it's all on a relaxing human scale you can enjoy without that Times Square sensation of being overwhelmed by numbers
Features include the Seedlings Stage for new or unsigned artists and the Venus Flytrap Palais, a stage totally dedicated to the wonderful and sometimes, frankly, weird in music, theatre, cabaret and performance art.
All that and much, much more: street theatre; kids' entertainments; stalls, food and drink; alternative therapy; dance, etc. Keep an eye on this site as we up-date it with the latest additions to what promises to be an epic festival.
As one of our patrons said of last year's event: 'I've been to most of the big UK festivals and Belladrum was the best by a long, long way. The atmosphere was spot on...'
It's the only place to be this summer. See y'all there!