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
Anomalie at Hare And Hounds

Anomalie

  • Hare And Hounds Birmingham
  • Thursday 17th October
  • AGMP presents Anomalie at Hare & Hounds on Thursday 17th October.
    Big Country at Dorking Halls

    Big Country

    • Dorking Halls Dorking
    • Thursday 17th October
    • AGMP presents Big Country Return To Steeltown' Tour 1984-2019
      From The Jam   at Portsmouth Pyramids

      From The Jam

      • Portsmouth Pyramids Portsmouth
      • Thursday 17th October
      • AGMP present From The Jam 'Setting Sons' 40th-anniversary concert with special guests: The Vapors live Portsmouth.
        Big Country at The Concorde 2

        Big Country

        • The Concorde 2 Brighton
        • Friday 18th October
        • AGMP presents Big Country Return To Steeltown' Tour 1984-2019
          From The Jam   at City Hall Salisbury

          From The Jam

          • City Hall Salisbury Salisbury
          • Friday 18th October
          • AGMP present From The Jam 'Setting Sons' 40th-anniversary concert with special guests: The Vapors live Salisbury.
            view all 260 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

            Discuss AGMP Concerts