---

SET NOCOUNT ON
;
SELECT WriteOff.ShopID, WriteOff.CodeStamp, WriteOff.Code, SUBSTRING(WriteOff.CodeStamp,4,13) AS BarCode, WriteOff.Status,   
    WriteOff.DateTimeStatus, WriteOff.ProductType, WriteOff.FirmID, WriteOff.ReasonID,  
    WriteOff.PrimaryDocType, isNull(WriteOff.PrimaryDocNumber,'') AS PrimaryDocNumber, WriteOff.PrimaryDocDate, WriteOff.Cost, 
    WriteOff.ExpirationDate, WriteOff.ShopKPP,
    Firms.INN, Firms.KPP, Firms.Name, Firms.email, Firms.ConfidantINN, ReasonsWriteOff.NameCRPT AS ReasonNameCRPT, 
    MarkTypes.NameCPRT AS MarkTypeNameCRPT, MarkTypes.CodeCPRT AS MarkTypeCodeCPRT 
FROM WriteOff 
LEFT JOIN Firms AS Firms ON (WriteOff.FirmID = Firms.ID) 
LEFT JOIN ReasonsWriteOff AS ReasonsWriteOff ON (WriteOff.ReasonID = ReasonsWriteOff.ID) 
LEFT JOIN MarkTypes AS MarkTypes ON (WriteOff.ProductType = MarkTypes.ID)
WHERE Status = 0 AND DateTimeStatus < '20260714 13:55:32' AND WriteOff.ShopID IN ('Ф80') and CodeStamp IN ('0104606419025465215KsjP6#1D9343Sa1') 
ORDER BY FirmID, ShopID, PrimaryDocNumber, MarkTypeCodeCPRT, ReasonID, Barcode
;
SET NOCOUNT OFF