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
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?