DECLARE @p_LanguageId INT, @p_Date DATE, @p_Top INT

SET @p_LanguageId = 1

SET @p_Date = '2018-06-19'

SET @p_Top = 20

SELECT * FROM (
       SELECT T2_Attraction.AttractionId, ISNULL(dbo.GetTranslation(N'T2_Site', N'Name', T2_Attraction.SiteId, @p_LanguageId), T2_Site.Name) AS SiteName, T2_Site.SiteId,

              ISNULL(dbo.GetTranslation(N'T2_Attraction', N'Name', T2_Attraction.AttractionId, @p_LanguageId), T2_Attraction.Name) AS AttractionName,

              ISNULL(dbo.GetTranslation(N'T2_Attraction', N'Description', T2_Attraction.AttractionId, @p_LanguageId),

              T2_Attraction.Description) AS AttractionDescription, dbo.GetAttractionClasses(T2_Attraction.AttractionId) AS AttractionClasses,

              MediaUrl, T2_Attraction.AttractionCode, T2_Attraction.CancellationDays, T2_Attraction.TotalRating, DiscountPercent, Color,

                     dbo.GetDiscountLevelAllocation(T2_Attraction.AttractionId,  T1_DiscountLevel.DiscountLevelId, @p_Date) -

                     dbo.GetDiscountLevelUsage(T2_Attraction.AttractionId,  T1_DiscountLevel.DiscountLevelId, @p_Date) AS LeftTickets

       FROM T2_Site INNER JOIN T2_Attraction ON T2_Site.SiteId = T2_Attraction.SiteId INNER JOIN

              T2_AttractionDiscount ON T2_Attraction.AttractionId = T2_AttractionDiscount.AttractionId INNER JOIN

              T1_DiscountLevel ON T2_AttractionDiscount.DiscountLevelId = T1_DiscountLevel.DiscountLevelId LEFT OUTER JOIN (

              SELECT * FROM T2_MediaGallery WHERE MediaCategoryId = 1

              ) T2_MediaGallery ON T2_Attraction.AttractionId = T2_MediaGallery.AttractionId

       WHERE (T2_Attraction.IsActive = 1) AND (T2_Site.IsActive = 1) AND AttractionDiscountId = dbo.GetBestDiscount(T2_Attraction.AttractionId, @p_Date, 1)

       ORDER BY DiscountPercent DESC OFFSET 20 ROWS FETCH NEXT 20 ROWS ONLY ) a WHERE a.AttractionClasses LIKE '%5%' OR a.AttractionClasses LIKE '%8'