SWG3 group

Keep track of SWG3 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 = 9537 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

next 1 SWG3 Events view all
Max Cooper at Boiler Shop

Max Cooper

  • Boiler Shop Newcastle Upon Tyne
  • Friday 11th October
  • One Hundred Billion Sparks [Live AV]
    view events
    about SWG3
    SWG3 Events

    •  

    SWG3 News view all news

    SWG3 Artists view all artists

    • Max Cooper

      Next Playing At:
      Max Cooper (11th October)

      Max Cooper Max Cooper

    Discuss SWG3