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