Big Day Out group

Keep track of Big Day Out events, tickets and news - all in one place. Join this group now for updates as they happen!

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 and iEventDate >= CURDATE() AND promotionBrandID = 9815 AND GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

next 1 Big Day Out Events view all
The National Pet Show  at The NEC

The National Pet Show

  • The NEC Birmingham
  • Saturday 2nd November
  • Meet the animals, see the experts, watch animal displays and shop the latest pet products!
    view events
    about Big Day Out


    Big Day Out News view all news

    Discuss Big Day Out