SELECT
       [sil].[OrderItemID] AS [orders_products_id]
     , [sih].[Ship-to Code] AS [orders_id]
     , [sil].[Campaign No_] AS [kupivip_categories_external_number]
     , [sil].[No_] AS [kupivip_products_code]
     , [sil].[Variant Code] AS [kupivip_variants_code]
     , CAST([sil].[Orig_ Quantity] AS INT) AS [is_supplied]
     , CAST([sil].[Quantity] AS INT) AS [is_sold]
     , CAST([sil].[Orig_ Quantity] - [sil].[Quantity] AS INT) AS [is_deleted]
     , CAST([sil].[Unit Price] AS DECIMAL(15, 2)) AS [products_price]
     , CAST([sil].[Amount] AS DECIMAL(15, 2)) AS [products_sum]
     , CAST([sil].[Amount Including VAT] AS DECIMAL(15, 2)) AS [products_sum_with_vat]
     , (select VPS.[VAT %] from [KupiVip].[dbo].[Privat Trade$VAT Posting Setup] VPS
    where VPS.[VAT Prod_ Posting Group] = i.[VAT Prod_ Posting Group]
      and VPS.[VAT Bus_ Posting Group] = [sil].[VAT Bus_ Posting Group])
     , ISNULL(
       (
        SELECT
               -CAST(SUM([ve].[Cost Amount (Actual)]) AS DECIMAL(15, 2)) AS [products_cost]
        FROM
             [dbo].[Privat Trade$Value Entry](NOLOCK) AS [ve]
        WHERE [ve].[Document Line No_] = [sil].[Line No_]
              AND [ve].[Document No_] = [sil].[Document No_]
              AND [ve].[Document Type] = 2
       ), 0) AS [products_cost]
     , ISNULL(
       (
        SELECT
               MAX([ile].[Lot No_]) AS [lot]
        FROM
             [dbo].[Privat Trade$Value Entry](NOLOCK) AS [ve]
             JOIN [dbo].[Privat Trade$Item Ledger Entry](NOLOCK) AS [ile]
                 ON [ile].[Entry No_] = [ve].[Item Ledger Entry No_]
        WHERE [ve].[Document Line No_] = [sil].[Line No_]
              AND [ve].[Document No_] = [sil].[Document No_]
              AND [ve].[Document Type] = 2 -- (Счет-факт. прод.)
       ), '') AS [lot]
     , ISNULL(
       (
        SELECT
               MAX([l].[Deal Code]) AS [incomes_id]
        FROM
             [dbo].[Privat Trade$Value Entry](NOLOCK) AS [ve]
             JOIN [dbo].[Privat Trade$Item Ledger Entry](NOLOCK) AS [ile]
                 ON [ile].[Entry No_] = [ve].[Item Ledger Entry No_]
             JOIN [Privat Trade$Lot](NOLOCK) AS [l]
                 ON [l].[Code] = [ile].[Lot No_]
        WHERE [ve].[Document Line No_] = [sil].[Line No_]
              AND [ve].[Document No_] = [sil].[Document No_]
              AND [ve].[Document Type] = 2 -- (Счет-факт. прод.)
       ), 0) AS [incomes_id]
     , ISNULL(
       (
        SELECT
               MAX([l].[Campaign No_]) AS [incomes_categories_id]
        FROM
             [dbo].[Privat Trade$Value Entry](NOLOCK) AS [ve]
             JOIN [dbo].[Privat Trade$Item Ledger Entry](NOLOCK) AS [ile]
                 ON [ile].[Entry No_] = [ve].[Item Ledger Entry No_]
             JOIN [Privat Trade$Lot](NOLOCK) AS [l]
                 ON [l].[Code] = [ile].[Lot No_]
        WHERE [ve].[Document Line No_] = [sil].[Line No_]
              AND [ve].[Document No_] = [sil].[Document No_]
              AND [ve].[Document Type] = 2 -- (Счет-факт. прод.)
       ), '') AS [incomes_kupivip_categories_external_number]
     , [sil].[Posting Date] AS [date_modified]
FROM
     [dbo].[Privat Trade$Sales Invoice Line](NOLOCK) AS [sil]
     JOIN [dbo].[Privat Trade$Sales Invoice Header](NOLOCK) AS [sih]
         ON [sil].[Document No_] = [sih].[No_]
WHERE [sih].[Host Code] = 'MSY'
      AND [sil].[Type] = 2 -- Товар
--  AND [sih].[Ship-to Code] = 4482214
    AND [sih].[Posting Date] < '2020-10-01'
    AND [sih].[Ship-to Code] != ''
ORDER BY
         [orders_id]
       , [orders_products_id];