AGMP Concerts group

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

next 5 AGMP Concerts Events view all
Baby Shakes at 100 Club

Baby Shakes

  • 100 Club London
  • Friday 19th July
  • New York City based, rock n’ roll-punk upstarts, Baby Shakes, head to 100 Club on Friday 19th July...
    The Brit Funk Association  at 100 Club

    The Brit Funk Association

    • 100 Club London
    • Saturday 20th July
    • AGMP presents The Brit Funk Association featuring Beggar & Co, Hi-Tension, Central Line & more
      The Long Ryders at Hare And Hounds

      The Long Ryders

      • Hare And Hounds Birmingham
      • Saturday 20th July
      • DHP presents The Long Ryders at Hare & Hounds on Saturday July 20th.
        From The Jam -  at Alban Arena

        From The Jam -

        • This event has been postponed until 20th Apr 2020
        • Alban Arena St Albans
        • Sunday 21st July
        • AGMP present From The Jam 'All Mods Cons' tour plus special guests The Truth live in St Albans
          Easy Star All-Stars  at Assembly Hall

          Easy Star All-Stars

          • Assembly Hall London
          • Friday 26th July
          • Easy Star All-Stars playing 'Dub Side of the Moon'
            view all 220 events
            about AGMP Concerts
            Keep up to date with all upcoming AGMP Concerts based in London

            •  

            AGMP Concerts News view all news

            AGMP Concerts Artists view all artists

            • Big Country

              Next Playing At:
              Big Country (11th October)

              Big Country Big Country
            • Shalamar

              Next Playing At:
              Shalamar (1st November)

              Shalamar Shalamar
            • Bad Manners

              Next Playing At:
              Bad Manners (7th December)

              Bad Manners Bad Manners
            • The Selecter

              Next Playing At:
              The Selecter (23rd November)

              The Selecter The Selecter
            • Aswad

              Next Playing At:
              Aswad (12th October)

              Aswad Aswad
            • Dreadzone

              Next Playing At:
              Dreadzone (29th November)

              Dreadzone Dreadzone

            Discuss AGMP Concerts