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

next 3 Goodgreef Events view all
Rong Pres. John Askew (Open To Close) at Joshua Brooks

Rong Pres. John Askew (Open To Close)

  • Joshua Brooks Manchester
  • Saturday 2nd November
  • John Askew all night Rong 
    170 attending
    Goodgreef 19th Birthday (Mad Friday!) at Digital

    Goodgreef 19th Birthday (Mad Friday!)

    • Digital Newcastle Upon Tyne
    • Friday 20th December
    • Goodgreef 19th Birthday, Mad Friday 20th December @ Digital, Newcastle, UK
      97 attending
      Cuckoo's 2nd Birthday special with John Askew (3hr set)  at Box Nottingham

      Cuckoo's 2nd Birthday special with John Askew (3hr set)

      • Box Nottingham Nottingham
      • Saturday 25th January 2020
      • Cuckoo celebrate their 2nd Birthday in style with 'THE BOSS' John Askew.
        view events
        about Goodgreef

        The UK's leading Trance & Hard-Dance clubbing brand. This year GOODGREEF

        •  

        Goodgreef News view all news

        Goodgreef Artists view all artists

        • Will Atkinson

          Next Playing At:
          Goodgreef 19th Birthday (Mad Friday!) (20th December)

          Will Atkinson Will Atkinson
        • Eddie Halliwell

          Next Playing At:
          Goodgreef 19th Birthday (Mad Friday!) (20th December)

          Eddie Halliwell Eddie Halliwell
        • John Askew

          Next Playing At:
          Rong Pres. John Askew (Open To Close) (2nd November)

          John Askew John Askew
        • Scot Project

          Next Playing At:
          Goodgreef 19th Birthday (Mad Friday!) (20th December)

          Scot Project Scot Project
        • James Cottle

          Next Playing At:
          Goodgreef 19th Birthday (Mad Friday!) (20th December)

          James Cottle James Cottle
        • Jak Aggas

          Next Playing At:
          Goodgreef 19th Birthday (Mad Friday!) (20th December)

          Jak Aggas Jak Aggas

        Discuss Goodgreef