SELECT [t0].[OfferID]
    ,[t0].[OfferTypeID]
    ,[t0].[NameEn]
    ,[t0].[NameRu]
    ,[t0].[Comment]
    ,[t0].[DescriptionEn]
    ,[t0].[DescriptionRu]
    ,[t0].[PartnerID]
    ,[t0].[HostPartnerID]
    ,[t0].[CountryID]
    ,[t0].[HotelID]
    ,[t0].[RoomTypeID]
    ,[t0].[MealID]
    ,[t0].[DaysBookBeforeCheckin]
    ,[t0].[StartDate]
    ,[t0].[EndDate]
    ,[t0].[IsCheckin]
    ,[t0].[ValidStartDate]
    ,[t0].[ValidEndDate]
    ,[t0].[Pay]
    ,[t0].[Stay]
    ,[t0].[PayStayTypeID]
    ,[t0].[IsUseMultiplicity]
    ,[t0].[UpgradeRoomTypeID]
    ,[t0].[UpgradeMealID]
    ,[t0].[Discount]
    ,[t0].[IsPercent]
    ,[t0].[IsHideOnSite]
    ,[t0].[SourceID]
    ,[t0].[SourceName]
    ,[t0].[Created]
    ,[t0].[Modified]
    ,[t0].[IsActive]
    ,[t0].[IsReadOnly]
    ,[t0].[IsDurationMustEqualsStay]
    ,[t0].[CalcOrder]
    ,[t0].[IsUseOnlySelectedAccomodations]
    ,[t0].[MinDaysCount]
    ,[t0].[MaxDaysCount]
    ,[t0].[AllowedPriceTypeIDs]
    ,[t0].[IsUseExtraPrices]
    ,[t0].[IsDenyCombineWithSameOfferType]
    ,[t0].[IsDenyCombineWithOtherOfferTypes]
    ,[t0].[DeniedOfferTypeIDs]
    ,[t0].[DeniedOfferTypes]
    ,[t0].[AllowedPriceTypes]
    ,[t0].[BookingCode]
    ,[t0].[IsPerNight]
    ,[t0].[Reduction]
    ,[t0].[ActivatedDate]
    ,[t0].[DeactivatedDate]
    ,[t0].[ActivatedUserID]
    ,[t0].[SyncRowVersion]
    ,[t0].[SyncRowVersionValue]
    ,[t0].[ExcludeOfferSourceIds]
    ,[t0].[WeekDaysMask]
    ,[t1].[OfferTypeID] AS [OfferTypeID2]
    ,[t1].[NameEn] AS [NameEn2]
    ,[t1].[NameRu] AS [NameRu2]
    ,[t1].[Code]
    ,[t1].[IsDiscountObligatory]
    ,[t1].[Description]
    ,[t1].[OrderSort]
    ,[t1].[OfferPriority]
    ,[t1].[SyncRowVersion] AS [SyncRowVersion2]
    ,[t1].[SyncRowVersionValue] AS [SyncRowVersionValue2]
    ,[t2].[PayStayTypeID] AS [payStayTypeUID]
FROM [Tarif].[Offer] AS [t0]
INNER JOIN [Tarif].[OfferType] AS [t1] ON [t0].[OfferTypeID] = [t1].[OfferTypeID]
INNER JOIN [Tarif].[PayStayType] AS [t2] ON [t0].[PayStayTypeID] = ([t2].[PayStayTypeID])
WHERE ([t0].[NameEn] = @p0)
    AND ([t1].[NameRu] = @p1)
    AND ([t0].[SyncRowVersionValue] > @p2)
ORDER BY [t0].[SyncRowVersionValue]