Bam!Bam!Bam! artists

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

These artists will be playing at Bam!Bam!Bam! events

  • Jehst

    Next Playing At:
    Jehst (19th September)

    Jehst Jehst
  • Blackalicious

    Next Playing At:
    Blackalicious (24th November)

    Blackalicious Blackalicious
  • mix master mike

    Next Playing At:
    Mix Master Mike (1st October)

    mix master mike mix master mike
  • Abstract Orchestra

    Next Playing At:
    Abstract Orchestra plays MF DOOM (4th October)

    Abstract Orchestra Abstract Orchestra