SELECT
       [sil].[OrderItemID] AS [orders_products_id]
     , [sih].[Ship-to Code] AS [orders_id]
     , [sil].[Campaign No_] AS [categories_id]
     , [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 [price]
     , CAST([sil].[Amount] AS DECIMAL(15, 2)) AS sum
     , CAST([sil].[Amount Including VAT] AS DECIMAL(15, 2)) AS [sum_with_vat]
     , [sil].[Posting Date] AS date_modified
FROM
     [dbo].[Privat Trade$Sales Invoice Line] AS [sil]
     JOIN [dbo].[Privat Trade$Sales Invoice Header] AS [sih]
         ON [sil].[Document No_] = [sih].[No_]
WHERE [sih].[Host Code] = 'MSY'
      AND [sil].[Type] = 2
ORDER BY
         [orders_id]
       , [orders_products_id];