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

next 5 Hare and Hounds Events view all
H&H Pub Quiz - £75 Cash First Place Prize at Hare And Hounds

H&H Pub Quiz - £75 Cash First Place Prize

  • Hare And Hounds Birmingham
  • Wednesday 21st August
  • The H&H Pub Quiz, on every Wednesday in the back bar.
    Listening Sessions: August Showcase at Hare And Hounds

    Listening Sessions: August Showcase

    • Hare And Hounds Birmingham
    • Wednesday 21st August
    • Listening Sessions return to H&H - all artists and producers welcome!
      Dry Cleaning at Hare And Hounds

      Dry Cleaning

      • Hare And Hounds Birmingham
      • Thursday 22nd August
      • This Is Tmrw presents Dry Cleaning at Hare & Hounds on Thursday August 22nd
        Kings Heath & Moseley NeighbourFood at Hare And Hounds

        Kings Heath & Moseley NeighbourFood

        • Hare And Hounds Birmingham
        • Thursday 22nd August
        • Kings Heath & Moseley NeighbourFood - The Kings Heath and Moseley Good Food Hub bring fresh local produce to you every Thursday - pick up from H&H.
          Disco Pussy at Hare And Hounds

          Disco Pussy

          • Hare And Hounds Birmingham
          • Friday 23rd August
          • Disco Pussy returns to the Hare on Friday 23rd August!
            view all 134 events
            about Hare and Hounds
            Situated in the South Birmingham suburb of Kings Heath, the Hare and Hounds has been around since 1820, but has stood in its present form since 1907. This, along with the beautiful and unique Art Nouveau tiles that line the entry hall and staircase, is a major contributing factor to its current Grade II listed status. Although playing host to local Birmingham legends UB4O?s first ever gig in 1979 (recently commemorated by a PRS Music Heritage award and plaque), it is only in the past 7 years that it?s really established itself as one of the most important and influential music venues in the country, playing a vital part in nurturing the city?s vibrant music and creative community. he pub boasts two downstairs bars which host regular food evenings, a pub quiz and weekend DJs whilst the two upstairs venues feature live music & club nights spanning jazz, indie, funk, reggae, hip hop, soul, house, D?n?B & comedy most nights of the week. Local & National promoters who present shows at the Hare & Hounds include Leftfoot, This Is Tmrw, Birmingham Promoters, Metropolis Music, SJM, AEG, Kililive, Live Nation, Glasswerk, World Unlimited, Cosmic American, Capsule (Supersonic Festival), Moseley Folk Festival, Mostly Jazz, Funk & Soul Festival and many more?

            •  

            Hare and Hounds News view all news

            Hare and Hounds Artists view all artists

            • Mungos Hi Fi

              Next Playing At:
              Mungo's Hi Fi (22nd November)

              Mungos Hi Fi Mungos Hi Fi
            • Dub Pistols

              Next Playing At:
              Dub Pistols (29th November)

              Dub Pistols Dub Pistols
            • Horse Meat Disco

              Next Playing At:
              Horse Meat Disco (25th October)

              Horse Meat Disco Horse Meat Disco
            • Akala

              Next Playing At:
              Get Loud 2019: Akala (25th September)

              Akala Akala
            • DJ ZINC

              Next Playing At:
              Sum Cellar presents DJ Zinc (21st September)

              DJ ZINC DJ ZINC
            • Slipmatt

              Next Playing At:
              Heritage w/ Fabio, Graeme Park, Slipmatt & Mark Luvdup (9th November)

              Slipmatt Slipmatt

            Discuss Hare and Hounds