Elrow group

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

next 1 Elrow Events view all
Shola Ama  Upclose and Personal at Door 77

Shola Ama Upclose and Personal

  • Door 77 Brighton
  • Saturday 5th October
  • To Celebrate the highly anticipated launch of Zaraha we have invited UK hip-hop's leading lady Shola Ama - to our stage for a rare headline show on Saturday 5t
    view events
    about Elrow

    Elrow shines with the first sunlight. Achieving it's primary function of entertain and amuse, elrow fulfils these two objectives each and every time it's doors open, whether is at their spiritual home in Viladecans, it's summer residency at Space in Ibiza or the many different venues and festivals that have enjoyed it?s joyful exuberance and happiness that has become elrows signature. An experience where spectacle, music, color and happiness, essential elements of elrows DNA, get together to create that unique and involving experience that our clients get themselves into as soon as they cross the front door of any of our events, regardless of city, country, continent or time of the day! Thanks to all these components, elrow mutates, together with all it's public, into a great family that enjoys this experience up-close and personal, something only achieved thanks to an absolute connection between the show, the artists, performers and public alike. Fun and uninhibited entertainment make elrow a unique and unrepeatable experience.

    •  

    Elrow News view all news

    Elrow Artists view all artists

    • Shola Ama

      Next Playing At:
      Shola Ama Upclose and Personal (5th October)

      Shola Ama Shola Ama

    Discuss Elrow