---

SELECT
    ROW_NUMBER() OVER (ORDER BY DATEDIFF(day, GETDATE(), a.est_dd)) AS item,
    b.cus_no,
    a.prd_name,
    a.qty,
    c.ut,
    CONVERT(varchar(5), a.os_dd, 110) AS os_date,
    CONVERT(varchar(5), a.est_dd, 110) AS est_date,
    DATEDIFF(day, GETDATE(), a.est_dd) AS days_remaining,
    CASE WHEN DATEDIFF(day, GETDATE(), a.est_dd) <= 0 THEN 0 ELSE 1 END AS new_column,
    d.zrr,
    d.beizhu,
    a.os_no
FROM
    tf_pOs a,
    mf_pOs b,
    prdt c,
    tf_pos_Z d
WHERE
    a.os_id = 'SO'
    AND a.qty > ISNULL(a.qty_ps, 0)
    AND ISNULL(b.cls_id, 'F') = 'F'
    AND a.os_no = b.os_no
    AND b.est_DD >= '2023-01-01'
    AND a.est_dd <= DATEADD(day, 3, GETDATE())
    AND b.po_DEP = 'A50'
    AND a.prd_no = c.prd_no
    AND a.os_no = d.os_no
    AND a.itm = d.itm
ORDER BY
    days_remaining ASC