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 = 6640 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0
Welcome to the busiest 2016 festival guide! Find the latest summer festival lineups, news and information; use our festival search to find your perfect festival; we've got some fantastic festival competitions and of course get the cheapest music festival tickets!
Fancy a big festival such as Reading or Leeds with something for everyone or do you prefer a dance festival like Creamfields, Bestival or South West Four?
Keep checking for the latest 2016 summer festival info!