Fam* Entertainment 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 = 7920 AND artists.active=1 GROUP BY artists.artistID ORDER BY ISNULL(artistRank) ASC, artistRank ASC LIMIT 6 OFFSET 0

next 1 Fam* Entertainment Events view all
Live Family Friendly Wrestling  at Murieston Scout Hall

Live Family Friendly Wrestling

  • Murieston Scout Hall Livingston
  • Saturday 2nd November
  • Live Family Friendly Professional wrestling in Livingston every month!
    view events
    about Fam* Entertainment
    Bringing international artists and brands to Lancashire and the North West.

    •  

    Fam* Entertainment News view all news

    Discuss Fam* Entertainment