Rainbow Venues group

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

next 3 Rainbow Venues Events view all
Foliee 3rd Birthday: Seb Zito Jesse Calosso (Cuttin Headz/Fuse) at The Mill Digbeth

Foliee 3rd Birthday: Seb Zito Jesse Calosso (Cuttin Headz/Fuse)

  • The Mill Digbeth Birmingham
  • Saturday 19th October
  • After 2 huge SOLD OUT summer shows, we return to our home of The Mill Digbeth to present to you the Foliée 3rd Birthday.
    Popular Event: 384 attending
    Foliee presents Rebuke ERA tour 22/11/19 [Birmigham] at The Blackbox

    Foliee presents Rebuke ERA tour 22/11/19 [Birmigham]

    • The Blackbox Birmingham
    • Friday 22nd November
    • Foliee presents the Rebuke ERA UK & IRELAND tour [The Blackbox, Birmigham] November 22nd 2019
      This Aint Berlin - 1st Birthday at The Blackbox

      This Aint Berlin - 1st Birthday

      • The Blackbox Birmingham
      • Saturday 30th November
      • This Ain’t Berlin is celebrating its first birthday this November. We will be going back to the infamous Blackbox!!
        view events
        about Rainbow Venues

        The Rainbow Venues are a series of non-commercial independently owned spaces with depth and character that demonstrate a progression of imaginative creativity and an epicenter of innovation. Encouraging and supporting home grown talent as well as attracting some of the world’s most prolific and underground artists, the Rainbow Venues has hand-picked and refurbished abandoned buildings from the decline of industry and transformed them into creative spaces to host raves, fashion shows, film shoots, cinema, burlesque fairs, car boots, charity events and even theatre. The Rainbow Venues is a true community with real people and has given birth to talented and ambitious entrepreneurs over the years.

        www.therainbowvenues.co.uk

        •  

        Rainbow Venues News view all news

        Rainbow Venues Artists view all artists

        • Seb Zito

          Next Playing At:
          Foliee 3rd Birthday: Seb Zito Jesse Calosso (Cuttin Headz/Fuse) (19th October)

          Seb Zito Seb Zito
        • Rothstein

          Next Playing At:
          Foliee presents Rebuke ERA tour 22/11/19 [Birmigham] (22nd November)

          Rothstein Rothstein
        • ARUN VERONE

          Next Playing At:
          Foliee 3rd Birthday: Seb Zito Jesse Calosso (Cuttin Headz/Fuse) (19th October)

          ARUN VERONE ARUN VERONE
        • Jake Whitehouse

          Next Playing At:
          Foliee 3rd Birthday: Seb Zito Jesse Calosso (Cuttin Headz/Fuse) (19th October)

          Jake Whitehouse Jake Whitehouse
        • NinetyOne

          Next Playing At:
          Foliee 3rd Birthday: Seb Zito Jesse Calosso (Cuttin Headz/Fuse) (19th October)

          NinetyOne NinetyOne
        • Karrèm & Nathan Forbes

          Next Playing At:
          Foliee 3rd Birthday: Seb Zito Jesse Calosso (Cuttin Headz/Fuse) (19th October)

          Karrèm & Nathan Forbes Karrèm & Nathan Forbes

        Discuss Rainbow Venues