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 Listings.active=1 and iEventDate >= CURDATE() AND promotionBrandID = 9815 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0 next 1 Big Day Out Events
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!
about Big Day Out
Discuss Big Day Out