The ShowHawk Duo 2019 Tour group

Keep track of The ShowHawk Duo 2019 Tour 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 = 10087 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

next 1 The ShowHawk Duo 2019 Tour Events view all
Get Loose - Liam Gallagher Afterparty with guest DJ Clint Boon at The Record Factory

Get Loose - Liam Gallagher Afterparty with guest DJ Clint Boon

  • The Record Factory Glasgow
  • Friday 15th November
  • Get Loose - Liam Gallagher Afterparty with guest DJ Clint Boon (Inspiral Carpets) & Get Loose DJ's
    view events
    about The ShowHawk Duo 2019 Tour

    The Showhawk Duo will be tearing it up across Ireland and the UK in 2019 on their biggest and best tour to date.

    Featuring trance anthems, crazy guitar licks and more subwoofer than you can handle, it shall be epic!

    •  

    Discuss The ShowHawk Duo 2019 Tour