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

next 5 Hope Works Events view all
George FitzGerald,Paranoid London,Willow,Batu,Nazira + Metrist at Hope Works

George FitzGerald,Paranoid London,Willow,Batu,Nazira + Metrist

  • Hope Works Sheffield
  • Friday 27th September
  • George FitzGerald,Paranoid London,Willow,Batu,Nazira + Metrist come to launch our new season!
    Helena Hauff, Rebekah, Lo Shea, Chris Duckenfield, 96 Back at Hope Works

    Helena Hauff, Rebekah, Lo Shea, Chris Duckenfield, 96 Back

    • Hope Works Sheffield
    • Saturday 28th September
    • Helena Hauff and Rebekah battle it out at hope Works for an almighty session
      No Bounds Festival 2019 at Various Sheffield Venues

      No Bounds Festival 2019

      • Various Sheffield Venues Sheffield
      • Friday 11th - Sunday 13th October
      • The Black Madonna, Juan Atkins, Dj Q, dBridge and many more come to Hope Works and various venues for Sheffields most forward thinking festival.
        No Bounds Festival 2019 at Various Sheffield Venues

        No Bounds Festival 2019

        • Various Sheffield Venues Sheffield
        • Friday 11th - Sunday 13th October
        • The Black Madonna, Juan Atkins, Dj Q, dBridge and many more come to Hope Works and various venues for Sheffields most forward thinking festival.
          No Bounds Festival 2019 at Various Sheffield Venues

          No Bounds Festival 2019

          • Various Sheffield Venues Sheffield
          • Friday 11th - Sunday 13th October
          • The Black Madonna, Juan Atkins, Dj Q, dBridge and many more come to Hope Works and various venues for Sheffields most forward thinking festival.
            view events
            about Hope Works

            Set up by Mixed In Sheffield it is a place for music/art Industries.Recording,engineering,production of music with rehersal facilities.Photo shoots for album covers and all the myriad of music industry related activities.

            Mixed In Sheffield is a proud supporter of Emmaus and does a great deal of work on a charity basis to further the good of the lives of people in Sheffield.

            We are an organisation dedicated to the people of Sheffield, to promoting, nurturing, developing and connecting talent.Our mission is to spread the message that Sheffield IS Music and we do music on a scale that would suprise many people.

            We punch well above our weight in many areas of the creative arts....let us help show you how and why. MIS.x

            •  

            Hope Works News view all news

            Hope Works Artists view all artists

            • George Fitzgerald

              Next Playing At:
              George FitzGerald,Paranoid London,Willow,Batu,Nazira + Metrist (27th September)

              George Fitzgerald George Fitzgerald
            • The Black Madonna

              Next Playing At:
              No Bounds Festival 2019 (11th October)

              The Black Madonna The Black Madonna
            • DJ Q

              Next Playing At:
              No Bounds Festival 2019 (11th October)

              DJ Q DJ Q
            • Helena Hauff

              Next Playing At:
              Helena Hauff, Rebekah, Lo Shea, Chris Duckenfield, 96 Back (28th September)

              Helena Hauff Helena Hauff
            • Rebekah

              Next Playing At:
              Helena Hauff, Rebekah, Lo Shea, Chris Duckenfield, 96 Back (28th September)

              Rebekah Rebekah
            • Zed Bias

              Next Playing At:
              No Bounds Festival 2019 (11th October)

              Zed Bias Zed Bias

            Discuss Hope Works