SELECT q.*
FROM (
    VALUES
    ('P0217403'),
('P0217402'),
('P0217401'),
('P0217400'),
('P0217399'),
('P0217398'),
('P0217397'),
('P0217396'),
('P0217395'),
('P0217394'),
('P0216262'),
('P0215728'),
('P0215718'),
('P0215527'),
('P0215526'),
('P0214006'),
('P0213602'),
('P0213463'),
('P0213053'),
('P0212903'),
('P0212097'),
('P0211452'),
('P0211295'),
('P0208880'),
('P0208817'),
('P0207409'),
('P0207097'),
('P0206610'),
('P0206276'),
('P0206273'),
('P0206268'),
('P0206265'),
('P0206208'),
('P0205489'),
('P0205488'),
('P0205487'),
('P0205486'),
('P0205485'),
('P0205484'),
('P0205483'),
('P0205482'),
('P0205470'),
('P0205469'),
('P0205468'),
('P0205467'),
('P0202234'),
('P0201457'),
('P0201449'),
('P0201447'),
('P0201437'),
('P0198471'),
('P0197669'),
('P0197668'),
('P0197663'),
('P0195770'),
('P0195764'),
('P0194140'),
('P0194061'),
('P0194057'),
('P0194052'),
('P0194048'),
('P0194032'),
('P0194028'),
('P0194007'),
('P0193991'),
('P0193683'),
('P0193682'),
('P0193580'),
('P0193575'),
('P0192351'),
('P0192341'),
('P0192340'),
('P0191881'),
('P0191880'),
('P0191879'),
('P0191878'),
('P0191852'),
('P0191408'),
('P0191407'),
('P0191406'),
('P0191405'),
('P0191404'),
('P0191403'),
('P0191402'),
('P0191401'),
('P0191400'),
('P0191399'),
('P0191398'),
('P0191397'),
('P0191328'),
('P0190896'),
('P0190895'),
('P0190348'),
('P0190346'),
('P0189751'),
('P0189747'),
('P0189743'),
('P0189739'),
('P0189734'),
('P0189731'),
('P0189215'),
('P0187653'),
('P0187319'),
('P0186682'),
('P0181992'),
('P0181991'),
('P0161274'),
('P0161273'),
('P0161272')
    -- ... metti tutti i tuoi ID
) AS ids(prodId)

CROSS APPLY (
    SELECT TOP (1)
        pt.PRODID,
        pt.ITEMID,
        pt.NAME,
        pt_ivd.PBMPROJECTINVENTID AS PROJID,
        dpnw.NAME AS CUSTNAME,
        pr.OPRNUM,
        FIRST_VALUE(dr.NOTES) OVER (ORDER BY dr.CREATEDDATETIME ASC) AS FistJsonNotes,
        FIRST_VALUE(dr.CREATEDDATETIME) OVER (ORDER BY dr.CREATEDDATETIME ASC) AS FistCreateDateTime,
        LAST_VALUE(dr.NOTES) OVER (ORDER BY dr.CREATEDDATETIME DESC) AS LastJsonNotes,
        FIRST_VALUE(dr.CREATEDDATETIME) OVER (ORDER BY dr.CREATEDDATETIME DESC) AS LastCreateDateTime
    FROM DocuRef dr
    LEFT JOIN ProdRoute pr
        ON dr.REFRECID = pr.RECID
        AND dr.REFCOMPANYID = pr.DATAAREAID
        AND dr.PARTITION = pr.PARTITION
    LEFT JOIN ProdTable pt
        ON pr.PRODID = pt.PRODID
        AND pr.DATAAREAID = pt.DATAAREAID
        AND pr.PARTITION = pt.PARTITION
    LEFT JOIN INVENTDIM pt_ivd
        ON pt_ivd.INVENTDIMID = pt.INVENTDIMID
        AND pt_ivd.DATAAREAID = pt.DATAAREAID
        AND pt_ivd.PARTITION = pt.PARTITION
    LEFT JOIN ProjTable pjt
        ON pt_ivd.PBMPROJECTINVENTID = pjt.PROJID
        AND pt_ivd.DATAAREAID = pjt.DATAAREAID
        AND pt_ivd.PARTITION = pjt.PARTITION
    LEFT JOIN CUSTTABLE ct
        ON pjt.CUSTACCOUNT = ct.ACCOUNTNUM
        AND pjt.DATAAREAID = ct.DATAAREAID
        AND pjt.PARTITION = ct.PARTITION
    LEFT JOIN DIRPARTYNAMEVIEW dpnw
        ON ct.PARTY = dpnw.PARTY
        AND ct.PARTITION = dpnw.PARTITION
    WHERE pt.PRODID = ids.prodId
      AND dr.REFCOMPANYID = 'PAL'
      AND dr.TYPEID = 'CMB-REP'
      AND dr.PARTITION = 5637144576
) AS q;