BOOMBOXCIRCUS group

Keep track of BOOMBOXCIRCUS 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 = 9645 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

next 2 BOOMBOXCIRCUS Events view all
Gravity w/Hype, Hazard, AC13, Nicky BM,SS,Potential Badboy at Beaver Works

Gravity w/Hype, Hazard, AC13, Nicky BM,SS,Potential Badboy

  • Beaver Works Leeds
  • Saturday 2nd November
  • Gravity at Beaver Works Leeds. Bringing you the freshest Bass Music night in the City this November. With a Bonfire, Fireworks & Halloween antics.....
    149 attending
    Boombox Circus 'Winter Wonderland' at Beaver Works

    Boombox Circus 'Winter Wonderland'

    • Beaver Works Leeds
    • Friday 29th November
    • Welcoming the new winter Season with all the magic of the Circus...
      96 attending
      view events
      about BOOMBOXCIRCUS

      •  

      BOOMBOXCIRCUS News view all news

      BOOMBOXCIRCUS Artists view all artists

      • DJ Hype

        Next Playing At:
        Gravity w/Hype, Hazard, AC13, Nicky BM,SS,Potential Badboy (2nd November)

        DJ Hype DJ Hype
      • Nicky Blackmarket

        Next Playing At:
        Gravity w/Hype, Hazard, AC13, Nicky BM,SS,Potential Badboy (2nd November)

        Nicky Blackmarket Nicky Blackmarket
      • Hazard

        Next Playing At:
        Gravity w/Hype, Hazard, AC13, Nicky BM,SS,Potential Badboy (2nd November)

        Hazard Hazard
      • Potential Badboy

        Next Playing At:
        Gravity w/Hype, Hazard, AC13, Nicky BM,SS,Potential Badboy (2nd November)

        Potential Badboy Potential Badboy
      • Bassline Smith

        Next Playing At:
        Gravity w/Hype, Hazard, AC13, Nicky BM,SS,Potential Badboy (2nd November)

        Bassline Smith Bassline Smith
      • Daddy Earl

        Next Playing At:
        Gravity w/Hype, Hazard, AC13, Nicky BM,SS,Potential Badboy (2nd November)

        Daddy Earl Daddy Earl

      Discuss BOOMBOXCIRCUS