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

next 4 Garage Nation Events view all
Sincere Feat DJ Spoony at OPEN Norwich

Sincere Feat DJ Spoony

  • OPEN Norwich Norwich
  • Saturday 21st September
  • Sincere is a night dedicated to the greatest classic and current Garage, RnB, & Hip Hop cuts
    Garage Nation Ibiza at Eden

    Garage Nation Ibiza

    • Eden San Antonio
    • Thursday 26th September
    • Garage Nation's 4th year in Ibiza will see 1 massive event take place at the Island's top late night venue Eden for the closing party weekend!
      Garage Nation Southampton  at Switch

      Garage Nation Southampton

      • Switch Southampton
      • Saturday 5th October
      • Garage Nation returns to Southampton at Switch on Saturday 5th October 2019!
        Halloween in the Sky - Artful Dodger and Friends at Atmosphere Venues (London Sky Bar)

        Halloween in the Sky - Artful Dodger and Friends

          view events
          about Garage Nation
          Garage Nation was established in 1997 and has continued to feed the appetite of all kinds of UK Garage Fan from across the world! We have events up and down the UK, so be sure to check out when we are coming to an area near you, or when you next want to make that well worth while road trip!

          •  

          Garage Nation News view all news

          Garage Nation Artists view all artists

          • Artful Dodger

            Next Playing At:
            Halloween in the Sky - Artful Dodger and Friends (1st November)

            Artful Dodger Artful Dodger
          • Matt Jam Lamont

            Next Playing At:
            Garage Nation Ibiza (26th September)

            Matt Jam Lamont Matt Jam Lamont
          • DJ Luck & MC Neat

            Next Playing At:
            Garage Nation Ibiza (26th September)

            DJ Luck & MC Neat DJ Luck & MC Neat
          • DJ LUCK AND MC NEAT

            Next Playing At:
            Garage Nation Ibiza (26th September)

            DJ LUCK AND MC NEAT DJ LUCK AND MC NEAT
          • Dj Cartier

            Next Playing At:
            Garage Nation Ibiza (26th September)

            Dj Cartier Dj Cartier
          • MC B LIVE

            Next Playing At:
            Garage Nation Ibiza (26th September)

            MC B LIVE MC B LIVE

          Discuss Garage Nation